java.sql.SQLException: You can't operate on a closed Statement!!! Error Code: 0 Call: SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?) bind => [162] Query: DataReadQuery(name="tableNodes" sql="SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?)")

c3p0 | pzak | 4 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

    c3p0:JDBC DataSources/Resource Pools / Bugs / #123 "You can't operate on a closed Statement!!!" and "You can't operate on a closed Connection!!!"

    sourceforge.net | 1 year ago
    java.sql.SQLException: You can't operate on a closed Statement!!! Error Code: 0 Call: SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?) bind => Query: DataReadQuery(name="tableNodes" sql="SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?)")
  2. 0

    Bug 418909 – Connection is unexpectedly closed by different thread just before using it (with external connection pools: c3p0 / BoneCP)

    eclipse.org | 1 year ago
    java.sql.SQLException: You can't operate on a closed Statement!!! Error Code: 0 Call: SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?) bind => [162] Query: DataReadQuery(name="tableNodes" sql="SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?)")
  3. 0

    c3p0:JDBC DataSources/Resource Pools / Bugs / #123 "You can't operate on a closed Statement!!!" and "You can't operate on a closed Connection!!!"

    sourceforge.net | 10 months ago
    java.sql.SQLException: You can't operate on a closed Statement!!! Error Code: 0 Call: SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?) bind => Query: DataReadQuery(name="tableNodes" sql="SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?)")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Connection is unexpectedly closed by different thread just before using it (with external connection pools: c3p0 / BoneCP)

    Eclipse Bugzilla | 4 years ago | pawel.zak.pawel
    java.sql.SQLException: You can't operate on a closed Statement!!! Error Code: 0 Call: SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?) bind => [162] Query: DataReadQuery(name="tableNodes" sql="SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?)")
  6. 0

    "You can't operate on a closed Statement!!!" and "You can't operate on a closed Connection!!!"

    c3p0 | 4 years ago | pzak
    java.sql.SQLException: You can't operate on a closed Statement!!! Error Code: 0 Call: SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?) bind => [162] Query: DataReadQuery(name="tableNodes" sql="SELECT t0.temp_element, t0.element FROM table t0 WHERE (t0.id = ?)")

    1 unregistered visitors
    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.lang.NullPointerException

      No message provided

      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery()
    2. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeQuery
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:119)
      2. com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
      3. com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
      4. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:134)
      4 frames
    3. EclipseLink (non-OSGi)
      EntityManagerImpl.flush
      1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:931)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:607)
      3. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
      4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
      5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
      6. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
      7. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
      8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
      9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      10. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
      11. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:246)
      12. org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
      13. org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
      14. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
      15. org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
      16. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
      17. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2885)
      18. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
      19. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
      20. org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:98)
      21. org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:88)
      22. org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
      23. org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:161)
      24. org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:222)
      25. org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
      26. org.eclipse.persistence.indirection.IndirectMap.buildDelegate(IndirectMap.java:110)
      27. org.eclipse.persistence.indirection.IndirectMap.getDelegate(IndirectMap.java:329)
      28. org.eclipse.persistence.indirection.IndirectMap$1.<init>(IndirectMap.java:200)
      29. org.eclipse.persistence.indirection.IndirectMap.entrySet(IndirectMap.java:199)
      30. org.eclipse.persistence.internal.queries.MapContainerPolicy$MapContainerPolicyIterator.<init>(MapContainerPolicy.java:890)
      31. org.eclipse.persistence.internal.queries.MapContainerPolicy.iteratorFor(MapContainerPolicy.java:529)
      32. org.eclipse.persistence.mappings.DirectMapMapping.cascadeDiscoverAndPersistUnregisteredNewObjects(DirectMapMapping.java:186)
      33. org.eclipse.persistence.internal.descriptors.ObjectBuilder.cascadeDiscoverAndPersistUnregisteredNewObjects(ObjectBuilder.java:1917)
      34. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.discoverAndPersistUnregisteredNewObjects(UnitOfWorkImpl.java:4162)
      35. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.discoverUnregisteredNewObjects(RepeatableWriteUnitOfWork.java:299)
      36. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.calculateChanges(UnitOfWorkImpl.java:716)
      37. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:433)
      38. org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:780)
      38 frames