环境：aix oracle was6.1
[13-1-4 14:00:25:584 GMT+08:00] 00014567 MCWrapper E J2CA0081E: 尝试在资源 No longer available 的 ManagedConnection WSRdbManagedConnectionImpl@76b276b2 上执行方法 destroy 时方法 destroy 失败。捕获到异常：com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Io 异常: A remote host did not respond within the timeout period.. with SQL State : null SQL Code : 17002
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.setLinkedException(DataStoreAdapterException.java:464)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2232)
at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1265)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3282)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1786)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:726)
at com.ibm.ejs.j2c.PoolManager.reclaimConnections(PoolManager.java:4256)
at com.ibm.ejs.j2c.PoolManager.executeTask(PoolManager.java:4138)
at com.ibm.ejs.j2c.TaskTimer.run(TaskTimer.java:89)
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: A remote host did not respond within the timeout period.DSRA0010E: SQL 状态 = null，错误代码 = 17,002
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:67)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:522)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:525)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:580)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2160)
... 7 more
---- Begin backtrace for Nested Throwables
java.sql.SQLException: Io 异常: A remote host did not respond within the timeout period.DSRA0010E: SQL 状态 = null，错误代码 = 17,002
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:393)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1036)
at oracle.jdbc.pool.OraclePooledConnection.close(OraclePooledConnection.java:220)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3275)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1786)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:726)
at com.ibm.ejs.j2c.PoolManager.reclaimConnections(PoolManager.java:4256)
at com.ibm.ejs.j2c.PoolManager.executeTask(PoolManager.java:4138)
at com.ibm.ejs.j2c.TaskTimer.run(TaskTimer.java:89)
收起