Neo4j error in load csv using periodic commit

Five Stars

Neo4j error in load csv using periodic commit



I have an exception in tNeo4jRow component with query "using periodic commit load csv with headers....". The error is:

Exception in component tNeo4jRow_1 
org.neo4j.driver.v1.exceptions.ClientException: Executing queries that use periodic commit in an open transaction is not possible.


Why can not I use periodic commit in tNeo4jRow component?


The environment is Talend Open Source - Big Data - 6.5.1 and db version Neo4j 3.2.X


Re: Neo4j error in load csv using periodic commit


Are you able to run your job succrssfully after removing the Periodic Commit from the query?

Best regards



Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.