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.
Questions tagged [distributed-transactions]
600 questions
0
votes
2 answers
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "DB_PROD_04" was unable to begin a distributed transaction
I have two servers:
SQL_UAT_01
DB_PROD_04
Both of these servers have the same database name and same tables:
SQL_UAT_01.Database_01.TestTable
DB_PROD_04.Database_01.TestTable
There is a trigger on each of these two tables.
When the trigger…
JJ.
- 9,580
- 37
- 116
- 189
0
votes
2 answers
Define a Wrapper for non-primitive types(classes)
I am implementing a middleware service provider in a distributed system, which provide lock management to the methods which are calling it,
we may have many commands requiring this service
Actually this service checks some conditions to see if it…
Arian
- 7,397
- 21
- 89
- 177
0
votes
1 answer
DTS transaction fails: Can not access a disposed object
We are running distributed transactions, and on some rare occasions we get the following error:
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'SqlDelegatedTransaction'. at
…
Marius
- 9,208
- 8
- 50
- 73
0
votes
1 answer
Can Transaction across machine with JMS?
Case:
Start: create transaction
Insert Data to DB (Machine A)
send sync JMS message to Queue (Machine A)
receive JMS message from the Queue (Machine B)
Insert Data to DB and return (Machine B)
further process in (Machine A)
End: Commit…
suiaing
- 31
- 1
- 4
0
votes
0 answers
Is injecting an argument, in a policy handler, within the unity interception pipeline, permissable?
So I have pulled my transaction scope into an aspect/policy. I want to associate a database connection, just one, with this transaction scope before calling the method (a data access method) in the pipeline which will call one or potentially more…
brumScouse
- 3,166
- 1
- 24
- 38
0
votes
1 answer
InvalidOperation in NHibernate AbstractBatcher on DTC Transaction close
I'm working on an application that is multi-threaded and using NServiceBus and NHibernate with SQL Server 2008RC (using DTC). The process has one session factory. Each thread has it's own Session which is disposed of when the transaction is…
PBe
- 11
- 2
0
votes
1 answer
Implementing TransactionManager in JINI
I'm implementing Two-Phase Lock using JINI.
I've done it by following algorithm definition. And in my implementation I have a few ArrayLists and HashMap to track which participants has committed or aborted transaction.
Every time I do…
aumanets
- 3,703
- 8
- 39
- 59
0
votes
0 answers
distributed solution using p2p
we are developing a standalone and distributed (web) application framework. we have sqlite dbs on each machine and framework saves data on that machine but if the machines are in network then they need to synchronize their data to other machines as…
Waqas
- 424
- 7
- 15
0
votes
1 answer
Distributed write job crashes remote machine with MongoDB server
Looking for any advice I can get.
I have 16 virtual CPUs all writing to a single remote MongoDB server. The machine that's being written to is a 64-bit machine with 32GB RAM, running Windows Server 2008 R2. After a certain amount of time, all…
-1
votes
3 answers
Spring boot "no transaction is in progress" with 2 datasources
I have two databases and i'm trying to save some records to both of them inside a service method.
This gives me the error: org.springframework.dao.InvalidDataAccessApiUsageException: no transaction is in progress; nested exception is…
InspectorGadget
- 879
- 6
- 20
-1
votes
1 answer
Stored Procedure and REST API call as a transaction
Imagen that you have a stored procedure in a database that you call from PHP. That procedure works like a transaction and selects/inserts data into the database. If it succeeds it commits, if it fails it rollbacks.
Now imagen that you need to store…
odjuret
- 19
- 2
-1
votes
2 answers
How to achieve transaction concept while dealing with multiple Azure resources in sequence
In my application while creating new user record via POST/users REST webapi endpoint, below are the steps involved
step 1: create entry in Azure Active Directory(AAD)
step 2: on success of step:1, send email notification to the concern user email id…
191180rk
- 735
- 2
- 12
- 37
-1
votes
1 answer
Distributed Databases questions
When we talk about Distribuited Databases, all them, must to have the same information?
for example imagine the table customers
select * from customers
this query must to return same result in any database?
in other word all users must exist in…
angel
- 4,474
- 12
- 57
- 89
-2
votes
1 answer
Instrumenting ILogger to .net core app trace - Dynatrace sink
App Environment: Azure, .NET Core 3.1, C#
We understand that Serilog provides a Dynatrace Sink Serilog.Sinks.Dynatrace for logging app trace statements to Dynatrace.
We are trying to avoid having a dependency on Serilog in our .NET core app.
Is…
Athadu
- 854
- 7
- 13
-2
votes
1 answer
does jdbcConnection have ExceptionListener support, similar to jmsConnection?
We use XA/distributed transaction, and I'm trying to notify/update global transaction status, should a participating xaResource-branch throw an exception.
A good example can be found in JMS Connection#setExceptionListener(), (ref.link), which…
fall14123
- 61
- 1
- 8