Is it possible to create database with hibernate?

artsi · **Joined:** Wed Nov 19, 2003 3:08 pm **Posts:** 20

Hi folks!

Is it possible to create database & table's to it with hibernate?
Any properties??

Artsi

Martin Kersten · **Joined:** Tue Mar 16, 2004 5:15 am **Posts:** 33

Take a look on import net.sf.hibernate.tool.hbm2ddl.SchemaUpdate. It creates the required table-structure for all your mappings.

I guess Hibernate is not able to create a database on its own, since it is not the task it was build for. Take a look at HSQLDB. Its a lightweight DBMS written entirely in Java. It is supported by Hibernate and suites well for small and midsize DBs.

anthony · **Posted:** Tue Mar 16, 2004 6:18 am

do you know hibernate comes with a full doc?
please read it
http://www.hibernate.org/hib_docs/refer ... guide.html

artsi · **Joined:** Wed Nov 19, 2003 3:08 pm **Posts:** 20

Yes i know documents, i have consult them, and also tried google to find any information creating database with hibernate (like in sql (mysql) (CREATE DATABASE...)) but currently any document i have found, is from driven some grep agains sources.

It seems that its not possible to create database with hibernate, maby it's possible with jdbc, not tested yet.

Artsi

anthony · **Posted:** Tue Mar 16, 2004 6:40 am

just use ant task coupled with SchemaExport using your mySql jdbc driver, it works great!

emmanuel · **Posted:** Wed Mar 17, 2004 10:28 am

Hibernate don't create databases, it can create/update schemas