-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Rusty,
Rusty Wright wrote: > I think the biggest gripe I've had with mysql is the problem where I was > violating a unique constraint and it was giving me some generic > (completely useless) error; HY001 I think. I've always found the error messages themselves very informative. For instance, if I attempt to insert a record into a table with an FK that doesn't match, MySQL's command-line interface gives me this message: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`database/target_table`, CONSTRAINT `name_of_foreign_key_constraint` FOREIGN KEY (`column_name`) REFERENCES `source_table` (`column_name`)) Perhaps Connector/J doesn't give quite such useful error messages, but I seem to recall something nice like "Foreign key constraint check failed". I have found that every database has stupid error codes and you basically have to code your app around tables of db-specific error codes if you want to give your users (or log files) anything better than the driver-supplied error messages. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkl38NUACgkQ9CaO5/Lv0PCwAgCggKgAfu/ZZ+ClRAGtEuM4+xyK e7EAn0R/4fyPgBfhxSB51um5ZW63jZzL =xo6L -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
