aspose file tools*
The moose likes JDBC and the fly likes com.ibm.websphere.ce.cm.StaleConnectionException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "com.ibm.websphere.ce.cm.StaleConnectionException" Watch "com.ibm.websphere.ce.cm.StaleConnectionException" New topic
Author

com.ibm.websphere.ce.cm.StaleConnectionException

weyman tan
Greenhorn

Joined: Dec 19, 2011
Posts: 3
Does any one can tell me why com.ibm.websphere.ce.cm.StaleConnectionException is thrown?

System out:
[1/3/12 6:01:15:336 CST] 0000006e WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -7
The XA Error message is : Resource manager is unavailable.
The Oracle Error code is : 17002
The Oracle Error message is: Internal XA Error
The cause is : null.
[1/3/12 6:01:15:345 CST] 0000006e WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMFAIL (-7). Exception is: <null>
[1/3/12 6:01:15:349 CST] 0000006e ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for
resource jdbc/pems01. The exception which was received is oracle.jdbc.xa.OracleXAException
[1/3/12 6:01:15:833 CST] 0000006e RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has res
ulted in an error. The error code was XAER_RMFAIL. The exception stack trace follows: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1045)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:249)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1352)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1289)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:144)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1232)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:647)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3219)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:384)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1934)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2065)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:559)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1893)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1848)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProx
y.java:169)
at $Proxy135.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:167)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:215)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:169)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:213)

Log4j output:
06:02:10,673 [Thread-2][ERROR DefaultErrorHandlerImpl.processError 22] OnlineBusinessDateWorker - Failed to doBatch RemoteException ERROR:java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: ; nested exception is:
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in resources/ss/ibatis/UserSQL.xml.
--- The error occurred while executing query.
--- Check the <sql statement>
--- Check the SQL Statement (preparation failed).
--- Cause: com.ibm.websphere.ce.cm.StaleConnectionException: enlist: caught Exception; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

 
 
subject: com.ibm.websphere.ce.cm.StaleConnectionException