I am using Spring with Hibernate to persist User entities. Users have roles and attributes. The Users table has many-to-many relationships with the Roles table and with the Attributes table. There are several cases in which I get a DataIntegrityViolationException while saving a User:
- when trying to persist a User with an already existing userName (violation of UNIQUE constraint)
- when trying to persist a User with a Role that has been deleted (in the meantime) (violation of FOREIGN KEY constraint)
- when trying to persist a User with an Attribute that has been deleted (in the meantime) (violation of FOREIGN KEY constraint)
I would like to know if there is a way to discriminate between these exceptions, in order to be able to display an appropriate message. My application has to support multiple databases (Oracle, MSSqlServer). Parsing the exception messages is not an option.

hello

did you solve the problem? I also get this Exception when inserting a user with an assigned role.

I have three tables, TBENUTZER (with users), TPROFILE (with roles) and a mapping table TBENU_TPROFIL_MATRIX. The benutzer and profile also have a many-to-many relationship

Angela