When to configure an XA datasource?

最新推荐文章于 2021-04-11 17:09:11 发布

iteye_9496

最新推荐文章于 2021-04-11 17:09:11 发布

阅读量190

点赞数

分类专栏： JBoss JEE Oracle 文章标签： jboss oracle xa-datasource

JEE 同时被 3 个专栏收录

40 篇文章

订阅专栏

Oracle

8 篇文章

订阅专栏

JBoss

5 篇文章

订阅专栏

本文介绍了解决JBoss中因使用本地事务而导致警告的方法。针对拥有多个数据源且事务跨越多个数据源的情况，需要配置X-A数据源来避免数据不一致的问题。此外，还提到了javax.transaction.UserTransaction API的正确配置对于JBoss事务管理的重要性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

If you ever came across this warning message from JBoss, you might wonder what's wrong:

[b]WARN [TxConnectionManager] Prepare called on a local tx. Use of local transactions on a jta transaction with more than one branch may result in inconsistent data in some cases of failure.[/b]

It's relevant to JBoss Transaction Management Service for multiple datasources. That is, you have multiple datasources configured and your transactions span multiple data sources. In this case, you need to configure them as XA datasources so that JBoss would not complain.

This is often the case when using Oracle, as you can have multiple users/schema in one database. My test showed this is when XA datasources should be configured.

For instance, we can have two users "BILLING" and "LOG" in one Oracle database. We need to configure two datasources for each of them. If transactions span across these two users, we need to configure xa-datasources:


<xa-datasource>
		<jndi-name>BILLINGDS_XA</jndi-name>
		<track-connection-by-tx>true</track-connection-by-tx>
		<isSameRM-override-value>false</isSameRM-override-value>
		<managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.oracle.XAOracle ManagedConnectionFactory</managedconnectionfactory-class>
		<transaction-isolation></transaction-isolation>
		<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
		<xa-datasource-property name="URL">jdbc:oracle:thin:@dbserverIP:1521:SID</xa-datasource-property>
		<xa-datasource-property name="User">BILLING</xa-datasource-property>
		<xa-datasource-property name="Password">passwordOfBILLING</xa-datasource-property>
		<min-pool-size>5</min-pool-size>
	  <max-pool-size>10</max-pool-size>
		<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.Oracle ExceptionSorter</exception-sorter-class-name>

	  <mbean code="org.jboss.resource.adapter.jdbc.xa.oracle.Or acleXAExceptionFormatter" name="jboss.jca:service=OracleXAExceptionFormatter">
	    <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
  	</mbean>
  </xa-datasource>

<xa-datasource>
		<jndi-name>LOGDS_XA</jndi-name>
		<track-connection-by-tx>true</track-connection-by-tx>
		<isSameRM-override-value>false</isSameRM-override-value>
		<managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.oracle.XAOracle ManagedConnectionFactory</managedconnectionfactory-class>
		<transaction-isolation></transaction-isolation>
		<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
		<xa-datasource-property name="URL">jdbc:oracle:thin:@dbserverIP:1521:SID</xa-datasource-property>
		<xa-datasource-property name="User">LOG</xa-datasource-property>
		<xa-datasource-property name="Password">passwdOfLOG</xa-datasource-property>
		<min-pool-size>5</min-pool-size>
	  <max-pool-size>10</max-pool-size>
		<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.Oracle ExceptionSorter</exception-sorter-class-name>

	  <mbean code="org.jboss.resource.adapter.jdbc.xa.oracle.Or acleXAExceptionFormatter" name="jboss.jca:service=OracleXAExceptionFormatter">
	    <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
  	</mbean>
  </xa-datasource>

Another point is that [b]javax.transaction.UserTransactiion[/b] is the JTA api for explicit management of transaction boundaries. This api cannot work properly without JBoss transaction management service turned on. That is, it only works with local-tx-datasource and xa-datasource configurations, not no-tx-datasource. Since it's part of the container's (JBoss for example) Transaction Management Service.