Can Hibernate create tables from mappings?

barabaka · **Joined:** Thu Nov 30, 2006 10:06 am **Posts:** 9

Can I create table or issue CREATE TABLE commands from Hibernate or some hibernate tools?

lester · **Posted:** Mon Dec 25, 2006 6:08 am

Yes, you can use Hibernate Tools.

Quote:

The tool used for schema generation is hbm2ddl; its class is org.hibernate.tool.hbm2ddl.SchemaExport, so it’s also sometimes called SchemaExport.

passos · **Posted:** Tue Dec 26, 2006 5:23 pm

Or use in your hibernate.cfg.xml:

Code:

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

djordje.ivanovic · **Joined:** Fri Dec 29, 2006 5:51 am **Posts:** 3

Sorry, mistake

djordje.ivanovic · **Joined:** Fri Dec 29, 2006 5:51 am **Posts:** 3

Can you give me some basic example how to use SchemaExport or hbm2ddl? Ok, i put <property name="hbm2ddl.auto">create</property> in hibernate.cfg.xml. What to do now? Please, this is wery urgent!!!

Thanks, Djordje

batmat · **Posted:** Fri Dec 29, 2006 7:51 am

It depends on what you want to do: if you just want to create the schema, then you're done. Just start your app and the schema will just be created as soon as you instantiate the sessionfactory.

If you want to get the SQL, it's very simple: read this part of the reference doc http://www.hibernate.org/hib_docs/v3/re ... etguide-s1

It will take you about three or four lines to write the code that will take your hibernate.cfg.xml file and generate all the corresponding SQL to the found mapping files.