Using cursors with result sets

jConnect implements many JDBC 2.0 cursor and update methods. These methods make it easier to use cursors and to update rows in a table based on values in a result set.

In JDBC 2.0, ResultSets are characterized by their type and their concurrency. The type and concurrency values are part of the java.sql.ResultSet interface and are described in its javadocs.

Table 2-5 identifies the characteristics of java.sql.ResultSet that are available in jConnect. When requested, jConnect opens server side scrollable cursors when the server is Adaptive Server 15.0 or later.

Table 2-5: java.sql.ResultSet options available in jConnect

Concurrency

Type

TYPE_FORWARD_ ONLY

TYPE_SCROLL_ INSENSITIVE

TYPE_SCROLL_ SENSITIVE

CONCUR_READ_ONLY

Supported

Supported

Not available

CONCUR_UPDATABLE

Supported

Not available

Not available

This section includes the following topics: