Hello, I'm running the same code in 2 different environments, but both environments access the same MySQL database (3.23.47 Max, running on Solaris 2.8) and both use mm.mysql-2.0.7. Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a Windows machine Environment 2: JDK 1.3.1 running on Red Hat Linux release 6.2 Kernel 2.2.14-5.0 on an i686, also JDK 1.3.1 running on Solaris 2.8 - the code executing in this environment was exported as a jar from Environment 1.
The code in question: On an insert of a record into a table, if an SQLException is thrown, I am checking the SQLException.getErrorCode() to see if its a duplicate entry. (I looked at the MySQL error codes and saw that 1062 was the one to look for.) When I run this code in Environment 1, it gets the 1062. When I run it in Environment 2, it gets an error code of 0. The MySQL table type is MyISAM. I looked around at various documentation to see what might be causing this (JDBC differences between JDK 1.2 and 1.3, etc.) but didn't see a thing. Does anyone have any ideas? Thanks much. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php