Hi
I have an issue where by when ever I stop the applciation server, DB connections errors are thrown. I think its because of an application bug but proving that is proving diffcult.
I have checked on IBM's website, but the closes match I could find was a resolution with fixpack 21 which I have.
I used the support assistant workbench but this didnt provide any further insight.
Here is the error that Im getting only when I stop the JVM;
[2/21/14 7:38:04:386 SAST] 00000010 MCWrapper E J2CA0081E: Method destroy failed while trying to execute method destroy on ManagedConnection WSRdbManagedConnectionImpl@7dfa7dfa from resource No longer available. Caught exception: co
m.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: [jcc][t4][2027][11212][3.62.57] A connection failed but has been re-established. The host name or IP address i
s "RBGUATDB2001.fnb.co.za" and the service name or port number is 50,800.
Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=08506. with SQL State : 08506 SQL Code : -4498
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:3266)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1784)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:724)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyAllFreeConnections(FreePool.java:2446)
at com.ibm.ejs.j2c.PoolManager.serverShutDown(PoolManager.java:1496)
at com.ibm.ejs.j2c.ConnectionServerShutDownFactoryImpl.shutdown(ConnectionServerShutDownFactoryImpl.java:94)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.shutdown(RALifeCycleManagerImpl.java:1417)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.stop(RALifeCycleManagerImpl.java:457)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ApplicationServerImpl.stop(ApplicationServerImpl.java:227)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ServerImpl.stop(ServerImpl.java:625)
at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook$1.run(ServerCollaborator.java:687)
at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4158)
at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4255)
at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook.run(ServerCollaborator.java:677)
at com.ibm.ws.runtime.component.ServerCollaborator$StopAction.alarm(ServerCollaborator.java:641)
at com.ibm.ejs.util.am._Alarm.run(_Alarm.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: [jcc][t4][2027][11212][3.62.57] A connection failed but has been re-established. The host name or IP address is "RBGUATDB2001.fnb.co.za" and the service name or port number is 5
0,800.
Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=08506DSRA0010E: SQL State = 08506, Error Code = -4,498
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)
... 22 more
---- Begin backtrace for Nested Throwables
java.sql.SQLException: [jcc][t4][2027][11212][3.62.57] A connection failed but has been re-established. The host name or IP address is "RBGUATDB2001.fnb.co.za" and the service name or port number is 50,800.
Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=08506DSRA0010E: SQL State = 08506, Error Code = -4,498
at com.ibm.db2.jcc.am.fd.a(fd.java:304)
at com.ibm.db2.jcc.am.fd.a(fd.java:356)
at com.ibm.db2.jcc.t4.a.a(a.java:476)
at com.ibm.db2.jcc.t4.a.L(a.java:1046)
at com.ibm.db2.jcc.t4.a.a(a.java:921)
at com.ibm.db2.jcc.t4.a.C(a.java:395)
at com.ibm.db2.jcc.t4.a.r(a.java:354)
at com.ibm.db2.jcc.am.o.i(o.java:228)
at com.ibm.db2.jcc.am.jb.z(jb.java:1333)
at com.ibm.db2.jcc.t4.b.z(b.java:4470)
at com.ibm.db2.jcc.am.jb.y(jb.java:1314)
at com.ibm.db2.jcc.am.df.close(df.java:80)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3260)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1784)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:724)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyAllFreeConnections(FreePool.java:2446)
at com.ibm.ejs.j2c.PoolManager.serverShutDown(PoolManager.java:1496)
at com.ibm.ejs.j2c.ConnectionServerShutDownFactoryImpl.shutdown(ConnectionServerShutDownFactoryImpl.java:94)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.shutdown(RALifeCycleManagerImpl.java:1417)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.stop(RALifeCycleManagerImpl.java:457)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ApplicationServerImpl.stop(ApplicationServerImpl.java:227)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)