with H2, you can also use its own in-mem pool, which gets a database per pool, so multi-connection is also possible