Hi,
I have been looking around at result sets. JAVA ResultSets
I wanted to understand
1 - SENSITIVE Scrollable resultset and an INSENSITIVE one
2 - Cursor Holdability
i.e.
HOLD_CURSORS_OVER_COMMIT: ResultSet cursors are not closed; they are holdable: they are held open when the method commit is called. Holdable cursors might be ideal if your application uses mostly read-only ResultSet objects.
CLOSE_CURSORS_AT_COMMIT: ResultSet objects (cursors) are closed when the commit method is called. Closing cursors when this method is called can result in better performance for some applications.
I have been looking around at result sets. JAVA ResultSets
I wanted to understand
1 - SENSITIVE Scrollable resultset and an INSENSITIVE one
2 - Cursor Holdability
i.e.
HOLD_CURSORS_OVER_COMMIT: ResultSet cursors are not closed; they are holdable: they are held open when the method commit is called. Holdable cursors might be ideal if your application uses mostly read-only ResultSet objects.
CLOSE_CURSORS_AT_COMMIT: ResultSet objects (cursors) are closed when the commit method is called. Closing cursors when this method is called can result in better performance for some applications.