Chapter 2: Programming Information

Using cursors with result sets

jConnect 5.x 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 5.x.

**Table 2-5: java.sql.ResultSet options available in jConnect 5.x**
Concurrency	Type
Concurrency	TYPE_FORWARD_ ONLY	TYPE_SCROLL_ INSENSITIVE	TYPE_SCROLL_ SENSITIVE
CONCUR_READ_ONLY	Supported in 5.x	Supported in 5.x	Not available in 5.x
CONCUR_UPDATABLE	Supported in 5.x	Not available in 5.x	Not available in 5.x

This section includes the following topics:

Creating a cursor
Positioned updates and deletes using JDBC 1.x methods
Using a cursor with a PreparedStatement object
Support for SCROLL_INSENSITIVE result sets in jConnect

View this book as PDF