You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Transcript from the original issue reported in the internal issue tracker.
PDB does not log exception thrown by connection.close(), merely reporting that an error has occurred.
JDBC API states the following on close()
It is strongly recommended that an application explicitly commits or rolls back an active transaction prior to calling the close method. If the close method is called and there is an active transaction, the results are implementation-defined.
—
The DB2 JDBC implementation throws an exception if a transaction is still active on close(). It does not close the transaction, so if the transaction is still active and holding on to locks, they will be "alive" for a long time (whatever the timeout is) causing deadlocks. While not closing the transaction is a a project issue (which we fixed), not reporting the exception makes troubleshooting much harder.
The text was updated successfully, but these errors were encountered:
Transcript from the original issue reported in the internal issue tracker.
PDB does not log exception thrown by connection.close(), merely reporting that an error has occurred.
JDBC API states the following on close()
It is strongly recommended that an application explicitly commits or rolls back an active transaction prior to calling the close method. If the close method is called and there is an active transaction, the results are implementation-defined.
—
The DB2 JDBC implementation throws an exception if a transaction is still active on close(). It does not close the transaction, so if the transaction is still active and holding on to locks, they will be "alive" for a long time (whatever the timeout is) causing deadlocks. While not closing the transaction is a a project issue (which we fixed), not reporting the exception makes troubleshooting much harder.
The text was updated successfully, but these errors were encountered: