Sorry it was a mistake of the phpmyadmin database. Created a db test and tested it there, here it works well:
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 END ETL PROCESSOR + extracted 1 records (0 records/sec) - 1 records -> loaded 0 documents (0 docum ents/sec) Total time: 24ms [0 warnings, 0 errors] But now comes another problem. My class is not filled with the entry from the MySQL db. How it comes? Am Freitag, 15. August 2014 20:59:00 UTC+2 schrieb Curtis Mosters: > > 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 <http://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]> 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]. >>> 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.
