java - How to create database in Hibernate at runtime?

Question

I'm using Hibernate tenancy and every time user logs I'm changing database to his username (SQLite). Sadly sometimes the database does not exists and I need to create it.

The problem is that I don't know how to create all tables in database at runtime.

Normally Hibernete creates for me db with this:

<property name="hibernate.hbm2ddl.auto">update</property>

Answer 1

Did you try the value create instead.

A value of create will create your tables at sessionFactory creation, and leave them intact.

A value of create-drop will create your tables, and then drop them when you close the sessionFactory.

That would be

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

More infornation here and here
Or there could be a dialect problem