Hello,

I am fairly new to hibernate, I have only used it to do simple things so far.
My scenario is this: I will have a table of users, the user.Name property is a unique column. What strategy should i take to ensure that there isnt a violation of the unique constraint and also tell the user that the name was already taken. I can catch DataIntegrityException in spring, but that does not tell me which column(s) was the culprit, neither does hibernate without having to do some regexp trickery with exception.getMessage();

Thanks

I was about to raise a new topic, but what I would like to achieve is the same as you zegloman.

I envisaged using the Hibernate mapping information to determine whether a given column has a unique index before saving data. This way, I hope to avoid unique constraint violations by running a Criteria query before saving (within the same transaction of course).

But does anyone know where in the Hibernate API we can get this information??

Thanks,

Doug.