Hi

I have a field which serves as the unique identifier for my entity.




My last validator is a custom validator that fires a SQL query to check if the entered tax code already exists in the table.

My problem is that Hibernate fires all the validators and then reports errors for the first one that failed validation. So my sql query in the custom validator runs every time until all other validations are passed.
Ouch !



Can someone offer advice how to handle this situation?

Thanks
Franco

Or should I not have custom validators at column level that fire SQL queries ?

Maybe a class level validator fired on save ?

But then, if my form has 30 fields starting with this as the first field, the user will know he has typed in an already existing code only at a later stage.

I am using JBoss Seam 2.0.2 SP1

I would like to keep all validations at the entity level. Can any other experienced Hibernate guys share how they handle duplicate key validations ?