Please send your Questions & Answers or Feedback to "mohan@javabook.org"

How cursor works in scrollable result set?

Another  tough JDBC Interview question, not many Java programmer knows about using Cursor in Java.

in JDBC 2.0 API new feature is added to move cursor in resultset backward forward and also in a particular row .

There are three constant define in result set by which we can move cursor.

·TYPE_FORWARD_ONLY: creates a nonscrollable result set, that is, one in which the cursor moves only forward

·TYPE_SCROLL_INSENSITIVE : a scrollable result set does not reflects changes that are made to it while it is open

·TYPE_SCROLL_SENSITIVE: a scrollable result set  reflects changes that are made to it while it is open

Related Posts Plugin for WordPress, Blogger...
Flag Counter