Checking feasibility go-sql client for derby database:
Points to remember: Use ij a tool that allows SQL scripts to be executed against any JDBC database. Derby uses DRDA(Distributed Releational Database Architecture) protocol for communication. Specifications of DRDA - https://pubs.opengroup.org/onlinepubs/9690989899/toc.pdf Set JAVA_HOME and DERBY_HOME for running ij terminal.
References:
- http://squirrel-sql.sourceforge.net/#installation
- http://db.apache.org/derby/papers/DerbyTut/ns_intro.html#ns_intro
- https://db.apache.org/derby/integrate/SQuirreL_Derby.html
Commands: To print schema: ./bin/dblook -d 'jdbc:derby://localhost:1527/firstdb;user=krishna' -z app -t test
To start in network server mode: ./bin/startNetworkServer
To stop network server: ./bin/stopNetworkServer
To ping derby: ./bin/NetworkServerControl ping localhost 1527
To print sysinfo: ./bin/sysinfo
Explore: