Saravanan Subramani

Greenhorn
+ Follow
since Feb 27, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Saravanan Subramani

Kindly reply if there is any solution...

Thanks.
Thanks for moving to ORM.
Hi,
in hibernate, is it possible to make query like this,

select transaction_id from table1 o where o.STATUS LIKE 'COM%' and o.transaction_id in (select id from table2 where country = :country)

just i want to join two table and get a result.

Thanks in advance.
Thanks for reply.

You mean Once completed the insertion, commit the changes. then, again call the procedures with new transaction.

like this,

session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
session.save();
session.save()
session.save()
session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();

session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();

call the procedure();
call the procedure();

session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();


Am i correct?

Thanks.
Hi,
I modified first name and last name.
Thanks.
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
Hi,

I am using Hibernate version:3.0 and oracle 10.

In my method, first will execute 4 insert query. after executing all insert queries , finally it should be calling a procedure and commit the transaction.

My problem is when i calling this method, what hibernate does is,first calling the procedure and then executing all insert queries.

Why is it doing like this? Is there any configuration required to tell which kind of query should execute first ?.

Help needed.

Thanks in advance.
Hi,
Thanks for reply,

I dont know how to register the out variables before the SP is executed

Thanks.
Is it possible? if i have composite key , one of the key should be have generated oracle sequence.

<composite-id>
<key-property name="batchId" column="H1SD_XB_BATCH_ID"></key-property>
<key-property name="taskId" column="H1SD_XB_TASK_ID">
<generator class="sequence">
<param name="sequence">h1sd_xb_task_seq</param>
</generator>
</key-property>
</composite-id>
<property name=
......


Ihis is not a proper syntax (throws error.invalid mapping exception).
Please help me how to configure for this situation.
Thanks in advance
Hi
My procedure will be return a integer object. not like a row.

i have problems with the return parameters of the stored procedure.

Thanks, I appreciate any help.
Thanks for reply.
I used mapping with following way,
//mapping
<sql-query name="FETCHBATCHID" callable="fale">
{ call PSFTCTE.common.TASKID(?) }
</sql-query>

//code
Query query = session.getNamedQuery("FETCHBATCHID").setParameter(0, userId);
int batId = query.executeUpdate();

i changed callable="false" in mapping file.

procedure is executing finely.but another problem is, when i call a procedure that return a out parameter, i am getting error.

mapping like this,

<sql-query name="FETCHBATCHID" callable="false">
{? = call PSFTCTE.xmlbatch_common.FETCHTASKID(?,?) }
</sql-query>

//code
Query query = session.getNamedQuery("FETCHBATCHID").setParameter(0, userId).setParameter(1, label);
int batId = query.executeUpdate();

I don't know how to write for get retrun out parameter.

Following Error is throwing ORA-01008: not all variables bound)

Hibernate: {? = call PSFTCTE.xmlbatch_common.FETCHTASKID(?,?) }
org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:174)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1163)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:334)
at com.orderengine.logic.TestDatabase.createBatchId(TestDatabase.java:100)
at com.orderengine.logic.TestDatabase.main(TestDatabase.java:36)
Caused by: java.sql.SQLException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:165)
... 4 more



I can use what you suggesed.But i would like to know why my code is not working when there is a return out parameter & where i made mistake.

Thanks in advance..
Hi ,

I am new in hibernate. What i want to do is, I have to call a procedure.
without specifying the column names in mapping file.

My procedure accept 2 input parameters, it generate a unique number and return it as out parameter. In this scenario,i dont know How to map and how to write the code.

this is my procedure,

FUNCTION FETCHID(ID VARCHAR,LABEL VARCHAR) RETURN NUMBER IS
OUTID NUMBER;
BEGIN

select swith_id into OUTBATCHID from ps_async
where h1sd_xb_exec_oprid = ID and trunc(send_date) = trunc(sysdate);

RETURN OUTID;
exception
when no_data_found then
select h1sd_xb_batch_seq.nextval into OUTID from dual;
insert into ps_async values(ID,sysdate,OUTID);
commit;
insert into xb_batch values (OUTID,INLABEL,'NEW',ID,' ',0,trunc(sysdate),ID,trunc(sysdate),ID);
commit;
RETURN OUTID;
END;

My procdure is referring 2 table. I saw so many samples like

<sql-query name="selectAllEmployees_SP" callable="true">
<return alias="emp" class="employee">
<return-property name="empid" column="EMP_ID"/>

<return-property name="name" column="EMP_NAME"/>
<return-property name="address" column="EMP_ADDRESS"/>
{ ? = call selectAllEmployees(?,?) }
</return>
</sql-query>

I think these are not needed in my requirement.what i want to do is just send 2 string parameters and get out parameter. i dont know how to set return-property for my requirement.

Please suggest me how to do that,

Thanks in advance
Saravanan.
[ July 17, 2008: Message edited by: ssaravanan saravanan ]