How avoid to create every time DB

craig1980 · **Joined:** Wed May 24, 2006 5:47 pm **Posts:** 14

Hi all. I'm newbie in hibernate. I'm using the Hibernate tools in order to create DB from my mapping files. In the hibernate.cfg.xml file i have inserted this tag:

<property name="hibernate.hbm2ddl.auto">create</property>

Well it seems to me that every time i start my application the tables are created even if they are already present. I'ld like to avoid this....how can i configure the tool in order to avoid this feature?

I'm using hibernate 3 on a project and hibernate 2.1.8 on another project. My environament is:

HIBERNATE 3 PROJECT:
JVM 1.5
LINUX RED/HAT ADVANCED SERVER
WINDOWS XP PROFESSIONAL
JBOSS 4.0
SIMPLE STAND-ALONE TEST PROGRAM

HIBERNATE 2.1.8 PROJECT:
JVM 1.4.10
LINUX RED/HAT ADVANCED SERVER
WINDOWS XP PROFESSIONAL
JBOSS 3.2.6
SIMPLE STAND-ALONE TEST PROGRAM

Thanks to all.
Angelo

thofis · **Posted:** Sun Jun 18, 2006 4:46 pm

You can comment the tag out (as it is not mandatory) like this...

Code:

... or you can set the value to validate (in hibernate 3)

Code:

<property name="hibernate.hbm2ddl.auto">validate</property>

Then hibernate won't create the tables at start, but will validate that your configuration fits to your tables.