Java derby database

Use ij to manage Java derby database

Install

sudo apt install derby-tools

Connect

$ jq
ij version 10.14
ij> connect 'jdbc:derby:<path/to/db>' USER 'myuser' PASSWORD 'password1';
ij> help;
ij> SHOW SCHEMAS;
ij> SHOW CONNECTIONS;
ij> show tables;
ij> select * from app.dpa_user;

GUI Derby DB clients

• Squirrel SQL
• DBeaver Community Edition

Resources

• Connecting to a Derby database db.apache.org/derby