java.sql.SQLException: Connection has already been closed.

Oracle Community | 967958 | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    JDBC control not work after upgrade application from workshop 8.1 to 9.2.3

    Oracle Community | 9 years ago | 666705
    java.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.
  2. 0

    JDBC control not work after upgrade application from workshop 8.1 to 9.2.3

    Oracle Community | 9 years ago | 666705
    java.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Planning 9.2 to 9.3.1 migration issues

    Oracle Community | 8 years ago | 698244
    java.sql.SQLException: [Hyperion][SQLServer JDBC Driver][SQLServer]'FK_HSP_FCALC _FID' is not a constraint.

    Root Cause Analysis

    1. java.sql.SQLException

      Connection has already been closed.

      at weblogic.jdbc.wrapper.PoolConnection.checkConnection()
    2. weblogic.jdbc.wrapper
      Connection.getMetaData
      1. weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62)
      2. weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)
      3. weblogic.jdbc.wrapper.Connection.getMetaData(Connection.java:476)
      3 frames
    3. COM.FutureTense.Servlet
      JDBCConn.GetTable
      1. COM.FutureTense.Servlet.JDBCConn.GetTable(JDBCConn.java:1388)
      1 frame
    4. COM.FutureTense.Common
      ftDBTable.selectTo
      1. COM.FutureTense.Common.ftDBTable.getconn(ftDBTable.java:3913)
      2. COM.FutureTense.Common.ftDBTable.ensureconn(ftDBTable.java:3906)
      3. COM.FutureTense.Common.ftDBTable.selectTo(ftDBTable.java:2231)
      3 frames
    5. COM.FutureTense.CatalogManager
      ElementCatalog._get
      1. COM.FutureTense.CatalogManager.ElementCatalog._getElementData(ElementCatalog.java:383)
      2. COM.FutureTense.CatalogManager.ElementCatalog._get(ElementCatalog.java:366)
      2 frames
    6. COM.FutureTense.Common
      ContentServer.processElement
      1. COM.FutureTense.Common.ContentServer.prepareElement(ContentServer.java:1831)
      2. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1879)
      2 frames
    7. COM.FutureTense.XML
      XMLEval.run
      1. COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
      2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
      3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
      4. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
      5. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
      5 frames
    8. COM.FutureTense.Common
      ContentServer.processElement
      1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3220)
      2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2460)
      3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1908)
      3 frames
    9. COM.FutureTense.XML
      XMLEval.run
      1. COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
      2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
      3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:233)
      4. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:233)
      5. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
      6. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
      7. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
      7 frames
    10. COM.FutureTense.Common
      ContentServer.evalPage
      1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3220)
      2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2460)
      3. COM.FutureTense.Common.ContentServer.generatePage(ContentServer.java:1549)
      4. COM.FutureTense.Common.ContentServer.evalPage(ContentServer.java:1248)
      4 frames
    11. Java RT
      HashMap.isEmpty
      1. java.util.HashMap.isEmpty(HashMap.java:321)
      1 frame
    12. COM.FutureTense.Common
      ContentServer.execute
      1. COM.FutureTense.Common.ContentServer.streamSSParams(ContentServer.java:498)
      2. COM.FutureTense.Common.ContentServer.execute(ContentServer.java:456)
      2 frames
    13. COM.FutureTense.Servlet
      FTServlet.doPost
      1. COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
      1 frame
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
      2 frames
    15. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      3. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
      4. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      4 frames
    16. com.fatwire.auth
      RequestAuthenticationFilter.doFilter
      1. com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:192)
      1 frame
    17. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      1 frame
    18. com.fatwire.wem
      SSOFilter.doFilter
      1. com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:695)
      2. com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
      2 frames
    19. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      1 frame
    20. com.fatwire.cs
      UIFilter.doFilter
      1. com.fatwire.cs.ui.framework.UIFilter.doFilter(UIFilter.java:109)
      1 frame
    21. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      1 frame
    22. com.fatwire.gst
      HttpResponseStatusFilter.doFilter
      1. com.fatwire.gst.foundation.httpstatus.HttpResponseStatusFilter.doFilter(HttpResponseStatusFilter.java:83)
      1 frame
    23. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
      1 frame
    24. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    25. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
      2. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
      2 frames
    26. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames