You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/04/21 19:29:58 UTC

[jira] [Updated] (DRILL-2837) Resolve what JDBC's Statement.cancel() really does

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

Daniel Barclay (Drill) updated DRILL-2837:
------------------------------------------
    Description: 
It is not clear exactly what JDBC's Statement.cancel() method is supposed to do.

The Javadoc method description for cancel() says only:

"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."




The JDBC PDF specification 


It seems reasonable to think that calling calling() on a Statement causes any associated query that has not already completed to be canceled, causes any associated ResultSet that is not already closed to be closed, and causes the statement to be closed.

In particular, it doesn't say whether the Statement object is closed or that any ResultSet is closed (and doesn't actually say that the query is canceled).





However, 

  was:
It is not clear exactly what JDBC's Statement.cancel() is supposed to do.

It seems reasonable to think that calling calling() on a Statement causes any associated query that has not already completed to be canceled, causes any associated ResultSet that is not already closed to be closed, and causes the statement to bebe closed.

The Javadoc method description for it says only:

"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."


It seems reasonable to think think that calling cancel() on a Statement causes the statement to be closed



(In particular, it doesn't say whether the Statement object is closed, doesn't say wha


However, 


> Resolve what JDBC's Statement.cancel() really does
> --------------------------------------------------
>
>                 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:
> "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."
> The JDBC PDF specification 
> It seems reasonable to think that calling calling() on a Statement causes any associated query that has not already completed to be canceled, causes any associated ResultSet that is not already closed to be closed, and causes the statement to be closed.
> In particular, it doesn't say whether the Statement object is closed or that any ResultSet is closed (and doesn't actually say that the query is canceled).
> However, 



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