List not_found_inTrans = new ArrayList();
for (int i = 0; i < inTrans_size; ++i)
{
WorkflowTransition flaseTransition = (WorkflowTransition) inTrans.get(i);
WorkflowActivity falseActivity = flaseTransition.getFromWorkflowActivity();
String false_owner_process_id = falseActivity.getWorkflowProcess().getUUID();
String false_activity_id = falseActivity.getUUID();
pstmt.setString(1, "FALSE");
pstmt.setString(2, packageId);
pstmt.setString(3, processId);
pstmt.setString(4, caseId);
pstmt.setString(5, false_owner_process_id);
pstmt.setString(6, false_activity_id);
rs = pstmt.executeQuery();
if (rs.next())
{
falseTrans_size += 1;
}
else
{
not_found_inTrans.add(flaseTransition);
}
}
ConnUtils.cleanupNoThrow(pstmt);
pstmt = null;
//$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
// -----------------Lookup In event_userTransaction ---------------------------------
//------------------VIP Code Section By zosatapo----------------------------------------
//$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Connection event_conn = null;
PreparedStatement event_pstmt = null;
ResultSet event_rs=null;
try
{
event_conn = (Connection) event_userTransaction.getStoreConnection().get();
strSQL =
"SELECT int_batchNo FROM "+userTransaction.getDatabase().getSchemaContext().getTableName(SchemaContext.SCHEMA_ACTIVITY_DISPATCH)+" "
+ "WHERE vc_disp_flag=? "
+ "AND vc_packageid=? "
+ "AND vc_processid=? "
+ "AND vc_caseid=? "
+ "AND vc_owner_processid=? "
+ "AND vc_activityid=? ";
event_pstmt = event_conn.prepareStatement(strSQL);
int not_found_inTrans_size = not_found_inTrans.size();
for (int i = 0; i < not_found_inTrans_size; ++i)
{
WorkflowTransition flaseTransition = (WorkflowTransition) not_found_inTrans.get(i);
WorkflowActivity falseActivity = flaseTransition.getFromWorkflowActivity();
String false_owner_process_id = falseActivity.getWorkflowProcess().getUUID();
String false_activity_id = falseActivity.getUUID();
event_pstmt.setString(1, "FALSE");
event_pstmt.setString(2, packageId);