Open (output) blob in auto-commit prevents connection close [JDBC348]

[firebird-issue-importer]

Submitted by: @mrotteveel

Is related to JDBC307

Having an output blob open in auto-commit prevents connection close. The connection close does not raise an exception.

Code to reproduce:

Connection conn = getConnectionViaDriverManager();
try {
FBBlob blob = (FBBlob) conn.createBlob();
FBBlobOutputStream stream = (FBBlobOutputStream) blob.setBinaryStream(1);
} finally {
conn.close();
}

After executing this, the connection to the database is physically still open because a transaction was started when the binary stream was opened (eg a drop database using FBManager fails). This transaction is never terminated and this causes an exception in FBManagedConnection.destroy(), but this exception is swallowed in FBStandaloneConnectionManager.connectionClosed(...).

Commits: 8c2f9f9 ccb7fb4

[firebird-issue-importer]

Modified by: @mrotteveel

Version: Jaybird 2.2.4 [ 10531 ]

Version: Jaybird 2.2.3 [ 10510 ]

Version: Jaybird 2.2.2 [ 10480 ]

Version: Jaybird 2.2.1 [ 10474 ]

Version: Jaybird 2.2 [ 10053 ]

Fix Version: Jaybird 3.0 [ 10440 ]

Component: JCA layer [ 10052 ]

Component: JDBC driver [ 10053 ]

[firebird-issue-importer]

Commented by: @mrotteveel

May have been fixed with JDBC307. Linked with 2.2.9 for the express purpose of verifying that. If it isn't fixed, then this will be deferred to 3.0.

[firebird-issue-importer]

Modified by: @mrotteveel

Fix Version: Jaybird 2.2.9 [ 10691 ]

[firebird-issue-importer]

Modified by: @mrotteveel

Link: This issue is related to JDBC307 [ JDBC307 ]

[firebird-issue-importer]

Commented by: @mrotteveel

Added tests to confirm this has been fixed by JDBC307

[firebird-issue-importer]

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

[firebird-issue-importer]

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]