Skip to content

Instantly share code, notes, and snippets.

@krishnakumar4a4
Created December 25, 2019 07:19
Show Gist options
  • Save krishnakumar4a4/fc7eddbec1349be9a6a296c15fcf3025 to your computer and use it in GitHub Desktop.
Save krishnakumar4a4/fc7eddbec1349be9a6a296c15fcf3025 to your computer and use it in GitHub Desktop.
Derby db setup

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:

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:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment