1 Reply Latest reply: Jul 14, 2014 10:43 AM by Joe Weinstein-Oracle RSS

    A series of java.sql.SQLException during rapid fire requests

    Thomas Beauvais

      I have a number of exceptions all around the same idea: WebLogic 10.3.6 is closing them before my application is actually done using them!

      I am completely lost as to why this could be happening?  It can happen easily when I hit refresh a few times in a row or even just one request.  Surely there most be something wrong with configuration but I have no idea what.  Any insight would be greatly appreciated.

       

      Caused By: java.sql.SQLException: close, Exception = null
           at weblogic.jdbc.wrapper.ResultSet.close(ResultSet.java:223)
           at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:228)
           at org.hibernate.loader.Loader.doQuery(Loader.java:770)
           at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
           at org.hibernate.loader.Loader.doList(Loader.java:2449)
           at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
           at org.hibernate.loader.Loader.list(Loader.java:2187)
           at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
           at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832)
           at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
           at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
           at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
           at de.silbury.statistik.jpa.PressReleaseRepositoryImpl.find(PressReleaseRepositoryImpl.java:107)
           at de.silbury.statistik.jpa.PressReleaseRepositoryImpl.findByDate(PressReleaseRepositoryImpl.java:66)
           at de.silbury.statistik.jpa.PressReleaseRepositoryImpl$$FastClassByCGLIB$$5d8667a2.invoke()
      

      and..

      java.sql.SQLException: Statement has already been closed
           at weblogic.jdbc.wrapper.Statement.checkStatement(Statement.java:331)
           at weblogic.jdbc.wrapper.Statement.preInvocationHandler(Statement.java:142)
           at weblogic.jdbc.wrapper.PreparedStatement_weblogic_jdbc_db2base_dddf.getMaxRows(Unknown Source)
           at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
           at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
           at org.hibernate.loader.Loader.doQuery(Loader.java:770)
           at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
           at org.hibernate.loader.Loader.doList(Loader.java:2449)
           at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
           at org.hibernate.loader.Loader.list(Loader.java:2187)
           at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
           at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832)
           at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
           at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
           at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
      

      and...

      java.sql.SQLException: Connection has already been closed.
           at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62)
           at weblogic.jdbc.wrapper.Statement.checkStatement(Statement.java:334)
           at weblogic.jdbc.wrapper.Statement.preInvocationHandler(Statement.java:142)
           at weblogic.jdbc.wrapper.PreparedStatement_weblogic_jdbc_db2base_dddf.getMaxRows(Unknown Source)
           at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
           at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
           at org.hibernate.loader.Loader.getResultSet(Loader.java:1883)
           at org.hibernate.loader.Loader.doQuery(Loader.java:718)
           at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
           at org.hibernate.loader.Loader.doList(Loader.java:2449)
           at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
           at org.hibernate.loader.Loader.list(Loader.java:2187)
           at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
           at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832)
           at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
           at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
           at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)