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.
Vertica sql error codes
+2Hi,
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
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.
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.
Hi Pravesh,
I'm still waiting for an answer on that.
Thanks,
Rotem.
I'm still waiting for an answer on that.
Thanks,
Rotem.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
