Last post Nov 07, 2013 07:43 PM by Coool
Nov 07, 2013 07:43 PM|Coool|LINK
Before I ask you a question, let me give you some background detail:
Currently I'm working on very-large legacy system with Oracle database and came up with a big task to implement a integration testing. Obviously, it was really easy to use script to insert test data and delete it by the end of the test.
But the problem is, along with inline queries (Gurrrr!!!), I have to use domain logic which behind the screen insert/update records and commit database transcation.
So, I'm thinking to create a wrapper that would begin one transaction before any test data are insert or domain logic is used, making the transaction the parent of all inline query and other transactions of domain logic.
My question are:
Will defining transaction on the top with savepoint make all decendent transaction it's child?
Will all commited nested transaction (from domain logic) rollback, if I rollback the parent transaction?