Bug #48658 List of error codes in class MysqlErrorNumbers and online docs is incomplete

• Submitted: 10 Nov 2009 9:26
• Modified: 11 Feb 2011 9:59
• Reporter: David Harper
• Status: Closed
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 5.1.10
• OS: Any
• Assigned to: Tony Bedford
• CPU Architecture: Any

[10 Nov 2009 9:26] David Harper

Description:
The list of error codes enumerated in com.mysql.jdbc.MysqlErrorNumbers is very incomplete.

None of the error codes from 1300 and above listed in mysqld_error.h are present in com.mysql.jdbc.MysqlErrorNumbers -- there are over 170 missing error codes.

Whilst this doesn't prevent Connector/J from working correctly, it *is* a serious inconvenience to application developers like myself who want to use the symbolic names for the error codes in their applications.

The documentation in

http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-error-sqlstates.html

is likewise incomplete, by the way.

How to repeat:
Compare mysqld_error.h with MysqlErrorNumbers.java

Suggested fix:
A simple awk script could be used to scan the latest version of mysqld_error.h to auto-generate a new version of MysqlErrorNumbers.java for each release of Connector/J.

[10 Nov 2009 12:24] Tonci Grgin

Hi David and thanks for your reasonable feature request.

Verified as described by looking into sources.

[13 Jan 2011 10:38] Tonci Grgin

Pushed up to revision 1035. No changelog entry as this is not actually a "fix".

[11 Feb 2011 9:59] Tony Bedford

The error codes referred to in the bug report are updated automatically from the source code. No changelog entry added as requested.