Well I tried some hours to get this running. Even studying
http://www.orientechnologies.com/docs/1.7.8/orientdb-etl.wiki/Transformer.html#edge
but nothing new to me.
Somehow the edges cannot be created with ETL. I'm using
*orientdb-etl-0.9.jar*. Should I maybe use another version?
Edit: also tried *orientdb-etl-0.9.2-SNAPSHOT.jar*, still not working =/
Am Montag, 25. August 2014 18:37:58 UTC+2 schrieb Curtis Mosters:
>
> Thanks Luca, the problem was actually not the ETL. It was that I mixed up
> the column name *id* and *person_id* in MySQL. Simply switched that names
> and it runs now.
>
> But somehow *no Edge* is created. I don't get a warning or something like
> that. It just seems that he does not find an id to join. But as you can see
> from the example above I have same ID in that classes. So what else could I
> try?
>
>
>
> Am Montag, 25. August 2014 18:16:43 UTC+2 schrieb Lvc@:
>>
>> No problem,
>> the person id was null. Change the edge block to treat with a WARNING the
>> case:
>>
>> { "edge": { "class": "Wrote", "direction" : "in",
>> "joinFieldName": "person_id",
>> "lookup":"Person.id", "unresolvedLinkAction":"WARNING"} }
>>
>> Lvc@
>> ᐧ
>>
>>
>> On 25 August 2014 18:12, 'Curtis Mosters' via OrientDB <
>> [email protected]> wrote:
>>
>>> Luca, I really don't know =/. Here is a picture, maybe more helpful:
>>>
>>> http://i.imgur.com/f9QJvM8.png
>>>
>>> Am Montag, 25. August 2014 18:07:01 UTC+2 schrieb Lvc@:
>>>>
>>>> What's the error?
>>>> ᐧ
>>>>
>>>>
>>>> On 25 August 2014 17:52, 'Curtis Mosters' via OrientDB <
>>>> [email protected]> wrote:
>>>>
>>>>> No problem Luca, but still the same problem. Here are my JSON's. Just
>>>>> in case I have something missing there. I braked it down to the things I
>>>>> really need:
>>>>>
>>>>> Person ETL:
>>>>> {
>>>>> "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\Test5"
>>>>> ,
>>>>> "tx": true,
>>>>> "batchCommit": 5000,
>>>>> "wal" : true,
>>>>> "dbType": "graph"
>>>>> }
>>>>> }
>>>>> }
>>>>>
>>>>>
>>>>> Post and edge Wrote ETL:
>>>>> {
>>>>> "config": {
>>>>> "verbose": true
>>>>>
>>>>> },
>>>>> "extractor" : {
>>>>> "jdbc": { "driver": "com.mysql.jdbc.Driver",
>>>>>
>>>>> "url": "jdbc:mysql://localhost/test",
>>>>>
>>>>> "userName": "root",
>>>>> "userPassword": "",
>>>>>
>>>>> "query": "select * from post" }
>>>>> },
>>>>> "transformers" : [
>>>>> { "vertex": { "class": "Post"} },
>>>>>
>>>>> { "edge": { "class": "Wrote", "direction" : "in",
>>>>> "joinFieldName": "person_id",
>>>>>
>>>>> "lookup":"Person.id", "unresolvedLinkAction":"CREATE"} }
>>>>> ],
>>>>> "loader" : {
>>>>> "orientdb": {
>>>>>
>>>>> "dbURL": "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test5"
>>>>> ,
>>>>> "tx": true,
>>>>> "batchCommit": 5000,
>>>>> "wal" : true,
>>>>> "dbType": "graph"
>>>>> }
>>>>> }
>>>>> }
>>>>>
>>>>> And Luca, no the Edge problem was already fixed be meself =)
>>>>>
>>>>> not it's this here take I can't handle to fix =/
>>>>>
>>>>>
>>>>> Exception in thread "main" java.lang.IllegalArgumentException:
>>>>> Property value can not be null
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> ---
>>>>> 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.
>>>
>>
>>
--
---
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.
