Thanks Luca, the problem was actually not the ETL. It was that I mixed up
the column name id and person_in in MySQL. Simply switched that names and
it runs.
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] <javascript:>> 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] <javascript:>.
>> 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.
