Options

Do Vertica JDBC driver supports Statement.cancel()

rishabrajrastogirishabrajrastogi
in General Discussion

I have a query which is taking significant time in returning results. So, I want to kill a running Vertica query through JDBC.
Kindly, let me know if Vertica JDBC driver supports 'Statement.cancel()'.
If it does not, what could be good way to achieve this.
Thanks in Advance

Comments

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Check out this thread:

    https://forum.vertica.com/discussion/236134/cancel-vertica-statement-from-jdbc

  • Options
    rishabrajrastogirishabrajrastogi
    edited September 2017

    Hi Jim

    Thanks for the answer,

    In the thread you posted, Chris_S says,
    "You are right in finding out that the current JDBC driver does not support canceling queries through .cancel().".
    So, is it correct to assume that Vertica JDBC driver does not support '.cancel()'?

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited September 2017

    I just checked the hot fix history. Looks like this issue was fixed in Vertica 7.2.3 released on 05/20/2016.

    Hot Fix details:
    Client Drivers - JDBC - Calling the Vertica JDBC driver cancel method could fail on a statement taking a long time to complete. This issue has been resolved.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...