Can I have H2 autocreate a schema in an in-memory database?

Question

(I've already seen the H2 database In memory - Init schema via Spring/Hibernate question; it is not applicable here.)

I'd like to know if there's a setting in H2 that will allow me to auto-create a schema upon connecting to it. If it helps, I'm only interested in the in-memory case.

H2 supports various semicolon-separated modifiers at the end of the URL, but I didn't find one for automatically creating a schema. Is there such a feature?

Answer 1

Yes, H2 supports executing SQL statements when connecting. You could run a script, or just a statement or two:

String url = "jdbc:h2:mem:test;" +               "INIT=CREATE SCHEMA IF NOT EXISTS TEST" String url = "jdbc:h2:mem:test;" +               "INIT=CREATE SCHEMA IF NOT EXISTS TEST\\;" +                    "SET SCHEMA TEST"; String url = "jdbc:h2:mem;" +               "INIT=RUNSCRIPT FROM '~/create.sql'\\;" +                    "RUNSCRIPT FROM '~/populate.sql'"; 

Please note the double backslash (\\) is only required within Java. The backslash(es) before ; within the INIT is required.

Answer 2

If you are using spring with application.yml, the following will work for you:

spring:   datasource:     url: jdbc:h2:mem:mydb;DB_CLOSE_ON_EXIT=FALSE;MODE=PostgreSQL;INIT=CREATE SCHEMA IF NOT EXISTS calendar