Copy Page

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account. You can also Sign Up for a new account.

<h1>JMS servers XA support evaluation</h1>

<p>Those are the information collected while testing BTM against some JMS servers. Also included:</p>

<ul>
	<li>An overall evaluation of the database's XA support</li>
	<li>Special features and/or limitations</li>
</ul>

<table class="wysiwyg-macro" data-macro-name="info" data-macro-parameters="title=XA only" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm86dGl0bGU9WEEgb25seX0&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p>JMS servers not providing an implementation of <code>javax.jms.XAConnectionFactory</code> have not been included.</p></td></tr></table>

<p>If you find mistakes, inconsistencies or simply want some other database to be tested (as long as there is at least a free trial version available) just let us know via the <a class="confluence-link" href="/display/BTM/Support" data-linked-resource-id="9240673" data-linked-resource-type="page" data-linked-resource-default-alias="Support" data-base-url="http://docs.codehaus.org">mailing list</a> and we'll consider your request.</p>

<h4>Contents</h4>
<img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvYzptYXhMZXZlbD0yfG1pbkxldmVsPTJ9&amp;locale=en_GB&amp;version=2" data-macro-name="toc" data-macro-parameters="maxLevel=2|minLevel=2">

<h2>ActiveMQ</h2>
<h3>Supported version(s)</h3>
<p>Tested against versions 4.2 and 5.1. All 4.x version prior to 4.1.1 are broken regarding recovery and cannot be used.</p>

<h3>Settings</h3>
<p>Local transactions cannot be mixed well with global transactions thus you should not enable <code>allowLocalTransactions</code> or ActiveMQ will throw an exception.</p>

<h3>Heuristics</h3>
<p>I could not find how to list in-doubt transactions nor how to manually terminate them.</p>

<h2>SwiftMQ</h2>
<h3>Supported version(s)</h3>
<p>Tested against versions 6.2 but works fine with more recent versions too. You need the JMS XA/ASF Swiftlet extension to be able to use XA transactions.</p>

<h3>Settings</h3>
<p>All default settings are fine.</p>

<h3>Heuristics</h3>
<p>The console can be used to list in-doubt transactions and to heuristically terminate and forget them.</p>

<h3>Example ResourceLoader configuration</h3>
<table class="wysiwyg-macro" data-macro-name="code" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGV9&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
resource.ds.className=bitronix.tm.resource.jms.JndiXAConnectionFactory
resource.ds.uniqueName=smq
resource.ds.maxPoolSize=5
resource.ds.driverProperties.initialContextFactory=com.swiftmq.jndi.InitialContextFactoryImpl
resource.ds.driverProperties.providerUrl=smqp://localhost:4001/timeout=10000
resource.ds.driverProperties.name=QueueConnectionFactory
</pre></td></tr></table>

<h2>HornetQ</h2>
<h3>Supported version(s)</h3>
<p>Tested against versions 2.0.0.BETA5. The JndiXAConnectionFactory included in BTM 1.3.2 and lower is too limited, you need BTM 1.3.3 or higher to use HornetQ.</p>

<h3>Settings</h3>
<p>All default settings are fine.</p>

<h3>Heuristics</h3>
<p>A JMX console (like the JDK jconsole tool) can be used to list in-doubt transactions and to heuristically terminate them. Just have a look at the org.hornetq/Server/Core JMX object which contains 3 interesting operations: listPreparedTransactions, commitPreparedTransaction, rollbackPreparedTransaction.</p>

<p>Still under investigation.</p>

<h3>Example ResourceLoader configuration</h3>
<table class="wysiwyg-macro" data-macro-name="code" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGV9&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
resource.ds.className=bitronix.tm.resource.jms.JndiXAConnectionFactory
resource.ds.uniqueName=hornet
resource.ds.maxPoolSize=5
resource.ds.driverProperties.initialContextFactory=org.jnp.interfaces.NamingContextFactory
resource.ds.driverProperties.providerUrl=jnp://localhost:1099
resource.ds.driverProperties.extraJndiProperties.java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces
resource.ds.driverProperties.name=XAConnectionFactory
</pre></td></tr></table>

<h2>SonicMQ (Progress Software)</h2>
<h3>Supported version(s)</h3>
<p>Tested against versions 7.6. The JndiXAConnectionFactory included in BTM 1.3.2 and lower is too limited (extraJndiProperties), you need BTM 1.3.3 or higher to use SonicMQ. Seems to support local transactions.</p>

<h3>Settings</h3>
<p>All default settings are fine.</p>

<h3>Heuristics</h3>
<p>Still under investigation.</p>

<h3>Example ResourceLoader configuration</h3>
<table class="wysiwyg-macro" data-macro-name="code" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGV9&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
resource.cf.className=bitronix.tm.resource.jms.JndiXAConnectionFactory
resource.cf.uniqueName=sonicmq
resource.cf.maxPoolSize=5
resource.cf.driverProperties.initialContextFactory=com.sonicsw.jndi.mfcontext.MFContextFactory
resource.cf.driverProperties.providerUrl=tcp://localhost:2506
resource.cf.driverProperties.securityPrincipal=username
resource.cf.driverProperties.securityCredentials=password
resource.cf.driverProperties.name=xaConnectionFactory
resource.cf.driverProperties.extraJndiProperties.com.sonicsw.jndi.mfcontext.domain=domain
</pre></td></tr></table>

<h3>Required Jars</h3>
<p>mfcontext-7.6.jar, sonic_Client-7.6.jar (warning JMS API is included in the Jar), sonic_Crypto-7.6.jar, sonic_XA-7.6.jar, sonic_XMessage-7.6.jar</p>