Pavel Pereslegin created IGNITE-26087:
-----------------------------------------

             Summary: Sql. Implement thin client internal SQL API to support 
reading script results
                 Key: IGNITE-26087
                 URL: https://issues.apache.org/jira/browse/IGNITE-26087
             Project: Ignite
          Issue Type: New Feature
          Components: sql ai3
            Reporter: Pavel Pereslegin


Currently SQL API over Thin Client supports script execution in a simplified 
form (SQL_EXEC_SCRIPT). Users cannot iterate over the results of the script and 
cannot use an explicit transaction.

To migrate the JDBC driver to use the SQL API over the thin client, we need to 
extend the thin client's internal API and support iteration over the script 
results.

* Extend SQL_EXEC operation to pass hasMoreResults flag from server to the 
client (extend ClientAsyncResultSet with hasMoreResults flag).
* Introduce new operation SQL_CURSOR_NEXT_RESULTSET (similar to 
JDBC_MORE_RESULTS) to allow switching to the next result set of the script.

Note: the script can be run inside a client transaction (this should work out 
of the box but we should verify this case).

Public API should not be changed. Tests should use internal API.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to