[jira] [Commented] (CALCITE-767) Commit functionality not exposed by the RPC server

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14634332#comment-14634332 ] 

James Taylor commented on CALCITE-767:
--------------------------------------

[~ndimiduk] - it'd be great if Avatica could add support for commit and rollback in it's RPC. Is there a Calcite JIRA for that that I can follow?

> Commit functionality not exposed by the RPC server
> --------------------------------------------------
>
>                 Key: CALCITE-767
>                 URL: https://issues.apache.org/jira/browse/CALCITE-767
>             Project: Calcite
>          Issue Type: Improvement
>          Components: avatica
>            Reporter: Lukas Lalinsky
>
> It seems that the commit/rollback functionality is not exposed by the RPC server, which means that it's only usable in autocommit mode. Avatica itself doesn't have a concept of commit in the RPC and the remote JDBC connection raises an exception when calling commit() on it, but Phoenix's native JDBC connection does implement commit(), so the RPC needs to be extended to allow calling that remotely.
> The easiest way to test this, "!autocommit off" and then "!commit" fails in "sqline-thin.py", but works in "sqline.py".



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)