opavlova/db-derby repository overview

⁠Apache Derby database

https://db.apache.org/derby/⁠

⁠Image tags

opavlova/db-derby

OS: ubuntu:14.04.4
Java version: 1.7
Java home:  /usr/lib/jvm/java-7-openjdk-amd64/jre
Apache Derby version: 10.12.1.1
Apache Derby home: /db-derby-10.12.1.1-bin/
Folder with databases: /dbs

⁠Usage

⁠How to connect to DB in IntelliJ IDEA 2020.3, DB created via Dockerfile:

1. Install docker https://docs.docker.com/engine/installation/⁠ https://docs.docker.com/engine/userguide/⁠

2. Add Docker support https://www.jetbrains.com/help/idea/docker.html⁠

3. Create a Dockerfile with the following content in IntelliJ IDEA:

FROM  opavlova/db-derby

1. Create and run a New Run Configuration

   click on the "Run on Docker' gutter (near "FROM" in the Editor)  -> choose "New Run Configuration"
   enter "-p 1527:1527"   into the  "Run options" field 
   Run  ( results are in the Services View )
   

   Copy

2. Create a connection to the database in the Database View:

   go to the Database View, add new Derby Data Source
   add URL:  jdbc:derby://localhost:1527/DOCKERDB
   add user=DOCKERDB, password = DOCKERDB
   Connect.
   

   Copy

⁠How to connect to DB in IntelliJ IDEA, DB created via image in the Docker view:

1. Go to the Services View

2. Connect to Docker

3. Pull the image Select "Images" item Enter "opavlova/db-derby"
   Press ctrl+click to pull the image

4. Run a container Select the pulled image in the list of images->Call context menu->Create Container Enter "-p 1527:1527" into the "Run options" field in the opened Docker Run Configuration (where port binding: "-p :") Run

5. Create a connection to the database in the Database View:

   go to the Database View, add new Data Source
   add URL:  jdbc:derby://localhost:1527/DOCKERDB
   user=DOCKERDB, password = DOCKERDB
   Connect.
   

   Copy

Dockerfile for opavlova/db-derby image: https://github.com/IdeaUJetBrains/DockerFiles/blob/master/docker-dir/db/Derby⁠