Spring Boot - JPA Hibernate not creating tables automatically?

Question

I have this code in my application.properties file:

# Spring DataSource
spring.datasource.driverClassName=org.postgresql.Driver
spring.sql.init.mode=always
spring.sql.init.platform=postgres
spring.datasource.url=jdbc:postgresql://localhost:5432/dbname
spring.datasource.username=postgres
spring.datasource.password=root

# JPA-Hibernate
spring.jpa.generate-ddl=true
spring.jpa.show-sql=false
spring.jpa.hibernate.ddl-auto=create

# https://stackoverflow.com/questions/43905119/postgres-error-method-org-postgresql-jdbc-pgconnection-createclob-is-not-imple
spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true

# Optimization for POSTGRES queries
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQL95Dialect

As you can see I have the spring.jpa.hibernate.ddl-auto=create line added but the tables are still not being created by the JPA. I have to manually create them in order for the project to compile. What is wrong?

maybe you use some keywords which reserved by jpa in you entities as fields. — amir raad
– amir raad, Commented Jan 6, 2023 at 15:08

Mark Rotteveel · Accepted Answer · 2024-12-28 12:26:24Z

5

You can use spring.jpa.hibernate.ddl-auto=update and check you are using @Table(name="table_name") top on the entity class. It may help.

edited Dec 28, 2024 at 12:26

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Jul 14, 2021 at 4:57

manish

1614 bronze badges

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

Comments

Mark Rotteveel · Accepted Answer · 2024-12-28 12:26:47Z

2

There are several possible causes:

Your entity classes are in the same or in a sub-package relative one where you have you class with @EnableAutoConfiguration. If not then your spring app does not see them and hence will not create anything in db
Your application.properties must be in src/main/resources folder.

Try adding @ComponentScan("package which contains entity classes, configurations and services")

edited Dec 28, 2024 at 12:26

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Jul 3, 2021 at 19:12

anish sharma

5904 silver badges6 bronze badges

Comments

S Badal · Accepted Answer · 2021-07-16 03:54:58Z

1

Check that you have added @Entity annotation to your model classes. Also, make sure that model classes are in the desired package.

answered Jul 16, 2021 at 3:54

S Badal

713 bronze badges

Comments

Mark Rotteveel · Accepted Answer · 2024-12-28 12:27:18Z

1

I faced this issue, so in application.properties, I replaced

spring.jpa.hibernate.ddl.auto=update

with

spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=update

Additionally, I added (optional)

spring.jpa.defer-datasource-initialization=true
spring.jpa.database = MYSQL

edited Dec 28, 2024 at 12:27

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered May 4, 2023 at 9:05

Muhammad Ali

1,1617 silver badges11 bronze badges

Comments

Descartes fowo · Accepted Answer · 2021-07-03 22:45:42Z

0

This is what you have to do:

1- Add @Entity annotation to every class you want to see as table

2- Add these lines in your application.properties:

spring.jpa.generate-ddl=true
spring.datasource.url=jdbc:postgresql://localhost:5432/dbname
spring.datasource.username=postgres
spring.datasource.password=root
spring.datasource.driver-class-name=org.postgresql.Driver
spring.jpa.show-sql=false 
spring.jpa.hibernate.ddl-auto=create-drop

answered Jul 3, 2021 at 22:45

Descartes fowo

12 bronze badges

Comments

amir raad · Accepted Answer · 2021-07-04 05:41:48Z

0

Check these annotations: 1- @Table( name: ), @ Entity on you class. 2- @Column(name: ), on each field.

answered Jul 4, 2021 at 5:41

amir raad

14210 bronze badges

Comments

Dharman · Accepted Answer · 2021-07-14 07:45:23Z

0

You can use this in the application.properties file it was work for me.

logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type=TRACE


spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
spring.data.jpa.repositories.enabled=true
spring.datasource.url=jdbc:postgresql://localhost:5432/dbname
spring.datasource.username=postgres
spring.datasource.password=password
spring.datasource.driverClassName=org.postgresql.Driver

And also use this annotation above the entity class.

 @Entity
 @Table(name=" give the name of the table you want ")

edited Jul 14, 2021 at 7:45

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jul 14, 2021 at 7:39

Kaushik Shaw

513 bronze badges

Comments

Badr B · Accepted Answer · 2022-11-16 21:13:56Z

0

My issue was that I created a new model, and one of the fields had a column name that was a reserved SQL keyword (e.g. "start", "end", "table", etc.) The table creation would fail due to a syntax error, but the application still started "successfully" for some reason.

answered Nov 16, 2022 at 21:13

Badr B

1,4441 gold badge15 silver badges20 bronze badges

Comments

Brandon Hauser · Accepted Answer · 2022-11-24 08:01:37Z

0

Make sure that your imports are from javax.persistence and not jakarta.persistence. Took me a while to solve this problem in a project where I was importing jakarta.persistence.Entity as well as other annotations. Once I switched all annotation imports to javax.persistence it all worked.

answered Nov 24, 2022 at 8:01

Brandon Hauser

1

1 Comment

kit Feb 4 at 18:16

jakarta is a rebrand of the javax package (because of Oracle). Changing the package to javax will be relevant when working with Spring Boot 2, as for Spring Boot 3 - you'll need to use jakarta

Procrastinator · Accepted Answer · 2024-06-18 05:54:27Z

0

I was also facing same issue. because I was using spring.jpa.properties.hibernate.dialect as org.hibernate.dialect.MySQLDialect replaced by org.hibernate.dialect.MySQL5InnoDBDialect and table got created

edited Jun 18, 2024 at 5:54

Procrastinator

2,67445 gold badges31 silver badges37 bronze badges

answered Jun 17, 2024 at 7:32

g_mdr

1

Comments

DiaMaBo Dev · Accepted Answer · 2025-01-11 07:03:05Z

0

I encounter the same error creation of the table and after having a long day, I mistakenly add String as type instead of Long

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private **String** id; <-- Long id;

answered Jan 11 at 7:03

DiaMaBo Dev

1

Comments

KARTHICK R · Accepted Answer · 2024-12-28 12:24:55Z

-1

In my case i have @SpringBootApplication(exclude = {DataSourceAutoConfiguration.class }) which is the RCA and fix is to remove the exclude

answered Dec 28, 2024 at 12:24

KARTHICK R

1

1 Comment

Dave Scotese Dec 29, 2024 at 21:34

I think you proposed an answer where you meant to add a comment to an existing answer. If this is not the case, then your answer needs to have a little more detail about why you feel that what you have will solve the asker's question.

Collectives™ on Stack Overflow

Spring Boot - JPA Hibernate not creating tables automatically?

12 Answers 12

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

12 Answers 12

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related