Hi, is there any way of knowing which object has caused a constraint violation when I execute the save or update methods. I'm executing the save or update methods over an object which has many others and so on.
Thanks!!

Leandro

Check the log of hibernate.
It should contain a clear explanation.

If you haven't done so already - add the following poperty to the main conifguration file of hibernate:

<property name="show_sql">true</property>

To enable sql statements logging.

Vitaliy

Thanks Vitaliy!

I mean at runtime...
I need to know which object has caused the constraint violation to inform it to the user...
Thanks!!

Leandro

Can't you get this info from the details of the exception?

It depends on what piece of software checks the constraint.

If it ist Hibernate Validation you should be able to examine the exception in a fairly straight forward way.

If it is the database your options will depend on the database and the actual constraint. E.g. in oracle 8 (I'm not sure about 9) it is not possible to tell from the exception which field was to long during a insert. In Oracle 10 you will get the column name in the exception, but the exact position is probably Language dependent. For real constraints (foreign key, check constraints, Unique constraitns) you will get the name of the constraint somewhere in the message and could examine the data dictionary for more information

Jens

Thanks Jens!
I'm working with Oracle 10 and I think that the database is checking the constraints, how can I verify this?

I need to know which object has caused the constraint violation to inform it to the user...


I'm using real constraints, but when you say data dictionary, what do you mean?

Thanks!!

Leandro

Hi again,
You can very easily determine if a error message comes from Oracle: If so it will contain Errorcodes of the form
ORA-#####

where ##### stands for some number

If you are updating/inserting more then one object in one go you don't have much chances to relyable identify the object which caused the problem. In fact it might not even be well defined.

If you are inserting/updating a single row per transaction I guess you could store the executed sql statement, and the bind variables and thereby identifying the object. At least I think this should be possible with an 'intercepter'(?), a object that gets informed whenever a sql statement is executed.

HTH
Jens

Ok, thanks Jens!!