Hey Luca, I found a little issue with the current MySQL example:
http://www.orientechnologies.com/docs/last/orientdb-etl.wiki/Import-from-DBMS.html
If you do it like in your tutorial, it does not work (I know you did not
yet rework it):
C:\Users\Mr. Kwox\Desktop\orientdb-community-2.0-SNAPSHOT\bin>oetl.bat etl-
stuff
\person.json
OrientDB etl v.2.0-SNAPSHOT (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
[1:vertex] DEBUG Transformer input: {ID:1,name:Hans}
Pipeline execution halted
ETL process halted: com.orientechnologies.orient.etl.
OETLProcessHaltedException:
Graph instance not found. Assure you have configured it in the Loader
But if you add the not green thing, it works properly.
{
"config": {
"log": "debug"
},
"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:C:/Users/Mr.
Kwox/Desktop/orientdb-community-2.0-SNAPSHOT/databases/test",
"dbType": "graph",
"dbAutoCreate": true
}
}
}
Am Dienstag, 9. Dezember 2014 18:41:44 UTC+1 schrieb Curtis Mosters:
>
> Ahh right. Always forget that I have to use the develop stage. Now
> working. Thanks.
>
> Am Dienstag, 9. Dezember 2014 17:30:36 UTC+1 schrieb Lvc@:
>>
>> Hi Curtis,
>> I'm talking about OrientDB 2.0-SNAPSHOT, pick it from:
>>
>>
>> https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/2.0-SNAPSHOT/
>>
>> or compile the "develop" branch.
>>
>> Lvc@
>>
>>
>> On 9 December 2014 at 17:18, 'Curtis Mosters' via OrientDB <
>> [email protected]> wrote:
>>
>>> Well I downloaded OrientDB M3 and compiled it, as well as with the ETL.
>>>
>>> So I should have the latest. Could you please tell me which one is the
>>> outdated? Thank.
>>>
>>> Am Dienstag, 9. Dezember 2014 15:08:28 UTC+1 schrieb Lvc@:
>>>>
>>>> Hi Curtis,
>>>> seems you don't have an updated OrientDB 2.0-SNAPSHOT linked to the ETL.
>>>>
>>>> Lvc@
>>>>
>>>> On 9 December 2014 at 12:55, 'Curtis Mosters' via OrientDB <
>>>> [email protected]> wrote:
>>>>
>>>>> Not able to get it working. I always get:
>>>>>
>>>>> C:\Users\Mr. Kwox\Desktop\orientdb-community-2.0-M3\bin>oetl.bat etl-
>>>>> stuff\perso
>>>>> n.json
>>>>> OrientDB etl v.2.0-M3 (build @BUILD@) www.orientechnologies.com
>>>>> Exception in thread "main" java.lang.NoSuchMethodError: com.
>>>>> orientechnologies.or
>>>>> ient.core.record.impl.ODocument.fromJSON(Ljava/lang/String;Ljava/lang/
>>>>> String;)Lc
>>>>> om/orientechnologies/orient/core/record/impl/ODocument;
>>>>> at com.orientechnologies.orient.etl.OETLProcessor.main(
>>>>> OETLProcessor.jav
>>>>> a:147)
>>>>>
>>>>> And I already got it working as you can see *here*
>>>>> <http://www.kwoxer.de/2014/08/20/etl-support-installieren-orientdb/>.
>>>>> So what's wrong now?
>>>>>
>>>>> Am Dienstag, 9. Dezember 2014 10:20:02 UTC+1 schrieb Curtis Mosters:
>>>>>
>>>>>> Great Luca, gonna test it with CSV files and a MySQL database today
>>>>>> and let you know if something is not properly working. =)
>>>>>>
>>>>>> Am Dienstag, 9. Dezember 2014 00:28:31 UTC+1 schrieb Lvc@:
>>>>>>>
>>>>>>> Hi guys,
>>>>>>> The ETL is moving fast to the final stage. For all the users
>>>>>>> interested on using it, I have created a new tutorial:
>>>>>>>
>>>>>>> http://www.orientechnologies.com/docs/last/orientdb-etl.wiki
>>>>>>> /Import-from-CSV-to-a-Graph.html
>>>>>>>
>>>>>>> Hope more people will avoid to write code to import an existent DB
>>>>>>> into OrientDB, but rather save precious time using ETL and their own
>>>>>>> JSON
>>>>>>> configuration file.
>>>>>>>
>>>>>>> Lvc@
>>>>>>>
>>>>>>> --
>>>>>
>>>>> ---
>>>>> 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.
