Docker image for H2

A Docker image for the H2 Database Engine. Supports S6 supervisor and UID/GID setting.

Versions

Currently only the latest stable image is built, which according to this page is Version 2.1.214 (2023-03-21).

How to use this image

docker run -e PUID=$UID -e PGID=$GID --name my-h2 -d brunoe/docker-database-h2

The default TCP port 9092 is exposed, so standard container linking will make it automatically available to the linked containers.

Use this JDBC string to connect from another container:

jdbc:h2:tcp://my-h2/my-db-name

Using the web interface

If you want to connect to the H2 web interface, bind the port 8082:

docker run -e PUID=$UID -e PGID=$GID --name my-h2 -p 8082:8082 -d brunoe/docker-database-h2

Then in your browser open http://localhost:8082/ and use the following connection parameters:

Driver Class: org.h2.Driver JDBC URL: jdbc:h2:my-db-name User Name: (empty) Password: (empty)

if you want to use the database from the host add port 8092

docker run --name my-h2 -p 8082:8082 -p 9092:9092 -d brunoe/docker-database-h2

Environment Variables

• H2_ARGS overrides the default server options (-web -webAllowOthers -tcp -tcpAllowOthers -ifNotExists)

• H2DATA specifies the location for the db files. If not set, /h2-data is used which is automatically created as a Docker volume. Ò

docker run --name my-h2 --detach \
  -e H2_ARGS="-tcp -tcpAllowOthers -ifNotExists"
  -p 9092:9092 \
  -v myh2-data:/h2-data \
  brunoe/docker-database-h2

Initialization scripts

This image uses an initialization mechanism similar to the one used in the official Postgres image.

You can add one or more *.sql or *.sh scripts under /docker-entrypoint-initdb.d (creating the directory if necessary). The image entrypoint script will run any *.sql files and source any *.sh scripts found in that directory to do further initialization before starting the service.

The name of the *.sql files will be used as the name of the database. For example, to create a table named "FOOBAR" in the "baz" database, add the following content to /docker-entrypoint-initdb.d/baz.sql:

CREATE TABLE FOOBAR;

If you want to do something more complex, use a .sh script instead, for example adding the following content to /docker-entrypoint-initdb.d/init.sh:

#!/bin/bash

java -cp /h2/bin/h2.jar org.h2.tools.RunScript \
  -script /docker-entrypoint-initdb.d/baz \
  -url "jdbc:h2:/h2-data/custom-db-name"