12
Result Set Enhancements

Standard JDBC 2.0 features in JDK 1.2.x include enhancements to result set functionality--processing forward or backward, positioning relatively or absolutely, seeing changes to the database made internally or externally, and updating result set data and then copying the changes to the database.

This chapter discusses these features, including the following topics:

• Overview

• Creating Scrollable or Updatable Result Sets

• Positioning and Processing in Scrollable Result Sets

• Updating Result Sets

• Fetch Size

• Refetching Rows

• Seeing Database Changes Made Internally and Externally

• Summary of New Methods for Result Set Enhancements

The Oracle JDBC drivers also include extensions to support these features in a JDK 1.1.x environment.

For more general and conceptual information about JDBC 2.0 result set enhancements, refer to the Sun Microsystems JDBC 2.0 API specification.

---