[jira] [Updated] (DRILL-2837) Resolve what Statement.cancel() really should do

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Barclay (Drill) updated DRILL-2837:
------------------------------------------
    Summary: Resolve what Statement.cancel() really should do  (was: Resolve Statement.cancel() really should do)

> Resolve what Statement.cancel() really should do
> ------------------------------------------------
>
>                 Key: DRILL-2837
>                 URL: https://issues.apache.org/jira/browse/DRILL-2837
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>            Reporter: Daniel Barclay (Drill)
>            Assignee: Daniel Barclay (Drill)
>
> It is not clear exactly what JDBC's Statement.cancel() method is supposed to do.
> The Javadoc method description for cancel() says only:
> bq. Cancels this Statement object if both the DBMS and driver support aborting an SQL statement. This method can be used by one thread to cancel a statement that is being executed by another thread.
> In particular, it's not clear what "cancels this Statement" really means.  (The JDBC PDF specification doesn't anything about it.)
>  
> It seems reasonable to think that calling cancel() on a Statement cancels any associated query that has not already completed, leaves any associated ResultSet closed, and leaves the statement closed.
> However, JDBC doesn't actually specify any of that, AvaticaStatement.cancel() does not close the Statement, and it's not clear whether SQLLine expects the above interpretation or not.



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