Difference between revisions of "Java derby database"
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...") |
|||
| 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 | |||
Revision as of 22:14, 19 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