Difference between revisions of "Java derby database"

From Ever changing code
Jump to navigation Jump to search
 
Line 23: Line 23:
* [http://squirrel-sql.sourceforge.net/ Squirrel SQL]
* [http://squirrel-sql.sourceforge.net/ Squirrel SQL]
* DBeaver Community Edition
* DBeaver Community Edition
= Resources =
* [http://db.apache.org/derby///docs/10.13/tools/ttoolsij97656.html Connecting to a Derby database] db.apache.org/derby

Latest revision as of 18:26, 21 April 2020

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

Retrieved from ‘http://wiki.ciscolinux.co.uk/index.php?title=Java_derby_database&oldid=5328’