Nested transaction

Posts   
 
    
Wally
User
Posts: 285
Joined: 29-Aug-2007
# Posted on: 13-Nov-2008 16:52:32   

Just want to verify...

Do you "begin" the real transaction on the "HelperClasses.Transaction" constructor or at the "HelperClasses.Transaction.Commit" method ?

If "HelperClasses.Transaction" constructor then that's perfect, thank you (and forget the remaining text) !!!

If the transaction is begun at the "HelperClasses.Transaction.Commit" method then it would not enables us to use nested transaction either with regular database specific transaction or LLBL transactions. Could you begin the transaction at the constructor or add a new public method to enable us to begin the transaction manually (with an internal flag if needed to not start it twice if necessary) ?

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 13-Nov-2008 18:32:59   

The transaction is started by the constructor. You should be able to verify this by using SQL query profiler, or your RDBMS's equivalent.

Matt

Wally
User
Posts: 285
Joined: 29-Aug-2007
# Posted on: 13-Nov-2008 19:38:07   

Thanks a lot simple_smile

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 13-Nov-2008 22:16:33   

HTH simple_smile