problem with INIT=RUNSCRIPT and relative paths

Question

I use maven conventions for source paths (src/main src/test) and i have my sql scripts in src/main/resources/scripts.

I want to run my app with H2 memory and i'd like to use the jdbc url to initialize my db :

database.url=jdbc:h2:mem:;INIT=RUNSCRIPT FROM 'src/main/resources/scripts/create.sql';

My problem is that this relative path (src/main/... ) does not work, and that H2 won't crash if the init=runscript command targets nothing.

Does someone know what is the path i should use to make this work ?

Thanks

You wrote "H2 won't crash if the init=runscript command targets nothing" - I can't reproduce this (H2 throws an exception in this case). What version of H2 do you use? Could you try with the latest version? I'm not aware this was different before, but maybe it was. — Thomas Mueller
– Thomas Mueller, Commented Dec 20, 2010 at 20:44
No you're right, now it crashes. I don't know what happened. — Maxime ARNSTAMM
– Maxime ARNSTAMM, Commented Dec 21, 2010 at 9:35

viktortnk · Accepted Answer · 2011-12-13 09:22:59Z

123

You can use the following url:
"jdbc:h2:mem:sample;INIT=RUNSCRIPT FROM 'classpath:scripts/create.sql'"

With that one it is possible to run script from classpath. So you can just put it src/main/resources/scripts or src/test/resources/scripts in your maven (or something else) project.

answered Dec 13, 2011 at 9:22

viktortnk

2,7671 gold badge20 silver badges18 bronze badges

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

3 Comments

Enbugger Over a year ago

I get MalformedURLException: unknown protocol: classpath on Java 11

MarekChr Over a year ago

This does not work on H2 2.1.210 when using folders in path after classpath:. stackoverflow.com/questions/70862699/…

MarekChr Over a year ago

Update to previous comment that it does not work: it does not work while using java modular system (module-info.java)

darioo · Accepted Answer · 2010-12-20 13:47:02Z

2

I'd suggest trying to use an absolute path for starters, just to check everything works. Afterwards, check your classpath. For example, bin/main/resources/scripts/create.sql, assuming bin is where your classes are compiled, and is on your classpath.

Since src, where your source lives, usually isn't on the classpath, this could be the source of your problem.

answered Dec 20, 2010 at 13:47

darioo

47.4k10 gold badges79 silver badges104 bronze badges

4 Comments

Maxime ARNSTAMM Over a year ago

With the absolute path, it works, but not any combination of relative paths i tried.

darioo Over a year ago

@Maxime: does H2 throw any error? Any sign of things not working from it's side mentioning that create.sql isn't found? Have you tried to put create.sql in the classpath?

Maxime ARNSTAMM Over a year ago

sorry : With the absolute path, it works, but not any combination of relative paths i tried. The scripts are in mywar.war/WEB-INF/classes/scripts/.. I tried /WEB-INF/.. WEB-INF/.. etc no results :/

user454322 Over a year ago

Since src, where your source lives, usually isn't on the classpath In Maven projects Whatever is inside src/main/resources usually is included in the classpath

PJ_Finnegan · Accepted Answer · 2022-10-14 14:41:38Z

0

For me it works if I keep the scripts under src/test/resources:

database.url=jdbc:h2:mem:;INIT=RUNSCRIPT FROM 'src/test/resources/create.sql';

Anyway, in a JUnit context, if you use the conventional file paths schema.sql (for the DDL) and data.sql (for the DDL) under src/test/resources, you don't need the specify the scripts with the INIT variable in the connection string. You can simply use:

database.url=jdbc:h2:mem:testdb

and JUnit will automatically run the scripts when creating the H2 instance in memory.

answered Oct 14, 2022 at 14:41

PJ_Finnegan

2,2011 gold badge24 silver badges17 bronze badges

Comments

likejudo · Accepted Answer · 2023-03-14 19:31:29Z

0

Your issue is you are specifying 'src/ You need to do ./src instead.

I had the same issue and this change fixed it:

spring.datasource.url=jdbc:h2:./src/main/resources/data.sql;INIT=RUNSCRIPT FROM './src/main/resources/data.sql'

If you are using Docker and Kubernetes,

add this line to Dockerfile

COPY src/main/resources/data.sql /app/src/main/resources/

edited Mar 14, 2023 at 19:31

answered Mar 13, 2023 at 14:57

likejudo

3,8058 gold badges60 silver badges120 bronze badges

Collectives™ on Stack Overflow

problem with INIT=RUNSCRIPT and relative paths

4 Answers 4

3 Comments

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related