A.3.1 Scrollable Result Sets

Scrollable result sets provide the ability to move the cursor forward and backward to a specified position or to a position relative to the current position. The following interfaces have new methods that support scrollable result sets.

• ResultSet

• methods for moving the cursor to a particular row or to a relative position (either forward or backward)
• methods for ascertaining the current position of the cursor
• constants indicating the scrollability of a result set

• Connection

• new versions of the methods for creating Statement, PreparedStatement, and CallableStatement objects that make the result sets they produce scrollable

• DatabaseMetaData

• method indicating whether the DBMS and driver support scrollable result sets