There are three types of scrolling for result sets:

• Forward-only scrolling
• Scroll-insensitive scrolling
• Scroll-sensitive scrolling

The JDBC2.1 Core API supports only forward-only scrolling and scroll-insensitive scrolling.

There are two types of parallel processing for result sets:

• Read-only parallel processing
• Updatable parallel processing

The JDBC2.1 Core API supports only read-only parallel processing.

(a) Notes about specifying an unsupported result set or type of parallel processing

No error results when an unsupported result set or an unsupported type of parallel processing is specified. The JDBC2.1 Core API assumes the result set that is closest to the specified type of result set or type of parallel processing, and generates an instance of the Statement class or that subclass. At this time, the API generates a warning (SQLWarning object) and associates it with an instance of the Connection class.

(b) Notes on using a scrolling-type result set

In the case of a scrolling-type result set, all retrieved data is cached in the JDBC driver. This means that a large data size increases the possibility of a memory shortage or a drop in performance. When you use a scrolling-type result set, you should take steps in advance to minimize the amount of retrieved data. For example, you can add appropriate conditions to the SQL statements.