|
|
|
JDBC supports scrollable cursors and c-treeACE SQL now implements this support.
Forward and backward cursor scrolling is supported and includes relative and absolute record number fetching.
Scrollable cursors are not enabled by default for a given connection. Scrollable cursors require that the query be executed in its entirety before the first fetch and results loaded into a temporary table. This can have preforming implications, especially for queries with a large result set where the client may only fetch the first few results.
For a JDBC connection the cursor type specified at connection time controls whether or not scrollable cursors are supported.
