cannot enlist more than one non-XA resource

最新推荐文章于 2024-02-29 20:32:43 发布

kyq叶鑫

最新推荐文章于 2024-02-29 20:32:43 发布

阅读量787

点赞数

分类专栏： java java代码多数据源事务与建表文章标签： java java代码多数据源事务与建表

本文链接：https://blog.youkuaiyun.com/kyq_1024yahoocn/article/details/54427537

版权

java 同时被 3 个专栏收录

8 篇文章

订阅专栏

java代码

4 篇文章

订阅专栏

多数据源事务与建表

1 篇文章

订阅专栏

本文针对使用多种方式操作多个数据源时出现的错误进行了解析，并提供了具体的解决方案。错误表现为无法注册超过一个非-XA资源的问题，通过调整数据源配置及采用特定的驱动来解决。

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

错误场景：多个数据源三种操作方式并存。

（1）关闭事务，使用jdbc执行建表语句

def.setPropagationBehavior(TransactionDefinition.PROPAGATION_NOT_SUPPORTED);

（2）（3）又使用了hibernate在不同sessionFacory之间切换执行sql。

错误代码：cannot enlist more than one non-XA resource, tried enlisting an XAResourceHolderState with uniqueName=dataSourceSCDP XAResource=a JDBC LrcXAResource in state NO_TX with XID null, already enlisted: an XAResourceHolderState with uniqueName=dataSource.1 XAResource=a JDBC LrcXAResource in state STARTED (started) with XID a Bitronix XID [3139322E3136382E35362E31000000000A6647B900000039 : 3139322E3136382E35362E31000000000A6647FE0000003A]

解决方案：

数据源的Driver使用 com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.

同时附上datasouce配置：

<bean id="dataSource" class="bitronix.tm.resource.jdbc.PoolingDataSource" init-method="init"
      destroy-method="close">
    <property name="className" value="${jdbc.driver}"/>
    <property name="uniqueName" value="dataSource"/>
    <!--the minimal amount of connections that can be in the pool.-->
    <property name="minPoolSize" value="${jdbc.minPoolSize}"/>
    <!--the maximum amount of connections that can be in the pool.-->
    <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/>
    <!--the amount of seconds and idle connection can stay in the pool before getting closed.-->
    <property name="maxIdleTime" value="300"/>
    <!--the amount of connections to be created at once when the pool needs to grow.-->
    <property name="acquireIncrement" value="2"/>
    <!--the amount of time between failed connection acquirements.-->
    <property name="acquisitionInterval" value="1"/>
    <!--the amount of time in seconds a call to get a connection from the pool will wait when the pool is empty.-->
    <property name="acquisitionTimeout" value="2"/>
    <!--false only if the database can run many transactions on the same connection.-->
    <property name="deferConnectionRelease" value="true"/>
    <!--true if the transaction manager should allow mixing XA and non-XA transactions.-->
    <property name="allowLocalTransactions" value="true"/>
    <property name="applyTransactionTimeout" value="true"/>
    <!--Set whether connections in the ACCESSIBLE state can be shared within the context of a transaction.-->
    <property name="shareTransactionConnections" value="true"/>
    <property name="driverProperties">
        <props>
            <prop key="url">${jdbc.url}</prop>
            <prop key="user">${jdbc.username}</prop>
            <prop key="password">${jdbc.password}</prop>
        </props>
    </property>
    <property name="testQuery" value="SELECT 1"/>
</bean>