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.

Ratings:
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(KVStoreFactory.java:245)
at oracle.kv.KVStoreFactory.getStore(KVStoreFactory.java:152)
at oracle.dbtools.raptor.onsd.connection.NSConnection.open(NSConnection.java:168)
at oracle.dbtools.raptor.onsd.connection.ConnectionCreator.createConnection(ConnectionCreator.java:27)
at oracle.dbtools.raptor.onsd.connection.NSConnections$C.getConnection(NSConnections.java:39)
at oracle.dbtools.raptor.onsd.connection.NSConnections.getConnection(NSConnections.java:181)
at oracle.dbtools.raptor.onsd.navigator.OnsdConnection.openConnectionImpl(OnsdConnection.java:166)
at oracle.dbtools.raptor.onsd.navigator.OnsdConnection.openConnectionImpl(OnsdConnection.java:26)
at oracle.dbtools.raptor.navigator.db.BaseConnectionNode.getConnection(BaseConnectionNode.java:46)
at oracle.dbtools.raptor.onsd.navigator.ConnectionTreeNode$LoadTask.doWork(ConnectionTreeNode.java:63)
at oracle.dbtools.raptor.onsd.navigator.ConnectionTreeNode$LoadTask.doWork(ConnectionTreeNode.java:26)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.kv.KVStoreException: Could not establish an initial login from: [:]
at oracle.kv.impl.security.login.RepNodeLoginManager.bootstrap(RepNodeLoginManager.java:248)
at oracle.kv.KVStoreFactory.getStoreInternal(KVStoreFactory.java:233)
… 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: ma-gcsdba-ltt01.corp.apple.com; nested exception is:
java.io.IOException: SSL connection to host is not valid.
at oracle.kv.impl.util.registry.RegistryUtils$ExceptionWrappingRegistry.rethrow(RegistryUtils.java:1233)
at oracle.kv.impl.util.registry.RegistryUtils$ExceptionWrappingRegistry.list(RegistryUtils.java:1222)
at oracle.kv.impl.security.login.RepNodeLoginManager.bootstrap(RepNodeLoginManager.java:144)
… 19 more
Caused by: java.rmi.ConnectIOException: Exception creating connection to: ; nested exception is:
java.io.IOException: SSL connection to host is not valid.
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:631)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:216)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:202)
at sun.rmi.server.UnicastRef.newCall(UnicastRef.java:342)
at sun.rmi.registry.RegistryImpl_Stub.list(Unknown Source)
at oracle.kv.impl.util.registry.RegistryUtils$ExceptionWrappingRegistry.list(RegistryUtils.java:1220)
… 20 more
Caused by: java.io.IOException: SSL connection to host is not valid.
at oracle.kv.impl.util.registry.ssl.SSLClientSocketFactory.createSocket(SSLClientSocketFactory.java:287)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:613)
… 25 more

Reply

Leave a Comment

 

Previous post:

Next post:

About Whitehorses
Company profile
Services
Technology

Whitehorses website

Home page
Whitebooks
Jobs

Follow us
Blog post RSS
Comment RSS
Twitter