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.
