Use Cursors with Result Sets

jConnect implements many JDBC 2.0 cursor and update methods.

• Cursors
  Methods for creating a cursor using jConnect.
• JDBC 1.x Methods for Positioned Updates and Deletes
  Review the methods to use JDBC 1.x.
• JDBC 2.0 Methods for Positioned Updates and Deletes
  The JDBC 2.0 methods to update the columns in the current cursor row and the database from the current cursor row in a result set.
• Release Locks at Cursor Close
  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.
• Select for Update Support
  Adaptive Server 15.7 and later supports select for update, which can lock rows for subsequent updates within the same transaction, and supports exclusive locks for updatable cursors.
• Cursor with PreparedStatement Object
  You can use PreparedStatement multiple times with the same or different values for its input parameters.
• TYPE_SCROLL_INSENSITIVE Result Sets in jConnect
  jConnect supports TYPE_SCROLL_INSENSITIVE result sets.
• Transact-SQL Queries with COMPUTE Clause
  jConnect for JDBC supports Transact-SQL queries that include a COMPUTE clause.