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.
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:
