MySQL Error Number
Posted by: Hugh Mungus
Date: July 09, 2019 09:42AM

Can someone remind me how to get the MySQL error number from a Java program? I'm using MySQL Connector 8.0.16 and am getting an SQLState of 08S01 and an SQLCode of 0. Many things can cause 08S01 so I need the error number from MySQL, which is apparently NOT the same as the SQLCode.

I found a way to get an sql error number from a command prompt but that's not going to work given that I'm running a Java program and it is accessing a remote server. I'm assuming there's some way for the Java program to get the error number but haven't found it yet.

Options: ReplyQuote

Written By
MySQL Error Number
July 09, 2019 09:42AM
July 09, 2019 01:49PM
July 11, 2019 03:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.