java.sql.SQLException: You can't operate on a closed Connection!!! 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 = ?)")

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via c3p0 by pzak
, 1 year ago
You can't operate on a closed Connection!!! 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 = ?)")
via eclipse.org by Unknown author, 1 year ago
You can't operate on a closed Connection!!! 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 = ?)")
via Eclipse Bugzilla by pawel.zak.pawel, 1 year ago
You can't operate on a closed Connection!!! 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 = ?)")
via sourceforge.net by Unknown author, 1 year ago
You can't operate on a closed Connection!!! 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 = ?)")
via sourceforge.net by Unknown author, 1 year ago
You can't operate on a closed Connection!!! 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 = ?)")
via Stack Overflow by Poyraz
, 2 years ago
Statement has already been closed Error Code: 0 Call: SELECT ID, FIRST_NAME, ISBLOCKED, LAST_NAME, MODIFIED, MSISDN, VERSION, OWNER_ID, CONTACT_ID FROM CONTACTS WHERE (OWNER_ID = ?) bind => [1 parameter bound] Query: ReadAllQuery(name
java.sql.SQLException: You can't operate on a closed Connection!!! 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 = ?)")
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:135)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1474)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1423)
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:697)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:585)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:246)
at org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
at org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2885)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:98)
at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:88)
at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:161)
at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:222)
at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
at org.eclipse.persistence.indirection.IndirectMap.buildDelegate(IndirectMap.java:110)
at org.eclipse.persistence.indirection.IndirectMap.getDelegate(IndirectMap.java:329)
at org.eclipse.persistence.indirection.IndirectMap$1.(IndirectMap.java:200)
at org.eclipse.persistence.indirection.IndirectMap.entrySet(IndirectMap.java:199)
at org.eclipse.persistence.internal.queries.MapContainerPolicy$MapContainerPolicyIterator.(MapContainerPolicy.java:890)
at org.eclipse.persistence.internal.queries.MapContainerPolicy.iteratorFor(MapContainerPolicy.java:529)
at org.eclipse.persistence.mappings.DirectMapMapping.cascadeDiscoverAndPersistUnregisteredNewObjects(DirectMapMapping.java:186)
at org.eclipse.persistence.internal.descriptors.ObjectBuilder.cascadeDiscoverAndPersistUnregisteredNewObjects(ObjectBuilder.java:1917)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.discoverAndPersistUnregisteredNewObjects(UnitOfWorkImpl.java:4162)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.discoverUnregisteredNewObjects(RepeatableWriteUnitOfWork.java:299)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.calculateChanges(UnitOfWorkImpl.java:716)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:433)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 3 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.