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

Configuring a XA datasource to mysql 8 DB with spring-boot and bitronix JTA manager fails with SqlException XAERR_RMERR

I have created a Spring Boot 2 (2.1.6.RELEASE) project with dependencies on spring-boot-starter-data-jpa and spring spring-boot-starter-jta-bitronix with a XA datasource configured for Mysql DB (8.0.16). The application property file (trimmed for…
Wai Keung Yiu
  • 471
  • 4
  • 10
3
votes
1 answer

JTA Datasources without transactions

(Assuming manual enlistment and delistment of resources.) I have a number of XA enabled resources/datasource for which I plan to perform transactional updates. Additionally, some of the XA-enabled datasources can be updated in isolation (without…
Chris
  • 4,450
  • 3
  • 38
  • 49
3
votes
1 answer

Only send JMS message once the JPA transaction commits

I'm working on a project that makes use of Spring's JmsTemplate, ActiveMQ and Hibernate. I have a method wrapped in a transaction which sends a message through the JmsTemplate, does a bit more work and then returns so that the transaction can…
Zecrates
  • 2,952
  • 6
  • 33
  • 50
3
votes
0 answers

GlassFish 5, JMS Wrong XAState: 0

I testing my application, reading from queue, but on log catch error: DTX5008: Pooling Exception: java.lang.IllegalStateException: Wrong XAState:…
3
votes
1 answer

Steps to setup distributed transaction management in JBoss

I am trying to implement a distributed transaction (XA) in JBoss EAP 6.2 application server so that multiple datastores can be accessed in a single coordinated atomic transaction. To be more precise, I'd like my transactional service method to write…
Taoufik Mohdit
  • 1,910
  • 3
  • 26
  • 39
3
votes
0 answers

XA Transactions Support for Coherence*Extend clients

I would like to wrap my Coherence cache update calls into transactions using the Coherence Resource Adapter to have full XA support. But it seems this feature is not applicable to Coherence*Extend clients. Is it any workaround to have Extend…
3
votes
1 answer

Cannot call Connection.commit in distributed transaction

I am using Weblogic 12c and I am getting the below error while committing distributed transactions in my application. "java.sql.SQLException: Cannot call Connection.commit in distributed transaction. Transaction Manager will commit the resource…
Codebeginner
  • 193
  • 4
  • 14
3
votes
0 answers

How to handle optimistic locking failure within XA transactions?

We are using Arjuna/Narayana XA transaction support for a project so we can have a single distributed transaction that spans multiple databases at the same time. One of our databases is MySQL. Like many other databases, MySQL throws a certain type…
Archie
  • 4,959
  • 1
  • 30
  • 36
3
votes
0 answers

Distributed Transaction between multiple Apps in Spring

I currently have a set of ERP style web applications build on top spring 3. The application is deployed into tomcat 7. The system developed some time ago without a cleanly defined architecture. Each Application has 3 parts (as sub projects). API:…
Firdous Amir
  • 1,297
  • 5
  • 21
  • 39
3
votes
1 answer

JMS Session and JPA transaction with XA

I'm using WebSphere 8.5 with EJB 3.1 and JMS Generic provider. I need to write messages in a queue using a stateless session bean as a producer. The EJB is annotated with the TransactionAttributeType.REQUIRED because I need to perform some "DB…
Yanosh
  • 368
  • 5
  • 15
3
votes
2 answers

XA error: XAResource.XAER_RMFAIL start() failed on resource Resource manager is unavailable

I developed an application on Weblogic 11g and configured a data source to connect Oracle 11g. When I start the application, I got an error, anyone have the ideas? java.sql.SQLException: Unexpected exception while enlisting XAConnection…
AnZhi
  • 43
  • 1
  • 2
  • 8
3
votes
1 answer

EJBs, XA transactions and error handling

We have what we believe is a fairly common XA use case: read a message from an in-queue write some data to a database write a response message to an out-queue (which is different from the in-queue) However we also need a way to handle internal…
Philippe Marschall
  • 4,452
  • 1
  • 34
  • 52
3
votes
1 answer

Multiple XA data sources in a single JTA transaction

I have been programming with the Java EE platform for a while, but sometimes I am missing the bigger picture. Using a EJBs and Container-Managed Transactions, how can I perform operations on multiple data sources in a single transaction? My code…
Danilo Piazzalunga
  • 7,590
  • 5
  • 49
  • 75
3
votes
1 answer

Atomikos, Tomcat, JTA java.lang.ClassCastException

Attempting to get transactions to work using Tomcat, Atomikos, ActiveMQ, and MySql. Followed these examples: Tomcat 7 Integration with Atomikos 3.5.2 and Tomcat 7.0.27 Integration with Atomikos 3.7.1 with no success... ERROR:…
Boyan
  • 165
  • 1
  • 2
  • 8
3
votes
1 answer

Testing JTA XA distributed transaction with JPA / Hibernate / MySQL

My goal is to have a standalone solution for building JUnit tests for local and distributed transactions using JPA over Hibernate over MySQL. So far, I have been able to use an XADataSource to access a XAResource and manage the distributed…
Miguel Pardal
  • 579
  • 1
  • 8
  • 19