java.sql.SQLException: Cannot close a connection while a transaction is still active.

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

Solutions on the web

via JFrog JIRA by dario louzado, 1 year ago
Cannot close a connection while a transaction is still active.
via JFrog JIRA by dario louzado, 1 year ago
Cannot close a connection while a transaction is still active.
via Stack Overflow by Stephane Grenier
, 2 years ago
Cannot close a connection while a transaction is still active.
via Stack Overflow by Sundeep
, 2 years ago
ResultSet not open. Operation 'getString' not permitted. Verify that autocommit is OFF.
via Apache's JIRA Issue Tracker by Kathey Marsden, 1 year ago
The exception 'java.sql.SQLException: ResultSet not open. Operation 'n ext' not permitted. Verify that autocommit is OFF.' was thrown while evaluating an expression.
via apache.org by Unknown author, 1 year ago
The exception 'java.sql.SQLException: ResultSet not open. Operation 'n ext' not permitted. Verify that autocommit is OFF.' was thrown while evaluating an expression.
java.sql.SQLException: Cannot close a connection while a transaction is still active.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkForTransactionInProgress(Unknown Source)
at org.apache.tomcat.jdbc.pool.PooledConnection.disconnect(PooledConnection.java:331)
at org.apache.tomcat.jdbc.pool.PooledConnection.release(PooledConnection.java:496)
at org.apache.tomcat.jdbc.pool.ConnectionPool.release(ConnectionPool.java:582)
at org.apache.tomcat.jdbc.pool.ConnectionPool.checkIdle(ConnectionPool.java:1000)
at org.apache.tomcat.jdbc.pool.ConnectionPool.checkIdle(ConnectionPool.java:981)
at org.apache.tomcat.jdbc.pool.ConnectionPool$PoolCleaner.run(ConnectionPool.java:1348)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)

Users with the same issue

Once, 1 year ago
Once, 5 months ago
Once, 7 months ago
Once, 7 months ago
81 times, 1 year ago
1 more bugmates

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