Docker image for H2

A Docker image for the H2 Database Engine.

Versions

• Version 2.2.224 (2023-09-17), the latest stable image, according to this page
• Version 2.1.214 (2022-06-13)
• Version 1.4.195 (2017-04-23)

How to use this image

docker run --name my-h2 -d buildo/h2database

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 --name my-h2 -p 8082:8082 -d buildo/h2database

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)

Environment Variables

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

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"