H2 Database Load Data from a Script

Question

I am trying to load some data from a script in a H2 database in a spring boot application but I am getting the File Not Found Exception. I have the yml file and Data File in the same directory. The two files exists in src/main/resources/config

 url: jdbc:h2:mem:test;MODE=MySQL;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE SCHEMA IF NOT EXISTS pdmp_app\;runscript from 'LoadData.sql'

luboskrnac · Accepted Answer · 2016-10-21 03:24:34Z

1

Instead of using H2 script execution, I would suggest to use Spring Boot initialization SQL scripts. Just place your script into file src/main/resources/data.sql and Spring Boot will take care of executing it.

answered Oct 21, 2016 at 3:24

luboskrnac

24.7k10 gold badges86 silver badges93 bronze badges

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

Comments

Gibolt · Accepted Answer · 2019-02-05 23:42:58Z

0

I found that this worked for me

runscript from 'classpath:LoadData.sql'

edited Feb 5, 2019 at 23:42

Gibolt

47.9k15 gold badges208 silver badges133 bronze badges

answered Feb 5, 2019 at 23:13

LouwMarais

364 bronze badges

Collectives™ on Stack Overflow

H2 Database Load Data from a Script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related