XA Aries Transactions in Jbosss Fuse with two databases
Issue
XA Aries Transactionsdont insert when it try to twoDatabase- The
aries XA transactionIt 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
