2 Using Oracle SQL Developer to View Oracle NoSQL Database

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:

  1. 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.

  2. A single node kvstore instance is created and opened using the default parameter values. Do not close this terminal as it shuts down kvlite.

  3. 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

  4. The output shows that a kvstore is up and running successfully.

  5. 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.