PreparedStatement pstmt = null;
try
{
SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
SchemaContext schemaContext=gCaseDatabaseImpl.getSchemaContext();
Store storeConfig= gCaseDatabaseImpl.getStore();
String packageId = workflowProcess.getWorkflowPackage().getUUID();
String processId = workflowProcess.getUUID();
String caseId = workflowCase.getUUID();
String strSQL =
"INSERT INTO "
+ schemaContext.getTableName(SchemaContext.SCHEMA_CASE_DATAFIELD)
+ "(vc_packageid,vc_processid,vc_caseid,vc_uuid,vc_type,vc_value) "
+ "VALUES(?,?,?,?,?,?)";
pstmt = conn.prepareStatement(strSQL);
pstmt.setString(1, packageId);
pstmt.setString(2, processId);