E. Features Introduced in Ingres 9.2 : Connectivity Enhancements : Scrollable Cursors in JDBC and OpenAPI
 
Share this page                  
Scrollable Cursors in JDBC and OpenAPI
Scrollable cursors are supported in JDBC. ResultSet types TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE and the ResultSet scrolling methods are supported. Ingres read-only (static) scrollable cursors are insensitive to changes, while updatable (keyset) scrollable cursors are sensitive to changes. For details, see the section Cursors and Result Set Characteristics in the chapter "Understanding JDBC Connectivity" of the Connectivity Guide.
Scrollable cursors are supported in OpenAPI. The application requests a scrollable cursor by setting the IIAPI_QF_SCROLL flag when opening the cursor using IIapi_query() with query type IIAPI_QT_OPEN. A scrollable cursor can be positioned prior to calling IIapi_getColumns() using either IIapi_scroll() or IIapi_position(). IIapi_getColumns() then returns rows starting with the row specified by IIapi_scroll() or IIapi_position(). For details, see the section Scrollable Cursors in the chapter "Introduction" in the OpenAPI User Guide.