Forums Register Login

Understanding types of Result Sets

+Pie Number of slices to send: Send
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.

+Pie Number of slices to send: Send
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.



Whatever. Here's a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1324 times.
Similar Threads
SQLException Cursor Closed
Understanding ResultSets
Reagarding ResultSet Close in a Thread
Connection, Resultset and statement
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 00:23:03.