Any query that updates the graph will run in a transaction. An updating query will always either fully succeed, or not succeed at all.
Cypher will either create a new transaction or run inside an existing one:
- If no transaction exists in the running context Cypher will create one and commit it once the query finishes.
- In case there already exists a transaction in the running context, the query will run inside it, and nothing will be persisted to disk until that transaction is successfully committed.
This can be used to have multiple queries be committed as a single transaction:
- Open a transaction,
- run multiple updating Cypher queries,
- and commit all of them in one go.
Note that a query will hold the changes in memory until the whole query has finished executing. A large query will consequently need a JVM with lots of heap space.
For using transactions over the REST API, see Section 22.1, “Transactional Cypher HTTP endpoint”.
When using Neo4j embedded, remember all iterators returned from an execution result should be exhausted fully to ensure that resources bound to them will be properly closed. Resources include transactions started by the query, so failing to do so may, for example, lead to deadlocks or other weird behavior.