SQL and JDBC ResultSet/Cursor Mechanisms

A cursor provides you with the ability to step through and process the rows in a ResultSet one by one. A java.sql.ResultSet object constitutes a cursor. You do not need to use a language construct, such as SQL-92's DECLARE CURSOR, to work with cursors in a Java application. In Derby, any SELECT statement generates a cursor.

• Simple Non-Updatable ResultSets
• Updatable Cursors
• ResultSets and Auto-Commit
• Scrolling Insensitive ResultSets
• Holdable Cursors