Skip to main content
601 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
54 views

Per all documentation I can find for the MSDTC tracing feature, selecting "Trace All Transactions" should provide a trace file that can be formatted and read. I have tried for several days ...
mfro's user avatar
  • 1
Best practices
0 votes
0 replies
51 views

I am going to try to implement such thing and thinking about the best practice. Of caurse I know about some patterns like SAGA with transaction outbox but I never used it in practice. Is there any ...
tidik's user avatar
  • 21
0 votes
0 answers
90 views

I'm currently working on a server application that needs to send transactions to a database hosted on a virtual machine (VMDB) located in a separate, untrusted domain (with a different Active ...
fedesbuc's user avatar
  • 1
-1 votes
1 answer
205 views

Currently, I can't get XA-Transactions AND Durable Subscription working at the same time. A Demo Projekt is here: https://github.com/proxora/Spring-boot-3-ActiveMQ-XA-Transactions-Durable-Subscription-...
xtermi2's user avatar
  • 846
0 votes
1 answer
102 views

I’m trying to implement two-phase commit transactions using Narayana REST-AT fully embedded in a Spring Boot application—no WildFly/JBoss server, no Docker Compose or external broker, just project ...
Watlas's user avatar
  • 26
0 votes
0 answers
86 views

I am not good at databases and SQL and have not worked on complex tasks. I will try to explain as best as I can. Thanks for your help. We are performing proof-of-concept (POC) and we are facing some ...
Rushikesh Yadav's user avatar
  • 1
0 votes
0 answers
60 views

I'd like to perform a massive parallel scanning of a large table in a clustered Oracle database setup (with a master node and several replicas). All client transactions that read from the table need ...
Vitaly Isaev's user avatar
  • 5,875
2 votes
1 answer
458 views

In a microservice architecture, each service typically manages its own database and executes operations independently. However, when dealing with business processes that span multiple microservices, ...
Dustin Lee's user avatar
  • 494
3 votes
2 answers
371 views

I am reading DDIA. It says "possible to make Dynamo-style quorums linearizable at the cost of reduced performance: a reader must perform read repair (see “Read repair and antientropy” on page 178)...
Zack Light's user avatar
  • 362
1 vote
1 answer
69 views

I have a use case where to mark a create entity operation as successful in my service, I have to write some metadata to DataBase 1 (my service has direct access to DB), internally call another api of ...
do5's user avatar
  • 73
0 votes
1 answer
38 views

The meat and potatoes of how our website works is that users create an "Activity" when they receive a call from a patient. An activity is essentially documenting what the patient is calling ...
Logan Cooper's user avatar
  • 93
0 votes
1 answer
272 views

We have upgraded recently from .NET Core 2.2 to .NET 6.0 and we encounter several issues. One of them is related to using System.Transaction which somehow is being upgraded to distributed transaction ...
herme 0's user avatar
  • 982
0 votes
1 answer
409 views

Update trigger doesn't work while using SQL Server linked server. I created a linked server on my local SQL Server. I can query this linked server (SELECT, UPDATE, INSERT etc.) from my local machine. ...
Farhad Aliyev's user avatar
  • 19
0 votes
1 answer
917 views

I have created a console application using the .Net 8 environment and there is this code in Program.cs: TransactionManager.ImplicitDistributedTransactions = true; var transactionOptions = new ...
Maksim Perevoshchikov's user avatar
  • 1
0 votes
1 answer
222 views

I have a setup which I can scale by adding nodes listening to a JMS Queue. All resources (nodes) write into the same database and work together on one or many "Jobs" in parallel. Job A -->...
jhemm's user avatar
  • 25
0 votes
0 answers
401 views

In my new microservices arch we are planning to 2PC protocol to handle distributed TX mgmt as we are using Oracle shared DB. I am unable to find any right implementation over the web. Is there any ...
CodingBee's user avatar
  • 21
1 vote
1 answer
5k views

