1 Reply Latest reply on Apr 15, 2014 9:09 AM by ctomc

    SQL Error: 17002, SQLState: 08006   IO Error: Connection reset in JBOSS 7.1

    ritikagupta

      I am getting following error regarding database connections-

       

      08:05:21,828 WARN  [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) SQL Error: 17002, SQLState: 08006

      08:05:21,828 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) IO Error: Connection reset

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) org.hibernate.exception.JDBCConnectionException: could not execute query

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.doList(Loader.java:2223)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.list(Loader.java:2099)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.snapon.daimlerportal.database.NewsFlashDAO.readAlertMessage(NewsFlashDAO.java:85)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.snapon.daimlerportal.session.DCAGSessionFacade.<init>(DCAGSessionFacade.java:96)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.snapon.daimlerportal.session.DCAGSessionFacade.getSession(DCAGSessionFacade.java:126)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.snapon.daimlerportal.action.BaseAction.getSession(BaseAction.java:46)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.snapon.daimlerportal.action.FrontPageAction.execute(FrontPageAction.java:19)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at sun.reflect.GeneratedMethodAccessor481.invoke(Unknown Source)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at java.lang.reflect.Method.invoke(Method.java:606)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)

       

      08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) Caused by: java.sql.SQLException: IO Error: Connection reset

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:874)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.doQuery(Loader.java:674)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at org.hibernate.loader.Loader.doList(Loader.java:2220)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     ... 81 more

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) Caused by: java.net.SocketException: Connection reset

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at java.net.SocketInputStream.read(SocketInputStream.java:189)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at java.net.SocketInputStream.read(SocketInputStream.java:121)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.net.ns.Packet.receive(Packet.java:282)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

       

      08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19)     ... 92 more

       

      08:05:21,906 ERROR [org.hibernate.transaction.JDBCTransaction] (http-0.0.0.0-0.0.0.0-80-19) JDBC commit failed: java.sql.SQLException: Closed Connection

          at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640) [ojdbc5.jar:11.2.0.1.0]

          at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680) [ojdbc5.jar:11.2.0.1.0]

          at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:986)

          at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:757)

          at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139) [hibernate3.jar:3.2.4.sp1]

          at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115) [hibernate3.jar:3.2.4.sp1]

          at com.snapon.daimlerportal.database.DCAGAbstractDAO.freeSession(DCAGAbstractDAO.java:26) [daimlerportal-ejb.jar:]

          at com.snapon.daimlerportal.database.NewsFlashDAO.readAlertMessage(NewsFlashDAO.java:93) [daimlerportal-ejb.jar:]

          at com.snapon.daimlerportal.session.DCAGSessionFacade.<init>(DCAGSessionFacade.java:96) [classes:]

          at com.snapon.daimlerportal.session.DCAGSessionFacade.getSession(DCAGSessionFacade.java:126) [classes:]

          at com.snapon.daimlerportal.action.BaseAction.getSession(BaseAction.java:46) [classes:]

          at com.snapon.daimlerportal.action.FrontPageAction.execute(FrontPageAction.java:19) [classes:]

          at sun.reflect.GeneratedMethodAccessor481.invoke(Unknown Source) [:1.7.0_25]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]

          at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]

          at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) [xwork-core-2.3.15.1.jar:2.3.15.1]

          at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) [xwork-core-2.3.15.1.jar:2.3.15.1]

          a

       

       

      Can anybody tell which type of error is it occurs?

       

      When I started my server application working fine for 5 days, then it starts showing above errors and when we do restart the JBOSS service it starts working fine.

      Is there any database configuration missing in my standalone.xml?

       

      Please help me , Thanks in advance.