Using Scrollable Result Sets

The JDBC Client supports forward-only and scroll-insensitive result sets against all data stores.

Scroll-sensitive result sets are not supported when using the OpenAccess SDK SQL engine. The third-party SQL engine supports scroll-sensitive result sets when the SELECT statement does not contain any of the following SQL language constructions:

• JOIN
• Aggregate functions
• GROUP BY

The JDBC Client supports updatable result sets.

Note: When the JDBC Client cannot support the requested result set type or concurrency, it will automatically downgrade it and generate one or multiple SQLWarnings with detailed information.