{
PreparedStatement pstmt = null;
try
{
SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
SchemaContext schemaContext=gCaseDatabaseImpl.getSchemaContext();
Store storeConfig= gCaseDatabaseImpl.getStore();
WorkflowCase workflowCase = workflowWork.getWorkflowCase();
String pkgId = workflowProcess.getWorkflowPackage().getUUID();
String processId = workflowProcess.getUUID();
String caseId = workflowCase.getUUID();
String workId = workflowWork.getUUID();
String strSQL =
"INSERT INTO "
+ schemaContext.getTableName(SchemaContext.SCHEMA_WORK_EVENT)
+ "(vc_packageid,vc_processid,vc_caseid,int_type,vc_operator,dat_opTime,vc_workid,vc_description) "
+ "VALUES(?,?,?,?,?,?,?,?)";
pstmt = conn.prepareStatement(strSQL);
pstmt.setString(1, pkgId);
pstmt.setString(2, processId);