[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2890) Hibernate cannot wrap HSQLDB constraint violations exceptions

Hibernate cannot wrap HSQLDB constraint violations exceptions ------------------------------------------------------------- Key: HHH-2890 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2890 Project: Hibernate3 Issue Type: Sub-task Components: core Affects Versions: 3.2.1 Reporter: Baptiste MATHUS Priority: Minor Attachments: UnitTestConstraintBug.zip Since I can't attach a file to a bug that hasn't been logged by me. I'll create a sub-bug, since logging a bug was anyway something I planned to do when I created the testcase. In the attached zip, you'll find a project that has two entities: Customer and Invoice. An Invoice references a Customer. I show that trying to delete a Customer that's referenced by an invoice doesn't throw a ConstraintViolationException with HSQLDB (1.8.0.7 or 1.7.3.3 gives the same result). The testcase is in the test package. I hope this helps tackle the problem. Before logging a bug in the HSQL tracker, I'd really appreciate to have your opinion. Shoud I do it? FYI, I tested the very same code on Oracle, and the ConstraintViolationException is very well thrown...