This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels
 
It's not a secret anymore!