Re: Neo4j Cypher Action - Implicit Transactions

[Hans Van Akelyen <ha...@gmail.com>]

Hi Axel,

As the Cypher script action allows you to execute multiple scripts
separated by a semicolon the code contains an explicit transaction and
commits after all commands are executed successfully.

I added a ticket [1] to investigate if we can add an option to avoid this
and allow PERIODIC COMMIT queries.

Unfortunately, I do not know of an alternative way to handle this query now
but maybe someone else on the mailing list has a creative solution.

Cheers,
Hans

[1] https://issues.apache.org/jira/browse/HOP-4033


On Thu, 30 Jun 2022 at 14:37, Kachler, Axel <ax...@siemens.com>
wrote:

> Dear Apache Hop Team,
>
>
>
> I’d like to run the following implicit transaction in the Cypher Action
> <https://hop.apache.org/manual/latest/pipeline/transforms/neo4j-cypher.html>
> :
>
>
>
> :auto MATCH (n:test)
>
> CALL { WITH n
>
> DETACH DELETE n
>
> } IN TRANSACTIONS OF 10000 ROWS;
>
>
>
> But the following error notification appears:
>
>
>
> Do you know what I can do that Hop accepts a statement which starts with a
> “:”.
>
> Maybe it’s a problem with my driver.
>
>
>
> Thank you for your support.
>
> Kind regards
>
>
>
> Axel
>
>
>
>
>
> Mit freundlichen Grüßen
>
> Axel Kacher
>
>
>
> Siemens AG
>
> Global Business Services
>
> Business Solutions & Services
>
> Data Process Consulting
>
> GBS B&S DE SOL GMS DCS DPC
>
> Dynamostr. 4
>
> 68165 Mannheim, Deutschland
>
> mailto:axel.kachler@siemens.com <ax...@siemens.com>
>
> www.siemens.com
>
> [image: Logo]
>
>
>
>
>
>
>