| Sam Vanhoutte 2005-06-02, 2:47 am |
| Hello,
I tried to make following POC with the SQL adapter:
I have two different stored procedures. The first allways executes
well, the second one tries to insert a null value in a nullable column
(to force an exception). The desired behavior is that these SQL calls
occur in one atomic transaction and that the first stored proc gets
rolled back after the second one crashes.
If I work with the SQL adapter send calls in an atomic scope, they only
get rolled back, when an exception is thrown in that atomic scope. So
it would be great to retrieve the exception from the stored proc in the
atomic scope. But offcourse, this is only possible in the long running
scopes (delivery notification exceptions).
So, what I'd like to know is if it's possible to send two different SQL
messages for stored procs in one DTC transaction.
I understand that the atomic scope should not run for more than a few
seconds (locking etc). So what about retries etc. of the SQL adapter?
Will these retries still be in the same distributed transaction?
Any comments on this will be greatly appreciated!
Best regards,
Sam Vanhoutte
CODit Belgium
|