Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
firebird-automations opened this issue Apr 13, 2014 · 7 comments

Comments

@firebird-automations
Copy link

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-automations
Copy link
Author

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-automations
Copy link
Author

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-automations
Copy link
Author

Modified by: @mrotteveel

Fix Version: Jaybird 2.2.9 [ 10691 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Link: This issue is related to JDBC307 [ JDBC307 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Added tests to confirm this has been fixed by JDBC307

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment