Questions tagged [xa]

XA allows to execute global transactions that access more than one resource. XA uses a two-phase commit protocol to ensure that all resources either commit or rollback.

XA (eXtended Architecture) allows to execute global transactions that access more than one resource.

The goal of XA is to allow multiple resources to be accessed within the same transaction, thereby preserving the ACID properties across applications. XA uses a two-phase commit protocol to ensure that all resources either commit or rollback.

327 questions
3
votes
1 answer

Sharing a transaction while using AbstractRoutingDataSource to switch datasources

How to share a transaction between datasources when using AbstractRoutingDataSource to switch the active data source? So far, without the transaction the queries get executed on both databases correctly, but when I start a transaction, everything…
Vedran
  • 10,369
  • 5
  • 50
  • 57
3
votes
3 answers

JBoss messaging and XA transactions: JMS messages are lost

I make some tests of distributed JMS and I am currently stuck with the following issue. I have two servers. The first one is JBoss 5.1 with JBoss Messaging 1.4.3, and the second one is JBoss 5.1 with two MDBs. One MDB is routing messages from queue…
androdevo
  • 752
  • 1
  • 8
  • 17
2
votes
1 answer

Manipulating order of XA resources

Is there a way to manipulate the order of executing the registered XAResources within a transaction for quarkus? In my scenario I have a database datasource and an ActiveMQ resource within the XA transaction configured. For me it seems that there is…
Michael
  • 41
  • 4
2
votes
1 answer

ActiveMQ JMS XA Atomikos - Transaction not started error

The situation is we want to use XA transactions to coordinate activity between ActiveMQ and Hibernate (Sql Server 2008). We are using: Spring 3.0.5 Hibernate 3.6.2 ActiveMQ 5.5.0 Atomikos 3.7 We are seeing the following errors getting generated in…
user782333
  • 131
  • 2
  • 7
2
votes
1 answer

32bit DLLs using MSDTC/oracle XA on 64 bit Win2k3

I have a COM+ application (mostly vb6 based), that I need running on a 64-bit system. It's supposed to communicate with an oracle database (10g, 32bit). Everything works fine when I disable XA, but when I have it enabled I receive the following…
cc0
  • 1,960
  • 7
  • 40
  • 57
2
votes
0 answers

how to wrap XADataSource using aries transaction jdbc

I am using pax jdbc 1.1.0 within karaf 4.1.2. here is my file for data source…
anna
  • 265
  • 1
  • 3
  • 17
2
votes
1 answer

spring boot distributed transaction error java.lang.ClassNotFoundException: javax.transaction.TransactionManager

I am trying to do distributed transaction but I have a lot of errors, so I have written this demo app to explain my problem my pom.xml has these dependencies :
Mohammed Nosirat
  • 324
  • 1
  • 3
  • 15
2
votes
3 answers

Oracle DB lock table use

Recently I had a task, according to which, I needed to have a specific lock functionality. The specific was due to: Transaction that was updating table was distributed, so I had no controll over it, During the day thousands non blocking…
mavarazy
  • 7,562
  • 1
  • 34
  • 60
2
votes
0 answers

Enroll Spring REST/SOAP service to XA transaction

I have in mind an scenario that theoretically looks possible to me, but I cannot find any information on the web. The technological environment is Java with Spring, but I am open to other alternatives. I have a service (ServiceA) that wraps a DB…
Javier Sedano
  • 923
  • 3
  • 11
  • 28
2
votes
2 answers

Slow performance spring.io flow from ActiveMQ to OracleAQ with XA

I have a Spring integration flow which bridges from ActiveMQ to OracleAQ. See example project under GitHub - https://github.com/cknzl2014/springio-ora-xa/tree/atomikos. When I run it without XA, it is blazingly fast. With XA, it processes only 1 to…
2
votes
2 answers

Does Postgres provide an XA compliant resource manager?

I would like to know if it is possible to use Postgres as a database backend with transaction monitors like Oracle Tuxedo or Microfocus Enterprise server on Linux. This can be possible if postgres provides an XA compilant ressource manager... I…
y.chraibi
  • 66
  • 4
2
votes
0 answers

Spring Boot using 2 XA datasources on WebLogic - Oracle - XAER_NOTA : The XID is not valid

I'm having problem with using two XA datasources in Spring Boot application. Firstly, I was unable to use basic datasources because of Spring JPA Hibernate implementation in error log was asking me to use XA datasources, so I switched to XA of this…
shx
  • 1,068
  • 1
  • 14
  • 30
2
votes
4 answers

Delaying sending of mail until transaction commits

Does anyone have a good tutorial or some advice on how to implement one's own XAResource? I need Spring's MailSender to be transactional, so that the mail will only be sent once the transaction commits, and it seems there isn't any existing…
Zecrates
  • 2,952
  • 6
  • 33
  • 50
2
votes
1 answer

Wildfly 10 jms send Message to queue as part of XA transaction

I have recently had to support a colleague in verifying why some system tests are not passing in wildfly, system tests that pass consistently on weblogic and glass fish. After analysing the log, it became clear the reason is related to a JMS message…
99Sono
  • 3,554
  • 27
  • 39
2
votes
0 answers

JBoss Pool datasource configuration - postgresql xa vs non-xa

I'm reading the examples from here, and I found an interesting piece: jdbc:postgresql://localhost:5432/postgresdb
caarlos0
  • 20,020
  • 27
  • 85
  • 160