Spring boot data.sql does not initialize data in Postgresql

Question

I have a Spring Rest Api application. This is the entity:

@Entity
@Table(name="a_example")
public class Example
{
    @Id
    @GeneratedValue
    private Long id;

    private String name;
    private String description;

    @Column(unique = true, nullable = false)
    private String filename;
}

Here is my data.sql in the resources folder:

INSERT INTO a_example(name, description, filename) VALUES('Xyz', 'Lorem ipsum', 'xyz');

INSERT INTO a_example(name, description, filename) VALUES('Pqr', 'Lorem ipsum', 'pqr');

And my application.properties:

spring.datasource.url=jdbc:postgresql://localhost:5432/xyz
spring.datasource.username=admin
spring.datasource.password=admin
spring.datasource.driverClassName=org.postgresql.Driver
spring.datasource.initialization-mode=always
spring.datasource.initialize=true
spring.datasource.data=classpath:data.sql

spring.jpa.generate-ddl=true
spring.jpa.properties.hibernate.ddl-auto=create

spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults = false
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQL9Dialect

The table exists, I can add data other ways, but I would prefer the data.sql to initalize it.

What am I missing?

I guess spring.jpa.properties.hibernate.ddl-auto=create should be spring.jpa.hibernate.ddl-auto=create. Try adding this property as well spring.jpa.show-sql=true to see if the sql is being triggered or not — pvpkiran
– pvpkiran, Commented Mar 27, 2020 at 13:35
the only thing that worked for me was this prop spring.datasource.initialization-mode=always which is deprecated by the way lol — Bigyan Devkota
– Bigyan Devkota, Commented Mar 19, 2022 at 15:20

Nasir · Accepted Answer · 2020-03-27 15:27:43Z

2

Change spring.jpa.properties.hibernate.ddl-auto=create to spring.jpa.hibernate.ddl-auto=create in the application.properties file And Change GeneratedValue annotation in the Example entity as below:

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;

FYI: You can use Liquibase or Flyway libraries too.

edited Mar 27, 2020 at 15:27

answered Mar 27, 2020 at 15:09

Nasir

5315 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Spring boot data.sql does not initialize data in Postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related