Adaptive Server 15.7 extends the declare cursor syntax to include the release_locks_on_close option, which releases shared cursor locks at isolation levels 2 and 3 when a cursor is closed. Adaptive Server Enterprise ODBC Driver 15.7 and jConnect for JDBC 7.07 support the release-lock-on-close semantics.
To apply this functionality to all read-only cursors created on an Adaptive Server Enterprise ODBC Driver connection, set the ReleaseLocksOnCursorClose connection property to 1. The default ReleaseLocksOnCursorClose value is 0.
To apply on a jConnect for JDBC connection, set the RELEASE_LOCKS_ON_CURSOR_CLOSE connection property to true. The default RELEASE_LOCKS_ON_CURSOR_CLOSE value is false.
Settings applied through these connection properties are static and cannot be changed after the connection has been established. This setting takes effect only when connected to a server that supports release_locks_on_close.
For information about release_locks_on_close, see the Adaptive Server Enterprise Reference Manual: Commands.