Hi
I am using the websphere 5.0.2. I am doing the transaction which has sequence :
SessionBean+DAO+Entity bean calls ,The problem is coming when inside session bean i am calling the entity bean (Session bean is running in trnsaction mode as "REQUIRED" but before saving i am getting the Sequenec ID from the database using the DAO(DAO has to statement one is Update+ Select), After getting the SeqID when i call the entity bean for saving the Data i get the Transaction Rollback Excption.
( Also i am not using the XA data source)
Here is the stack trace for the Exception ::::
DEBUG com.ubs.ir.infra.swiskey.skepersistence.session
.SKEPersat com.ibm.ejs.jts.jta.TransactionImpl.enlistResource(TransactionImpl.ja
va:5 at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:468)at
e.java: at com.ibm.rmi.iiop.ORB.process(ORB.java:396)23_Tie.java:97)a:111)own So
urce)se at com.ibm.CORBA.iiop.ORB.process(ORB.java:1608)DTradeService_6e214023.p
rocessT at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2164)er_1c62dfb1.p
rocessT at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63)
[3/2/05 at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95)d enlist caug
ht
java at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
while trying to enlist resources from datasource jdbc/skeds with the Transactio
n Manager for the current transaction, and threw a Exception.
[3/2/05 at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Un
know at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:468)at
e.java: at com.ibm.ejs.jts.jta.TransactionImpl.enlistResource(TransactionImpl.ja
va:568) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1608)DTradeService_6e214023.p
rocessT at com.ibm.ejs.jts.jta.JTSXA.enlistResource(JTSXA.java:1061)r_1c62dfb1.p
rocessT at com.ibm.ejs.jts.jta.JTSXA.enlistOnePhase(JTSXA.java:1038))2E: Error u
sing ad at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrappe
r.java:512)com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
---- Begin backtrace for nested exception
java.lang.IllegalStateException
at com.ibm.ejs.jts.jta.TransactionImpl.enlistResource(TransactionImpl.ja
va:568)
at com.ibm.ejs.jts.jta.JTSXA.enlistResource(JTSXA.java:1061)
at com.ibm.ejs.jts.jta.JTSXA.enlistOnePhase(JTSXA.java:1038)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrappe
r.java:512)
at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(Connection
EventListener.java:743)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractio
nPendingEvent(WSRdbManagedConnectionImpl.java:1330)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionImpl.enlistIfNecessary(WSRdbC
onnectionImpl.java:489)
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.
java:324)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeCreate(WSRelati
onalRAAdapter.java:192)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Un
known Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstance
Exte at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:468)at
e.java: at com.ibm.rmi.iiop.ORB.process(ORB.java:396)23_Tie.java:97)a:111)own So
urce) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1608)DTradeService_6e214023.p
rocessT at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2164)er_1c62dfb1.p
rocessT at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Un
know at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:468)at
e.java: at com.ibm.ejs.jts.jta.TransactionImpl.enlistResource(TransactionImpl.ja
va:5 at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:468)at
e.java: at com.ibm.rmi.iiop.ORB.process(ORB.java:396)23_Tie.java:97)a:111)own So
urce)sT at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstance
Exte at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:468)at
e.java: at com.ibm.rmi.iiop.ORB.process(ORB.java:396)23_Tie.java:97)a:111)own So
urce)Be at com.ibm.CORBA.iiop.ORB.process(ORB.java:1608)DTradeService_6e214023.p
rocessT at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2164)er_1c62dfb1.p
rocessT at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63)e.utilpm.Pe
rsisten at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95) or execute a
n Inter at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
[3/2/05 16:45:22:348 GMT] 327473 ExceptionUtil E CNTR0020E: Non-application ex
ception occurred while processing method "save" on bean "BeanId(SKEPersistence#S
KEPersistenceEJB.jar#SKEPersistence, null)". Exception data: javax.ejb.Transacti
onRolledbackLocalException: ; nested exception is: javax.ejb.EJBException: nest
ed exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: P
MGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rs
adapter.cci.WSInteractionImpl@6f13bb
Thanks for helping in advance
Regards
Sanjeev
[ March 03, 2005: Message edited by: Sanju Sharma ]