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

Vertica sql error codes

Hi,
I'm using SQLException to catch faulty sql operations.
according to documentation SQLException.getErrorCode() is supposed to return vendor specific codes (Vertica in this case)
I was not able to find any error codes table that correspond to what I'm getting from this method for example:
code 2629 when trying to modify column's datatype with the same datatype it already has.
Is there any?
Thanks.

Comments

  • Hi,

    We do have one such list in Vertica Doc. However, I am unable to find the error code you mentioned. 
    I hope it helps with other error code you get.

    Programmer's Guide --> Appendix: Error Codes --> HP Vertica SQLSTATE List
    (https://my.vertica.com/docs/6.1.x/HTML/index.htm#22351.htm)

    Thanks,
    Pravesh


  • Hi,
    This is the exact table I encountered in my search, and I don't find any match between it and the values returned in getErrorCode of SQLException.
    This specific value was just an example but I'm having the same issue with all the error codes.
    Ideas?
    Thanks,
    Rotem.
  • Rotem,

    Let me try and find something on this.

    I will get back.

    Thanks,
    Pravesh
  • Hi Pravesh,
    I'm still waiting for an answer on that.
    Thanks,
    Rotem.

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.