Result Set Types

JDBC defines the following result set types:

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

Forward-only result sets allow you to move forward, but not backward, through the data. The application can move only forward using the next() method.

Typically, a scroll-insensitive result set ignores changes that are made while it is open. It provides a static view of the underlying data it contains. The membership, order, and column values of rows are fixed when the result set is created.

In contrast, a scroll-sensitive result set provides a dynamic view of the underlying data, reflecting changes that are made while it is open. The membership and ordering of rows in the result set may be fixed, depending on how it is implemented.