Using cursors with result sets

jConnect 6.0 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 6.0.

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

Concurrency

Type

TYPE_FORWARD_ ONLY

TYPE_SCROLL_ INSENSITIVE

TYPE_SCROLL_ SENSITIVE

CONCUR_READ_ONLY

Supported in 6.0

Supported in 6.0

Not available in 6.0

CONCUR_UPDATABLE

Supported in 6.0

Not available in 6.0

Not available in 6.0

This section includes the following topics: