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.

Miss Chanandler Bong · Accepted Answer · 2020-03-23 14:22:34Z

59

<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, 2020 at 14:22

Miss Chanandler Bong

4,27811 gold badges30 silver badges40 bronze badges

answered Jul 15, 2015 at 6:26

Aung Myat Hein

4,2081 gold badge40 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Pascal Schneider Over a year ago

If you put a value in the property 'password', is automatically set and used?

Aung Myat Hein Over a year ago

Yes. hibernate will do automatically.

Azarea Over a year ago

how can i set the character encoding when creating database?

Aung Myat Hein Over a year ago

Use jdbc:mysql://localhost:3306/footballdb?createDatabaseIfNotExist=true&useUnicode=yes&characterEncoding=UTF-8

tesnik03 · Accepted Answer · 2014-01-12 00:43:10Z

13

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

will do

answered Jan 12, 2014 at 0:43

tesnik03

1,3792 gold badges13 silver badges24 bronze badges

6 Comments

Billie Over a year ago

Thanks! when is the difference between this and <property name="hibernate.hbm2ddl.auto">update</property>?

tesnik03 Over a year ago

create will create a new schema and update will look for the schema and do the update

Billie Over a year ago

I can use create instead of udpate , or should I use both?

tesnik03 Over a year ago

just create is enough for the first time and then change it back to update for future

nr.iras.sk Over a year ago

@yyny: this will not create database from my experience. If database is there, it will create tables. Thats only. Any other way?

|

Jugal Panchal · Accepted Answer · 2014-11-03 02:30:26Z

7

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.

answered Nov 3, 2014 at 2:30

Jugal Panchal

1,56817 silver badges21 bronze badges

Comments

simon · Accepted Answer · 2016-05-12 12:51:57Z

7

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, 2016 at 12:51

simon

7759 silver badges23 bronze badges

1 Comment

codepleb Over a year ago

I really like this solution, but it does not work for me. I get com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Collectives™ on Stack Overflow

Hibernate auto create database

4 Answers 4

4 Comments

6 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

6 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related