1 - SENSITIVE Scrollable resultset and an INSENSITIVE one
2 - Cursor Holdability
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.
Scroll sensitive means that your result set is dynamic. If the underlying data changes while the result set is alive and it is scroll sensitive, then your result set is updated with the most recent information. Exactly how this is done is "implementation defined".
Holdable means you give the application control over what happens to the result set when commit is called.
You may want to keep your result set open. You can see how "CLOSE_ON_COMMIT" would use less resources.
Men call me Jim. Women look past me to this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop