java.sql.SQLException: This Connection has either timed out or been closed, and it has returned to its pool. You must re-acquire the Connection.

Oracle Community | 25409 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Application Module - No Trx Please

    Oracle Community | 1 decade ago | 25409
    java.sql.SQLException: This Connection has either timed out or been closed, and it has returned to its pool. You must re-acquire the Connection.
  2. 0

    Exception java.sql.SQLException: This Connection has either timed out

    Oracle Community | 1 decade ago | 843810
    java.sql.SQLException: This Connection has either timed out or been closed, and it has returned to its pool. You must re-acquire the Connection.

    Root Cause Analysis

    1. java.sql.SQLException

      This Connection has either timed out or been closed, and it has returned to its pool. You must re-acquire the Connection.

      at jrun.sql.JRunConnectionHandle.assertConnectionExists()
    2. jrun.sql
      JRunConnectionHandle.rollback
      1. jrun.sql.JRunConnectionHandle.assertConnectionExists(JRunConnectionHandle.java:50)
      2. jrun.sql.JRunConnectionHandle.rollback(JRunConnectionHandle.java:107)
      2 frames
    3. oracle.jbo.server
      DBTransactionImpl.disconnect
      1. oracle.jbo.server.DefaultTxnHandlerImpl.handleRollback(DefaultTxnHandlerImpl.java:139)
      2. oracle.jbo.server.DBTransactionImpl.doRollback(DBTransactionImpl.java:3657)
      3. oracle.jbo.server.DBTransactionImpl.rollback(DBTransactionImpl.java:1826)
      4. oracle.jbo.server.ApplicationModuleImpl.resetState(ApplicationModuleImpl.java:3156)
      5. oracle.jbo.server.ApplicationModuleImpl.resetState(ApplicationModuleImpl.java:3145)
      6. oracle.jbo.server.DBTransactionImpl.disconnect(DBTransactionImpl.java:3971)
      7. oracle.jbo.server.DBTransactionImpl2.disconnect(DBTransactionImpl2.java:306)
      8. oracle.jbo.server.DBTransactionImpl.disconnect(DBTransactionImpl.java:4108)
      8 frames
    4. oracle.jbo.common
      SessionCookieImpl.useApplicationModule
      1. oracle.jbo.common.ampool.DefaultConnectionStrategy.disconnect(DefaultConnectionStrategy.java:328)
      2. oracle.jbo.common.ampool.ApplicationPoolImpl.disconnect(ApplicationPoolImpl.java:2979)
      3. oracle.jbo.common.ampool.ApplicationPoolImpl.recycleUnreferencedInstance(ApplicationPoolImpl.java:1586)
      4. oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1386)
      5. oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2062)
      6. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:398)
      6 frames
    5. oracle.jbo.http
      HttpSessionCookieImpl.useApplicationModule
      1. oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:230)
      1 frame
    6. oracle.jbo.html
      ApplicationModuleTag.doStartTag
      1. oracle.jbo.html.jsp.datatags.ApplicationModuleTag.doStartTag(ApplicationModuleTag.java:193)
      1 frame
    7. Unknown
      jrun__itempage2ejspd._jspService
      1. jrun__itempage2ejspd._jspService(jrun__itempage2ejspd.java:61)
      1 frame
    8. jrun.jsp.runtime
      HttpJSPServlet.service
      1. jrun.jsp.runtime.HttpJSPServlet.service(HttpJSPServlet.java:43)
      1 frame
    9. jrun.jsp
      JSPServlet.service
      1. jrun.jsp.JSPServlet.service(JSPServlet.java:110)
      1 frame
    10. jrun.servlet
      ServletEngineService.dispatch
      1. jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
      2. jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
      3. jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
      4. jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
      4 frames
    11. jrun.servlet.jrpp
      JRunProxyService.invokeRunnable
      1. jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
      1 frame
    12. jrunx.scheduler
      WorkerThread.run
      1. jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
      2. jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
      2 frames