BossLog: { 0071} 2007/01/29 13:14:56.079 01 SYSTEM=D102 SERVER=WCS012 PID=0X0400038E TID=0X163EF320 0X000020 c=C.1
./bborjtr.cpp+861 ... BBOO0221W DSRA8650W: Error closing a JDBC child wrapper, com.ibm.ws.rsadapter.jdbc.WSJccResultSet@1b95f419
com.ibm.db2.jcc.t2zos.y: [IBM/DB2][T2zos/2.8.49]T2zosResultSet.readCursorClose:nativeCloseCursor:3009:DB2 engine SQL
error, SQLCODE = -501, SQLSTATE = 24501, error tokens =
at com.ibm.db2.jcc.t2zos.x.a(x.java:48)
at com.ibm.db2.jcc.t2zos.x.a(x.java:738)
at com.ibm.db2.jcc.t2zos.x.a(x.java:814)
at com.ibm.db2.jcc.t2zos.T2zosResultSet.Ib(T2zosResultSet.java:870)
at com.ibm.db2.jcc.c.jf.i(jf.java:533)
at com.ibm.db2.jcc.c.jf.g(jf.java:512)
at com.ibm.db2.jcc.c.jf.e(jf.java:473)
at com.ibm.db2.jcc.c.jf.close(jf.java:458)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.closeWrapper(WSJdbcResultSet.java:257)
at com.ibm.ws.rsadapter.jdbc.WSJccResultSet.closeWrapper(WSJccResultSet.java:73)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:126)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.closeChildWrappers(WSJdbcObject.java:162)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:125)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.closeChildWrappers(WSJdbcObject.java:162)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.dissociate(WSJdbcConnection.java:916)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.dissociateHandles(WSRdbManagedConnectionImpl.java:2195)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:2318)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1188)
at com.ibm.ejs.j2c.poolmanager.FreePool.returnToFreePool(FreePool.java:328)
at com.ibm.ejs.j2c.poolmanager.PoolManager.release(PoolManager.java:1283)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:1697)
at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletionCode(LocalTransactionWrapper.java:1075)
at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1012)
at com.ibm.ws390.tx.TransactionSynchronizer.afterCompletion(TransactionSynchronizer.java:220)
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.informSynchronizations(LocalTranCoordImpl.java:1404)
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1125)
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.end(LocalTranCoordImpl.java:1236)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:687)
at com.ibm.ejs.csi.BeanManaged.postInvoke(BeanManaged.java:304)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:574)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3136)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2992)
at com.test.ejbs.EJSRemoteStatelessZTRScreener_96160c49.getReport(EJSRemoteStatelessZTRScreener_96160c49
.java:51)
at com.test.ejbs._ZTRScreener_Stub.getAuditReport(_ZTRScreener_Stub.java:352)
at com.test.AuditReportWorker.getAuditReport(AuditReportWorker.java:72)
at com.test.CaseMgrAuditReportServlet.generatePDFOutput(CaseMgrAuditReportServlet.java:119)
at com.test.CaseMgrAuditReportServlet.doPost(CaseMgrAuditReportServlet.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:292)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:47)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1031)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:598)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:208)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:127)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:286)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:290)
at com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.dispatch(WS390Router.java:405)
at com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.dispatchByURI(WS390Router.java:364)
at com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.service(WS390Router.java:318)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:69)
at com.ibm.ws390.wc.http.HttpConnection.readAndHandleRequest(HttpConnection.java:810)
at com.ibm.ws390.wc.http.HttpConnection.handle390Request(HttpConnection.java:701)
at com.ibm.ws390.wc.httpcatcher.WS390HttpTransport.handleRequest(WS390HttpTransport.java:94)
at com.ibm.ws390.wc.httpcatcher.WS390HttpTransportWrapper.httprequest(WS390HttpTransportWrapper.java:58)
at com.ibm.ws390.orb.ServerRegionBridge.httpinvoke(ServerRegionBridge.java:683)
at com.ibm.ws390.orb.ORBEJSBridge.httpinvoke(ORBEJSBridge.java:196)
at com.ibm.ws390.orb.parameters.HTTPInvoke.HTTPInvokeParmSetter(HTTPInvoke.java:84)
BossLog: { 0072} 2007/01/29 13:14:56.089 01 SYSTEM=D102 SERVER=WCS012 PID=0X0400038E TID=0X163EF320 0X000020 c=C.1
./bborjtr.cpp+861 ... BBOO0220E WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback. com.ibm.ws.LocalTransaction.LocalTranCoordImpl com.ibm.ws.LocalTransaction.LocalTranCoordImpl
BossLog: { 0073} 2007/01/29 13:18:02.000 01 SYSTEM=D102 SERVER=WCS012 PID=0X0400038E TID=0X163EF320 0X000020 c=F.1
When I test the same on my WSAD 5.1, things seem to work fine and I get the required result without a problem. But its only when I port it to WAS 5.1 I start experiecing the above errors.
I had read on many forums and in various sites, stating that this error is a result of a Cursor(ResultSet) being read after its closed. This is surely not an issue with the code but something with the DB2 driver end as it seems so from the stack.
This is quite urgent and any help on this would be greatly appreciated.