Hi, I'm migrating from Hibernate 2.1.7 to Hibernate version:3. The schema update functionality worked alright with the 2.1.7 version of Hibernate (on HSQLDB 1.7.3 and the latest 1.8).

But after installing Hibernate 3, schemaupdate wants to add the constraints again (even though they already exists and there are no changes in the mapping-files). The problem is maybe that metadata lookup differs from H2 (I havn't change database version since then)???
Ex:
config.configure(getHibernateMappingFile());
new SchemaUpdate(config).execute(true, true);

I didn't notice this problem until I started up with a rather big HSQL DB, containing millions of rows. Due to this problem, my database grows with at least a factor 10.

(Just to be clear, HSQLDB doesn't allocate this amount of space to minimize fragmentation - if anyone would suggest that...)

Any ideas what to do?
Thanks!

Just a thought. It might just be that all constraints didn't exists or were disabled, due to some reason.