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.