-
Notifications
You must be signed in to change notification settings - Fork 90
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Use JDBC cursors for SQL client streaming #208
Labels
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The implementation of the SQL client streaming with JDBC will load the entire results set in memory. Here is a short description on how to proceed for the implementation:
JDBCPreparedQuery
has an optionalcursorId
andfetch
values indicating whether the query should or not use a cursor to execute the queryWe likely need a
Map<String, JDBCPreparedQuery<?, ?>>
that keeps the prepared queries holding theResultSet
When a non null
cursorId
is providedResultSet
that holds a cursor. ThisResultSet
is cached on the action so it can be reused multiple times-the action should be looked up in the map and reused instead of being created otherwise
When an action is executed and provides its result it gives a boolean indicating whether the end has been reached:
The text was updated successfully, but these errors were encountered: