The type of a ResultSet object determines the level of its functionality in
two areas: the ways in which the cursor can be manipulated, and how concurrent
changes made to the underlying data source are reflected by the ResultSet object.
The sensitivity of a ResultSet object is determined by one of three different
ResultSet types:
TYPE_FORWARD_ONLY:
The result set cannot be scrolled; its cursor moves forward only, from
before the first row to after the last row. The rows contained in the
result set depend on how the underlying database generates the results.
That is, it contains the rows that satisfy the query at either the time
the query is executed or as the rows are retrieved.
TYPE_SCROLL_INSENSITIVE:
The result can be scrolled; its cursor can move both forward and backward
relative to the current position, and it can move to an absolute position.
The result set is insensitive to changes made to the underlying data source
while it is open. It contains the rows that satisfy the query at either the
time the query is executed or as the rows are retrieved.
TYPE_SCROLL_SENSITIVE:
The result can be scrolled; its cursor can move both forward and backward
relative to the current position, and it can move to an absolute position.
The result set reflects changes made to the underlying data source while
the result set remains open.
The default ResultSet type is TYPE_FORWARD_ONLY.
|