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. jConnect accordingly supports the release-lock-on-close semantics.
To apply on a jConnect connection, set the RELEASE_LOCKS_ON_CURSOR_CLOSE connection property to true. The default RELEASE_LOCKS_ON_CURSOR_CLOSE value is false.
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.
