Luca, could you also if you can't help me just give a statement. Just say
it does not work currently or you testing it or anything.
Just that I know this problem gets a solution because currently it's
unusable for Windows users =/
Thank you.
Am Dienstag, 26. August 2014 10:17:06 UTC+2 schrieb Curtis Mosters:
>
> Switching from Person to Author was just to test your Tutorial as exactly
> as possible. I now added some logs. There you can see that there is no
> warning but also no edge is created:
>
> Person ETL:
>
> {
> "config": {
> "verbose": true
> },
> "extractor" : {
> "jdbc": { "driver": "com.mysql.jdbc.Driver",
> "url": "jdbc:mysql://localhost/test",
> "userName": "root",
> "userPassword": "",
> "query": "select * from Author" }
> },
> "transformers" : [
> { log : { prefix: "BEFORE->" } },
> { "vertex": { "class": "Author"} },
> { log : { prefix: "AFTER->" } }
> ],
> "loader" : {
> "orientdb": {
> dbURL: "plocal:C:\Users\kwoxer\Desktop\DB - orientdb\databases\Test"
> ,
> dbUser: "root",
> dbPassword: "root",
> dbAutoDropIfExists: false,
> dbAutoCreate: true,
> tx: false,
> wal: false,
> batchCommit: 1000,
> dbType: "graph",
> indexes: [{class:"Author", fields:["id:string"], type:
> "UNIQUE_HASH_INDEX" }]
> }
> }
> }
>
> The results in command line:
>
> C:\Users\kwoxer\Desktop\DB - orientdb\bin>oetl.bat backup\luca\person.json
> OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
> BEGIN ETL PROCESSOR
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 1015ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 2015ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 3016ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 4016ms [0 warnings, 0 errors]
> BEFORE->{id:1,name:wda}
> AFTER->v(Author)[#11:0]
> BEFORE->{id:2,name:fwf}
> AFTER->v(Author)[#11:1]
> END ETL PROCESSOR
> + extracted 3 records (7 records/sec) - 3 records -> loaded 2 vertices (4
> vertic
> es/sec) Total time: 4427ms [0 warnings, 0 errors]
>
> Post/Edge ETL:
>
> {
> "config": {
> "verbose": true
> },
> "extractor" : {
> "jdbc": { "driver": "com.mysql.jdbc.Driver",
> "url": "jdbc:mysql://localhost/test",
> "userName": "root",
> "userPassword": "",
> "query": "select * from Post" }
> },
> "transformers" : [
> { log : { prefix: "LOG 1->" } },
> { "vertex": { "class": "Post"} },
> { log : { prefix: "LOG 2->" } },
> { "edge": { "class": "Wrote", "direction" : "in",
> "joinFieldName": "person_id",
> "lookup":"Author.id", "unresolvedLinkAction":"WARNING"} },
> { log : { prefix: "LOG 3->" } }
> ],
> "loader" : {
> "orientdb": {
> dbURL: "plocal:C:\Users\kwoxer\Desktop\DB - orientdb\databases\Test"
> ,
> dbUser: "root",
> dbPassword: "root",
> dbAutoDropIfExists: false,
> dbAutoCreate: true,
> tx: false,
> wal: false,
> batchCommit: 1000,
> dbType: "graph",
> indexes: [{class:"Post", fields:["person_id:string"], type:
> "UNIQUE_HASH_INDEX" }]
> }
> }
> }
>
> Here the command line output:
>
> C:\Users\kwoxer\Desktop\DB - orientdb\bin>oetl.bat backup\luca\postedge.
> json
> OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
> BEGIN ETL PROCESSOR
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 1000ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 2001ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 3001ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 4001ms [0 warnings, 0 errors]
> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
> vertic
> es/sec) Total time: 5001ms [0 warnings, 0 errors]
> LOG 1->{person_id:1,title:wadwd}
> LOG 2->v(Post)[#12:0]
> LOG 3->v(Post)[#12:0]
> LOG 1->{person_id:2,title:fawf}
> LOG 2->v(Post)[#12:1]
> LOG 3->v(Post)[#12:1]
> END ETL PROCESSOR
> + extracted 3 records (8 records/sec) - 3 records -> loaded 2 vertices (5
> vertic
> es/sec) Total time: 5356ms [0 warnings, 0 errors]
>
> I don't know why it is working for you. Did you already try one ETL of
> mine? Maybe you have some other config? Maybe something "*oetl.bat*" is
> n...
--
---
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
