H2 database - how to init multiple schema (yml)

Question

My conf (working):

    jdbc-url: jdbc:h2:mem:myDb;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS MYSCHEMA_1

I need to init mulitple schema, but i can't find the syntax. So far I tried:

jdbc-url: jdbc:h2:mem:myDb;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS MYSCHEMA_1, MYSCHEMA_2
jdbc-url: jdbc:h2:mem:myDb;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS MYSCHEMA_1;CREATE SCHEMA IF NOT EXISTS MYSCHEMA_2
jdbc-url: jdbc:h2:mem:myDb;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS MYSCHEMA_1;INIT=CREATE SCHEMA IF NOT EXISTS MYSCHEMA_2

check this answer: https://stackoverflow.com/a/49695179/600486 — blurfus, Oct 22 '18 at 23:58
its not in yml, that looks like what I tried with ';'. But it doesn't work — Tyvain, Oct 23 '18 at 00:01
@ochi it seems to not work in yml. All examples are in xml or java, and that's not what I want. — Tyvain, Oct 23 '18 at 00:03
did you try the double-slashes (`\\ `) before the colon (`;`)? — blurfus, Oct 23 '18 at 00:07
@ochi the solution as a simple '\' ... got confused by java example, where the double \\ is to escape the first \ — Tyvain, Oct 23 '18 at 00:08

Tyvain · Accepted Answer · 2018-10-23T00:33:25.333

20

Solution is:

jdbc:h2:mem:myDb;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS SCHEMA_1\;CREATE SCHEMA IF NOT EXISTS SCHEMA_2

note the simple '\' in yml. Double '\\' in java is to escape the first one.

edited Oct 23 '18 at 00:33

answered Oct 23 '18 at 00:07

Tyvain

2,640
6
36
70

That file format is called [YAML](http://yaml.org/spec/1.2/spec.html) and the file extension to use for files in that format is [`.yaml`](http://yaml.org/faq.html) when possible. So where does the "yml" come form? I hope you are not running an 8.3 filesystem for your `.jva` programs. – Anthon Oct 23 '18 at 06:41
De verdad muchas gracias, me sirvió con los doble \\ – arxzel Apr 26 '22 at 20:41
on yaml i must use '\\' otherwise -> java.lang.IllegalStateException: Failed to load property source from (classpath:application-test.yaml) – Tiago Medici May 12 '22 at 07:56

H2 database - how to init multiple schema (yml)

1 Answers1