StrataFrame Forum / StrataFrame Application Framework / Business Objects and Data Access (How do I?) / Cross database transaction / Latest Posts

RE: Cross database transaction

ChanKK — Tue, 05 May 2009 04:23:53 GMT

Hi,
I just spent some time to have a look how could I integrate transactionScope to SF. Too bad is that it is not so straight forward for multi-thread environment. As SF uses threading for DataLayer, therefore TransactionScope (which only support single thread) can not be used. Even though DependentTransaction does support multi thread, but it required code change at SF dataLayer.

Hope SF can implement this, or advice how could we accomplish this.

http://www.pluralsight.com/community/blogs/jimjohn/archive/2005/05/01/7923.aspx

Thank you

RE: Cross database transaction

Chan — Tue, 16 Dec 2008 10:19:43 GMT

Hi,
I found that, we can use TransactionScope class to have distributed transaction without using DTC. However, I haven't go thru how to implement this in SF.

Please advice if you have any ideas.

Thank you

RE: Cross database transaction

Trent L. Taylor — Tue, 16 Dec 2008 09:08:56 GMT

You can try and setup this up, but I think that you are going to have to use a distributed transaction in order to cross multiple databases under a single transaction.

Cross database transaction

Chan — Fri, 12 Dec 2008 11:33:17 GMT

Hi,
I have data in multiple databases. Does SF support transaction for multiple data source? How?

Thank you