Automatic create schema in database

hamtho2 · **Joined:** Tue Jan 15, 2008 6:26 am **Posts:** 8

Hi,

is there any chance to let hiberrnate automatically create a schema?
I defined a default schema for my entities, but unfortunately it is only possible to deploy these entities, if the schema already exists in the database. I thought of something equal as it is already possible for automatic creation of database-tables for the entities if the property 'hibernate.hbm2ddl.auto' has been defined to 'create'.

Thanks for your help

Thomas

Hibernate version:
3.2.5 or newer

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

If you specify the default schema in the connection properties (hibernate.default_schema), Hibernate will write your data objects there. Additionally, you can specify a different schema on each of your mapping files (<hibernate-mapping. schema="xxx")

If what you want is to create several schemas on the fly, you can achieve that by creating several configuration objects.

Code:

      cfg.setProperty("hibernate.default_schema", "schema1");
String[] schema1=cfg.generateSchemaCreationScript(new org.hibernate.dialect.MckoiDialect());
      SchemaExport se1=new SchemaExport(cfg1);
      se1.create(true, true);

                ...

      cfg2.setProperty("hibernate.default_schema", "schema2");
String[] schema2=cfg.generateSchemaCreationScript(new org.hibernate.dialect.MckoiDialect());
      SchemaExport se2=new SchemaExport(cfg2);
      se2.create(true, true);

Consider, however, that your session comes from only one of those, therefore only one of these schemas can be takes as the default one. For the other, the schema will have to be specified in the schema name on the mapping files, or explicitly in your queries.