0 Replies Latest reply on Apr 19, 2018 7:30 AM by nishanth2601

    Connection handle has been closed and is unusable

    nishanth2601

      Hi,

       

      I am frequently getting below error and my jboss-7 getting crashed.

       

       

      11:15:44,123 ERROR [lsi.common.security.validator.CoreLogger] (http-/0.0.0.0:8109-587) IN dataaccessmanager catch block

      11:15:44,123 ERROR [lsi.common.security.validator.CoreLogger] (http-/0.0.0.0:8109-587) Exception MesageConnection handle has been closed and is unusable

      11:15:44,123 ERROR [lsi.common.security.validator.CoreLogger] (http-/0.0.0.0:8109-676) IN dataaccessmanager catch block

      11:15:44,123 ERROR [lsi.common.security.validator.CoreLogger] (http-/0.0.0.0:8109-676) Exception MesageConnection handle has been closed and is unusable

      11:15:44,123 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/JCMWeb].[XMLHTTPListener]] (http-/0.0.0.0:8109-587) JBWEB000236: Servlet.service() for servlet XMLHTTPListener threw exception: java.sql.SQLException: Connection handle has been closed and is unusable

          at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1616)

          at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1593)

          at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:398)

          at lsi.common.ob.entry.DataAccessManager.getData(DataAccessManager.java:2102) [classes:]

          at lsi.common.ob.entry.XMLHTTPListener.doPost(XMLHTTPListener.java:3526) [classes:]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at com.filters.WebFilter.doFilter(WebFilter.java:59) [classes:]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.4.0.Final-redhat-19.jar:7.4.0.Final-redhat-19]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]

          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]

       

       

      Please help me to fix this