1

I have set up my Spring Boot application so that my H2 embedded database is populated at startup. I've done this by creating a data.sql file in the src/main/resources folder.

What I don't understand is what causes this to run at startup.

Also, I'd like to make this conditional - e.g. prevent it from executing when I'm running unit tests. Is this possible?

A similar question was asked here, but it is unresolved.

Improve this question
4
  • Do you want to load data based on spring profile? Commented Nov 19, 2018 at 10:31
  • I don't know. I'm new to all this so still trying to figure it out. Commented Nov 20, 2018 at 11:29
  • quick and short explanation of how you can do it answered by me here: stackoverflow.com/questions/38040572/… Commented Nov 20, 2018 at 12:02
  • FUTURE READERS.. You can find a "spring profile" driven answer here : stackoverflow.com/questions/23790743/… Commented Jun 11, 2021 at 18:50

1 Answer 1

Reset to default
2

The mechanism that causes your data.sql file to be loaded is described in the Spring documentation in chapter 85.3 Database Initialization

The data.sql file name is the fallback filename when no scripts are set through the property spring.datasource.data (for a list of common spring properties go here and look for properties regarding datasource)

So for your usecase rename you dml scripts to something like data-default.sql and data-test.sql and set them profile specific in your application.yml or properties file.

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

1 Comment

In addition I'd suggest to use high level DB migration utilities to set up your DB docs.spring.io/spring-boot/docs/current/reference/html/…

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.