Skip to Main Content

NoSQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with Oracle NoSQL Database Loader Sample Program

759e745f-1f34-4fcc-8daf-a531067976b1Sep 2 2014 — edited Dec 11 2014

Hi

I downloaded with BigDatalite Virtual Machine (which comes with Oracle NoSQL). I wanted to load some records into the NoSQL database - and I noticed there is a sample program to load a CSV file or XML file into a NoSQL database - see link

Oracle NoSQL Database Documentation

I prepared an XML file to load - and started the loader program - and it failed

[oracle@bigdatalite work]$ java -cp $SAMPLE_HOME/OLH/ONLH/deploy/onlh.jar:$SAMPLE_HOME/OLH/ONLH/lib/nosql/kvclient-1.2.123.jar oracle.kv.sample.Loader -i $SAMPLE_HOME/OLH/ONLH/deploy/DTS_MEASUREMENT.xml -m "DTS <devicetag> <offset>" -n "<datetime>" -v "<temp>" -t xml -h bigdatalite.localdomain -p 5000
Exception in thread "main" oracle.kv.FaultException: Oracle NoSQL DB 11gR2.1.2.123 Could not contact any RepNode at: [bigdatalite.localdomain:5000]
Fault class name: oracle.kv.KVStoreException
at oracle.kv.KVStoreFactory.getStore(KVStoreFactory.java:57)
at oracle.kv.sample.common.BaseLoader.getKVConnection(BaseLoader.java:162)
at oracle.kv.sample.common.BaseLoader.init(BaseLoader.java:127)
at oracle.kv.sample.common.BaseLoader.<init>(BaseLoader.java:121)
at oracle.kv.sample.Loader.<init>(Loader.java:23)
at oracle.kv.sample.Loader.main(Loader.java:139)
Caused by: oracle.kv.KVStoreException: Could not contact any RepNode at: [bigdatalite.localdomain:5000]
at oracle.kv.impl.util.TopologyLocator.getInitialTopology(TopologyLocator.java:199)
at oracle.kv.impl.util.TopologyLocator.get(TopologyLocator.java:58)
at oracle.kv.impl.api.RequestDispatcherImpl.<init>(RequestDispatcherImpl.java:227)
at oracle.kv.KVStoreFactory.getStore(KVStoreFactory.java:51)
... 5 more
Caused by: java.rmi.UnmarshalException: error unmarshalling return; nested exception is:
java.lang.ClassNotFoundException: oracle.kv.impl.util.registry.ClientSocketFactory (no security manager: RMI class loader disabled)
at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
at oracle.kv.impl.util.TopologyLocator.getInitialTopology(TopologyLocator.java:160)
... 8 more

etc etc

[oracle@bigdatalite work]$

However the database seems to up and I can see the topology - what am I doing wrong ?

 

[oracle@bigdatalite work]$ java -jar $KVHOME/lib/kvstore.jar runadmin -host bigdatalite.localdomain -port 5000
kv-> show topology
store=kvstore numPartitions=10 sequence=14
zn: id=zn1 name=KVLite repFactor=1 type=PRIMARY

sn=[sn1] zn:[id=zn1 name=KVLite] bigdatalite.localdomain:5000 capacity=1 RUNNING
[rg1-rn1] RUNNING
No performance info available

shard=[rg1] num partitions=10
[rg1-rn1] sn=sn1

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2015
Added on Sep 2 2014
2 comments
1,800 views