XA Aries Transactions in Jbosss Fuse with two databases

Solution Unverified - Updated -

Issue

  • XA Aries Transactions dont insert when it try to two Database
  • The aries XA transaction It doesn't work.
  • The bundle go to two sybase Database, but in second insert (2nd database) remains waiting forever..
  • below is the stack trace

like it has a "loop" to attempt to register the connection to the second DDBB (1): 21:25:59,938 | DEBUG | #0 - timer://foo | TransactionErrorHandler | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | Transaction begin (0x38212eca) redelivered(unknown) for (MessageId: ID-DELL-2-ABC-00-00-00-1 on ExchangeId: ID-DELL-2-JRS-DI-0000-000000000-0-2)) 21:25:59,943 | DEBUG | #0 - timer://foo | JtaTransactionManager | 148 - org.apache.servicemix.bundles.spring-tx - 3.2.8.RELEASE_1 | Creating new transaction with name [null]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT 21:25:59,954 | INFO | #0 - timer://foo | TransaccionXa | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | empezando la de transacciones XA 21:25:59,954 | INFO | #0 - timer://foo | TransaccionXa | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | grabando en 2. 21:25:59,955 | DEBUG | #0 - timer://foo | SendProcessor | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | >>>> Endpoint[direct://insert1] Exchange[Message: [Body is null]] 21:25:59,956 | DEBUG | #0 - timer://foo | SendProcessor | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | >>>> Endpoint[sql://INSERT%20INTO%20xyz2%20(name,amount)%20VALUES%20('%20TX-XA%202%20con%20Spring',555)?dataSource=2XADataSource] Exchange[Message: [Body is null]] 21:25:59,957 | DEBUG | #0 - timer://foo | JdbcTemplate | 254 - org.apache.servicemix.bundles.spring-jdbc - 3.2.8.RELEASE_1 | Executing prepared SQL statement [INSERT INTO xyz2 (name,amount) VALUES ('TX-XA2con Spring',555)] 21:25:59,959 | DEBUG | #0 - timer://foo | DataSourceUtils | 254 - org.apache.servicemix.bundles.spring-jdbc - 3.2.8.RELEASE_1 | Fetching JDBC Connection from DataSource 21:26:00,000 | DEBUG | #0 - timer://foo | DataSourceUtils | 254 - org.apache.servicemix.bundles.spring-jdbc - 3.2.8.RELEASE_1 | Registering transaction synchronization for JDBC Connection 21:26:00,025 | INFO | #0 - timer://foo | TransaccionXa | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | x en 1.. 21:26:00,026 | DEBUG | #0 - timer://foo | SendProcessor | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | >>>> Endpoint[direct://insert1] Exchange[Message: [Body is null]] 21:26:00,026 | DEBUG | #0 - timer://foo | SendProcessor | 142 - org.apache.camel.camel-core - 2.12.0.redhat-610379 | >>>> Endpoint[sql://INSERT%20INTO%20xyz%20(name,amount)%20VALUES%20('%20TX-XA%20GPS%20con%20Spring',2015)?dataSource=XADataSource1] Exchange[Message: [Body is null]] 21:26:00,026 | DEBUG | #0 - timer://foo | JdbcTemplate | 254 - org.apache.servicemix.bundles.spring-jdbc - 3.2.8.RELEASE_1 | Executing prepared SQL statement [INSERT INTO xyz (name,amount) VALUES (' TX-XA 1 con Spring',2015)] 21:26:00,026 | DEBUG | #0 - timer://foo | DataSourceUtils | 254 - org.apache.servicemix.bundles.spring-jdbc - 3.2.8.RELEASE_1 | Fetching JDBC Connection from DataSource 21:26:00,622 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint started. 21:26:00,625 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint done. 21:26:05,625 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint started. 21:26:05,628 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint done. 21:26:10,629 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint started. 21:26:10,632 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint done. 21:26:15,632 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint started. 21:26:15,635 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint done. 21:26:20,637 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint started. 21:26:20,640 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint done. 21:26:25,640 | DEBUG | heckpoint Worker | MessageDatabase | 131 - org.apache.activemq.activemq-osgi - 5.9.0.redhat-610379 | Checkpoint started

Environment

  • Red Hat JBoss Fuse
    • 6.1.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content