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

Atlassian JIRA | Mark Gaylard | 9 years 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

    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 | 9 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 | 9 years ago | Mark Gaylard
    java.sql.SQLException: You can't operate on a closed Statement!!!

    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