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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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