Dockerized H2 database service.

• Based on the OpenJDK official image
• H2-DATA location on /opt/h2-data
• A mix of zhilvis/docker-h2 and zilvinasu/h2-dockerfile.

There are many changes in this major version, including changes in the information schema tables. An option has been added to the h2.server.properties for convenience to allow you to use the information schema from v1 since it is difficult to find information about this online (OLD_INFORMATION_SCHEMA=true).

Note the use of this property in the constructor of https://github.com/h2database/h2database/blob/master/h2/src/main/org/h2/engine/SessionRemote.java

Automated builds on docker registry:

• latest, 2.1.210 (2.1.210/Dockerfile)
• 2.0.204 (2.0.204/Dockerfile)
• 1.4.199 (1.4.199/Dockerfile)
• 1.1.119 (1.1.119/Dockerfile)
• alpine (alpine/Dockerfile)
• geodb (geodb/Dockerfile)

Get the image:

docker pull githubrafis/h2

Run as a service, exposing ports 1521 (TCP database server) and 81 (web interface) and mapping DATA_DIR to host:

docker run -d -p 1521:1521 -p 81:81 -v /path/to/local/data_dir:/opt/h2-data --name=MyH2Instance githubrafis/h2

Or run as a service with an extra custom config set in the command line, like allowing to create database at connection:

docker run -d -p 1521:1521 -p 81:81 -v /path/to/local/data_dir:/opt/h2-data -e H2_OPTIONS=-ifNotExists --name=MyH2Instance githubrafis/h2

The H2 web console will be available at: http://localhost:81

See the logs while running:

docker logs -f MyH2Instance

Create an empty test database:

docker exec -it MyH2Instance touch /opt/h2-data/test.mv.db