Java derby database

From Ever changing code
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

Resources