Hi,

I'm currently facing the following issue:

I would like to auto-create a MSSQL-database (MSSQL Server Express 2014).

I've set the following properties:

<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.url">jdbc:sqlserver://127.0.0.1\SQLEXPRESS;databaseName=mm_test</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>

This works well, if the database 'mm_test' already exists - i.e. it creates the table structure of the configuration-mappings.

However, how can I accomplish that the database mm_test will be automatically created, if it does not exist?

I've found the possibility to put a parameter into the connection-url e.g.

<property name="hibernate.connection.url">jdbc:sqlserver://127.0.0.1\SQLEXPRESS;databaseName=mm_test;createDatabaseIfNotExist=true;</property>

which does obviously not work for MSSQL-databases.

Also if I create a root-database hibernate configuration and run a HSQL - statement (CREATE DATABASE mm_test) in NetBeans, I get java.lang.IllegalArgumentException: node to traverse cannot be null!

Any hint appreciated,

Thanks,

Regards

Klaus

Hibernate does not create databases. The database has to be there.

More, you should use a tool like Flyway in production. Hbm2ddl is suitable for testing or creating the initial script only.

Thanks!