XA Aries Transactions in Jbosss Fuse with two databases
Issue
XA Aries Transactions
dont insert when it try to twoDatabase
- 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.