Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error while loading MySQL data into Neo4j using ETL #82

Open
conker84 opened this issue Aug 6, 2021 · 2 comments
Open

Error while loading MySQL data into Neo4j using ETL #82

conker84 opened this issue Aug 6, 2021 · 2 comments

Comments

@conker84
Copy link

conker84 commented Aug 6, 2021

I get this error when I try to import data. It says mapping is successful, I can see nodes and some relationships.

COMMAND: java -cp "C:\Users\Dell.Neo4jDesktop\graphApps_global\neo4j-etl-ui/dist/neo4j-etl.jar" org.neo4j.etl.NeoIntegrationCli export --mapping-file "C:\Users\Dell\AppData\Local\Temp/mysql_northwind_northwind_mapping.json" --destination "C:\Users\Dell.Neo4jDesktop\relate-data\dbmss\dbms-fc479351-02a2-450d-93af-ccdc9205b93d/data/databases/graph.db/" --import-tool "C:\Users\Dell.Neo4jDesktop\relate-data\dbmss\dbms-fc479351-02a2-450d-93af-ccdc9205b93d/bin" --rdbms:password "" --rdbms:user "root" --rdbms:url "jdbc:mysql://localhost:3306/northwind?autoReconnect=true&useSSL=false&useCursorFetch=true&allowPublicKeyRetrieval=true" --csv-directory "C:\Users\Dell\AppData\Local\Temp" --options-file "C:\Users\Dell\AppData\Local\Temp/import-tool-options.json" --using "bulk:neo4j-import" --neo4j:url "bolt://localhost:7687" --neo4j:user "neo4j" --neo4j:password "root" --force
- Illegal command (NullPointerException: null)
@vga91
Copy link

vga91 commented Aug 6, 2021

The bug is due to the empty MySql password --rdbms:password ""

@slicksammy
Copy link

Thanks @vga91 - had the same issue and that fixed it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants