Hbm2ddl

thommie · **Joined:** Sun Jul 01, 2007 4:10 am **Posts:** 5

Hi does anyone have an example that use hbm2ddl to create the database?

I need som help with it, i have my classes ant hbm.xml files. with this i want to create the database, so that i know that the database gets the right structure.

I appreciate all the help i can get with this, i have searched alot but cant figure it out!

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

There is an HibernateTask for cleaning/creating the database if you are using NAnt.
Otherwise, check around for docs on SchemaExport, the tool to use to do this.
Basically, you need a reference to you ISession and your NHibernate configuration object. Then you can:

Code:

IDbConnection connection = session.Connection;
new SchemaExport(configuration).Execute(false, true, false, true, connection, null);

Hope this helps

marcal · **Posted:** Mon Jul 02, 2007 10:35 am

One other note... the SchemaExport object currently only supports execution always with a conditional drop. So, don't execute at startup if there will be an existing database--it will get blown away.

In general, SchemaExport is very unsophisticated... but very useful for unit testing where you'd always like to have a brand-new DB at each test run, especially if you are changing your schema as you go. However, it is currently useless as a schema versioning tool in a production scenario.

thommie · **Joined:** Sun Jul 01, 2007 4:10 am **Posts:** 5

mnichols wrote:

There is an HibernateTask for cleaning/creating the database if you are using NAnt.
Otherwise, check around for docs on SchemaExport, the tool to use to do this.
Basically, you need a reference to you ISession and your NHibernate configuration object. Then you can:

Code:

IDbConnection connection = session.Connection;
new SchemaExport(configuration).Execute(false, true, false, true, connection, null);

Hope this helps

i´m not using NAnt, just started with Nhibernate, so i should search on SchemaExport?

Is it hard to configure Nhibernate to use schema export with my mapping files?