Hibernate version: 3.1.3
HSQLDB version: 1.8.0.5

I am unable to get the unique="true" to do anything at all in HSQLDB. It seems like setting it to true or false has no effect at all one way or another.

Here is a snippet from my HBM file.


I can insert 2 records into the DB using hibernate with the same title without an error of any kind.

Anyone have any ideas or thoughts or suggestions?
:-)
-AZ

Well, it seems to do something in fact. Did you modify the schema or ask SchemaUpdate to do it? For me, it adds a unique(theColumn) at the end of the ddl of the table creation.

I just tested, if I try to use the same name on 2 instances, it throws a ConstraintViolationException.

Maybe you thought that Hibernate would perform a unique check if unique="true" is specified? If so, just be aware that this information is only used by the schema creation code, so as to generate the schema (and so the unique constraint). Hibernate can't simply do this check, because it would force it to load every instances of a class to do that check at each insert/update :-).

HTH

The following should do the trick, I believe:



HTH,

Tara