Spring Boot doesn't create tables in Postgres

Question

I am trying to generate schema tables based on entities. But tables are not created. What's wrong?

Entity example:

@Entity
@NoArgsConstructor
@Getter @Setter
public class User {
    @Id @GeneratedValue(strategy = GenerationType.AUTO)
    public Long id;

    public String username;
    public String password;

    public User(String username, String password) {
        this.username = username;
        this.password = password;
    }

    public User(String username) {
        this(username, username + "pass");
    }
}

application.properties:

spring.datasource.url=jdbc:postgresql://localhost:5432/dbtest
spring.datasource.username=vssekorin
spring.datasource.password=
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.hibernate.ddl-auto=update

Dependencies:

compile('org.springframework.boot:spring-boot-starter-data-jpa')
runtime('com.h2database:h2')
compile('org.telegram:telegrambots:3.6.1')
runtime('org.postgresql:postgresql')
compileOnly('org.projectlombok:lombok')
testCompile('org.springframework.boot:spring-boot-starter-test')

Warning: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement

can you show the complete log for this "GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement" — Keaz
– Keaz, Commented Jul 11, 2018 at 15:30

Lorelorelore · Accepted Answer · 2018-07-11 14:35:56Z

15

It should be:

spring.jpa.generate-ddl = true

in your application.properties.

Or you can change this line:

spring.jpa.hibernate.ddl-auto=update

in

spring.jpa.hibernate.ddl-auto=create

More details: Spring Database initialization

answered Jul 11, 2018 at 14:35

Lorelorelore

3,4038 gold badges32 silver badges44 bronze badges

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

Comments

Yogendra Mishra · Accepted Answer · 2018-07-11 14:40:14Z

2

just change spring.jpa.hibernate.ddl-auto from update to create.

answered Jul 11, 2018 at 14:40

Yogendra Mishra

2,6392 gold badges17 silver badges21 bronze badges

Comments

Aziz · Accepted Answer · 2021-04-06 09:44:00Z

0

Try adding this property spring.datasource.driverClassName=org.postgresql.Driver

and change spring.jpa.hibernate.ddl-auto from update to create

answered Apr 6, 2021 at 9:44

Aziz

1

1 Comment

Mr R Over a year ago

Hi @Aziz - welcome to Stack Overflow. Your answer more than 2.5 years after an answer was provided that accepted by the author of the OP (original post) doesn't seem to add anything new, OR you believe it does, then please edit the accepted answer to add your new insight.

Abror · Accepted Answer · 2023-03-02 02:17:43Z

0

Entity(name="Users") postgresql can't create a table named user and

spring.jpa.hibernate.ddl-auto=create

answered Mar 2, 2023 at 2:17

Abror

12 bronze badges

1 Comment

nmngl31 Jul 18 at 19:33

Thanks! I had spring.jpa.hibernate.ddl-auto = create-drop. Changing entity from 'User' to 'Users' did the trick for me.

lf.melo · Accepted Answer · 2023-03-24 22:30:44Z

0

In my case, i created a entities package outside the main application class;

Exemple:

wrong

correct

edited Mar 24, 2023 at 22:30

answered Mar 24, 2023 at 22:07

lf.melo

595 bronze badges

Comments

Faycal Mehdi · Accepted Answer · 2024-02-11 00:14:00Z

0

i have encountered same problem, in my case it was the fact i created the package model outside of the root folder where Application.java class is situated.

answered Feb 11, 2024 at 0:14

Faycal Mehdi

11 bronze badge

Collectives™ on Stack Overflow

Spring Boot doesn't create tables in Postgres

6 Answers 6

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related