*
The moose likes JDBC and the fly likes TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels" Watch "TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels" New topic
Author

TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels

Luke Murphy
Ranch Hand

Joined: May 12, 2010
Posts: 300
Reading through the javadoc for

TYPE_SCROLL_INSENSITIVE: The constant indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.

TYPE_SCROLL_SENSITIVE: The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes made by others.

Will always override the overrides the isolation level of your JDBC connection?

For example, suppose your isolation level is something like TRANSACTION_REPEATABLE_READ and you set your result to TYPE_SCROLL_SENSITIVE - surely this is a contradiction?

Thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels
 
Similar Threads
TYPE_SCROLL_SENSITIVE
resultset scrollability
JDBC ResultSet
Regarding TYPE_SCROLL_SENSITIVE ResultSets
difference between sensitive and insensitive of resultset