600 questions
0
votes
0
answers
31
views
Different results when invoking function with raw sql and plsql [duplicate]
Well I have 2 distinct Oracle 12c databases, lets name them db1 and db2
I have a link from db1 to db2 (DBL_DB2), also grants for execution of pkg2 which contains procedure 2, which we call proc2 (in ...
-1
votes
1
answer
180
views
Spring boot 3 + ActiveMQ + XA-Transactions + Durable Subscription to JMS Topic dows not work properly
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-...
- 836
0
votes
0
answers
78
views
Error while using stored procedure in distributed transaction
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 ...
2
votes
1
answer
419
views
How to achieve distributed transaction consistency in a microservices architecture without using 2PC?
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, ...
- 494
1
vote
1
answer
65
views
Handling custom transaction failures
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 ...
- 73
0
votes
1
answer
258
views
ASP.NET Core 6 and EF Core - distributed transaction
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 ...
- 982
0
votes
1
answer
910
views
I have a deadlock on a distributed transaction in a .NET 8 environment, but I don't understand how to resolve it
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 ...
0
votes
0
answers
394
views
Java spring boot 2PC protocol implementation
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 ...
- 21
0
votes
2
answers
212
views
Configure conditioned replication between databases in a single instance of Cloud Spanner
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 ...
2
votes
0
answers
196
views
How do distributed locks work in Spring Data JPA repository level?
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 @...
- 131
0
votes
0
answers
157
views
Running two JDBC transactions for different databases - will it work?
I want to make transactional update in two databases. Given I have following pseudocode:
try {
Connection conn1 = DriverManager.getConnection("jdbc:postgresql://HOST1", "postgres1&...
- 3,505
2
votes
0
answers
107
views
Multi-master data replication across different AWS regions
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 ...
- 21
0
votes
1
answer
68
views
is there any way to use Rollback the DB operations performed by set of consecutive API's network calls to Help Automation
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 ...
- 307
0
votes
1
answer
46
views
How to rollback all the insert and update that are done in different tables from different function calls that are called through the single api
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(...
- 1
6
votes
5
answers
8k
views
.NET 7 Distributed Transactions issues
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 ...
- 778
0
votes
1
answer
539
views
Narayana Transaction Manager configuration - Not rolling back
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 ...
1
vote
1
answer
333
views
MSDTC over network does not work in Azure Pipeline Microsoft hosted agents
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 ...
- 43
1
vote
1
answer
777
views
Atomikos transaction timeout when insert into huge table
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 ...
- 33
2
votes
0
answers
144
views
Atomikos - Working with two databases and single repository
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 ...
- 1,583
0
votes
1
answer
989
views
How to save result of executing command in link server
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 ...
- 1,081
1
vote
0
answers
364
views
How to correctly mix JTA and JPA transaction in Spring application
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>
&...
- 1,426
1
vote
1
answer
1k
views
Number of Messages Per Transaction in Kafka
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 ...
- 372
2
votes
2
answers
337
views
Can Distributed SQL tools be applied as alternatives to 2 phase commit or sagas patterns for distributed transaction coordination?
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 ...
3
votes
2
answers
1k
views
Design / Implement Transactional Outbox pattern in schema isolated multitenant application
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)...
- 1,676
0
votes
1
answer
1k
views
How to rollback child transaction if any exception in parent transaction?
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 ...
- 223