Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Do Vertica JDBC driver supports Statement.cancel()

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

  • 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()'?

  • Jim_KnicelyJim_Knicely 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.