Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 24th, 2006, 05:20 AM
Authorized User
Join Date: Jun 2006
Location: mumbai, Maharastra, India.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to balesh
Default Problem with nested transaction

Hi All,

I am facing a problem with transactions. I can't explain the whole Scenario but i can explain why i am logical confused. I want to know if we have a transaction in asp.net attach to a sqlcommand. The command is calling several sql procedures one after another. In these procedures we are also using transactions. I want to know how these transactions behave. Means what happen if the transactions in procedure rollback, or commit to the asp.net trasaction.
Will it also be affected or not.

Suppose sqlcommand is calling three procedure proc1, proc2 and proc3 one by one.We have attached a transction to sqlcommand. After successfully calling the proc1, sqlcommand moves to proc2.

In proc2, we are using trasctions and in a perticular condtion we rollback or commit inside proc2. Will it rollback the work done in proc1 also.

Please help me asap.

Thanks in advance

Old November 25th, 2006, 01:38 PM
Authorized User
Join Date: Sep 2006
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

The answer is wht u rollback or commit in proc2,it effects the before proc too.In this way the transaction takes place in dotnet transaction.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Any help problem when trying to make a transaction koco .NET Framework 3.5 0 June 20th, 2008 03:51 AM
Transaction problem (pg298) abc_abc BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 June 29th, 2006 02:57 AM
Sub Transaction Problem gaurav_jain2403 SQL Server 2000 3 May 13th, 2006 10:53 AM
Problem Regarding DB2 transaction log amitbattu J2EE 0 July 21st, 2004 03:43 AM
Problem in biztalk transaction block Avi Biztalk 0 July 2nd, 2004 02:18 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.