...
- There's a primitive command-line utility called
ij. Its interactive use can be made tolerable by giving it virtual files via process substitutionrunning it repeatedly from the shell via:ij -p <(echo "...connection properties...") <(echo "...sql commands...") - Once connected via
ij:SHOW TABLES;– shows tablesDESCRIBE <tablename>;– describes a particular table. If the tablename is uppercase, don't quote it here.- Quote uppercase table names in SQL queries. E.g.
SELECT "ID" from "SYNCS";
- If ij's output is too narrow (row values end with '&' indicating truncation), run the SQL:
maximumdisplaywidth 10000; - For BLOBs, this page of examples is your friend.
- The Derby docs are quite good, but use frames, so Google will take you to some random-looking page without any context. Start from here.
...