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

What’s the difference between TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE?


An insensitive  resultset is like the snapshot of the data in the database when query was executed.

A sensitive resultset does NOT represent a snapshot of data, rather it contains points to those rows which satisfy the query condition.

After we get the resultset the changes made to data are not visible through the resultset, and hence they are known as insensitive.

After we obtain the resultset if the data is modified then such modifications are visible through resultset.

Performance not effected with insensitive.

Since a trip is made for every ‘get’ operation, the performance drastically get affected.
Related Posts Plugin for WordPress, Blogger...
Flag Counter