Two-phase-commit problem Websphere 4.03/Oracle 8.1.7

Hi,

I have a problem that occurs at the postinvoke stage after running a method in an enterprise bean (sessionless with container managed persistance). The method operates on data from two datasource (read from one and read/write from/to the other). Both datasources are defined as oracle.jdbc.xa.client.OracleXADataSource.

This problem occurs when running postinvoke:

java.sql.SQLException: ORA-02051: another session in same transaction failed

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
	at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
	at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
	at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:265)
	at com.ibm.ejs.jts.jta.XARminst.endAssociation(XARminst.java:365)
	at com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.completionPreinvoke(JTAXAResourceImpl.java:707)
	at com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.commit_one_phase(JTAXAResourceImpl.java:303)
	at com.ibm.ejs.jts.jts.ResourceVector.deliverPrepare(ResourceVector.java:200)
	at com.ibm.ejs.jts.jts.ResourceVector.beforePrepare(ResourceVector.java:185)
	at com.ibm.ejs.jts.tran.EventCallback.executeCallback(EventCallback.java:161)
	at com.ibm.ejs.jts.tran.EventCallback.executeCallbackTree(EventCallback.java:132)
	at com.ibm.ejs.jts.tran.EventCallback.executeCallbackTree(EventCallback.java:123)
	at com.ibm.ejs.jts.tran.EventPrepare.ExecuteBeforePrepareCallbacks(EventPrepare.java:302)
	at com.ibm.ejs.jts.tran.EventPrepare.event_LocalPrepareWork(EventPrepare.java:277)
	at com.ibm.ejs.jts.tran.EventPrepare.event_BecomeCoordinator(EventPrepare.java:960)
	at com.ibm.ejs.jts.tran.EventControl.event_EndTopLevel(EventControl.java:295)
	at com.ibm.ejs.jts.tran.TrecInterface.end(TrecInterface.java:88)
	at com.ibm.ejs.jts.jts.TerminatorImpl.commit(TerminatorImpl.java:89)
	at com.ibm.ejs.jts.jts.CurrentImpl.commit(CurrentImpl.java:200)
	at com.ibm.ejs.jts.jts.CurrentSet.commit(CurrentSet.java:256)
	at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:190)
	at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:67)
	at com.ibm.ejs.csi.RequiresNew.postInvoke(RequiresNew.java:54)
	at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:414)
	at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:1772)
	at com.statoil.eports.partneraccounting.bo.EJSRemoteStatelessIntSportLiftingsBO.transferSportLiftings(EJSRemoteStatelessIntSportLiftingsBO.java:40)
	at com.statoil.eports.partneraccounting.bo._EJSRemoteStatelessIntSportLiftingsBO_Tie._invoke(_EJSRemoteStatelessIntSportLiftingsBO_Tie.java:105)
	at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java:506)
	at com.ibm.CORBA.iiop.ORB.process(ORB.java:2362)
	at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java:185)
	at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java:104)
	at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

Any help would be appreciated!

Staale Received on Fri Jun 13 2003 - 08:32:24 CDT