Follow Us on Twitter

NoSQL quick 101 with Oracle NoSQL v3.4

by Patrick Sinke on October 20, 2015 · 1 comment

Since I wrote my Whitebook “What is NoSQL And How Do I Use It” (sorry only in Dutch), some things have changed. Also I found out some things were not quite clear.  One of those confusing things, is that in the examples I call my host “weblogic” (the host I used in my demo), but when kvstore runs locally, it can be replaced by “localhost” .

I went through the examples with NoSQL 3.4 and Oracle JDK 1.8, en that resulted in the following steps for a working solution:

$> java -jar lib/kvstore.jar kvlite &
$> java -jar lib/kvstore.jar ping -host localhost -port 5000
$> javac -classpath lib/kvstore.jar:examples examples/externaltables/*.java
$> java -classpath lib/kvclient.jar:examples externaltables.LoadCookbookData -store kvstore -host localhost -port 5000 -nops 10
$> java -Xmx256m -Xms256m -jar ./lib/kvcli.jar -host localhost -port 5000 -store kvstore
kv-> connect store -host localhost -port 5000 -name kvstore
kv-> get kv -all;

Does the example above work for you? Please leave a reply if you encounter errors or problems with this approach.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

{ 1 comment… read it below or add one }

Nilay July 14, 2016 at 7:25 pm

Hi Patrick
Thanks for the post. I have a question regarding a similar topic. I am trying to connect to Oracle NoSql from Sql Developer. I do have a trust file on my local, and i point SQL Dev connection to it. I however get the following exception when i try to connect. I am able to connect to the NoSql DB from java client. Any clues, hints could help.

oracle.kv.FaultException: Could not establish an initial login from: [:] ()
Fault class name: oracle.kv.KVStoreException
at oracle.kv.KVStoreFactory.getStoreInternal(
at oracle.kv.KVStoreFactory.getStore(
at oracle.dbtools.raptor.onsd.connection.ConnectionCreator.createConnection(
at oracle.dbtools.raptor.onsd.connection.NSConnections$C.getConnection(
at oracle.dbtools.raptor.onsd.connection.NSConnections.getConnection(
at oracle.dbtools.raptor.onsd.navigator.OnsdConnection.openConnectionImpl(
at oracle.dbtools.raptor.onsd.navigator.OnsdConnection.openConnectionImpl(
at oracle.dbtools.raptor.navigator.db.BaseConnectionNode.getConnection(
at oracle.dbtools.raptor.onsd.navigator.ConnectionTreeNode$LoadTask.doWork(
at oracle.dbtools.raptor.onsd.navigator.ConnectionTreeNode$LoadTask.doWork(
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$
at java.util.concurrent.Executors$
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$
Caused by: oracle.kv.KVStoreException: Could not establish an initial login from: [:]
at oracle.kv.KVStoreFactory.getStoreInternal(
… 18 more
Caused by: java.rmi.ConnectIOException: Problem connecting to the KVStore server, which may be caused by a security mismatch between the client and server; nested exception is:
java.rmi.ConnectIOException: Exception creating connection to:; nested exception is: SSL connection to host is not valid.
at oracle.kv.impl.util.registry.RegistryUtils$ExceptionWrappingRegistry.rethrow(
at oracle.kv.impl.util.registry.RegistryUtils$ExceptionWrappingRegistry.list(
… 19 more
Caused by: java.rmi.ConnectIOException: Exception creating connection to: ; nested exception is: SSL connection to host is not valid.
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(
at sun.rmi.transport.tcp.TCPChannel.createConnection(
at sun.rmi.transport.tcp.TCPChannel.newConnection(
at sun.rmi.server.UnicastRef.newCall(
at sun.rmi.registry.RegistryImpl_Stub.list(Unknown Source)
at oracle.kv.impl.util.registry.RegistryUtils$ExceptionWrappingRegistry.list(
… 20 more
Caused by: SSL connection to host is not valid.
at oracle.kv.impl.util.registry.ssl.SSLClientSocketFactory.createSocket(
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(
… 25 more


Leave a Comment


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS