Hibernate is not auto-creating a table that does not exist in the DB

Question

I have a basic Hibernate code, I have set the property "hibernate.hbm2ddl.auto" as update still it is not auto-creating the table in the Database.

These are the required files:

employee.hbm.xml

<hibernate-mapping>
  <class name="contacts.employee" table="contacts">
      <meta attribute="class-description"></meta>
    <id column="contactId" name="contactId" type="string">
      <generator class="assigned"/>
    </id>
    <property column="contactName" length="100" name="contactName" not-null="true" type="string"/>
    <property column="password" length="100" name="password" not-null="true" type="string"/>
    <set cascade="all" name="groupOfResponsibilities" table="employee_responsibilty">
      <key column="contactId"/>
      <many-to-many class="contacts.responsibilities" column="responsibilityId"/>

    </set>

  </class>
</hibernate-mapping>

responsibility.hbm.xml

<hibernate-mapping>
  <class name="contacts.responsibilities" table="responsibilities">
    <meta attribute="class-description">
        This class list of responsibilities if an employee
    </meta>
    <id column="responsibilityId" name="responsibilityId" type="long">
      <generator class="increment"/>
    </id>
    <property column="responsibilityName" name="responsibilityName" type="string"/>
  </class>
</hibernate-mapping>

hibernate.cfg.xml

<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/****</property>
    <property name="hibernate.connection.username">*****</property>
    <property name="hibernate.connection.password">*****</property>
    <property name="hibernate.hbm2ddl.auto">update</property>
    <property name="hibernate.show_sql">true</property>
    <mapping resource="contacts/employee.hbm.xml"/>
    <mapping resource="contacts/responsibilitiy.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

This is the Main.java that I am trying to run:

public class Main {

    public static void main(String[] args) {

        SessionFactory sessionfactory = NewHibernateUtil.getSessionFactory();
        Transaction transaction = null;
        try {
            Session session = sessionfactory.openSession();
            transaction = session.beginTransaction();
            Set<responsibilities> groups = new HashSet<responsibilities>();
            responsibilities responsibilityOne=new responsibilities("Java");
            responsibilities responsibilityTwo=new responsibilities("SQL");
            responsibilities responsibilityThree=new responsibilities("Oracle");
            groups.add(responsibilityOne);
            groups.add(responsibilityTwo);
            groups.add(responsibilityThree);
            String uuid = UUID.randomUUID().toString();
            String uuid2 = UUID.randomUUID().toString();
            employee firstEmployee;
            firstEmployee = new employee(uuid, "Mike", groups);
            employee secondEmployee = new employee(uuid2, "Marc", groups);
            session.save(responsibilityOne);
            session.save(responsibilityTwo);
            session.save(responsibilityThree);
            session.save(firstEmployee);
            session.save(secondEmployee);

            transaction.commit();
        } catch (HibernateException e) {
            transaction.rollback();
            e.printStackTrace();
        } finally {

        }

    }
}

This is the error that I get:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '**.responsibilities' doesn't exist

score 26 · Accepted Answer · answered Feb 23 '15 at 09:58

26

I had the same issue, this worked for me -

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

answered Feb 23 '15 at 09:58

Sachchidanand Singh

1,456
1
15
15

1

Also to me. Likely nobody on the Earth can say, why the $§%&"§$ do we have to use sometimes `"hibernate.something"` property and sometimes only `"something"`... – peterh Aug 09 '17 at 13:35
I'm facing the same issue and i've tried `create` before also but it didn't work. I dont know whether I'll have to open a new question. – Tanzeel Aug 29 '21 at 04:04

score 24 · Answer 2 · answered Oct 11 '15 at 14:49

The following scenario could be another reason why Hibernate cannot auto-create your table:

@Entity
public class Employee {
  @Id
  @GeneratedValue
  private String empID;
  private String name;
}

The table Employee will not be auto-created by Hibernate since empID is a String and it has the @GeneratedValue annotation. empID should be an int or long. I had this problem sometime and I changed my id field that had the @GeneratedValue annotation to be of type int and Hibernate auto-created the table.

score 12 · Answer 3 · edited May 23 '17 at 12:16

12

I had the same problem, I solved it by changing:

org.hibernate.dialect.MySQLInnoDBDialect

to

org.hibernate.dialect.MySQLDialect

I found the solution in this question.

edited May 23 '17 at 12:16

Community

1
1

answered Oct 06 '14 at 13:30

Carloso

135
1
10

Same goes for the spatial versions of the dialects. Hibernate has a lot of mysterious error logs. – Allan Veloso Mar 21 '19 at 15:51
1

The referred question suggests: `MySQL5InnoDBDialect` instead of `MySQLInnoDBDialect` which worked for me. – Arashsoft May 14 '19 at 20:53

score 3 · Answer 4 · answered Oct 23 '14 at 08:27

3

I had the same issue, but for me the solution was:

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

instead of

<property name="hibernate.hbm2ddl">create-drop</property>

answered Oct 23 '14 at 08:27

Cristi B.

651
7
17

score 3 · Answer 5 · edited Jul 11 '18 at 10:15

First, check your MySQL version with $mysql --version $mysql Ver 14.14 Distrib 5.5.11

Then change Dialect accordingly

then change the dialect property /For this example I have given MySQL55Dialect/ org.hibernate.dialect.MySQL55Dialect

//////////////////////////////////////////////// --where you can find Dialect:

org.hibernate.dialect
try 
import org.hibernate.dialect.ctrl+space
you find option

Hope this Help

urug · Answer 6 · 2014-03-11T22:32:26.030

2

Why don't you try create or create-drop instead. Seems to serve your purpose. http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-optional

edited Mar 11 '14 at 22:32

answered Feb 10 '14 at 12:36

urug

405
7
18

score 1 · Answer 7 · answered Dec 27 '20 at 10:03

1

I add to Spring application.properties and work

spring.datasource.driver.class-name=com.mysql.jdbc.Driver
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.generate-ddl=true

answered Dec 27 '20 at 10:03

m_besmek

41
4

score 0 · Answer 8 · answered Oct 08 '20 at 17:43

0

If u are Using Hibernate 5 or above this will be solved by changing the dialect to org.hibernate.dialect.MySQL5Dialect. It worked for me .

answered Oct 08 '20 at 17:43

Vivek

27
4

score 0 · Answer 9 · answered Sep 01 '22 at 20:31

0

for me, there was space in table name in hibernate annotation. Once removed space, table got created.

answered Sep 01 '22 at 20:31

laas_me

1
1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Sep 08 '22 at 10:14

score -1 · Answer 10 · answered Nov 12 '17 at 16:30

Hibernate can create 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 Configuration object. By Default it just validate the schema with DB and fail if anything not already exist by giving error "ORA-00942: table or view does not exist".

score -1 · Answer 11 · answered Aug 09 '18 at 14:21

For the existing working environment, or for any big application area, it's not recommended to set hibernate.hbm2ddl.autoon create or create-drop , as it is shown below

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

though it works, but it will drop all the existing tables of the database every time you restart the server.

If you are using the hibernate jar version 5.2.0 then please switch to either lower or any other version.This version jar is having some issue regarding update.

It worked for me and i hope it will work for others too.

score -1 · Answer 12 · answered Jun 20 '21 at 06:44

-1

after 3 hours In my case i was using wrong groupID and artifact in the packages names.

answered Jun 20 '21 at 06:44

George S

11
1

score -1 · Answer 13 · edited Jul 30 '21 at 18:21

-1

Adding this in application.properties works for me

spring.jpa.generate-ddl=true

edited Jul 30 '21 at 18:21

Barak

3,066
2
20
33

answered Jul 30 '21 at 12:23

Sergio Lewczuk

1

score -2 · Answer 14 · answered Aug 10 '18 at 07:59

-2

Just do correct configuration

1) Create, Every time a new table will create. All Old data will be deleted.

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

2) Update, If any modification has done then same will reflect to DB.

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

answered Aug 10 '18 at 07:59

Angad Bansode

825
6
15

This is not answering the reason for failure. I guess everyone knows what option create or update do. This is a very generic answer, without understanding the question. – Amit Baderia Aug 11 '19 at 15:54

Hibernate is not auto-creating a table that does not exist in the DB

14 Answers14

Linked

Related