What is the meaning of ResultSet.TYPE_SCROLL_INSENSITIVE
-
This means that the ResultSet is insensitive to scrolling
-
This means that the Resultset is sensitive to scrolling, but insensitive to updates, i.e. not
-
This means that the ResultSet is sensitive to scrolling, but insensitive to changes made by others
-
The meaning depends on the type of data source, and the type and version of the driver you use with this data source
TYPE_SCROLL_INSENSITIVE creates a scrollable ResultSet that allows bidirectional navigation (first, last, absolute, relative). The 'INSENSITIVE' means it doesn't reflect changes made by others after the ResultSet was created - it shows a static snapshot. Option A is wrong - 'insensitive' refers to change sensitivity, not scrolling ability. Option B has the sensitivity backwards.
TYPE_SCROLL_INSENSITIVE means the ResultSet supports scrolling (forward, backward, and to absolute positions) but is "insensitive" in the sense that it does not reflect changes made to the underlying data by other transactions after the ResultSet was created — it works off a snapshot rather than a live view. This differs from TYPE_SCROLL_SENSITIVE, which does pick up such external changes.