Thanks for reply.Please find my method.
private void storeRequests(CreateSubscriptionDAO createPrepaidSubscriptionDAO, GenerateDocumentDAO generateDocumentDAO, UpdateReservationDAO updateReservationDAO, CreateOracleERPOrderDAO createOracleERPOrderDAO) throws OrderEngineDatabaseException{
logger.debug("----storeBatchRequests----");
Session session = null;
try{
session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
logger.info(Constants.LOG_STORE_BATCH_TABLES_ATTEMPT);
long t11 = System.currentTimeMillis();
// Create and store batch table object
Calendar timestamp = Calendar.getInstance();
String label = webShop + timestamp.getTime();
CallableStatement callableStatement = null;
callableStatement = session.connection().prepareCall("{? = call PSFTADM.xmlbatch_common.fetchbatchid(?,?)}");
callableStatement.setString(2,user);
callableStatement.setString(3,label);
callableStatement.registerOutParameter(1, OracleTypes.INTEGER);
callableStatement.execute();
Long batchId = new Long(callableStatement.getLong(1));
callableStatement.close();
logger.debug("Batch id :"+ batchId);
// Store all requests in the batch tables
if (createPrepaidSubscriptionDAO != null){
//create task id
Long taskId = createTaskId(session);
createPrepaidSubscriptionDAO.setBatchId(batchId);
createPrepaidSubscriptionDAO.setTaskId(taskId);
logger.info(Constants.LOG_PREPAID_SUBSCRIPTION_ATTEMPT);
long t1 = System.currentTimeMillis();
session.save(createPrepaidSubscriptionDAO);
//session.flush();
long t2 = System.currentTimeMillis();
logger.info(Constants.LOG_PREPAID_SUBSCRIPTION_SUCCESS + (t2-t1) + " ms");
}
if (generateDocumentDAO != null){
//create task id
Long taskId = createTaskId(session);
generateDocumentDAO.setBatchId(batchId);
generateDocumentDAO.setTaskId(taskId);
logger.info(Constants.LOG_GENERATE_DOCUMENT_ATTEMPT);
long t1 = System.currentTimeMillis();
session.save(generateDocumentDAO);
//session.flush();
long t2 = System.currentTimeMillis();
logger.info(Constants.LOG_GENERATE_DOCUMENT_SUCCESS + (t2-t1) + " ms");
}
if (updateReservationDAO != null){
//create task id
Long taskId = createTaskId(session);
updateReservationDAO.setBatchId(batchId);
updateReservationDAO.setTaskId(taskId);
logger.info(Constants.LOG_UPDATE_RESERVATION_ATTEMPT);
long t1 = System.currentTimeMillis();
session.save(updateReservationDAO);
//session.flush();
long t2 = System.currentTimeMillis();
logger.info(Constants.LOG_UPDATE_RESERVATION_SUCCESS + (t2-t1) + " ms");
}
if (createOracleERPOrderDAO != null){
//create task id
Long taskId = createTaskId(session);
createOracleERPOrderDAO.setBatchId(batchId);
createOracleERPOrderDAO.setTaskId(taskId);
logger.info(Constants.LOG_CREATE_ORACLE_ORDER_ATTEMPT);
long t1 = System.currentTimeMillis();
session.save(createOracleERPOrderDAO);
//session.flush();
long t2 = System.currentTimeMillis();
logger.info(Constants.LOG_CREATE_ORACLE_ORDER_SUCCESS + (t2-t1) + " ms");
}
//prepare batch - calling procedure
session.getNamedQuery("batchPrepare").setParameter(0, batchId).executeUpdate();
//update batch
logger.debug("BatchPrepare Success ");
// calling procedure
session.getNamedQuery("batchUpdate").setParameter(0, batchId).setParameter(1, "PRCS").executeUpdate();
long t22 = System.currentTimeMillis();
logger.info(Constants.LOG_STORE_BATCH_TABLES_SUCCESS + (t22-t11) + " ms");
session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();
}
catch(Exception exception){
logger.error("Received exception: " + exception.getMessage());
session.getTransaction().rollback();
HibernateUtil.getSessionFactory().close();
//exception.printStackTrace();
OrderEngineDatabaseException orderEngineDatabaseException = new OrderEngineDatabaseException(exception.getMessage());
throw orderEngineDatabaseException;
}
}
query output is:
Hibernate: {call PSFTADM.xmlbatch_common.BATCH_PREPARE(?) }
Hibernate: {call PSFTADM.xmlbatch_common.BATCH_UPDATE(?,?) }
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUB (H1SD_XB_TRANS_ID, RBTACCTNO, SALES_USER_ID, H1SW_SALESIND_NAME, H1SD_OFFER1, H1SD_MSISDN_CH, H1UK_IMSI, UICCID, H1UK_PUK1A, H1SD_IMEI_CH, CAPTURE_ID, H1SD_MASTORDID_CH, H1SW_URL_CNTR, H1SD_PREPTYPE_CH, H1SD_ORDTYPE, H1SD_ORDACTION_CH, H1SD_EMAILTYPE_CH, EMAIL_ADDR, FIRST_NAME, LAST_NAME, H1SD_CALLDATA_CH, H1SD_DONORNUM_CH, H1SD_DONOROPR_CH, H1SD_DNRUICCID_CH, H1SD_PORTDATE_DT, H1SD_PORTHOUR_CH, H1SD_DEFFERED_CH, H1SD_DEV_PAY_CH, H1SD_START_PAY_CH, H1SD_LANG_CH, H1SD_ASYNC_CH, H1SD_PRINTCNTRCT, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOC (H1SD_XB_TRANS_ID, CAPTURE_ID, H1SD_MASTORDID_CH, H1SD_SWITCHID_CH, H1SD_DOCTYPDESC_CH, H1SW_URL_CNTR, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_UPDRES (H1SD_XB_TRANS_ID, H1SD_PAYMENT_ID, EXTERNAL_ID, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_ERPORD (H1SD_XB_TRANS_ID, TAXPAYER_ID, H1SD_CUSTID_CH, H1SD_PRSNFLG_CH, BO_NAME, FIRST_NAME, LAST_NAME, H1SD_SITECODE_CH, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, POSTAL, CITY, COUNTRY, COUNTY, H1SD_MASTORDID_CH, URL, H1SD_ORDREF_CH, H1SD_SALESCHNL_CH, H1SD_ORDTYPE, H1SD_OPRTYPE_CH, H1SD_AUTHRET_CH, H1SD_PYMTCODE_CH, H1SD_CUSTPONM_CH, H1SD_RECCONFLG_CH, H1SD_CONFEMAIL_CH, H1SD_DELMETH_CH, H1SD_RETREASCD_CH, H1SD_RETPAIDBY_CH, H1SD_CUSTNT_CH, H1SD_HANDNT_CH, H1SD_ORDCRTBY_CH, H1SD_PAYTRXID_CH, H1SD_PARTDEL_CH, H1SD_ALLOWSTCK_CH, H1SD_DELCNTCT_CH, H1SD_DELCONT_CH, H1SD_DELPINCOD_CH, H1SD_DELPHONE_CH, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_UPDRESP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTITEM_ID, H1SD_ITEM_ID) values (?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_UPDRESP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTITEM_ID, H1SD_ITEM_ID) values (?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_ERPORDP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, CAPTURE_ID, H1SD_MASTORDID_CH, H1SD_OPRTYPE_CH, PRODUCT_ID, H1SD_BINDING_CH, H1SD_OFFER1, RA_CAMPAIGN_ID, H1SD_ORDTYPE, H1SD_DISCNT_CH, H1SD_PRICE2_NM, REQUEST_DT, H1SD_MSISDN_CH, H1SD_DONORNUM_CH, RBTACCTNO, H1SD_PYMTCODE_CH, EMAIL_ADDR, FIRST_NAME, LAST_NAME, DESCR, H1SD_COSTCODE_CH, H1SW_SALESIND_NAME, H1SD_SALESCHNL_CH, H1SD_SUBSCRTYP_CH) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_ERPORDP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, CAPTURE_ID, H1SD_MASTORDID_CH, H1SD_OPRTYPE_CH, PRODUCT_ID, H1SD_BINDING_CH, H1SD_OFFER1, RA_CAMPAIGN_ID, H1SD_ORDTYPE, H1SD_DISCNT_CH, H1SD_PRICE2_NM, REQUEST_DT, H1SD_MSISDN_CH, H1SD_DONORNUM_CH, RBTACCTNO, H1SD_PYMTCODE_CH, EMAIL_ADDR, FIRST_NAME, LAST_NAME, DESCR, H1SD_COSTCODE_CH, H1SW_SALESIND_NAME, H1SD_SALESCHNL_CH, H1SD_SUBSCRTYP_CH) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select orderstatu0_.EXTERNAL_ID as EXTERNAL1_1_0_, orderstatu0_.TRX_ID as TRX2_1_0_, orderstatu0_.H1SD_WEBORDRSTS_CH as H3_1_0_, orderstatu0_.H1SD_COUNTRY as H4_1_0_, orderstatu0_.H1SD_CUSTTYPE as H5_1_0_, orderstatu0_.H1SD_ORDTYPE as H6_1_0_, orderstatu0_.ERROR_CODE as ERROR7_1_0_, orderstatu0_.H1SD_ERROR_DESCR as H8_1_0_, orderstatu0_.ROW_ADDED_DTTM as ROW9_1_0_, orderstatu0_.ROW_ADDED_OPRID as ROW10_1_0_, orderstatu0_.ROW_LASTMANT_DTTM as ROW11_1_0_, orderstatu0_.ROW_LASTMANT_OPRID as ROW12_1_0_ from PSftadm.PS_H1SD_WEBORD_TBL orderstatu0_ where orderstatu0_.EXTERNAL_ID=?
Hibernate: update PSftadm.PS_H1SD_WEBORD_TBL set TRX_ID=?, H1SD_WEBORDRSTS_CH=?, H1SD_COUNTRY=?, H1SD_CUSTTYPE=?, H1SD_ORDTYPE=?, ERROR_CODE=?, H1SD_ERROR_DESCR=?, ROW_ADDED_DTTM=?, ROW_ADDED_OPRID=?, ROW_LASTMANT_DTTM=?, ROW_LASTMANT_OPRID=? where EXTERNAL_ID=?
u1562tzz: $ javaEngine.sh
Hibernate: select * from PSFTADM.PS_H1SD_WEBORD_TBL o where o.H1SD_WEBORDRSTS_CH = ? or o.H1SD_WEBORDRSTS_CH = ?
Hibernate: select orderstatu0_.EXTERNAL_ID as EXTERNAL1_1_0_, orderstatu0_.TRX_ID as TRX2_1_0_, orderstatu0_.H1SD_WEBORDRSTS_CH as H3_1_0_, orderstatu0_.H1SD_COUNTRY as H4_1_0_, orderstatu0_.H1SD_CUSTTYPE as H5_1_0_, orderstatu0_.H1SD_ORDTYPE as H6_1_0_, orderstatu0_.ERROR_CODE as ERROR7_1_0_, orderstatu0_.H1SD_ERROR_DESCR as H8_1_0_, orderstatu0_.ROW_ADDED_DTTM as ROW9_1_0_, orderstatu0_.ROW_ADDED_OPRID as ROW10_1_0_, orderstatu0_.ROW_LASTMANT_DTTM as ROW11_1_0_, orderstatu0_.ROW_LASTMANT_OPRID as ROW12_1_0_ from PSftadm.PS_H1SD_WEBORD_TBL orderstatu0_ where orderstatu0_.EXTERNAL_ID=?
Hibernate: update PSftadm.PS_H1SD_WEBORD_TBL set TRX_ID=?, H1SD_WEBORDRSTS_CH=?, H1SD_COUNTRY=?, H1SD_CUSTTYPE=?, H1SD_ORDTYPE=?, ERROR_CODE=?, H1SD_ERROR_DESCR=?, ROW_ADDED_DTTM=?, ROW_ADDED_OPRID=?, ROW_LASTMANT_DTTM=?, ROW_LASTMANT_OPRID=? where EXTERNAL_ID=?
Hibernate: select orderdao0_.EXTERNAL_ID as EXTERNAL1_0_0_, orderdao0_.H1SD_ORDERXML_L as H2_0_0_ from PSftadm.PS_H1SD_WEBXML_TBL orderdao0_ where orderdao0_.EXTERNAL_ID=?
PSProperties not loaded from file. Couldn't find file: pstools.properties
Hibernate: {call PSFTADM.xmlbatch_common.BATCH_PREPARE(?) }
Hibernate: {call PSFTADM.xmlbatch_common.BATCH_UPDATE(?,?) }
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUB (H1SD_XB_TRANS_ID, RBTACCTNO, SALES_USER_ID, H1SW_SALESIND_NAME, H1SD_OFFER1, H1SD_MSISDN_CH, H1UK_IMSI, UICCID, H1UK_PUK1A, H1SD_IMEI_CH, CAPTURE_ID, H1SD_MASTORDID_CH, H1SW_URL_CNTR, H1SD_PREPTYPE_CH, H1SD_ORDTYPE, H1SD_ORDACTION_CH, H1SD_EMAILTYPE_CH, EMAIL_ADDR, FIRST_NAME, LAST_NAME, H1SD_CALLDATA_CH, H1SD_DONORNUM_CH, H1SD_DONOROPR_CH, H1SD_DNRUICCID_CH, H1SD_PORTDATE_DT, H1SD_PORTHOUR_CH, H1SD_DEFFERED_CH, H1SD_DEV_PAY_CH, H1SD_START_PAY_CH, H1SD_LANG_CH, H1SD_ASYNC_CH, H1SD_PRINTCNTRCT, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOC (H1SD_XB_TRANS_ID, CAPTURE_ID, H1SD_MASTORDID_CH, H1SD_SWITCHID_CH, H1SD_DOCTYPDESC_CH, H1SW_URL_CNTR, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_UPDRES (H1SD_XB_TRANS_ID, H1SD_PAYMENT_ID, EXTERNAL_ID, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_ERPORD (H1SD_XB_TRANS_ID, TAXPAYER_ID, H1SD_CUSTID_CH, H1SD_PRSNFLG_CH, BO_NAME, FIRST_NAME, LAST_NAME, H1SD_SITECODE_CH, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, POSTAL, CITY, COUNTRY, COUNTY, H1SD_MASTORDID_CH, URL, H1SD_ORDREF_CH, H1SD_SALESCHNL_CH, H1SD_ORDTYPE, H1SD_OPRTYPE_CH, H1SD_AUTHRET_CH, H1SD_PYMTCODE_CH, H1SD_CUSTPONM_CH, H1SD_RECCONFLG_CH, H1SD_CONFEMAIL_CH, H1SD_DELMETH_CH, H1SD_RETREASCD_CH, H1SD_RETPAIDBY_CH, H1SD_CUSTNT_CH, H1SD_HANDNT_CH, H1SD_ORDCRTBY_CH, H1SD_PAYTRXID_CH, H1SD_PARTDEL_CH, H1SD_ALLOWSTCK_CH, H1SD_DELCNTCT_CH, H1SD_DELCONT_CH, H1SD_DELPINCOD_CH, H1SD_DELPHONE_CH, H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_CRSUBP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, PRODUCT_ID) values (?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_GENDOCE (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTKEYNM_CH, H1SD_EXTKEYVAL_CH, H1SD_DATATYPE_CH, H1SD_EXTTYPNM_CH, DESCR) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_UPDRESP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTITEM_ID, H1SD_ITEM_ID) values (?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_UPDRESP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, H1SD_EXTITEM_ID, H1SD_ITEM_ID) values (?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_ERPORDP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, CAPTURE_ID, H1SD_MASTORDID_CH, H1SD_OPRTYPE_CH, PRODUCT_ID, H1SD_BINDING_CH, H1SD_OFFER1, RA_CAMPAIGN_ID, H1SD_ORDTYPE, H1SD_DISCNT_CH, H1SD_PRICE2_NM, REQUEST_DT, H1SD_MSISDN_CH, H1SD_DONORNUM_CH, RBTACCTNO, H1SD_PYMTCODE_CH, EMAIL_ADDR, FIRST_NAME, LAST_NAME, DESCR, H1SD_COSTCODE_CH, H1SW_SALESIND_NAME, H1SD_SALESCHNL_CH, H1SD_SUBSCRTYP_CH) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PSFTADM.PS_H1SD_XB_ERPORDP (H1SD_XB_BATCH_ID, H1SD_XB_TASK_ID, CAPTURE_ID, H1SD_MASTORDID_CH, H1SD_OPRTYPE_CH, PRODUCT_ID, H1SD_BINDING_CH, H1SD_OFFER1, RA_CAMPAIGN_ID, H1SD_ORDTYPE, H1SD_DISCNT_CH, H1SD_PRICE2_NM, REQUEST_DT, H1SD_MSISDN_CH, H1SD_DONORNUM_CH, RBTACCTNO, H1SD_PYMTCODE_CH, EMAIL_ADDR, FIRST_NAME, LAST_NAME, DESCR, H1SD_COSTCODE_CH, H1SW_SALESIND_NAME, H1SD_SALESCHNL_CH, H1SD_SUBSCRTYP_CH) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select orderstatu0_.EXTERNAL_ID as EXTERNAL1_1_0_, orderstatu0_.TRX_ID as TRX2_1_0_, orderstatu0_.H1SD_WEBORDRSTS_CH as H3_1_0_, orderstatu0_.H1SD_COUNTRY as H4_1_0_, orderstatu0_.H1SD_CUSTTYPE as H5_1_0_, orderstatu0_.H1SD_ORDTYPE as H6_1_0_, orderstatu0_.ERROR_CODE as ERROR7_1_0_, orderstatu0_.H1SD_ERROR_DESCR as H8_1_0_, orderstatu0_.ROW_ADDED_DTTM as ROW9_1_0_, orderstatu0_.ROW_ADDED_OPRID as ROW10_1_0_, orderstatu0_.ROW_LASTMANT_DTTM as ROW11_1_0_, orderstatu0_.ROW_LASTMANT_OPRID as ROW12_1_0_ from PSftadm.PS_H1SD_WEBORD_TBL orderstatu0_ where orderstatu0_.EXTERNAL_ID=?
Hibernate: update PSftadm.PS_H1SD_WEBORD_TBL set TRX_ID=?, H1SD_WEBORDRSTS_CH=?, H1SD_COUNTRY=?, H1SD_CUSTTYPE=?, H1SD_ORDTYPE=?, ERROR_CODE=?, H1SD_ERROR_DESCR=?, ROW_ADDED_DTTM=?, ROW_ADDED_OPRID=?, ROW_LASTMANT_DTTM=?, ROW_LASTMANT_OPRID=? where EXTERNAL_ID=?s