Scripts to manipulate String data of an Oracle NoSQL database (community edition). Languages: Jython, Java, JRuby, Clojure, Groovy, Rhino.

Requisites

1. Oracle NoSQL community edition, version 1.2.123, up & running.

2. For the Jython script: Jython 2.5.2.

3. For Java: Java 1.6.0_30.

4. For the JRuby script: JRuby 1.6.5.1.

5. For Clojure: Clojure 1.3.0.

6. Groovy: 1.8.5.

7. Rhino: 1.7R3.

   Oracle NoSQL Database and the programming languages are installed on the SAME machine.

   Tested on a CentOS 5.7 virtual machine.

Usage (Jython)

1. On a command prompt, type

   /absolute/path/jython /absolute/path/Jython_oraclenosql.py -kvclientpath=/opt/kv-1.2.123/lib/kvclient-1.2.123.jar -storename=store_name -connectionstring=host:port

   For interactive mode: add -i to jython's arguments:

   /absolute/path/jython -i ...

   In some cases, it may be convenient to add the switch -C iso-8859-1 to properly display Western European non-ascii characters on the console:

   /absolute/path/jython -C iso-8859-1 ...

   To run automatic tests, add -test to the script arguments:

   /absolute/path/jython /absolute/path/Jython_oraclenosql.py -test ...

2. Optional: Modify the last lines of the file Jython_oraclenosql.py to reflect the defaults so no command line arguments must be passed.

   Assuming above created Jython's console and preloaded Jython_oraclenosql.py, the functions that can be called are:

   • connect("oracle_store_name", "host:port")
   • countAll()
   • version()
   • test("oracle_store_name", "host:port")
   • putIfPresent("MajorComponent1/MajorComponent2/-/MinorComponent1","Value")
   • putIfAbsent("MajorComponent1/MajorComponent2/-/MinorComponent1","Value")
   • put("MajorComponent1/MajorComponent2/-/MinorComponent1","Value")
   • get("MajorComponent1/MajorComponent2/-/MinorComponent1")
   • delete("MajorComponent1/MajorComponent2/-/MinorComponent1")
   • multiDelete("MajorComponent1")
   • multiGet("MajorComponent1/MajorComponent2")
   • storeIterator ("MajorComponent1")

Usage (Java)

1. Navigate to the directory where the file Java_oraclenosql.java resides.

2. javac -cp .:/opt/kv-1.2.123/lib/kvclient-1.2.123.jar Java_oraclenosql.java

3. java -cp .:/opt/kv-1.2.123/lib/kvclient-1.2.123.jar Java_oraclenosql [arguments]

   Defaults can be changed in the script. The arguments are optional: -s store_name -h host_name -p port -t -i

   With the -t argument, the test function is executed. The test function calls put, get, putIfAbsent, putIfPresent, storeIterator, countAll, getAllKeys, delete, multiDelete. Two created records will be deleted before finishing.

   The -i argument starts a very simple read line capability. Only "put(key)", "get(key)", "delete(key)", "multiDelete(major_key_components)", "countAll()", "getAllKeys()", "storeIterator(partial_major_key_component)", work at this moment. Terminate with quit().

Usage (JRuby)

1. Run: "/opt/jruby/bin/jruby /path/to/Jruby_oraclenosql.rb -S store_name -H host_name -p port -t" (-t is to run the test).

2. Optional: Modify the last lines of the file Jruby_oraclenosql.rb to suit the environment (store name, host, port, key) so the arguments do not need to be entered.

   "connect", "put", "get", "delete", "countAll", "test" (simply tests all other functions), are working.

Usage (Clojure)

Uwe, das ist fuer Dich.

1. Modify the last lines of the file Clojure_oraclenosql.clj to reflect the environment.
2. Modify the script clj to reflect the classpath.
3. Navigate to the folder containing both scripts, "clj" and "Clojure_oraclenosql.clj".
4. Run with "./clj Clojure_oraclenosql.clj". It connects to the store, writes one value, reads it, deletes the written value, and counts the number of records in the store.

Usage (Groovy)

1. Modify the top lines of the script with the store name, host, port, encoding.

2. Navigate to the directory where the file Groovy_oraclenosql.groovy is.

3. Run with "groovy -cp /opt/kv-1.2.123/lib/kvclient-1.2.123.jar Groovy_oraclenosql.groovy"

   It runs some automatic tests (connect, put, get, delete, storeIterator).

Usage (Rhino)

1. Navigate to the directory where the file Rhino_oraclenosql.js is.

2. Identify where kvclient-1.2.123.jar and Rhino's js.jar are and modify the path below accordingly.

3. Run with java -cp .:/opt/kv-1.2.123/lib/kvclient-1.2.123.jar:/opt/rhino1_7R3/js.jar org.mozilla.javascript.tools.shell.Main Rhino_oraclenosql.js -s=store_name -h=host_name -p=port

4. Optional: Modify the last lines of the script Rhino_oraclenosql.js with the default store name, host, port. Then no arguments need to be passed in the command line.

   It runs an automatic test (connect, countAll, put, get, delete). If arguments are not passed the defaults are tried.