Hi Curtis,
if you get last snapshot I've introduced the log level. Remove "verbose"
(deprecated) and set: "log": "debug" in config:
{
"config": {
"log": "true"
},
Then please send me the logs.
Lvc@
On 27 August 2014 16:04, 'Curtis Mosters' via OrientDB <
[email protected]> wrote:
> 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 [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
---
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.
