Running SQL Shell with KVLocal

You can run SQL queries and DDL statements directly from the SQL shell. This is described in Introduction to the SQL Shell.

You can connect to KVLocal and start the SQL shell as follows:

java -jar <KVHOME>/lib/sql.jar -helper-hosts localhost:5000 -store kvstore

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 SQL CLI:

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