Hi!
I am confused about import.sql feature as well a few things around it.
i am using version of hibernate that comes with jboss seam 2.0.3.CR1 (version 3.something)
Besides that it is jboss AS 4.2.2 GA, Postgres db.

I have 2 tables for 2 entitys/classes. None of the tables gets updated
with stuff from import.sql if i am using setting
<property name="hibernate.hbm2ddl.auto" value="update"/>
but both gets "updated" with one of those 2 setting.
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
or
<property name="hibernate.hbm2ddl.auto" value="create"/>
in persistence.xml file.
The first table is called competence_group and it actually doesnt get
droped(probably because it has a foreign key) It does get updated though, preserving old values despite hibernate.hbm2ddl.auto=create or create-drop. When i change it to update then no updates to that table.
The second table either gets created and then data from import.sql inserted or nothing with hibernate.hbm2ddl.auto=update.

My question is why ? :)

I dont see any errors in the server.log except sometimes about errors in the import.sql, although i am able to run sql from import.sql manually

Please help!
/Alex