Hi,

We would like to be able to rely on ConstraintViolationException.getConstraintName() in our application.
The problem appears to be that different DBs and/or drivers will return the constraint in a different case.


e.g. It seems that no matter how we specify the constraints in the DDL, HSQLDB (1_8_0_RC9) always returns the constraint name in upper-case, and Informix (IBM JDBC 2.21 JC6) always in lower-case.

Currently, we have worked around this limitation by extending the Dialects to override getViolatedConstraintNameExtracter() to make it always return the constraint name in upper case.
That way, the application can rely on ConstraintViolationException.getConstraintName() in a database-agnostic way.

My question is:

Could this change be incorporated into the existing Dialects that ship with hibernate? (I'd rather not maintain this independently unless I need to)

Also, I've implemented buildSQLExceptionConverter(), etc. for InformixDialect (based on HSQLDialect's implementation).
How would I go about contributing this? Should I create a JIRA issue to submit my suggested changes?

Thanks

I'd rather not. Add it as a JIRA enhancement request and see if anyone votes for it.


Yes, thats the correct process. Add the *patch* as a JIRA enhancement request.

FYI, I've opened the following JIRA issues:

http://opensource.atlassian.com/project ... se/HHH-365
http://opensource.atlassian.com/project ... se/HHH-366