javax.transaction.TransactionRolledbackException is Session Bean

[Ketan Khimani]

Hello Frnds,
I am working on IBM VAJ 3.5.3 and ihd write entity beans.
I am having a session bean (No 1) (for inserting record in DB as three tables r there icn not use directly entity ejb) and from that session bean i am calling another session bean (No 2) which is getting the max value from database for inserting the record. I want this bean for entire application as i wll be generating unique id for each n every table, for that ihd created session bean.
And after getting the max value i am inserting this max value and other data gathered from user in database through two different entity beans.
So now when i am doing this i am getting javax.transaction.TransactionRolledbackException.
But if i am calling only (No 2)bean that for getting max value from database and not intserting record throug entity thn it is working fine , the another bean(No 2 ) is giving the desired result.
And if i am calling only insert operation and not bean (No 2) than also it is working fine.
The problem is that I am doing database operation in My (No 2)bean , doing connection and one select query. if i am commenting it out that whole the thing is working correctly.
The whole error is as follows , if anybody can help me , pls send reply :
Exception is:
javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: com.ibm.websphere.csi.CSITransactionRolledbackException:
java.lang.Throwable(java.lang.String)
java.lang.Exception(java.lang.String)
java.io.IOException(java.lang.String)
java.rmi.RemoteException(java.lang.String)
com.ibm.websphere.csi.CSIException(java.lang.String)
com.ibm.websphere.csi.CSITransactionRolledbackException(java.lang.String)
void com.ibm.ejs.csi.TranStrategy.commit()
void com.ibm.ejs.csi.TranStrategy.postInvoke(com.ibm.websphere.csi.EJBKey, com.ibm.ejs.csi.TxCookieImpl)
void com.ibm.ejs.csi.TransactionControlImpl.postInvoke(com.ibm.websphere.csi.EJBKey, com.ibm.websphere.csi.TxCookie, com.ibm.websphere.csi.ExceptionType)
void com.ibm.ejs.container.EJSContainer.postInvoke(com.ibm.ejs.container.EJSWrapper, int, com.ibm.ejs.container.EJSDeployedSupport)
void com.next.analysis.ejbs.EJSRemoteInsertMTFigureItem.insert()
org.omg.CORBA.portable.OutputStream com.next.analysis.ejbs._EJSRemoteInsertMTFigureItem_Tie._invoke(java.lang.String, org.omg.CORBA.portable.InputStream, org.omg.CORBA.portable.ResponseHandler)
com.ibm.rmi.ServerResponse com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(com.ibm.rmi.ServerRequest)
com.ibm.rmi.ServerResponse com.ibm.CORBA.iiop.ORB.process(com.ibm.rmi.ServerRequest)
void com.ibm.CORBA.iiop.WorkerThread.run()
void com.ibm.ejs.oa.pool.ThreadPool$PooledThread.run()
minor code: 0 completed: No
Ketan Khimani
NextGen InfoNET Pvt. Ltd.
------------------