473,750 Members | 2,270 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Transactions across components

RJN
Hi

I have a transaction requirement that spawns across components. Typical
example is saving address, order etc. Each of these components will do
their part of transaction. If any of the transactions failed, then all
the transactions have to be rolled back. One way is to go for COM+
transaction using ServicedCompone nt. But this affects performance and
moreover we have no across database transactions. Another way I found is
to use ServiceConfig class (http://www.15seconds.com/issue/030930.htm).
But this requires Windows 2003 server. Is there any other way to do
this?

Thanks

rjn

*** Sent via Developersdex http://www.developersdex.com ***
Nov 21 '05 #1
1 960
Use ADO transaction. Place the connection/transaction in a place all
components can access it, and have them use it. Be sure you are
committing/rolling back the transaction and closing the connection when the
whole call stream is done.

"RJN" <rj*@yahoo.co m> wrote in message
news:uU******** *****@TK2MSFTNG P09.phx.gbl...
Hi

I have a transaction requirement that spawns across components. Typical
example is saving address, order etc. Each of these components will do
their part of transaction. If any of the transactions failed, then all
the transactions have to be rolled back. One way is to go for COM+
transaction using ServicedCompone nt. But this affects performance and
moreover we have no across database transactions. Another way I found is
to use ServiceConfig class (http://www.15seconds.com/issue/030930.htm).
But this requires Windows 2003 server. Is there any other way to do
this?

Thanks

rjn

*** Sent via Developersdex http://www.developersdex.com ***

Nov 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2382
by: Richard Maher | last post by:
Hi, I am seeking the help of volunteers to test some software that I've developed which facilitates distributed two-phase commit transactions, encompassing any resource manager (e.g. SQL/Server or Oracle) controlled by Microsoft's Distributed Transaction Coordinator in a Windows2000 environment, with any resource manager under the control of DECdtm (e.g. Rdb (or Oracle via the XA Veneer)) in a VMS environment.
1
4197
by: Rick | last post by:
I'm having problems with EnterpriseServices transactions running against Oracle 9iR2. I am inconsistently getting Oracle ORA-24761: Transaction Rolled Back results mid-transaction. If I start the transaction and run it against an object it might fail. If I rerun the same transaction again it might work. But on trying again it might fail. If I disable transactions <Transaction(TransactionOption.Disabled)> the app runs and all the data...
3
393
by: Iain Mcleod | last post by:
I wish to do a series of inserts on a sql server database in the context of a transaction. The inserts will be done as a series of stored procedure calls. I wish to be able to rollback any inserts should one fail. A quick google on ".net transactions" and the following page comes up: http://samples.gotdotnet.com/quickstart/aspplus/doc/mtstransactions.aspx It says basically that the class System.EnterpriseServices.ContextUtil is the...
3
4051
by: Irfan | last post by:
There are several ways of handling Transactions in DotNet. Some of them are 1. Using COM+ Serviced Component. 2. Using ADO .Net 3. using stored procedure What is the best way of handling Transaction in DotNet Enterprise Application interms of performance, maintainance and scalability? How feasible it would be if we go for stored procedure option, considering
3
1839
by: Lada 'Ray' Lostak | last post by:
Hello ppl, Imagine some online system, based on PgSql. There are 'many' parts which depends on each other. I will give small example, but instead of simple table imagine changing tenths various tables (editing). So, 'change table A' can be work for hours. There are tables tableA and tableB. Changes are made by thin client. If you change tableA, you have to also change tableB to 'finish' operation. Between starting changing tableA...
5
6115
by: Allan Ebdrup | last post by:
I'm using dotNet 2.0 and VS2005, I would like to have some code call several webservices that I have written that insert data into a DB (MSSQL 2000) inside a transaction. So that I can rollback if something goes wrong. Can I support transactions across webservices on different frontend servers? And if so how? I've tried to google for it but haven't found anything yet. Kind Regards, Allan Ebdrup
6
1598
by: RAM | last post by:
Hello, (Sorry for my English...) I am learning .NET 2.0 (C#, ASP.NET, ADO.NET etc.). I need to write a database application (SQL Server) consisting of a number of database transactions (like accounting system). Each of these transactions has enty in menu, parameters screen (.aspx page), some logic (probably implemented in code-behind), and results screen (could be same.aspx page). I need a good design, some ideas of experienced...
12
2043
by: Rami | last post by:
I have some requirement for an automated payment system. The system has four machines setup as follows: 1- Two machines have a clustered database. 2- Two machines have a .net business logic component that will handle payment transactions with certain external component (Payment Gateway) My query is regarding transaction handling inside the business logic component. Because this component is running on two machines and these two...
3
7100
by: psycho | last post by:
I am working on an N-tier application using following components: 1. Data Access Layer using DLINQ which consists of Data Context class and Table Mapping classes. 2. Business Logic Layer. 3. Presentation Layer (normal ASP.NET pages) The problem is that I have to handle database transactions which can span multiple tables. So where should I place the transaction code. I think I should do it in BLL. But how do I control the transaction at...
0
9000
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9396
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9339
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9256
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6081
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4713
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4887
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3322
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2804
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.