h2 in-memory tables, remote connection

Question

I am having problems with creating an in memory table, using H2 database, and accessing it outside of the JVM it is created and running in.

The documentation structures the url as jdbc:h2:tcp://<host>/mem:<databasename>

I've tried many combinations, but simply cannot get the remote connection to work. Is this feature working, can anyone give me the details of how they used this.

Answer 1

You might look at In-Memory Databases. For a network connection, you need a host and database name. It looks like you want jdbc:h2:tcp://localhost/mem:db1 or jdbc:h2:tcp://127.0.0.1/mem:db1