<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
JBoss 7 Without XA Data Sources
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/randy.layman">Randy Layman</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/758435#758435">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Is there anyway to configure JBoss 7 to not use XA transactions in JTA managed transactions?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/758435#758435">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>