Latest revision as of 18:08, 31 October 2018

Internal

An external H2 instance must be running and exposing access over network. This article explains how to do that:

Accessing an H2 Instance Embedded within a Different JVM

Right edge tabs -> Database -> + -> Driver -> H2 -> make sure it's downloaded and it is new enough.

Right edge tabs -> Database -> + -> Data Source -> H2:

Name: "H2 instance in another JVM"

From the URL dropdown box, select "URL only" and use the following URL:

jdbc:h2:tcp://localhost/mem:default;DB_CLOSE_DELAY=-1

User: sa

Password: leave it empty

Test Connection.

Apply -> OK.

For more details on this database mode, see:

Accessing an H2 Instance Embedded within a Different JVM

@@ Line 16: / Line 16: @@
 Name: "H2 instance in another JVM"
-Host: localhost
+From the URL dropdown box, select "URL only" and use the following URL:
-Database: mem
+ jdbc:h2:tcp://localhost/mem:default;DB_CLOSE_DELAY=-1
 User: sa
@@ Line 28: / Line 28: @@
 Apply -> OK.
-See: {{Internal|H2#Accessing_an_H2_Instance_Embedded_within_a_Different_JVM|Accessing an H2 Instance Embedded within a Different JVM}}
+For more details on this database mode, see: {{Internal|H2#Accessing_an_H2_Instance_Embedded_within_a_Different_JVM|Accessing an H2 Instance Embedded within a Different JVM}}