Difference between revisions of "Java derby database"

From Ever changing code
Jump to navigation Jump to search
(Created page with "Use <code>ij</code> to manage Java derby database Install <source lang=bash> sudo apt install derby-tools </source> Connect <source lang=bash> $ jq ij version 10.14 ij> co...")
 
 
(One intermediate revision by the same user not shown)
Line 19: Line 19:
ij> select * from app.dpa_user;
ij> select * from app.dpa_user;
</source>
</source>
= GUI Derby DB clients =
* [http://squirrel-sql.sourceforge.net/ Squirrel SQL]
* 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 19: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’