hi,
While my app server not doing any transaction and it is in stand by mode. I lost my oracle database connection and but it came up again. however ,when I try to use the connection at the time of time. It gave me following error. I am using Oracle 9.2 XA driver . Appserver is Websphere 5.1.
I think ,connection pool knew about his oracle connection went down ,but he doesn't know that it came back.. or no retry
Please help me on resolving this.
Thanks
JK
[10/11/05 14:23:00:156 LKT] 7b6baf1b WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -3
The XA Error message is : A resource manager error has occured in the transaction branch.
The Oracle Error code is : 65535
The Oracle Error message is: Internal XA Error
The cause is : null.
[10/11/05 14:23:00:406 LKT] 7b6baf1b WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
[10/11/05 14:23:00:984 LKT] 7b6baf1b RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:927)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1267)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:164)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:390)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1903)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1456)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:349)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:762)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:741)
at com.isi.oms.dao.AuthenticateDAOImplDBOracle.isValidSession(AuthenticateDAOImplDBOracle.java:464)
at com.isi.oms.session.UserManagementSessionFacadeBean.isValidSession(UserManagementSessionFacadeBean.java:176)
at com.isi.oms.session.EJSRemoteStatelessUserManagementSessionFacade_60765d2c.isValidSession(EJSRemoteStatelessUserManagementSessionFacade_60765d2c.java:22)