distributed-transactions

How do two-phase commits prevent last-second failure?

I am studying how two-phase commit works across a distributed transaction. It is my understanding that in the last part of the phase the transaction coordinator asks each node whether it is ready to commit. If everyone agreed, then it tells them to go ahead and commit. What prevents the following failure? All nodes respond that they a...

How do I configure authentication between linked servers?

I am trying to test a proof of concept that I can run a distributed transaction across two linked SQL Servers, linked using sp_addlinkedserver - their names are Server1 and Server2, both running under default instances. Each server holds a single database, Source and Destination respectively and the destination database holds a single t...

Distributed transactions with WCF

Basic architecture: n physical boxes each hosting the same WCF service, sitting begind a load balancer. Each box hitting a single database infrastructure that does not support transactions - don't ask :( So, in the data access layer of my app I need some method of distributed transactions. What are my options? Note that clients to my...

What are options for VB-ASP applications for consuming .NET web services?

I have a traditional ASP application which is expected to consume a .net web service. What support does ASP provide for such a scenario? I rememeber VB script supporting a transaction attribute at the start of the page. Can i use the transaction to include the web service call as well? Any pointers would be appreciated. thanks Parito...

Security risk of enabling MSDTC

MSDTC is disabled by default (windows 2003 - onwards) and I want to have it enabled for an application I'm developing that requires distributed transactions from .Net C#. I don't believe there are any security issues with enabling it, but does SO know of any security issues with enabling the DTC? Cheers Ollie ...

Oracle 10.2 acting weird. Or is it me...

Please check out the following query. The SQL isn't as bad as it looks. Basically, we have a fact table and some simple joins to some dimension tables. Then we have a join to a derived table, given the alias ACCOUNTS-DIM-DEP SELECT dw_mgr.fa_trans_fct.period, dw_mgr.fa_trans_fct.asset_cost_company_code, dw_mgr.fa_tra...

Transactions within loop within stored procedure

I'm working on a procedure that will update a large number of items on a remote server, using records from a local database. Here's the pseudocode. CREATE PROCEDURE UpdateRemoteServer pre-processing get cursor with ID's of records to be updated while on cursor process the item No matter how much we optimize it, th...

using toplink from hibernate

hi, i am using hibernate but i want to add an application that is using hibernate. the problem that i am facing is when i want to perform global transaction on that combined application. i am using weblogic as container, now the problem is that hibernate created its own connection, i want that toplink should use that connection only... c...

WS-AT Issue between WPS 6.2 and WAS 7.0

Hi, I have a BPEL running on WPS 6.2 trying to call a web service on developed on RAD 7.5, deployed on RAD test environment. I have setup WS Transaction policy on both client and server. I get an error on WAS 7.0 saying Must Understand check failed for headers: {http:// schemas.xmlsoap.org/ws/2004/10/wscoor}CoordinationContext...

WCF Transaction Flow Question

I would like to configure WCF service operations to accept a transaction if my client sends one, but not to create one if none is sent. I think this would be similar to the Supported transaction attribute in COM+. Does anyone know whether this can be accomplished with WCF transactions? I am trying to accomplish this all by using the...

How do i program a "Distributed Transaction"?

In the past all my db needs were solved by sqlite. Now designing a db that can potentially be large i looked into "Distributed Transaction". How do i program that? I found some results explaining what distributed transaction is but non explained how to program it. I know in code i have a few transactions that i may want to batch into a ...

When does it make sense to have a single transaction per multiple database connections?

Can anyone help me see in what kind of scenarios it would make sense to have one shared database transaction and multiple connections? Thanks. ...

If I access UserTransaction does this mean that I use 2 phase commit or XA?

Hi UserTransaction ut=lookup.... ut.beginTransaction(); saveToFooDB(); statelessEjb.transactionSupportedMethod(); //saves something to the Foo DB saveToFooDB(); ut.commit(); If i was doing the above then my understanding is that it is not an XA transaction as it doesn't span across multiple resources (like DB plus JMS). Is my understa...

Delivery of JMS message before the transaction is committed

Hi, I have a very simple scenario involving a database and a JMS in an application server (Glassfish). The scenario is dead simple: 1. an EJB inserts a row in the database and sends a message. 2. when the message is delivered with an MDB, the row is read and updated. The problem is that sometimes the message is delivered before the...

Reliable test for MSDTC promoting transactions to distributed?

How can I reliably check that MSDTC has promoted a transaction to a distributed transaction? This is when using TransactionScope in .net. Currently a co-worker is testing this by shutting down the coordinator on his machine - if an exception is thrown this is taken as evidence that an attempt to promote the transaction has occurred. Is...

SOA and distributed transactions

When do distributed transactions make sense in a service-oriented architecture? ...

Why is TransactionScope using a distributed transaction when I am only using LinqToSql and Ado.Net

We are having problems on one machine, with the error message: "MSDTC on server XXX is unavailable." The code is using a TransactionScope to wrap some LingToSql database code; there is also some raw Ado.net inside of the transaction. As only a single sql database (2005) is being accessed, why is a distributed transaction being ...

How do you deal with denormalization / secondary indexes in database sharding?

Say I have a "message" table with 2 secondary indexes: "recipient_id" "sender_id" I want to shard the "message" table by "recipient_id". That way to retrieve all messages sent to a certain recipient I only need to query one shard. But at the same time, I want to be able to make a query that ask for all messages sent by a certain sen...

Integrity and Confidentiality in Distributed Transactions

Hello! I've a question regarding distributed transactions. Let's assume I have 3 transaction programs: Transaction A begin a=read(A) b=read(B) c=a+b write(C,c) commit Transaction B begin a=read(A) a=a+1 write(A,a) commit Transaction C begin c=read(C) c=c*2 write(A,c) commit So there are 5 pairs of critical operations: C2-A5...

DBA's say no to SQL Server DTC?

I am trying to get our DBA's to enable DTC on a cluster of SQL Server 2005. Unfortunately they keep refusing. Their argument that they would need to set up a dedicated host for DTC (Could take months!!) as it is not a matter of ticking a few boxes. Is this true? How intrusive is DTC on a shared environment such as a SQL farm. Do I have a...