SQL Error: 17002, SQLState: 08006 IO Error: Connection reset in JBOSS 7.1
ritikagupta Apr 15, 2014 8:06 AMI 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.