Docker Derby

Dockerfile to run Derby in network mode.

How to use

Build the image.

docker build -t derby .

The following command starts container with the latest version of the Derby Network Server listening on port <dbport> and creates database <dbname> inside.

docker run --name=derby \
      --env dbname=<dbname> \
      --env dbuser=<dbuser> \
      --env dbpass=<dbpass> \
      --env dbport=<dbport> \
      --expose=<dbport> -d -P derby

Example:

docker run --name=derby \
      --env dbname=DbTest \
      --env dbuser=axibase \
      --env dbpass=axibase \
      --env dbport=8443 \
      --expose=8443 -d -P derby

Connect to <dbname> from client

• using ij:

anna@axibase:/# ~/test/db-derby-10.14.1.0-bin/bin/ij
ij version 10.14
ij> CONNECT 'jdbc:derby://localhost:32867/DbTest;user=axibase;password=axibase';
ij> CREATE TABLE FIRSTTABLE
     (ID INT PRIMARY KEY,
     NAME VARCHAR(12));
0 rows inserted/updated/deleted
ij> INSERT INTO FIRSTTABLE VALUES 
    (10,'TEN'),(20,'TWENTY'),(30,'THIRTY');

3 rows inserted/updated/deleted
ij> SELECT * FROM FIRSTTABLE;

     ID         |NAME
    ------------------------
    10         |TEN
    20         |TWENTY
    30         |THIRTY

3 rows selected

• using JDBC API:

Connection conn = DriverManager.getConnection("jdbc:derby://localhost:32867/DbTest;user=axibase;password=axibase");

32867 is port retrieved with the docker port derbycommand.