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

Prepared transactions with Postgres 8.4.3 on CentOS

I have set 'max_prepared_transactions' to 20 in the local postgres.config and yet the transaction fails with the following error trace (but only on Linux). Since in Windows the same code works seamlessly I am wandering if this isn't an issue of…
Petre Maierean
  • 914
  • 3
  • 14
  • 21
7
votes
3 answers

JDBC driver does not support XA issue

I am getting "JDBC driver does not support XA issue" Error committing transaction:; nested exception is: javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannot be a participant in two-phase commit.
Ashish Kumar Gupta
  • 279
  • 2
  • 3
  • 9
6
votes
2 answers

Are XA/JTA transactions still used?

I have an application that interacts multiple databases and some custom services. For some operations, I need transaction-like behavior where a set of changes either commit across all databases/services or all roll back if an error occurs. The XA…
Chris Sears
  • 6,502
  • 5
  • 32
  • 35
6
votes
2 answers

An illegal attempt to commit a one phase capable resource with existing two phase capable resources

I have an MDB in WebSphere 6. The MessageListener is linked to a Tibco EMS queue. In the MDB I'm trying to write to a WebSphere MQ queue. I get the following error: WMSG0042I: MDB Listener LoanIQ Payments Inbound started successfully for…
Synesso
  • 37,610
  • 35
  • 136
  • 207
6
votes
2 answers

Atomikos: exception when transaction contains more than one persist

I'm experimenting with standalone JPA and JTA / XA transaction management provided by Atomikos. My simple unit test persists 3 records, wrapped in a JTA UserTransaction. When using H2 as backing database, the test works fine. When using MySQL as the…
geert3
  • 7,086
  • 1
  • 33
  • 49
6
votes
2 answers

JBOSS: Thread freezing on Oracle XA Transaction using Atomikos

I am getting an error after sometime on my application when I going to transmit some data using atomikos and hibernate. 2015-11-06 07:11:56,353 WARN [http-/0.0.0.0:8083-10] datasource.xa.XAResourceTransaction - XA resource 'COTXADBMS': resume for…
6
votes
4 answers

Wildfly 10 failing to load MySQL XA driver on startup

I have a web application I am deploying in wildfly-10.0.0. It requires a mysql xa driver. I have the following error: 2015-10-13 12:25:37,979 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 33) WFLYCTL0013:…
RBall444
  • 111
  • 1
  • 2
  • 5
6
votes
1 answer

Is it safe to set Hibernate after_transaction as a JTA connection release mode when using Bitronix Transcation Manager?

According to Hibernate docs, in a JTA environment the default connection release mode is after_statement, meaning that after each statement the hibernate logical connection is released. When the logical connection is released, the Connection close()…
Vlad Mihalcea
  • 142,745
  • 71
  • 566
  • 911
6
votes
1 answer

How to process distributed transaction within postgresql?

Anyone can kindly tell me how to process distributed transaction within postgresql, which is also called "XA"? Is there any resources about it? Great thanks for any answer.
Moon_of_father
  • 183
  • 1
  • 3
  • 10
6
votes
1 answer

How to do XA transaction which includes JDBC and JMS transactions?

I need to do XA transaction in JavaSE with JDBC and JMS Queues. I have weblogic server to lookup for resources. Could you help me with some sample code?
Stalin Gino
  • 592
  • 9
  • 28
5
votes
1 answer

When do I use XA datasource and 2 phase commit

Can someone please explain the use of XA dataSource and how transaction management works in an XA datasource ? How is XA datasouce and 2 Phase commit related?
Aravind A
  • 9,507
  • 4
  • 36
  • 45
5
votes
1 answer

XA transactions and message bus

In our new project we would like to achieve transactions that involve jpa (mysql) and a message bus (rabbitmq) We started building our infrastructure with spring data using mysql and rabbitmq (via spring amqp module). Since rabbitMq is not…
Urbanleg
  • 6,252
  • 16
  • 76
  • 139
5
votes
2 answers

HornetQ: How to reuse XAConnection and XASession

I'm facing some issues trying to reuse a XAConnection and XASession on multiple workers in my JBoss application. I've managed simplify the issue down to just one single method. It should be able to both Produce and Consumer a message using the same…
dhrm
  • 14,335
  • 34
  • 117
  • 183
5
votes
1 answer

Use websphere MQ as XA transaction coordinator

I am trying to use Websphere MQ (without WAS) as the XA transaction coordinator for my java application between MQ and Oracle 11g. Is it possible? Is it a good practice? I have installed the MQ V7.0.1 server on my windows (64bit win7) and config…
Philip
  • 61
  • 1
  • 4
4
votes
1 answer

Jboss - Strange exception after auto-reconnecting to XA datasource

I'm using a XA datasource on Jboss 6, using and to auto-reconnect when one of the connections is dead. This works, but the problem is that after the "reconnecting", every two minutes or so…
GoofyHTS
  • 263
  • 1
  • 6
  • 15
1
2
3
21 22