MDriven PreDelete + auto cascade deletes, what is rolled back if deletion is canceled?
Using MDriven Framework, we want to use PreDelete to clean up some linked objects that can't be handled automatically due to interdependencies (they need to be deleted in a particular order).
The class in question also has some M-M links with link objects (that should be auto deleted by the framework) and some composite links (that should result in linked objects to be auto deleted by the framework).
I assume that those auto deletions happen after return from PreDelete.
What happens if some of these auto deletions fail? (E.g. if some cascade PreDelete returns with canDelete == false.)
Is the entire delete operation rolled back, including the operations performed by the original/main object's PreDelete?
I would assume that the entire delete operation is wrapped by a transaction (IUndoService.StartTransaction). Is this true? Otherwise, how is it done and what happens if the delete is canceled or throws?
Yes - everything is wrapped in a transaction and on fail to perform the whole everything is rolledback.
Below is a snap of the code to get an idea of the flow:
- Clickhouse table data deleting
- MDriven PreDelete + auto cascade deletes, what is rolled back if deletion is canceled?
- Spanner - many smaller transactions vs fewer larger ones?
- Does adding @Transactional annotation to method is a must when making database calls?
- Mongodb v4.0 Transaction, MongoError: Transaction numbers are only allowed on a replica set member or mongos
- SQL Server - transactions roll back on error?
- Are there any difference between data integrity and data consistency?
- Read, Increment and Update Transaction in SQL Server
- Is it possible to disable the enlistment to ambient transactions in Entity Framework Core 8 globally?
- Differentiate between main transaction and autonomous transaction?
- How to log errors in DB within a transaction that fails with Entity Framework 6
- Codeigniter Transactions
- There will have any effect for updating after queryRunner.commitTransaction() in Typeorm , Node.js
- What is the 'best' way to do distributed transactions across multiple databases using Spring and Hibernate
- Does Cassandra offer any semantics similar to REPEATABLE READ?
- Postgres, update and lock ordering
- JPA @Transactioanl REQUIRES_NEW AND Catch RuntimeException But rollback
- How to rollback gremlin transaction using gremlinpython?
- Spring-Boot migration 2.7 to 3.3 on open liberty. Problem with @Transactional(readOnly = true)
- Transactions inside functions in SurrealDB
- Handle a function that can be called within a transaction or not
- How can I commit() this transaction?
- Mongoose transaction session.withTransaction is not a function
- consistency by isolation levels, while SELECT SUM(...) million records, UPDATE some records
- Writing atomic functions in Python
- C# MySQL transactions not working
- Does using a transaction for read queries provide benefits under Read Committed Isolation Level in PostgreSQL?
- Postgres serializable isolation level confusion
- Optimistic vs. Pessimistic locking
- What does suspending a transaction mean?