Hi

I tried to implement 2 Phase commit in websphere application server V5.0,and my Oraacle version is 9.2.0.1



These are the settings i have done in Admin Console i have used


1) Oracle JDBC Thin Driver (XA)

2) classpath is : ojdbc14.jar

3)Implementation class name is :oracle.jdbc.xa.client.OracleXADataSource

and created the datasources





When i run the application .I am getting the error message as

XAER_RMERR. Exception is: null





and in the stack trace i am getting this exception




org.omg.CORBA.TRANSACTION_ROLLEDBACK: com.ibm.websphere.csi.CSITransactionRolledbackException: at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:546) at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:128) at com.ibm.ejs.csi.RequiresNew.postInvoke(RequiresNew.java:85) at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:531) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2801) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2681) at EJSRemoteStatelessTestEJB_c8de4a21.testXA(EJSRemoteStatelessTestEJB_c8de4a21.java:38) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie.testXA_(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:151) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie._invoke(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:74) at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:582) at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:437) at com.ibm.rmi.iiop.ORB.process(ORB.java:320) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1544) at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2063) at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63) at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) :javax.transaction.TransactionRolledbackException: com.ibm.websphere.csi.CSITransactionRolledbackException: at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:546) at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:128) at com.ibm.ejs.csi.RequiresNew.postInvoke(RequiresNew.java:85) at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:531) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2801) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2681) at EJSRemoteStatelessTestEJB_c8de4a21.testXA(EJSRemoteStatelessTestEJB_c8de4a21.java:38) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie.testXA_(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:151) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie._invoke(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:74) at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:582) at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:437) at com.ibm.rmi.iiop.ORB.process(ORB.java:320) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1544) at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2063) at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63) at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) at com.ibm.ejs.container.util.ExceptionUtil.mapCSIException(ExceptionUtil.java:51) at com.ibm.ejs.container.RemoteExceptionMappingStrategy.mapCSITransactionRolledBackException(RemoteExceptionMapp ingStrategy.java:207) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2858) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2681) at EJSRemoteStatelessTestEJB_c8de4a21.testXA(EJSRemoteStatelessTestEJB_c8de4a21.java:38) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie.testXA_(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:151) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie._invoke(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:74) at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:582) at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:437) at com.ibm.rmi.iiop.ORB.process(ORB.java:320) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1544) at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2063) at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63) at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) minor code: 0 completed: No at com.ibm.ejs.csi.OrbUtilsImpl.mapException(OrbUtilsImpl.java:80) at com.ibm.ejs.container.RemoteExceptionMappingStrategy.mapCSITransactionRolledBackException(RemoteExceptionMapp ingStrategy.java:207) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2858) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2681) at EJSRemoteStatelessTestEJB_c8de4a21.testXA(EJSRemoteStatelessTestEJB_c8de4a21.java:38) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie.testXA_(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:151) at _EJSRemoteStatelessTestEJB_c8de4a21_Tie._invoke(_EJSRemoteStatelessTestEJB_c8de4a21_Tie.java:74) at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:582) at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:437) at com.ibm.rmi.iiop.ORB.process(ORB.java:320) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1544) at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2063) at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63) at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))









Can any one help me how to fix this issue.




Regards

Arun Kumar X