Hi,
I am new to OrientDB and exploring how its JSON importation module works in
order to build a database of heterogenous documents.
For this, I installed version 3.0.21 and run the OrientDB server and Studio.
I attempted to run the example of importing a JSON file into demoDB , using
the documentation instructions:
- I adapted the configuration file as below:
{
"config": {
"log": "debug"
},
"source" : {
"file": { "path":
"/Users/armand/GIT/markdown-report/examples/orient/database.json" }
},
"extractor" : {
"json": {}
},
"transformers" : [
{ "merge": { "joinFieldName": "id", "lookup": "Account.id" } },
{ "vertex": { "class": "Account"} },
{ "edge": {
"class": "Friend",
"joinFieldName": "friends",
"lookup": "Account.id",
"unresolvedLinkAction": "CREATE"
} }
],
"loader" : {
"orientdb": {
"dbURL": "remote:localhost/demodb",
"dbUser": "admin",
"dbPassword": "admin",
"dbAutoDropIfExists": true,
"dbAutoCreate": true,
"standardElementConstraints": false,
"tx": false,
"wal": false,
"batchCommit": 1000,
"dbType": "graph",
"classes": [{"name": "Account", "extends":"V"}, {"name": "Friend",
"extends":"E"}, {"name": 'Enemy', "extends":"E"}],
"indexes": [{"class":"Account", "fields":["id:integer"],
"type":"UNIQUE_HASH_INDEX" }]
}
}
}
and with a JSON source file exactly the same as in the documentation,
namely:
[
{
"name": "Joe",
"id": 1,
"friends": [2,4,5],
"enemies": [6]
},
{
"name": "Suzie",
"id": 2,
"friends": [1,4,6],
"enemies": [5,2]
}
]
- then, I ran ETL in a bash console on macOSX:
$ ~/Downloads/orientdb-3.0.21/bin/oetl.sh import.json
OrientDB etl v.3.0.21 - Veloce (build
1d8b0c01ca8fe12a516bba355681e3ec8b218d1d, branch 3.0.x)
https://www.orientdb.com
2019-07-15 17:02:27:193 INFO Default limit of open files (512) will be
used. [ONative]Exception in thread "main"
com.orientechnologies.orient.core.exception.OConfigurationException: Error
on loading config file: import.json
at
com.orientechnologies.orient.etl.OETLProcessorConfigurator.parseConfigAndParameters(OETLProcessorConfigurator.java:79)
at
com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:116)
Caused by: java.io.FileNotFoundException: import.json (No such file or
directory)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.<init>(FileInputStream.java:138)
at
com.orientechnologies.common.io.OIOUtils.readFileAsString(OIOUtils.java:145)
at
com.orientechnologies.orient.etl.OETLProcessorConfigurator.parseConfigAndParameters(OETLProcessorConfigurator.java:69)
... 1 more
Any idea of what went wrong? Perhaps the loader dbURL field?
Thanks for any help.
Armand
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/orient-database/064eb186-1322-4df8-b342-6d06842bbad3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
