How to set up Spring Boot + Bitronix + non-XA Datasource + XA JMS Connection

Question

I'm trying to set-up Bitronix in Spring Boot to use last resource gambit with non-XA datasource. Of course by default (autoconfiguration) data source does not participate in XA transaction. It seems that org.springframework.boot.jta.XADataSourceWrapper will work only for XADataSource.

How to connect DataSource with Bitronix?

score 2 · Accepted Answer · answered Jan 22 '16 at 16:03

2

Bitronix uses its LrcXADataSource to implement the last resource gambit. You need to tell Spring Boot to create an XAResource of that type:

spring.datasource.xa.data-source-class-name=bitronix.tm.resource.jdbc.lrc.LrcXADataSource

You'll also need to set some other properties that will depend on the database you're using and how it's configured. For example, the name of the JDBC driver class:

spring.datasource.xa.properties.driver-class-name=org.hsqldb.jdbcDriver

answered Jan 22 '16 at 16:03

Andy Wilkinson

108,729
24
257
242

1

And then `org.springframework.boot.jta.XADataSourceWrapper` will wrap it up with Bitronix's connection pool `org.springframework.boot.jta.bitronix.PoolingDataSourceBean`, right? – Piotr Gwiazda Jan 23 '16 at 09:11
But what happens if I have 2 Non-XA Datasources? – Carlos Alberto Feb 11 '16 at 20:28
@ElLordCode The last resource gambit only works with a single non-XA DataSource – Andy Wilkinson Feb 11 '16 at 20:45
Is there any solution if need more than one Non-XA Datasources in my Bitronix server? – Carlos Alberto Feb 11 '16 at 20:47

How to set up Spring Boot + Bitronix + non-XA Datasource + XA JMS Connection

1 Answers1

Linked