MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL Error Number
Hugh Mungus
July 09, 2019 09:42AM
Re: MySQL Error Number
Peter Brawley
July 09, 2019 01:49PM
Re: MySQL Error Number
Filipe Silva
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.