| Author |
SaveAsOrder and Transactions
|
|
| mnet123 2005-06-13, 5:51 pm |
| I want to call OrderGroup.SaveAsOrder as part of a transaction; since i need
to make some other SQL calls after the call to SaveAsOrder.
I should have ability to rollback the entire transaction, if error is
encountered.
How can i achieve this?
--
Regards
| |
| Ravi Shankar 2005-06-14, 2:49 am |
| Hi mnet123
Post OrderGroup.SaveAsOrder if you want to rollback then a sequence call of
OrderGroup.SaveAsBasket + OrderGroupManager.DeleteOrderGroupFromDisk should
provide an effective rollback mechanism... However one thing you'd not be
able to rollback is the order number/tracking number.. So sometime in the
future you might not be able to locate an order entry given a tracking number
because of this 
"mnet123" wrote:
> I want to call OrderGroup.SaveAsOrder as part of a transaction; since i need
> to make some other SQL calls after the call to SaveAsOrder.
> I should have ability to rollback the entire transaction, if error is
> encountered.
>
> How can i achieve this?
> --
> Regards
| |
| mnet123 2005-06-14, 5:55 pm |
| So there is no real rollback mechanism to achieve this, by making it part of
a transaction. I would have really liked to have it as part of a transaction.
--
Regards
"Ravi Shankar" wrote:
[vbcol=seagreen]
> Hi mnet123
>
> Post OrderGroup.SaveAsOrder if you want to rollback then a sequence call of
> OrderGroup.SaveAsBasket + OrderGroupManager.DeleteOrderGroupFromDisk should
> provide an effective rollback mechanism... However one thing you'd not be
> able to rollback is the order number/tracking number.. So sometime in the
> future you might not be able to locate an order entry given a tracking number
> because of this
>
> "mnet123" wrote:
>
| |
| Ravi Shankar 2005-06-16, 5:50 pm |
| Hi mnet123,
That type of support is possible if your call is invoked within the pipeline
where you write COM+ components that can address such issues. From the
description of what you want to do the pipeline component approach would not
be suitable for your pusposes.
"mnet123" wrote:
[vbcol=seagreen]
> So there is no real rollback mechanism to achieve this, by making it part of
> a transaction. I would have really liked to have it as part of a transaction.
>
> --
> Regards
>
>
> "Ravi Shankar" wrote:
>
|
|
|
|