SQLException Error codes

[David Pellegrini]

Hi All,

Where is the list of SQLException error codes documented? My search of the online manual
did not turn up anything.

My specific need is to detect when an insert results in a duplicate for a unique
key/index. I am accustomed (with Oracle) to examining the SQLException's getErrorCode()
for such matters, but it is
returning 0. I suppose I can scan the getMessage() for "Duplicate", but that
seems like a kludge ...

My config:
MySQL 3.22.20a
mm.mysql.jdbc-1.2a
Blackdown jdk117_v1a
Red Hat Linux 5.2

Thanks!

-David Pellegrini