Stack Overflow
Stack Overflow

Questions tagged [distributed-transactions]

An operational bundle which consists of multiple ACID transactions, usually on multiple servers, which must all commit or roll back. A transaction manager coordinates this through two-phase commits.

600 questions
9
votes
1 answer

Does Two-phase Commit Protect Against Final Commit Failures?

Suppose all the databases involved in a distributed transaction implemented with two-phase commit signal that they are ready to commit and have the necessary locks. The coordinator signals to commit and all databases execute their portion of the…
user782220
  • 10,677
  • 21
  • 72
  • 135
8
votes
3 answers

How do you handle validation in composite microservice request?

Consider an application with two entities: User (contains basic user data, such as name) Passport (contains authentication credentials, i.e. password) And two internal microservices: UserService (responsible for creating and managing users and…
Slava Fomin II
  • 26,865
  • 29
  • 124
  • 202
8
votes
2 answers

Atomikos transaction logs com.atomikos.icatch.enable_logging=false

I would like to understand if the Distributed Transaction Capabilities will work for my application if I set the com.atomikos.icatch.enable_logging=false Do I understand correctly that the Transaction Recovery is relevant in the cases where there…
Alexander Petrov
  • 9,204
  • 31
  • 70
8
votes
1 answer

Why does Azure Database perform better with transactions

We decided to use a micro-orm against an Azure Database. As our business only needs "inserts" and "selects", we decided to suppress all code-managed SqlTransaction (no concurrency issues on data). Then, we noticed that our instance of Azure Database…
Rénald
  • 1,412
  • 12
  • 29
8
votes
1 answer

Transaction Management in Spring JMS listener

I have a spring JMS listener which is listening to queue . Once the message arrives at the input queue , it does certain processing on the message and puts the messages to multiple other queues for further processing (we may call these other queues…
KBR
  • 464
  • 1
  • 7
  • 24
8
votes
3 answers

XA/JTA transaction: JMS message arrives before DB changes are visible

Context is: producer (JTA transaction PT) is both sending message to JMS queue and making DB update; consumer (JTA transaction CT) listens on same queue and reads DB when message is received; application server - WebLogic, DB - Oracle. I've…
Ralkie
  • 3,736
  • 3
  • 25
  • 25
8
votes
2 answers

Query global temp table on a linked server

I have seen all of the references on how to query two different tables on two different SQL servers, and I understand how it is to be implemented. However, the command doesn't seem work with temporary tables created with the ##. If I write a join on…
mpilatzke76
  • 81
  • 1
  • 1
  • 3
7
votes
3 answers

Can I use NHibernate's AdoNetTransactionFactory with distributed transactions?

I am dealing with a strange issue related to NHibernate and distributed transactions in a WCF service. See Deadlocks causing 'Server failed to resume the transaction' with NHibernate and distributed transactions for more details. One thing that…
jon without an h
  • 572
  • 1
  • 4
  • 17
7
votes
3 answers

Transaction handling multi-tier application

Is there a possibility having transactions across multiple systems? For exeample: layer 1 - exposes web services (Deployed to weblogic) layer 2 - .NET front end (Deployed to IIS) Can we have transaction commit or rollback for multiple web service…
priceline
  • 91
  • 3
7
votes
2 answers

Accessing transaction status in container managed beans

I have a @Stateless EJB using container managed transaction. Is there a way to access the "status" of javax.transaction.UserTransaction? That is, calling UserTransaction.getStatus() inside the bean methods? I know access to UserTransaction is…
Vicky
  • 5,380
  • 18
  • 60
  • 83
7
votes
4 answers

NHibernate 3.0: TransactionScope and Auto-Flushing

In NHibernate 3.0, FlushMode.Auto does not work when running under an ambient transaction only (that is, without starting an NHibernate transaction). Should it? using (TransactionScope scope = new TransactionScope()) { ISession session =…
Jeff Sternal
  • 47,787
  • 8
  • 93
  • 120
7
votes
3 answers

Distributed transactions in microservices

I have 2 microservices S1 and S2. S1 invokes S2 to update a data and then S1 inserts another data,But let's consider S1 fails,Then we need to rollback the data updated by S2 or else we'll be in inconsistent state. I also gone through Saga…
Ragavan
  • 101
  • 9
7
votes
1 answer

Azure failed to marshal transaction into propagation token for elastic transaction (Works for MSDTC)

In windows azure we have hosted two asp.net webapi project as app service. We need to enable distributed transaction here. We initiate transaction inside one api. Then inside that transaction scope we fetch propagation token of that transaction and…
Anup
  • 1,502
  • 2
  • 15
  • 31
7
votes
2 answers

Spring Distributed Transaction Involving RMI calls possible?

Background I have Spring Client application that provisions a service to two servers using RMI. In the the client I save an entity to the database (easy) and make rmi calls to two servers with details of the entity. I am using Spring 3.0.2 on the…
Paul Whelan
  • 16,574
  • 12
  • 50
  • 83
7
votes
2 answers

Distributed Transaction on Linked Server between sql server and mysql

I have a table say Table1 on SQL Server 2014 and MySQL both. Table1 ID INT,Code VARCHAR(100) I created a linked server MyLinkedServer in SQL Server using "Microsoft OLEDB Provider for ODBC". **Linked Server ** EXEC master.dbo.sp_addlinkedserver…
ughai
  • 9,830
  • 3
  • 29
  • 47
1 2
3
…
39 40