Register / Login
JDBC and Relational Databases
TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and isolation levels
posted 4 years ago
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
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?
It is sorta covered in the
JavaRanch Style Guide
difference between sensitive and insensitive of resultset
Regarding TYPE_SCROLL_SENSITIVE ResultSets