Running SQL Shell with KVLocal

To connect SQL shell to a KVLocal instance, run the following command:

java -jar <KVHOME>/lib/sql.jar -helper-hosts <host:port> -store <storeName>

Where, <KVHOME> refers to the directory where Oracle NoSQL Database package files reside.

Note:

When using Unix domain socket to connect to KVLocal, specify the hostname in this form: unix_domain:KVROOT/sockets/sock. For example, if the KVROOT directory is /disk1/kvroot, run the following command to start the Administration CLI:

java -jar <KVHOME>/lib/kvstore.jar -helper-hosts unix_domain:/disk1/kvroot/sockets/sock:5000 -store kvstore

For a complete list of utility commands accessed through "java -jar <KVHOME>/lib/sql.jar <command>", see Shell Utility Commands.