Seeding Initial Data - Spring Boot with data.sql

Question

data.sql is executed before JPA entities are created and it creates the error that the table is not found. can anyone help me with it? I have seen the same question in this link Spring Boot - Loading Initial Data but the question is not answered.

Could you add the error log and the code being executed at application startup? — Juliyanage Silva
– Juliyanage Silva, Commented Jul 22, 2021 at 12:41

Baptiste Beauvais · Accepted Answer · 2021-07-22 19:58:39Z

1

This is a normal and wanted behaviour from Springboot since version 2.5 I believe. The idea behind this is that pure SQL (with schema.sql and data.sql) and JPA based database creation technologies are two different approaches to database initialisation.

By default, the framework will assert that only one is used and give priority to SQL based. The initialisation will be done in this order :

Run schema.sql to create and manipulate the database structure (DDL)
Run data.sql to populate the database (DML)
Initialize your EntityManagerFactory

To implement the behaviour that you want, you need to tell him to prioritize JPA over pure SQL. This can be done by settings this in your configuration :

spring.jpa.defer-datasource-initialization=true

More details are available in the official documentation, point 9.3 specifically.

answered Jul 22, 2021 at 19:58

Baptiste Beauvais

2,1361 gold badge16 silver badges22 bronze badges

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

1 Comment

Miki Ahmed Over a year ago

thanks done. I was confused for two days thank you.

Collectives™ on Stack Overflow

Seeding Initial Data - Spring Boot with data.sql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related