Alright, got oetl to run with:
- Clone the repository on your computer, by executing:
- git clone https://github.com/orientechnologies/orientdb-etl.git
- Compile the module, by executing:
- mvn clean install
- Copy script/oetl.sh (or .bat under Windows) to $ORIENTDB_HOME/bin
- Copy target/orientdb-etl-2.0-SNAPSHOT.jar to $ORIENTDB_HOME/lib
and my json looks like:
{
"config": {
"verbose": true
},
"extractor" : {
"jdbc": { "driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost/phpmyadmin",
"userName": "root",
"userPassword": "",
"query": "select * from pma_recent" }
},
"transformers" : [
{ "vertex": { "class": "Test"} }
],
"loader" : {
"orientdb": {
"dbURL": "plocal:127.0.0.1/Test",
"dbAutoCreate": true
}
}
}
But here I get:
D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat config-test.json
OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
Exception in thread "main" java.lang.NullPointerException
at com.orientechnologies.orient.etl.transformer.OVertexTransformer.
execu
teTransform(OVertexTransformer.java:57)
at com.orientechnologies.orient.etl.transformer.OAbstractTransformer
.tra
nsform(OAbstractTransformer.java:37)
at com.orientechnologies.orient.etl.OETLPipeline.execute(
OETLPipeline.ja
va:97)
at com.orientechnologies.orient.etl.OETLProcessor.
executeSequentially(OE
TLProcessor.java:459)
at com.orientechnologies.orient.etl.OETLProcessor.execute(
OETLProcessor.
java:253)
at com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor
.jav
a:221)
- Table exists
- DB access is successful
- OrientDB url should also be fine (but I always use *connect
remote:127.0.0.1/Test root root* to connect and do anything else in the
database)
What is my problem/how to solve this?
Am Donnerstag, 14. August 2014 18:45:21 UTC+2 schrieb Lvc@:
>
> Hi Curtis,
> What's the problem? You cannot start it, you have errors on connection, or
> what?
>
> About the config file you can put it everywhere and then call the etl as:
>
> > oetl.sh <your-config-file>
>
> Lvc@
>
>
>
> On 14 August 2014 14:48, 'Curtis Mosters' via OrientDB <
> [email protected] <javascript:>> wrote:
>
>> I don't get it to work. Also searched for some more information already.
>>
>> I included the JDBC driver
>> https://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar&;
>>
>> into the lib folder.
>>
>> But where shall I put the config now?
>>
>> Am Donnerstag, 14. August 2014 14:03:13 UTC+2 schrieb Curtis Mosters:
>>
>>> Hey Luca, yeah it's just MySQL.
>>>
>>> God damn I did not find your link before. Sounds great and instantly
>>> testing this awesome stuff thanks =)
>>>
>>> Am Donnerstag, 14. August 2014 13:34:57 UTC+2 schrieb Lvc@:
>>>>
>>>> Hi Curtis,
>>>> unfortunately that syntax was a proposal, but in the wiki seems has
>>>> been removed the fundamental word "proposal". If you want to import
>>>> something in OrientDB the easier way is using the ETL: just one JSON for
>>>> configuration and that's all.
>>>>
>>>> What's your source? A RDBMS?
>>>>
>>>> https://github.com/orientechnologies/orientdb-etl/wiki/Import-from-DBMS
>>>>
>>>> Lvc@
>>>>
>>>>
>>>> On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB <
>>>> [email protected]> wrote:
>>>>
>>>>> Hi, just found it here: https://github.com/orientechnologies/orientdb/
>>>>> wiki/Import-RDBMS-to-Graph-Model
>>>>>
>>>>> Scroll a bit down. Mine is just copied from there.
>>>>>
>>>>> To your link: I want to import a 100 gb database into OrientDB, I
>>>>> don't think that the SQL Batch is the thing I'm looking for?
>>>>>
>>>>> Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa:
>>>>>>
>>>>>> Hi Curtis
>>>>>>
>>>>>> where did you find this syntax?
>>>>>>
>>>>>> *CREATE EDGE E TRANSFORM comment.postId TO **post.id
>>>>>> <http://post.id>* *INVERSE*
>>>>>>
>>>>>> I do not see it in the documentation.
>>>>>>
>>>>>> You could use SQL Batch for your case
>>>>>>
>>>>>> https://github.com/orientechnologies/orientdb/wiki/SQL-batch
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB <
>>>>>> [email protected]>:
>>>>>>
>>>>>>> Hey guys I really need some help here.
>>>>>>>
>>>>>>> Shall I ask maybe somewhere else?
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> ---
>>>>>>> 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] <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.
