New thread for this problem: https://groups.google.com/forum/#!topic/orient-database/JbMrhqSGXGM
Am Freitag, 15. August 2014 21:16:27 UTC+2 schrieb Curtis Mosters: > > 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.
