Support Article
Method destroy failed when trying to executeon ManagedConnection
SA-33130
Summary
Method destroy failed while trying to execute method destroy on ManagedConnection
Error Messages
1/25/17 13:45:57:332 CST] 0000008e FfdcProvider W com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on /apps_01/webapps/BaseXPWAS8_profile/logs/ffdc/XP2_server0_83b4d329_17.01.25_13.45.57.3282069304147777525163.txt com.ibm.ejs.container.LocalExceptionMappingStrategy.setUncheckedException 178
[1/25/17 13:45:57:358 CST] 0000008e FfdcProvider W com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on /apps_01/webapps/BaseXPWAS8_profile/logs/ffdc/XP2_server0_83b4d329_17.01.25_13.45.57.3338276440138716568418.txt com.ibm.ejs.j2c.MCWrapper.destroy 797
[1/25/17 13:45:57:358 CST] 0000008e MCWrapper E J2CA0081E: Method destroy failed while trying to execute method destroy on ManagedConnection WSRdbManagedConnectionImpl@8639ff16 from resource No longer available. Caught exception: java.lang.NullPointerException
at oracle.jdbc.pool.OraclePooledConnection.removeFromImplictCache(OraclePooledConnection.java:1064)
at oracle.jdbc.pool.OracleImplicitConnectionCache.storeCacheConnection(OracleImplicitConnectionCache.java:1470)
at oracle.jdbc.pool.OracleImplicitConnectionCache.reusePooledConnection(OracleImplicitConnectionCache.java:1727)
at oracle.jdbc.pool.OracleConnectionCacheEventListener.connectionClosed(OracleConnectionCacheEventListener.java:87)
at oracle.jdbc.pool.OraclePooledConnection.callImplicitCacheListener(OraclePooledConnection.java:622)
at oracle.jdbc.pool.OraclePooledConnection.logicalCloseForImplicitConnectionCache(OraclePooledConnection.java:536)
at oracle.jdbc.pool.OraclePooledConnection.logicalClose(OraclePooledConnection.java:557)
at oracle.jdbc.driver.LogicalConnection.closeInternal(LogicalConnection.java:309)
at oracle.jdbc.driver.LogicalConnection.close(LogicalConnection.java:274)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3873)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:2087)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:2954)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2608)
at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1295)
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.driveSynchronization(LocalTranCoordImpl.java:581)
at com.ibm.tx.ltc.embeddable.impl.EmbeddableLocalTranCoordImpl.informSynchronizations(EmbeddableLocalTranCoordImpl.java:220)
Steps to Reproduce
Configure Oracle RAC (Real Application Cluster) datasource in Websphere.
Root Cause
A third-party product issue. Did not follow the IBM Websphere Oracle RAC datasource setup.
Resolution
Make the following change to the operating environment:
The following custom properties for the datasource need to follow the exact order:
disableWASConnectionPooling
connectionCachingEnabled
connectionCacheName
removeExistingOracleConnectionPoolIfExists
Refer to the relevant IBM documentation if needed.
Published February 4, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.