To use Oracle SQL Developer, you must create a connection to the Oracle NoSQL Database store.
For information about security considerations for NoSQL data stores, see Steps to Configure KVSTORE Installation in the Oracle NoSQL Database Administrator's Guide.
To create a connection to the Oracle NoSQL Database, perform the following steps:
Confirm that a kvstore is up and running. In the examples below, kvlite is used. To start kvlite, enter the following command in a terminal:
java -jar $KVHOME/lib/kvstore.jar kvlite
KVHOME refers to the directory where you have installed Oracle NoSQL Database. This command assumes that Oracle NoSQL Database is installed in the local machine.
Figure 2-1 Start KVLite
Description of "Figure 2-1 Start KVLite"
A single node kvstore instance is created and opened using the default parameter values. Do not close this terminal as it shuts down kvlite.
To verify that kvlite is running, enter the following command in a new terminal:
java -jar $KVHOME/lib/kvstore.jar ping -host localhost -port 5000
The output shows that a kvstore is up and running successfully.
Open SQL Developer.
Note:By default, Oracle NoSQL Database stores are installed with security being enabled, but you must check with your store's administrator to find out whether your store was installed with or without security.