3 Replies Latest reply: Oct 1, 2009 10:27 AM by Joe Weinstein-Oracle RSS

    java.sql.SQLRecoverableException: Io exception: Connection reset

    Jagadeesh

      Hi All,

      The following error occurs many time in application (though not evertime, some times error doesn't comes up and web page get's displayed). This sporadic error is driving me crazy. i tried using the drivers provided by oracle but i still see the same error sporadically.

      Environment:
      Server:
      $ uname -a
      Linux searay 2.6.9-89.ELsmp #1 SMP Mon Apr 20 10:33:05 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

      Application Server:
      Oracle BEA Weblogic 103

      JDK:
      Jrocket 1.6 version

      Using Oracle's ojdbc14.jar driver file for getting connecting.


      java.sql.SQLRecoverableException: Io exception: Connection reset
      at com.capitalone.intranet.m1.transaction.TransactionHandler.executeQuery(TransactionHandler.java:369)
      at com.capitalone.intranet.m1.dbcontrols.DatabaseManager.executeSelect(DatabaseManager.java:347)
      at com.capitalone.intranet.m1.buslogic.M1News.readAnnouncement(M1News.java:56)
      at jsp_servlet._html.__m1news._jspService(__m1news.java:100)
      at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(Unknown Source)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

      Appreciate your help,
      Thanks,
      Jags

        • 1. Re: java.sql.SQLRecoverableException: Io exception: Connection reset
          Joe Weinstein-Oracle
          You should show us the full orignal stacktrace of the
          exception, not where the application chose to
          throw it's own exception with the message....
          • 2. Re: java.sql.SQLRecoverableException: Io exception: Connection reset
            Jagadeesh
            Please find the actual stackTrace. this is what i see when i print the stack trace. If i refresh the page for around 4 to 5 times the error disappears. But again if i try logging in into application after few mins i see the same error message.

            java.sql.SQLRecoverableException: Io exception: Connection reset
            at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
            at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
            at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:785)
            at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
            at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
            at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
            at com.capitalone.intranet.m1.transaction.TransactionHandler.executeQuery(TransactionHandler.java:311)
            at com.capitalone.intranet.m1.dbcontrols.DatabaseManager.executeSelect(DatabaseManager.java:347)
            at com.capitalone.intranet.m1.buslogic.M1News.readAnnouncement(M1News.java:56)
            at jsp_servlet._html.__m1news._jspService(__m1news.java:100)
            at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
            at weblogic.security.service.SecurityManager.runAs(Unknown Source)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

            Edited by: Jagadeesh on Sep 30, 2009 11:43 PM
            • 3. Re: java.sql.SQLRecoverableException: Io exception: Connection reset
              Joe Weinstein-Oracle
              Hi. That exception is simply the Oracle JDBC driver reporting that it's connection
              to the DBMS was closed out from under it while in use. The real porblem is at
              the DBMS, such as if the session died abruptly. I'd suggest checking the DBMS
              error log.
              Joe