Spring Boot 3 doesn't support Atomikos. https://github.com/spring-projects/spring-boot/wiki/Spring-Boot-3.0-Migration-Guide Support for the following dependencies has been removed in Spring Boot 3.0: ...
simyaci's user avatar
  • 93
0 votes
2 answers
214 views

im working on a school project about replication in databases. I created a cloud spanner instance with 5 databases. The "main" database is named electores_nac and i want to replicate only ...
André Gelabert's user avatar
  • 1
0 votes
1 answer
238 views

Am creating some utility tool with c# code for DBA(run Background job to get some metrics), for that am using failover database server(dbserver-fa) for read data and primary server(dbserver) for write ...
Kalaivanan2k4's user avatar
  • 37
2 votes
0 answers
197 views

Let's imagine we have an application that has 3 instances and 1 DB (there might be more synchronized DBs) and we have a withdraw method that basically selects the account from account table with @...
Aksoy's user avatar
  • 131
0 votes
1 answer
120 views

I have a linked Server connected from ServerA to ServerB. In each server there is an SP that initiates a transaction and it is necessary for one ServerA.SP to be executed within ServerB.SP. My problem ...
Moises Hernandez's user avatar
  • 21
0 votes
0 answers
160 views

I want to make transactional update in two databases. Given I have following pseudocode: try { Connection conn1 = DriverManager.getConnection("jdbc:postgresql://HOST1", "postgres1&...
MiamiBeach's user avatar
  • 3,505
1 vote
2 answers
7k views

I try to follow migration guide when atomikos was removed in spring boot 3: https://github.com/spring-projects/spring-boot/wiki/Spring-Boot-3.0-Migration-Guide but I can no see information about it. ...
hudi's user avatar
  • 16.6k
2 votes
0 answers
111 views

We need to synchronize data stored in different AWS regions that may reside on different databases(MySQL, Postgres, DynamoDB etc.). For example, we may have a user that has a profile in both us-east-1 ...
Meghan's user avatar
  • 21
1 vote
1 answer
200 views

How can I manage eventual consistency when getting stock balance (or like bank account balance) from read database when implementing CQRS? I dont want to playback events as I believe it will be a ...
AKBK's user avatar
  • 11
0 votes
1 answer
72 views

is there any way to use Rollback the DB operations performed by set of consecutive API's network calls to Help Automation For instance if i have a test script to test my application so my test script ...
ksk's user avatar
  • 307
1 vote
1 answer
188 views

I am working on QLDB from last 3 months on a single region using it as a leisure database. Now, business wants to move applications in multi-region support. I found many of the AWS services support ...
bakshay's user avatar
  • 43
0 votes
1 answer
51 views

I am calling an API to save the production data, I need to save various details like batch no, machine no, and process in different database Class ProductionImpl{ public Long saveProduction(...
YJ_'s user avatar
  • 1
1 vote
1 answer
561 views

Imagine there is an app where a user has a wallet which they can top it up with cash, cash it out or make purchases from an external system, when the user creates a new purchase order, we first deduct ...
MistaOS's user avatar
  • 255
6 votes
5 answers
8k views

I am developing small POC application to test .NET7 support for distributed transactions since this is pretty important aspect in our workflow. So far I've been unable to make it work and I'm not sure ...
Bola's user avatar
  • 778
1 vote
1 answer
305 views

Consider order processing which consists of multiple micro-services each for: Create order. Make payment. Update inventory. Deliver order. Let say saga execution coordinator is used to implement ...
ankit's user avatar
  • 35
0 votes
1 answer
560 views

I am trying to configure the narayana transaction manager with camel and spring. I have created two data source objects and inserting two records in to two different databases. I am throwing error ...
chandrahas g's user avatar
  • 1
0 votes
1 answer
201 views

I am trying to learn the different consistency models and I ran into these slides. However, I can't interpret the slide below on strict serializability which slide 4 of the slides says that a read ...
heretoinfinity's user avatar
  • 1,804
1 vote
1 answer
343 views

I have the following scenario. I am running a pipeline in Microsoft Hosted agent windows-2022. In the pipeline process, I run a sql server container, which serves as my database server. My application ...
Manas's user avatar
  • 43
0 votes
1 answer
1k views

There is a situation that I have separate CommandBus and EventBus, I have a consumer that listens to the commands in the command bus and after the operation is handled it publishes related events to ...
Saeed Ganji's user avatar
  • 306
1 vote
1 answer
800 views

I'm using atomikos to handle global transaction between 2 different databases. I ran before with more than 1 billion records and this problem just appeared couple days ago. I guess the reason is my ...
leetrinh's user avatar
  • 33
0 votes
1 answer
2k views

If a user calls service A, and service A then calls service B, tracing is simple using the correlation ID. Now if service A calls service B multiple times, the same correlationID gets used for each of ...
Jerald Baker's user avatar
  • 1,481
2 votes
0 answers
146 views

I'm playing around with Atomikos. Using this as a starting point: https://www.fabiomaffioletti.me/blog/2014/04/15/distributed-transactions-multiple-databases-spring-boot-spring-data-jpa-atomikos/ In ...
Haris Hajdarevic's user avatar
  • 1,583
1 vote
0 answers
684 views

Dears, I am going to use multiple databases in my application but as you know, distributed transactions is not supported in efcore yet. So is there any work around to save multiple transactions across ...
Alaa Adel's user avatar
  • 143
0 votes
1 answer
1k views

I need to execute same command in different server using linked-server. INSERT #Result EXEC ('command') AT @linked_server Because Insert statement opens an Implicit transaction and I can not enable ...
Meyssam Toluie's user avatar
  • 1,081
-1 votes
3 answers
5k views

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 ...
InspectorGadget's user avatar
  • 1,006
1 vote
0 answers
370 views

My Spring application was using JPA transaction manager but for some situations I would like to use JTA transaction manager. Therefore I updated Spring config to something like that: <beans> &...
Radu Dumbrăveanu's user avatar
  • 1,426
0 votes
0 answers
555 views

I have a use case as below: Prepare a transaction and keep this transaction id. Do some operations in multiple sessions using the same transaction id. Do some operations in any external system. Do ...
Rudra's user avatar
  • 411
1 vote
1 answer
1k views

Are there guidelines on how many messages and/or partitions can be involved in a Kafka Producer Transaction before performance really starts to suffer? Obviously, the more partitions are involved, the ...
cmcnealy's user avatar
  • 372
1 vote
0 answers
227 views

When there are multiple requests for updating same document in a AttemptContext transaction block, data becomes inconsistent because of concurrent threads trying to update the document. Also a warning ...
Maninder Chhabra's user avatar
  • 123
2 votes
2 answers
342 views

I am currently reading the Microservices Patterns and it says there are mostly two approaches for distributed transactions: two phase commit (2PC) and sagas pattern. Also, I've heard about currently ...
Alexander Bashkirov's user avatar
  • 83
2 votes
1 answer
1k views

Has anyone also noticed an issue with queue browsing with 5.16.2? It happens when using an XA connection and starting a session without a transaction context. This always worked fine but no longer ...
Ramden's user avatar
  • 107
3 votes
2 answers
1k views

I have a multi-tenant application. The tenants data is isolated based on schema. I want to implement a transactional outbox pattern, where I want to store the events in a table (in same transaction)...
Kumar's user avatar
  • 1,676
0 votes
0 answers
401 views

I have a reproducible case where NO deadlock victim is detected. The configuration is as follows: Database 1 runs on SQL Server 1 on Machine 1 Database 2 runs on SQL Server 2 on Machine 2 The MSDTCs ...
Stefan Vettiger's user avatar
  • 95
0 votes
1 answer
1k views

I have two transaction manager for two database. I need to persist same data into both databases. If one transaction failed, other one need rollback. I have done like below public interface ...
Sangeetharaj's user avatar
  • 223

1
2 3 4 5
…
13