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
4
votes
1 answer

Mysql XA Isolation Level

Does anyone know why Mysql requires serializable isolation level to achieve ACID properties with XA transactions or what would be lost if you used repeatable read and XA? However, for a distributed transaction, you must use the SERIALIZABLE…
benmmurphy
  • 2,503
  • 1
  • 20
  • 30
4
votes
1 answer

Does Neo4j still support XA transactions?

I use spring boot and neo4j for my project. SDN(spring data neo4j) as a data access layer. Recently I faced a problem where I need cross-store persistence, I need to update data in both neo4j and oracle database. So standard way to do that is XA…
noobie
  • 43
  • 3
4
votes
0 answers

camel Atomikos XA continually reconecting

I have recently moved my routes over to use XA, I am not sure if this is normal behavior or a problem but I am seeing continual reconnecting in the log and the transaction logs are growing when there is no activity as such on the jms queue. The logs…
Paul B
  • 51
  • 4
4
votes
1 answer

How to make a distributed transactions in Laravel Eloquent orm or DB facades?

I cannot find APIs like XA in Laravel, and seems there's no implementation in Eloquent or DB facades. If I want to use XA or other way to make a MySQL distributed transaction in Laravel, how should I do?
chenxinlong
  • 1,677
  • 2
  • 15
  • 30
4
votes
1 answer

Distributed Transaction with SQL Server and Websphere MQ

We have SQL server 2012 as the DB server and Websphere MQ on Redhat Linux as the MQ server. Our applications are on a Redhat Linux server and implemented in C++. We need distributed transaction capability so that transactions can span both the…
Yash
  • 946
  • 1
  • 13
  • 28
4
votes
1 answer

Need to use legacy PLSQL with DBLink call, in an XA transaction, and can not use shared connection

I have an Oracle PLSQL program in database A, that select's data from other database B through a DBLink. I call the PLSQL program from a Java EE application. Till now, it all works fine. Database B is out out my scope, it belongs to an external…
4
votes
1 answer

XA Transactions support in MySQL Cluster?

Does MySQL Cluster supports XA Transactions? I'm using the NDBCLUSTER engine. I have an app which needs to update multiple dbs for a transaction.
shahalpk
  • 3,383
  • 7
  • 36
  • 55
4
votes
1 answer

Can an Akka actor participate in an XA transaction?

Can an Akka actor participate in an XA transaction? For example, can an actor send a message to a remote actor within the same XA transaction as a database operation (assuming the JDBC driver is an XA driver) such that if the database operation…
Derek Mahar
  • 27,608
  • 43
  • 124
  • 174
4
votes
3 answers

JBoss spamming XA Recovery warnings

I'm running a JPA/Spring application that connects to multiple XA enabled datasources on Microsoft SQL Server. Everything works just fine, with global transactions correctly starting and rolling back as needed... But, every now and then JBoss goes…
Vedran
  • 10,369
  • 5
  • 50
  • 57
4
votes
1 answer

Performance Overhead of XA Data Sources - Best Practices

I am trying to understand the Impact of XA Datasources on Performance. In many applications, it happens that not all the transactions need to participate in Distributed Transactions (meaning only a few transactions require to be…
Sandeep Jindal
  • 14,510
  • 18
  • 83
  • 121
4
votes
2 answers

Does JTA work across multiple threads?

From JTA specs i understand that it works (or supports) distributed transactions only for calling thread. Does this mean that transactions cannot be spanned across multiple threads? Or it depends on implementation? Does any JTA implementation…
spark07
  • 168
  • 2
  • 10
3
votes
0 answers

ActiveMQ 5, JBoss 7 and XA transactions

I've found this article to configure ActiveMQ in JBoss 5 : How to configure ActiveMQ JCA connector in JBoss to use XA connections? But I'm using JBoss AS 7 and can't figure out how to make it enlist my Jmstransaction in the global XA transaction…
Manuel
  • 31
  • 2
3
votes
1 answer

How to perform XA transaction in EJB?

I have a MDB listening to particular topic. I have configured XA data source with jboss... I have set persistance .xml org.hibernate.ejb.HibernatePersistence
user796666
  • 91
  • 3
  • 11
3
votes
3 answers

RAD 8 Exception

Please help me understand the possible causes of this exception, or better still how to fix it? The exception stack trace is as follows: com.ibm.ws.Transaction.XAResourceNotAvailableException: java.lang.Exception: Parameter xaResInfo lacks an RA…
Gopal
  • 71
  • 1
  • 9
3
votes
1 answer

If in a transaction we do write only on one data source, is it possibile to avoid 2PC or handle commint manually? (J2CA0030E)

We are migrating an application from IBM WebSphere Traditiona 8.5 to OpenLiberty 19.0.0.12 (Both with IBM JDK 8). In the process we want to get rid of XA transactions, are there is only one method that is actually using two different data sources,…
Matteo
  • 487
  • 4
  • 12
1 2
3
21 22