The actual property you are setting in this case is the
INIT property. Here, you have set it to be equal to exactly one statement. You can of course set it to be equal to several statements:
The examples above are canonical strings, free of escape characters. If you are setting these inside a Java
String you’ll need to escape things properly. Here’s a sample JDBC URL written as a double-quoted Java
String that makes H2 log using SLF4J and runs some DDL on every connection:
"jdbc:h2:mem:chirp;INIT=SET TRACE_LEVEL_FILE=4\\;RUNSCRIPT FROM 'classpath:foo.ddl'"
Note the double backslashes: the first backslash escapes the next one, which, in turn, escapes the semicolon, because the semicolon is used as a delimiter in the actual JDBC URL itself.