Nonstop Database, HiRDB Version 9 UAP Development Guide
Scrolling and parallel processing have been added to the JDBC2.1 Core API as expansion facilities for result sets (ResultSet class).
There are three types of scrolling for result sets:
The JDBC2.1 Core API supports only forward-only scrolling and scroll-insensitive scrolling.
There are two types of parallel processing for result sets:
The JDBC2.1 Core API supports only read-only parallel processing.
No error results when an unsupported result set or an unsupported type of parallel processing is specified. The JDBC2.1 Core API assumes the result set that is closest to the specified type of result set or type of parallel processing, and generates an instance of the Statement class or that subclass. At this time, the API generates a warning (SQLWarning object) and associates it with an instance of the Connection class.
For a scrolling-type result set, all retrieved data is cached in the JDBC driver. This means that a large data size increases the possibility of a memory shortage or a drop in performance. When you use a scrolling-type result set, you should take steps in advance to minimize the amount of retrieved data. For example, you can add appropriate conditions to the SQL statements.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.