Spring-boot populate H2 database with schema.sql and data.sql

Question

I set up Spring-boot to work with H2 in-memory database application.properties file is in the /config directory and it looks like, this file is processed

spring.datasource.url=jdbc:h2:mem:mydb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
spring.h2.console.path=/myconsole
spring.h2.console.enabled=true
spring.datasource.initialize=true
spring.datasource.schema=schema.sql
spring.datasource.data=data.sql

This file is processed and the console appears at /myconsole But the schema.sql and data.sql are not processed and db is empty. I placed schema.sql and data.sql files both under /config and /src/main/resources.

SQL language instructions are correct and I can populate the table using console input.

Another strange thing is even though i name db as

spring.datasource.url=jdbc:h2:mem:mydb

the spring console loads another database testdb

o.s.j.d.e.EmbeddedDatabaseFactory --- Starting embedded database: url='jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'

How to load the H2 database correctly?

user3687431 · Accepted Answer · 2016-06-21 08:58:46Z

11

Resolved the issue.

The spring boot app requires its ownd jdbc dependency

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

NON-boot dependency, that I had, is NOT enough alone:

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
</dependency>

Without the "spring-boot-starter-jdbc" dependency "spring.datasource.url" settings in file "application.properties" are not processed. That file is actually processed, but not the jdbc settings. Spring boot will create its own testdb in the memory, which destroys the data after closing the application.

answered Jun 21, 2016 at 8:58

user3687431

2832 gold badges3 silver badges10 bronze badges

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

Comments

Levent Divilioglu · Accepted Answer · 2024-11-22 22:28:34Z

0

Followings are outdated;

spring.datasource.schema
spring.datasource.data

The replacements are;

spring.sql.init.schemaLocations
spring.sql.init.dataLocations

Related Class;

org.springframework.boot.sql.init.DatabaseInitializationSettings

Check replacements via additional-spring-configuration-metadata.json under META-INF directory of spring-boot-autocinfigure-3.3.5.jar.

Spring Boot version: 3.3.5

I don't know from which version exactly this replacement did occur but as of 3.3.5 it's as above.

answered Nov 22, 2024 at 22:28

Levent Divilioglu

11.7k5 gold badges61 silver badges111 bronze badges

Collectives™ on Stack Overflow

Spring-boot populate H2 database with schema.sql and data.sql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related