java.sql.SQLException: You can't operate on a closed Statement!!!

Atlassian JIRA | Mark Gaylard | 8 years ago
  1. 0

    We occasionally get empty notification emails from bamboo. All they have in them is the subject '[Bamboo]'. The logged errors are below. It doesn't happen every time, maybe 1 in 5 or so. This started happening when we upgraded from v1.2.2 to v2.0.3. I did an export of 1.2.2, then created a new bamboo home and database for v2.0.3 to use then imported the previous export. The version of the database and jdbc driver stayed the same. Mark. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,745 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [BatcherImpl] exception clearing maxRows/queryTimeout java.sql.SQLException: You can't operate on a closed Statement!!! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1206) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:149) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:105) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:889) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1198) ... 46 more 2008-06-16 10:42:37,748 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [PersistentCollection] Failed to lazily initialize a collection net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889] at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80) at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.collection.AbstractCollectionPersister.convert(AbstractCollectionPersister.java:728) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:291) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2424) at org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:543) at org.postgresql.jdbc3.Jdbc3Statement.createResultSet(Jdbc3Statement.java:36) at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:196) at org.postgresql.core.v3.QueryExecutorImpl$1.handleResultRows(QueryExecutorImpl.java:377) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1275) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) ... 36 more 2008-06-16 10:42:37,750 ERROR [pool-26-thread-1] [AllBuildsCondition] Could not create email content for notificationAll Completed Builds

    Atlassian JIRA | 8 years ago | Mark Gaylard
    java.sql.SQLException: You can't operate on a closed Statement!!!
  2. 0

    We occasionally get empty notification emails from bamboo. All they have in them is the subject '[Bamboo]'. The logged errors are below. It doesn't happen every time, maybe 1 in 5 or so. This started happening when we upgraded from v1.2.2 to v2.0.3. I did an export of 1.2.2, then created a new bamboo home and database for v2.0.3 to use then imported the previous export. The version of the database and jdbc driver stayed the same. Mark. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,745 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [BatcherImpl] exception clearing maxRows/queryTimeout java.sql.SQLException: You can't operate on a closed Statement!!! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1206) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:149) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:105) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:889) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1198) ... 46 more 2008-06-16 10:42:37,748 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [PersistentCollection] Failed to lazily initialize a collection net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889] at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80) at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.collection.AbstractCollectionPersister.convert(AbstractCollectionPersister.java:728) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:291) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2424) at org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:543) at org.postgresql.jdbc3.Jdbc3Statement.createResultSet(Jdbc3Statement.java:36) at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:196) at org.postgresql.core.v3.QueryExecutorImpl$1.handleResultRows(QueryExecutorImpl.java:377) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1275) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) ... 36 more 2008-06-16 10:42:37,750 ERROR [pool-26-thread-1] [AllBuildsCondition] Could not create email content for notificationAll Completed Builds

    Atlassian JIRA | 8 years ago | Mark Gaylard
    java.sql.SQLException: You can't operate on a closed Statement!!!
  3. 0

    c3p0 Prepared Statement closed for no apparent reason

    Stack Overflow | 3 years ago | dsd
    java.sql.SQLException: You can't operate on a closed Statement!!!
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SessionException on simple request

    Google Groups | 4 years ago | Torsten Zesch
    java.sql.SQLException: You can't operate on a closed Statement!!!
  6. 0

    NewProxyPreparedStatement.isClosed() issue

    GitHub | 3 years ago | brettwooldridge
    java.sql.SQLException: You can't operate on a closed Statement!!!

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      You can't operate on a closed Statement!!!

      at com.mchange.v2.sql.SqlUtils.toSQLException()
    2. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.getMaxRows
      1. com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
      2. com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
      3. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1206)
      3 frames
    3. net.sf.hibernate
      BatcherImpl.closeQueryStatement
      1. net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:149)
      1 frame