IntelliJ IDEA H2 Support

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

Overview

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