Difference between revisions of "Java derby database"
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 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
- Squirrel SQL
- DBeaver Community Edition
Resources
- Connecting to a Derby database db.apache.org/derby