Develop cleaner solution for closing resources on commit/rollback [JDBC401]

[firebird-automations]

Submitted by: @mrotteveel

Is related to JDBC307

The fix for JDBC307 goes through a number of layers to not close the serverside cursor on commit/rollback (as this is done automatically by Firebird). It might be worthwhile to investigate an alternative solution, where the signalling of commiting or rolling back will make those resources (result set, but also blobs) switch to closed state without calling the server side.

This would probably be cleaner and less confusing.

[firebird-automations]

Modified by: @mrotteveel

Link: This issue is related to JDBC307 [ JDBC307 ]

[firebird-automations]

Modified by: @mrotteveel

Fix Version: Jaybird 3.0 [ 10440 ]

[firebird-automations]

Modified by: @mrotteveel

Fix Version: Jaybird 3.1 [ 10441 ]

Fix Version: Jaybird 3.0 [ 10440 ] =>

[firebird-automations]

Modified by: @mrotteveel

Fix Version: Jaybird 5 [ 10871 ]

Fix Version: Jaybird 4 [ 10441 ] =>

[mrotteveel]

Deferring for later release. Not a priority.