Spring boot load H2 db file from classpath

Question

I want to package prepopulated h2 db-files with a Spring boot application. The database is only going to be used to read values.

How am I able to load the H2 files that are available on the classpath? I am very uncertain how to setup the spring.datasource.url to get this to work.

Take a look at this thread h2-database.66688.n3.nabble.com/… You can try something like jdbc:h2:zip:~/ my.jar!/db — Stan
– Stan, Commented Jul 8, 2016 at 9:35

Miloš Milivojević · Accepted Answer · 2016-07-08 09:44:07Z

2

I would suggest you export the schema and data into SQL scripts and use the in-memory H2 DB in combination with Spring Boot's built-in initialization feature: http://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html#howto-initialize-a-database-using-spring-jdbc

Granted, it may result in a slower startup if you have a relatively big dataset but if that were the case you probably wouldn't have put it in the JAR in the first place :)

answered Jul 8, 2016 at 9:44

Miloš Milivojević

5,3993 gold badges29 silver badges41 bronze badges

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

1 Comment

Jarle Hansen Over a year ago

This is a good suggestion, I tried it and it works fine. It is actually quite fast to load a considerable amount of sql on startup.

Collectives™ on Stack Overflow

Spring boot load H2 db file from classpath

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related