I wanted to use the ETL to import some MySQL data.
So this is the json:
{
"config": {
"verbose": true
},
"extractor" : {
"jdbc": { "driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost/test",
"userName": "root",
"userPassword": "",
"query": "select * from person" }
},
"transformers" : [
{ "vertex": { "class": "Person"} }
],
"loader" : {
"orientdb": {
"dbURL": "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test",
"dbAutoCreate": true
}
}
}
And it works:
D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat backup\config-test.json
OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
END ETL PROCESSOR
+ extracted 1 records (0 records/sec) - 1 records -> loaded 0 documents (0
docum
ents/sec) Total time: 34ms [0 warnings, 0 errors]
But when I look now in the folder for some Peron files, there are none of
them. Also looked in the Studio, nothing.
I also mentioned that I now cannot remove the "Test" folder which was
created by ETL. Just can be deleted when the server was shutdown.
I really have no idea what's going on.
Btw the MySQL db is "test" with just the table "person" and one entry.
Please give me some tips guys =)
--
---
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].
For more options, visit https://groups.google.com/d/optout.
