How do I let Hibernate create the database?

hlfsousa · **Posted:** Mon Jul 10, 2006 2:11 pm

Hello, everyone! I have an EJB 3 application, and so far I create the Oracle database schema myself. Now I want to test the application on MySQL and I surely don't want to review and change dozens of table definitions and constraints to do it. How should I proceed? Is there any property to set in persistence.xml which will flag that I want the schema created for me?
Thanks a lot

alesj · **Posted:** Tue Jul 11, 2006 3:30 am

Code:

hibernate.hbm2ddl.auto    Automatically validate or export schema DDL to the database when the SessionFactory is created. With create-drop, the database schema will be dropped when the SessionFactory is closed explicitly.

eg. validate | update | create | create-drop 

<!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">create</property>