In my application we are using websphere6.0 after server starts, first time when i tried to login in my application am getting the following exception can any one of you help me out... thanks in advance ..
[11/4/08 12:08:57:800 IST] 0000002a StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -4499 and SQLState <null>, to a StaleConnectionException: com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: Connection reset. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
at com.ibm.db2.jcc.a.a.a(a.java:428)
at com.ibm.db2.jcc.a.ab.b(ab.java(Compiled Code))
at com.ibm.db2.jcc.a.ab.c(ab.java(Inlined Compiled Code))
at com.ibm.db2.jcc.a.ab.c(ab.java(Compiled Code))
at com.ibm.db2.jcc.a.ab.v(ab.java(Inlined Compiled Code))
at com.ibm.db2.jcc.a.db.a(db.java(Compiled Code))
at com.ibm.db2.jcc.a.r.a(r.java(Inlined Compiled Code))
at com.ibm.db2.jcc.a.sb.g(sb.java(Compiled Code))
at com.ibm.db2.jcc.b.zc.n(zc.java(Compiled Code))
at com.ibm.db2.jcc.b.zc.a(zc.java:1857)
at com.ibm.db2.jcc.b.zc.e(zc.java:775)
at com.ibm.db2.jcc.b.zc.execute(zc.java:759)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.preTestConnection(WSRdbManagedConnectionImpl.java:4186)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java(Compiled Code))
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:618)
at com.ibm.ejs.j2c.poolmanager.FreePool.removeCleanupAndDestroyAllFreeConnections(FreePool.java:1766)
at com.ibm.ejs.j2c.poolmanager.PoolManager.fatalErrorNotification(PoolManager.java:1045)
at com.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:1896)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:324)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:1943)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1251)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:881)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java(Compiled Code))
at org.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code))
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java(Compiled Code))
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java(Compiled Code))
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java(Compiled Code))
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java(Compiled Code))
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java(Compiled Code))
at com.visiontss.muis.dao.DataAccessObject.executeHQL(DataAccessObject.java(Compiled Code))
at com.visiontss.muis.dao.hb.DataConstantHBDAO.findAll(DataConstantHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.findAll(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.DataConstant.findAll(DataConstant.java(Inlined Compiled Code))
at com.visiontss.muis.constants.MuisConstants.initialize(MuisConstants.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.constructQuery(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.search(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.search(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getScrollCollection(OrganizationLevel.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.initialize(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getRollId(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.dao.hb.EmployeeHBDAO.getEmpTypeId(EmployeeHBDAO.java:2859)
at com.visiontss.muis.dao.hb.EmployeeHBDAO.read(EmployeeHBDAO.java:3009)
at com.visiontss.muis.bo.BusinessObject.read(BusinessObject.java(Compiled Code))
at com.visiontss.muis.bo.Employee.empTypeId(Employee.java:1331)
at com.visiontss.muis.manager.EmployeeManager.getEmpTypeId(EmployeeManager.java:356)
at com.visiontss.muis.bao.EmployeeBAO.getEmpTypeId(EmployeeBAO.java:489)
at com.visiontss.muis.facade.ejb.EmployeeFacadeBean.getEmpTypeId(EmployeeFacadeBean.java:298)
at com.visiontss.muis.facade.ejb.EJSRemoteStatelessEmployeeFacade_90f5587e.getEmpTypeId(EJSRemoteStatelessEmployeeFacade_90f5587e.java:468)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java(Compiled Code))
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy25.getEmpTypeId(Unknown Source)
at com.visiontss.muis.facade.ejb._EmployeeFacade_Stub.getEmpTypeId(_EmployeeFacade_Stub.java:984)
at com.visiontss.muis.web.action.EmployeeListAction.executeAction(EmployeeListAction.java:160)
at com.visiontss.muis.web.action.MuisAction.execute(MuisAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined Compiled Code))
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled Code))
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[11/4/08 12:08:57:815 IST] 0000002a MCWrapper E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection WSRdbManagedConnectionImpl@782c45f6 from resource No longer available. Caught exception: com.ibm.ws.exception.WsException: DSRA1130E: A fatal connection error occurred on another connection while this connection was active. This connection cannot be reset to a usable state.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:224)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:175)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:232)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java(Compiled Code))
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:618)
at com.ibm.ejs.j2c.poolmanager.FreePool.removeCleanupAndDestroyAllFreeConnections(FreePool.java:1766)
at com.ibm.ejs.j2c.poolmanager.PoolManager.fatalErrorNotification(PoolManager.java:1045)
at com.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:1896)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:324)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:1943)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1251)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:881)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java(Compiled Code))
at org.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code))
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java(Compiled Code))
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java(Compiled Code))
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java(Compiled Code))
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java(Compiled Code))
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java(Compiled Code))
at com.visiontss.muis.dao.DataAccessObject.executeHQL(DataAccessObject.java(Compiled Code))
at com.visiontss.muis.dao.hb.DataConstantHBDAO.findAll(DataConstantHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.findAll(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.DataConstant.findAll(DataConstant.java(Inlined Compiled Code))
at com.visiontss.muis.constants.MuisConstants.initialize(MuisConstants.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.constructQuery(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.search(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.search(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getScrollCollection(OrganizationLevel.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.initialize(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getRollId(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.dao.hb.EmployeeHBDAO.getEmpTypeId(EmployeeHBDAO.java:2859)
at com.visiontss.muis.dao.hb.EmployeeHBDAO.read(EmployeeHBDAO.java:3009)
at com.visiontss.muis.bo.BusinessObject.read(BusinessObject.java(Compiled Code))
at com.visiontss.muis.bo.Employee.empTypeId(Employee.java:1331)
at com.visiontss.muis.manager.EmployeeManager.getEmpTypeId(EmployeeManager.java:356)
at com.visiontss.muis.bao.EmployeeBAO.getEmpTypeId(EmployeeBAO.java:489)
at com.visiontss.muis.facade.ejb.EmployeeFacadeBean.getEmpTypeId(EmployeeFacadeBean.java:298)
at com.visiontss.muis.facade.ejb.EJSRemoteStatelessEmployeeFacade_90f5587e.getEmpTypeId(EJSRemoteStatelessEmployeeFacade_90f5587e.java:468)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java(Compiled Code))
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy25.getEmpTypeId(Unknown Source)
at com.visiontss.muis.facade.ejb._EmployeeFacade_Stub.getEmpTypeId(_EmployeeFacade_Stub.java:984)
at com.visiontss.muis.web.action.EmployeeListAction.executeAction(EmployeeListAction.java:160)
at com.visiontss.muis.web.action.MuisAction.execute(MuisAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined Compiled Code))
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled Code))
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[11/4/08 12:08:57:831 IST] 0000002a AbstractBatch W exception clearing maxRows/queryTimeout
[11/4/08 12:08:57:847 IST] 0000002a AbstractBatch W TRAS0014I: The following exception was logged com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java(Inlined Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java(Compiled Code))
at org.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code))
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java(Compiled Code))
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java(Compiled Code))
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java(Compiled Code))
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java(Compiled Code))
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java(Compiled Code))
at com.visiontss.muis.dao.DataAccessObject.executeHQL(DataAccessObject.java(Compiled Code))
at com.visiontss.muis.dao.hb.DataConstantHBDAO.findAll(DataConstantHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.findAll(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.DataConstant.findAll(DataConstant.java(Inlined Compiled Code))
at com.visiontss.muis.constants.MuisConstants.initialize(MuisConstants.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.constructQuery(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.search(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.search(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getScrollCollection(OrganizationLevel.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.initialize(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getRollId(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.dao.hb.EmployeeHBDAO.getEmpTypeId(EmployeeHBDAO.java:2859)
at com.visiontss.muis.dao.hb.EmployeeHBDAO.read(EmployeeHBDAO.java:3009)
at com.visiontss.muis.bo.BusinessObject.read(BusinessObject.java(Compiled Code))
at com.visiontss.muis.bo.Employee.empTypeId(Employee.java:1331)
at com.visiontss.muis.manager.EmployeeManager.getEmpTypeId(EmployeeManager.java:356)
at com.visiontss.muis.bao.EmployeeBAO.getEmpTypeId(EmployeeBAO.java:489)
at com.visiontss.muis.facade.ejb.EmployeeFacadeBean.getEmpTypeId(EmployeeFacadeBean.java:298)
at com.visiontss.muis.facade.ejb.EJSRemoteStatelessEmployeeFacade_90f5587e.getEmpTypeId(EJSRemoteStatelessEmployeeFacade_90f5587e.java:468)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java(Compiled Code))
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy25.getEmpTypeId(Unknown Source)
at com.visiontss.muis.facade.ejb._EmployeeFacade_Stub.getEmpTypeId(_EmployeeFacade_Stub.java:984)
at com.visiontss.muis.web.action.EmployeeListAction.executeAction(EmployeeListAction.java:160)
at com.visiontss.muis.web.action.MuisAction.execute(MuisAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined Compiled Code))
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled Code))
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
.
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java(Inlined Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java(Compiled Code))
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java(Compiled Code))
at org.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code))
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java(Compiled Code))
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java(Compiled Code))
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java(Compiled Code))
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java(Compiled Code))
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java(Compiled Code))
at com.visiontss.muis.dao.DataAccessObject.executeHQL(DataAccessObject.java(Compiled Code))
at com.visiontss.muis.dao.hb.DataConstantHBDAO.findAll(DataConstantHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.findAll(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.DataConstant.findAll(DataConstant.java(Inlined Compiled Code))
at com.visiontss.muis.constants.MuisConstants.initialize(MuisConstants.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.constructQuery(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.dao.hb.OrganizationLevelHBDAO.search(OrganizationLevelHBDAO.java(Compiled Code))
at com.visiontss.muis.bo.BusinessObject.search(BusinessObject.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getScrollCollection(OrganizationLevel.java(Inlined Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.initialize(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.bo.OrganizationLevel.getRollId(OrganizationLevel.java(Compiled Code))
at com.visiontss.muis.dao.hb.EmployeeHBDAO.getEmpTypeId(EmployeeHBDAO.java:2859)
at com.visiontss.muis.dao.hb.EmployeeHBDAO.read(EmployeeHBDAO.java:3009)
at com.visiontss.muis.bo.BusinessObject.read(BusinessObject.java(Compiled Code))
at com.visiontss.muis.bo.Employee.empTypeId(Employee.java:1331)
at com.visiontss.muis.manager.EmployeeManager.getEmpTypeId(EmployeeManager.java:356)
at com.visiontss.muis.bao.EmployeeBAO.getEmpTypeId(EmployeeBAO.java:489)
at com.visiontss.muis.facade.ejb.EmployeeFacadeBean.getEmpTypeId(EmployeeFacadeBean.java:298)
at com.visiontss.muis.facade.ejb.EJSRemoteStatelessEmployeeFacade_90f5587e.getEmpTypeId(EJSRemoteStatelessEmployeeFacade_90f5587e.java:468)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java(Compiled Code))
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy25.getEmpTypeId(Unknown Source)
at com.visiontss.muis.facade.ejb._EmployeeFacade_Stub.getEmpTypeId(_EmployeeFacade_Stub.java:984)
at com.visiontss.muis.web.action.EmployeeListAction.executeAction(EmployeeListAction.java:160)
at com.visiontss.muis.web.action.MuisAction.execute(MuisAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined Compiled Code))
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled Code))
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[11/4/08 12:08:57:847 IST] 0000002a JDBCException W SQL Error: -4499, SQLState: null
[11/4/08 12:08:57:847 IST] 0000002a JDBCException E A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: Connection reset. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
[11/4/08 12:08:57:862 IST] 0000002a JDBCException W SQL Error: -4499, SQLState: null
[11/4/08 12:08:57:862 IST] 0000002a JDBCException E A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: Connection reset. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
[11/4/08 12:08:57:894 IST] 0000002a JDBCException W SQL Error: -99999, SQLState: null
[11/4/08 12:08:57:894 IST] 0000002a JDBCException E Invalid operation: statement closed
[11/4/08 12:08:57:909 IST] 0000002a JDBCException W SQL Error: -99999, SQLState: null
[11/4/08 12:08:57:909 IST] 0000002a JDBCException E Invalid operation: statement closed
[11/4/08 12:08:57:909 IST] 0000002a JDBCException W SQL Error: -99999, SQLState: null
[11/4/08 12:08:57:925 IST] 0000002a JDBCException E Invalid operation: statement closed
[11/4/08 12:08:57:925 IST] 0000002a ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getEmpTypeId" on bean "BeanId(MUISEJBEAR#MUISFACADEEJB.jar#EmployeeFacade, null)". Exception data: java.lang.NumberFormatException: null
at java.lang.Long.parseLong(Long.java(Compiled Code))
at java.lang.Long.<init>(Long.java:644)
at com.visiontss.muis.dao.hb.EmployeeHBDAO.getEmpTypeId(EmployeeHBDAO.java:2861)
at com.visiontss.muis.dao.hb.EmployeeHBDAO.read(EmployeeHBDAO.java:3009)
at com.visiontss.muis.bo.BusinessObject.read(BusinessObject.java(Compiled Code))
at com.visiontss.muis.bo.Employee.empTypeId(Employee.java:1331)
at com.visiontss.muis.manager.EmployeeManager.getEmpTypeId(EmployeeManager.java:356)
at com.visiontss.muis.bao.EmployeeBAO.getEmpTypeId(EmployeeBAO.java:489)
at com.visiontss.muis.facade.ejb.EmployeeFacadeBean.getEmpTypeId(EmployeeFacadeBean.java:298)
at com.visiontss.muis.facade.ejb.EJSRemoteStatelessEmployeeFacade_90f5587e.getEmpTypeId(EJSRemoteStatelessEmployeeFacade_90f5587e.java:468)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java(Compiled Code))
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy25.getEmpTypeId(Unknown Source)
at com.visiontss.muis.facade.ejb._EmployeeFacade_Stub.getEmpTypeId(_EmployeeFacade_Stub.java:984)
at com.visiontss.muis.web.action.EmployeeListAction.executeAction(EmployeeListAction.java:160)
at com.visiontss.muis.web.action.MuisAction.execute(MuisAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined Compiled Code))
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled Code))
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[11/4/08 12:08:57:956 IST] 0000002a WSRdbManagedC W DSRA0180W: Exception detected during ManagedConnection.destroy(). The exception is: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: invalid operation: connection closed. with SQL State : null SQL Code : -99999
at com.ibm.db2.jcc.b.o.yb(o.java(Compiled Code))
at com.ibm.db2.jcc.b.o.rollback(o.java:1170)
at com.ibm.db2.jcc.b.wb.rollback(wb.java:166)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:2681)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1489)
at com.ibm.ejs.j2c.poolmanager.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:632)
at com.ibm.ejs.j2c.poolmanager.FreePool.returnToFreePool(FreePool.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.PoolManager.release(PoolManager.java(Compiled Code))
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java(Inlined Compiled Code))
at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeAfter(RegisteredSyncs.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.TransactionImpl.distributeAfter(TransactionImpl.java(Inlined Compiled Code))
at com.ibm.ws.Transaction.JTA.TransactionImpl.postCompletion(TransactionImpl.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.TransactionImpl.internalRollback(TransactionImpl.java:2368)
at com.ibm.ws.Transaction.JTA.TransactionImpl.rollback(TransactionImpl.java:1698)
at com.ibm.ws.Transaction.JTA.TranManagerImpl.rollback(TranManagerImpl.java:274)
at com.ibm.ws.Transaction.JTA.TranManagerSet.rollback(TranManagerSet.java:181)
at com.ibm.ejs.csi.TranStrategy.rollback(TranStrategy.java:911)
at com.ibm.ejs.csi.TranStrategy.handleException(TranStrategy.java:220)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java(Compiled Code))
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled Code))
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled Code))
at com.visiontss.muis.facade.ejb.EJSRemoteStatelessEmployeeFacade_90f5587e.getEmpTypeId(EJSRemoteStatelessEmployeeFacade_90f5587e.java:480)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java(Compiled Code))
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy25.getEmpTypeId(Unknown Source)
at com.visiontss.muis.facade.ejb._EmployeeFacade_Stub.getEmpTypeId(_EmployeeFacade_Stub.java:984)
at com.visiontss.muis.web.action.EmployeeListAction.executeAction(EmployeeListAction.java:160)
at com.visiontss.muis.web.action.MuisAction.execute(MuisAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined Compiled Code))
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled Code))
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.sql.SQLException: invalid operation: connection closedDSRA0010E: SQL State = null, Error Code = -99,999
... 59 more
Read this:
http://hibernate.org/42.html