String processId = workflowProcess.getUUID();
String packageId = workflowProcess.getWorkflowPackage().getUUID();
String caseId = workflowCase.getUUID();
List paramList = new ArrayList();
WorkflowParameter parameter = null;
String strSQL =
"SELECT vc_uuid,vc_type,vc_value FROM "
+ schemaContext.getTableName(SchemaContext.SCHEMA_CASE_DATAFIELD)
+ " "
+ "WHERE vc_packageId=?"
+ " "
+ "AND vc_processid=?"
+ " "
+ "AND vc_caseId=?";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet jrs = null;
try
{
conn = ConnUtils.getConnection(storeConfig);
pstmt = conn.prepareStatement(strSQL);
pstmt.setString(1, packageId);
pstmt.setString(2, processId);
pstmt.setString(3, caseId);
jrs = pstmt.executeQuery();
String vc_uuid = null;
String vc_type = null;
String vc_value = null;
while (jrs.next())
{
vc_uuid = jrs.getString("vc_uuid");
vc_type = jrs.getString("vc_type");
vc_value = jrs.getString("vc_value");
parameter = new WorkflowParameter(vc_uuid, vc_uuid, TypeDefinition.XPDLToJava(vc_type));
parameter.setValue(ConvertUtils.convert(vc_value, parameter.getType()));
paramList.add(parameter);
}
}
finally