Randy Layman [
https://community.jboss.org/people/randy.layman] created the discussion
"JBoss 7 Without XA Data Sources"
To view the discussion, visit:
https://community.jboss.org/message/758435#758435
--------------------------------------------------------------
I am porting our application from JBoss 4 to JBoss 7 and have run into a snag. For a few
very specific use cases we use two data sources within the same JTA transaction context
(manged via Spring's TransactionProxyFactoryBean). We want transactions on one data
source to not impact the other. In JBoss 4 we accomplished this by not using XA Data
Sources. This seems to have caused JTA to commit one transaction after the other
independently. For all other use cases, we use a single Data Source and therefore
don't need XA functionality.
In moving to JBoss 7, I initially configured the same way -- non-XA data sources. However
when the second data source was first referenced I got a an error message that meant you
can't have two non-XA data sources in the same transaction. Configuring with XA data
sources does allow the application to function, but now the two transactions are married
together.
Is there anyway to configure JBoss 7 to not use XA transactions in JTA managed
transactions?
For the curious, here is our main use case: In the course of fulfilling an order from
customers we charge their credit card and we configure their newly purchased service. We
never, ever, want the bank to have a record of a credit card transaction that we
don't. So we have a seperate database (and thus data source) for the credit card
transactions. And we want those transactions to always commit, regardless of any issues
we might have configuring their service that causes a rollback.
If it is relevant we are using JBoss 7.1.1-Final connecting to Postgres 8 (with the
Postgres 9 database driver) running on JDK 1.6.
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/758435#758435]
Start a new discussion in Datasource Configuration at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]