Hibernate auto create database

Question

I have a Java EE Hibernate project, and I'm using MySQL as a database.

I want that when I first time run the project, it will create the database automatically.

This is my hibernate.cnf.xml:

<?xml version='1.0' encoding='utf-8' ?>

<!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" >

<hibernate-configuration>
    <session-factory>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost/InternetProject</property>
        <property name="connection.username">root</property>
        <property name="connection.password"></property>
        <property name="connection.pool_size">10</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        <property name="show_sql">true</property>
        <mapping class="entities.Business" />
        <mapping class="entities.Coupon" />
        <mapping class="entities.User" />
        <mapping class="entities.LastLogin" />
    </session-factory>  
</hibernate-configuration>

When I first time run this project on another computer, how can I make the database InternetProject to be created?

According to the config file, it might already do it and I'm not aware to it.

Thanks in advance.

score 57 · Answer 1 · edited Mar 23 '20 at 14:22

57

<property name="hibernate.hbm2ddl.auto">create</property> will create tables. But it will not create database. Change the connection url to generate the database.
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/InternetProject?createDatabaseIfNotExist=true</property>
<property name="connection.username">root</property>
<property name="connection.password"></property>
<property name="connection.pool_size">10</property>

Update : character encoding when creating database

<property name="connection.url">
    jdbc:mysql://localhost/InternetProject?createDatabaseIfNotExist=true&useUnicode=yes&characterEncoding=UTF-8
</property>

edited Mar 23 '20 at 14:22

Miss Chanandler Bong

4,081
10
26
36

answered Jul 15 '15 at 06:26

Aung Myat Hein

4,018
1
36
42

If you put a value in the property 'password', is automatically set and used? – Pascal Schneider Feb 06 '18 at 07:57
1

Yes. hibernate will do automatically. – Aung Myat Hein Feb 06 '18 at 08:09
how can i set the character encoding when creating database? – Azarea Mar 22 '18 at 02:18
1

Use jdbc:mysql://localhost:3306/footballdb?createDatabaseIfNotExist=true&useUnicode=yes&characterEncoding=UTF-8 – Aung Myat Hein Mar 22 '18 at 02:24

score 13 · Answer 2 · answered Jan 12 '14 at 00:43

13

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

will do

answered Jan 12 '14 at 00:43

tesnik03

1,324
2
13
23

1

Thanks! when is the difference between this and `update`? – Billie Jan 12 '14 at 00:50
2

create will create a new schema and update will look for the schema and do the update – tesnik03 Jan 12 '14 at 01:01
1

I can use `create` instead of `udpate` , or should I use both? – Billie Jan 12 '14 at 01:11
1

just create is enough for the first time and then change it back to update for future – tesnik03 Jan 12 '14 at 01:13
11

@yyny: this will not create database from my experience. If database is there, it will create tables. Thats only. Any other way? – skmaran.nr.iras Sep 16 '14 at 03:41
this xml sintax doesnt validate. cvc-complex-type.2.1: Element 'property' must have no character or element information item [children], because the type's content type is empty – Savrige Nov 16 '15 at 19:07

score 8 · Answer 3 · answered May 12 '16 at 12:51

8

Hibernate will not create the database for you, only the tables. To create the database you need to tell MySQL to create it if it does'nt already exist by adding a parameter to the URL. E.g.:

jdbc:mysql://db:3306/mydatabase?createDatabaseIfNotExist=true

answered May 12 '16 at 12:51

simon

707
8
22

I really like this solution, but it does not work for me. I get `com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure` – codepleb Nov 11 '16 at 11:47

score 7 · Answer 4 · answered Nov 03 '14 at 02:30

There are multiple option for auto property.

create - It creates new tables corresponding mapping or annotation. It drops existing tables and data.
update - It keeps existing data and tables. It updates schema. here we have to take care contrants.
create-drop - It is same like create but once session gets closed it drops everything.
validate - it validates or matches schema with map or annotation. It's valid for Production environment.
```

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

I hope it helps.

Hibernate auto create database

4 Answers4

Linked