Does Hibernate create tables in the database automatically

Question

Upon reading this (archived) tutorial, they have not mentioned anything over creating tables in the DB. Does the Hibernate handle it automatically by creating tables and fields once i specify them.

Here is my beans configuration.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:prefix="/WEB-INF/jsp/" p:suffix=".jsp" />
    
    <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/spring"/>
        <property name="username" value="monwwty"/>
        <property name="password" value="www"/>
    </bean>
    
    <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="myDataSource" />
        <property name="annotatedClasses">
            <list>
                <value>uk.co.vinoth.spring.domain.User</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.hbm2ddl.auto">create</prop>
            </props>
        </property>
    </bean>
    
    <bean id="myUserDAO" class="uk.co.vinoth.spring.dao.UserDAOImpl">
        <property name="sessionFactory" ref="mySessionFactory"/>
    </bean>
    
    <bean name="/user/*.htm" class="uk.co.vinoth.spring.web.UserController" >
        <property name="userDAO" ref="myUserDAO" />
    </bean>
    
</beans>

Jin Kwon · Accepted Answer · 2014-11-12 02:20:15Z

58

your hibernate.hbm2ddl.auto setting should be defining that the database is created (options are validate, create, update or create-drop)

edited Nov 12, 2014 at 2:20

Jin Kwon

22.4k18 gold badges133 silver badges219 bronze badges

answered Dec 22, 2010 at 7:48

David O'Meara

3,03328 silver badges40 bronze badges

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

1 Comment

Mark W Over a year ago

this setting is found in the hibernate config file.

Aravind Yarram · Accepted Answer · 2012-01-27 20:22:30Z

23

Yes it does in your case because of the below property in your config. This is ok during testing but in production you need to disable this.

<prop key="hibernate.hbm2ddl.auto">create</prop>

edited Jan 27, 2012 at 20:22

answered Dec 22, 2010 at 7:48

Aravind Yarram

80.5k49 gold badges239 silver badges335 bronze badges

2 Comments

William Morrison Over a year ago

Could you elaborate on why disabling this during production is advisable?

Kevin Meredith Over a year ago

"The built-in Hibernate connection pool is in no way intended for production use. It lacks several features found on production-ready connection pools." docs.jboss.org/hibernate/orm/4.2/quickstart/en-US/html/…

z0r · Accepted Answer · 2013-02-11 23:01:33Z

6

For me it wasn't working even with hibernate.hbm2ddl.auto set to update. It turned out that the generated creation SQL was invalid, because one of my column names (user) was an SQL keyword. This failed softly, and it wasn't obvious what was going on until I inspected the logs.

answered Feb 11, 2013 at 23:01

z0r

8,6805 gold badges67 silver badges87 bronze badges

Comments

Aaric Chen · Accepted Answer · 2016-03-09 09:19:26Z

6

add following property in your hibernate.cfg.xml file

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

BTW, in your Entity class, you must define your @Id filed like this:

@Id
@GeneratedValue(generator = "increment")
@GenericGenerator(name = "increment", strategy = "increment")
@Column(name = "id")
private long id;

if you use the following definition, it maybe not work:

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id")
private long id;

answered Mar 9, 2016 at 9:19

Aaric Chen

1,1881 gold badge11 silver badges12 bronze badges

Comments

SkyWalker · Accepted Answer · 2016-07-27 02:00:13Z

6

Yes, Hibernate can be configured by way of the hibernate.hbm2ddl.auto property in the hibernate.cfg.xml file to automatically create tables in your DB in order to store your entities in them if the table doesn't already exist.

This can be handy during development where a new, in-memory, DB can be used and created a new on every run of the application or during testing.

edited Jul 27, 2016 at 2:00

SkyWalker

29.3k14 gold badges77 silver badges134 bronze badges

answered Jan 8, 2012 at 6:01

prem

611 silver badge1 bronze badge

Comments

KC_911723 · Accepted Answer · 2019-08-28 04:16:59Z

5

If property hibernate.ddl-auto = update, then it will not create the tables automatically. To create tables automatically, you need to set the property to hibernate.ddl-auto = create

The list of option which is used in the spring boot are

validate: validate the schema, makes no changes to the database.
update: update the schema.
create: creates the schema, destroying previous data.
create-drop: drop the schema at the end of the session
none: is all other cases

So for the first time you can set it to create and then next time on-wards you should set it to update.

answered Aug 28, 2019 at 4:16

KC_911723

1632 silver badges4 bronze badges

Comments

Ankit · Accepted Answer · 2015-12-02 10:16:28Z

0

yes you can use

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

answered Dec 2, 2015 at 10:16

Ankit

6035 silver badges12 bronze badges

Comments

Ashish Sharma · Accepted Answer · 2017-11-12 16:36:40Z

0

Hibernate can create a table, hibernate sequence and tables used for many-to-many mapping on your behalf but you have to explicitly configure it by calling setProperty("hibernate.hbm2ddl.auto", "create") of the Configuration object. By Default, it just validates the schema with DB and fails if anything not already exists by giving error "ORA-00942: table or view does not exist".

If you do above configuration then order of performed actions will be:- a) Drop all tables and sequence and do not give an error if they are not already present. b) create all table and sequence c) alter tables with constraints d) insert data into it.

answered Nov 12, 2017 at 16:36

Ashish Sharma

6801 gold badge11 silver badges26 bronze badges

Collectives™ on Stack Overflow

Does Hibernate create tables in the database automatically

8 Answers 8

1 Comment

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

1 Comment

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related