Adds the ability to specify the holdability of a ResultSet object. A holdable cursor, or result, is one that does not automatically close when the transaction that contains the cursor is committed. JDBC 3.0 adds support for specifying cursor holdability. For you to specify the holdability of your ResultSet, you must do so when you prepare a statement using the createStatement(), prepareStatement(), or prepareCall() methods. The holdability may be one of the following constants:
HOLD_CURSORS_OVER_COMMIT – ResultSet objects (cursors) are not closed; they are held open when a commit operation is implicitly or explicitly performed.
CLOSE_CURSORS_AT_COMMIT – ResultSet objects (cursors) are closed when a commit operation is implicitly or explicitly performed.
If you close a cursor when a transaction is committed, it usually results in better performance. Unless you require the cursor after the transaction, it is recommended that you close the cursor when the commit operation is carried out. Because the specification does not define the default holdability of a ResultSet, its behavior will depend on the implementation.
