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.
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.
0
Comments
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
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.
Let me try and find something on this.
I will get back.
Thanks,
Pravesh
I'm still waiting for an answer on that.
Thanks,
Rotem.