JDBC driver does not support XA, hence cannotbe a participant in two-phase commit. 解决办法

最新推荐文章于 2020-04-25 12:39:00 发布
最新推荐文章于 2020-04-25 12:39:00 发布
阅读量647 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/g154625119/article/details/9001993
版权

在让部署重新搭建weblogic 10后，系统在提交JMS消息是有发现有如下报错：

JDBC driver does not support XA, hencecannot be a participant in two-phase commit. To force this participation, setthe GlobalTransactionsProtocol attribute to LoggingLastResource (recommended)or EmulateTwoPhaseCommit for the Data Source = datasource/pass/eoa9istg/0

       at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1884)

       atweblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:376)

       at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:268)

       atweblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:623)

       at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)

       atweblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)

       atcom.paic.pafa.app.biz.action.impl.pafaTxnAction_3r4470_ELOImpl.perform(UnknownSource)

       atsun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)

       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       at java.lang.reflect.Method.invoke(Method.java:597)

       at com.paic.pafa.app.lwc.service.remoting.access.ejb.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:111)

       atcom.paic.pafa.app.lwc.service.remoting.access.ejb.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:193)

       atcom.paic.pafa.app.lwc.core.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)

       atcom.paic.pafa.app.lwc.core.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)

       at $Proxy65.perform(Unknown Source)

       at com.paic.pass.biz.async.TxnPassJob.doAction(TxnPassJob.java:29)

       at com.paic.pass.biz.async.PassJob.execute(PassJob.java:106)

       at org.quartz.core.JobRunShell.run(JobRunShell.java:203)

       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:596)

Caused by:javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannotbe a participant in two-phase commit. To force this participation, set theGlobalTransactionsProtocol attribute to LoggingLastResource (recommended) orEmulateTwoPhaseCommit for the Data Source = datasource/pass/eoa9istg/0

       atweblogic.jdbc.wrapper.JTSXAResourceImpl.prepare(JTSXAResourceImpl.java:83)

       at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:1343)

       atweblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:513)

       atweblogic.transaction.internal.ServerSCInfo.startPrepare(ServerSCInfo.java:392)

       at weblogic.transaction.internal.ServerTransactionImpl.localPrepare(ServerTransactionImpl.java:2633)

       atweblogic.transaction.internal.ServerTransactionImpl.globalPrepare(ServerTransactionImpl.java:2281)

       at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:307)

       ... 17 more

.>

javax.ejb.TransactionRolledbackLocalException:Error committing transaction:; nested exception is:javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannotbe a participant in two-phase commit. To force this participation, set theGlobalTransactionsProtocol attribute to LoggingLastResource (recommended) orEmulateTwoPhaseCommit for the Data Source = datasource/pass/eoa9istg/0

javax.transaction.xa.XAException: JDBCdriver does not support XA, hence cannot be a participant in two-phase commit.To force this participation, set the GlobalTransactionsProtocol attribute toLoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source= datasource/pass/eoa9istg/0

       atweblogic.jdbc.wrapper.JTSXAResourceImpl.prepare(JTSXAResourceImpl.java:83)

       atweblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:1343)

       atweblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:513)

       atweblogic.transaction.internal.ServerSCInfo.startPrepare(ServerSCInfo.java:392)

       at weblogic.transaction.internal.ServerTransactionImpl.localPrepare(ServerTransactionImpl.java:2633)

       atweblogic.transaction.internal.ServerTransactionImpl.globalPrepare(ServerTransactionImpl.java:2281)

       atweblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:307)

        atweblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:268)

       atweblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:623)

       at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)

       atweblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)

       atcom.paic.pafa.app.biz.action.impl.pafaTxnAction_3r4470_ELOImpl.perform(UnknownSource)

       at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)

       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       at java.lang.reflect.Method.invoke(Method.java:597)

       at com.paic.pafa.app.lwc.service.remoting.access.ejb.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:111)

       atcom.paic.pafa.app.lwc.service.remoting.access.ejb.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:193)

       atcom.paic.pafa.app.lwc.core.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)

       atcom.paic.pafa.app.lwc.core.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)

       at $Proxy65.perform(Unknown Source)

       at com.paic.pass.biz.async.TxnPassJob.doAction(TxnPassJob.java:29)

       at com.paic.pass.biz.async.PassJob.execute(PassJob.java:106)

       at org.quartz.core.JobRunShell.run(JobRunShell.java:203)

       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:596)

javax.ejb.TransactionRolledbackLocalException:Error committing transaction:; nested exception is:javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannotbe a participant in two-phase commit. To force this participation, set theGlobalTransactionsProtocol attribute to LoggingLastResource (recommended) orEmulateTwoPhaseCommit for the Data Source = datasource/pass/eoa9istg/0

       at weblogic.ejb.container.internal.EJBRuntimeUtils.throwTransactionRolledbackLocal(EJBRuntimeUtils.java:240)

       atweblogic.ejb.container.internal.EJBRuntimeUtils.throwEJBException(EJBRuntimeUtils.java:138)

       atweblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:650)

       atweblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)

       atweblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)

       atcom.paic.pafa.app.biz.action.impl.pafaTxnAction_3r4470_ELOImpl.perform(UnknownSource)

       at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)

       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       at java.lang.reflect.Method.invoke(Method.java:597)

       atcom.paic.pafa.app.lwc.service.remoting.access.ejb.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:111)

       at com.paic.pafa.app.lwc.service.remoting.access.ejb.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:193)

       atcom.paic.pafa.app.lwc.core.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)

       at com.paic.pafa.app.lwc.core.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)

       at $Proxy65.perform(Unknown Source)

       at com.paic.pass.biz.async.TxnPassJob.doAction(TxnPassJob.java:28)

       at com.paic.pass.biz.async.PassJob.execute(PassJob.java:104)

        atorg.quartz.core.JobRunShell.run(JobRunShell.java:202)

       atorg.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:596)

Caused by:javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannotbe a participant in two-phase commit. To force this participation, set theGlobalTransactionsProtocol attribute to LoggingLastResource (recommended) orEmulateTwoPhaseCommit for the Data Source = datasource/pass/eoa9istg/0

       at weblogic.jdbc.wrapper.JTSXAResourceImpl.prepare(JTSXAResourceImpl.java:83)

       atweblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:1343)

       atweblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:513)

       at weblogic.transaction.internal.ServerSCInfo.startPrepare(ServerSCInfo.java:392)

       atweblogic.transaction.internal.ServerTransactionImpl.localPrepare(ServerTransactionImpl.java:2633)

       at weblogic.transaction.internal.ServerTransactionImpl.globalPrepare(ServerTransactionImpl.java:2281)

       atweblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:307)

       atweblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:268)

       atweblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:623)

       atweblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)

       at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)

       atcom.paic.pafa.app.biz.action.impl.pafaTxnAction_3r4470_ELOImpl.perform(UnknownSource)

       at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       at java.lang.reflect.Method.invoke(Method.java:597)

       atcom.paic.pafa.app.lwc.service.remoting.access.ejb.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:111)

       atcom.paic.pafa.app.lwc.service.remoting.access.ejb.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:193)

       atcom.paic.pafa.app.lwc.core.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)

       atcom.paic.pafa.app.lwc.core.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)

       at $Proxy65.perform(Unknown Source)

       at com.paic.pass.biz.async.TxnPassJob.doAction(TxnPassJob.java:29)

       at com.paic.pass.biz.async.PassJob.execute(PassJob.java:106)

       at org.quartz.core.JobRunShell.run(JobRunShell.java:203)

       ... 1 more

2013-05-27 09:51:13.075 [ERROR] Errorcommitting transaction:; nested exception is: javax.transaction.xa.XAException:JDBC driver does not support XA, hence cannot be a participant in two-phasecommit. To force this participation, set the GlobalTransactionsProtocolattribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for theData Source = datasource/pass/eoa9istg/0

2013-05-27 09:51:13.076 [ERROR]com.paic.pass.biz.async.PassJob:execute,PassJob.java:115

2013-05-27 09:51:13.076 [ERROR]org.quartz.core.JobRunShell:run,JobRunShell.java:202

2013-05-27 09:51:13.076 [ERROR]org.quartz.simpl.SimpleThreadPool$WorkerThread:run,SimpleThreadPool.java:596

2013-05-27 09:51:13.076 [ERROR] ...

2013-05-27 09:51:13.076 [DEBUG] job over!2013-05-27 09:51:13 > DefaultQuartzScheduler_Worker-13

 

2013-05-27 09:51:18.002 [DEBUG] threadName:Pooled Threads:DefaultQuartzScheduler_Worker-15

2013-05-27 09:51:18.002 [DEBUG]oas-csms10SF4543isRunJobFlag

2013-05-27 09:51:18.002 [DEBUG]oas-csms10SF4543isRunJobFlag

2013-05-27 09:51:18.002 [DEBUG] actionName= dispenseRequestAction,isRunJobFlag= oas-csms10SF4543 服务器运行

2013-05-27 09:51:18.003 [DEBUG] 进入com.paic.pass.biz.async.DispenseRequestJob

2013-05-27 09:51:18.003 [DEBUG]com.paic.pass.biz.async.DispenseRequestJob job time begin.



 后来经过分析发现是JMS 连接工厂配置有问题，取消勾选 “已启用 XA 连接工厂” 后问题解决。


码头123
关注
Ivan Sutherland _ Sketchpad - UCAM-CL-TR-574.pdf
03-22
the program in use, and a widely-cited conference publication [10]. Copies of the dissertation were distributed relatively widely, but it was never published commercially. It is still available in ...
JDBC driver does not support XA, hence cannot be a participant in two-phase
weihongchao的专栏
10-11 1634
weblogic配置数据库连接池及连接后发布应用，登录应用后，控制台报错： -------------------------------------------------------------------------------- nested within: ---------------------------------------------------------------...
Endeca Install Problem ‘JDBC driver does not support XA, hence cannot be a participant in to-phase c
Love is smiling
06-06 3240
If like me you’ve downloaded Endeca 3.1 and want to try all the extra goodies that have been added. One of the first things I wanted to do was try out the Provisioning service and get Endeca to
Weblogic Xa数据源和非Xa数据源的选择
m0_37740977的博客
02-05 3688
背景：在项目上，不管是ADF应用，BPM应用，或者是OSB、SOA接口，数据源和出站连接池的建立必然少不了，而数据源的类型就有Xa数据源和非Xa数据源，那我们如何选择呢，选择不当会造成什么后果呢，下面给出一点小小的心得如何选择：在新建数据源的时候，经常面临是建立Xa数据源还是非Xa数据源，这块有一个选择标准,如果数据库后台package的函数或者过程需要commit或者rollback,那么调用这...
JTA经典问答.
wonder的地下室
02-10 2913
JTA经典问答   先转过来,有空再翻译. 提
JTA经典问答（初译版）收藏
土豆的专栏
07-03 1619
转载自：http://blog.csdn.net/wonder4/archive/2006/02/16/599995.aspx/*这篇JTA问答问题都很经典，回答也十分言简意赅。通过问答将XA driver与non-XA driver在分布式事务中的使用注意事项讲述的很清楚，解决了我原先的一些困惑。现把原文贴出来，希望对大家有所助益。*/1.        Can I use a non-XA
On-Manifold Preintegration for Real-Time Visual-Inertial Odometry.pdf
04-06
and a-posteriori bias correction in analytic form. The second contribution is to show that the preintegrated IMU model can be seamlessly integrated into a visual-inertial pipeline under the unifying...
qtbrowserplugin-2.4_1-opensource.tar.gz
03-02
This module can not function if built as a DLL, it must be statically linked with the plugin. Hence, DLL building is not supported, and the -library option to configure will be ignored. For the ...
apache-tomcat-9.0.17.rar
03-13
It is a process whereby objects define their dependencies, that is, the other objects they work with, only through constructor arguments, arguments to a factory method, or properties that are set on ...
two-phase commit
JavaMan_chen的专栏
08-10 3013
Two-phase commit(二段事务提交)是解决分布式事务的一种有效方式，当数据库由于数据量较大而进行垂直拆分时，需要引入分布式事务来确保数组整体的一致性和完整性 顾名思义，事务的提交分成两个阶段：准备阶段和提交阶段 1.准备阶段(Prepare Phase) 准备阶段Slave所做事情 1.从Master获取写操作请求并在本地执行，同时将执行记录写入redo日志文件，便于出错后
jdbc连接Mysql数据库时常见错误及解决方法
LISTENING9的博客
04-25 1392
1、Mysql客户端连接失败--》查看服务端是否开启； 2、java程序报错：没找到合适的驱动--》先看数据库对应的驱动对不对（注意后面不能+.class）； eg: 3、字符串格式不对（Unknown initial character set index '255' received from server. Initial client character set can be for...
两阶段提交（Two-Phase Commit）
qq_33339479的博客
10-22 6442
两阶段提交 两阶段提交是一种同步协议，是计算机网络尤其是在数据库领域内，为了使基于分布式系统架构下的所有节点在进行事务处理过程中保持原子性和一致性而设计的一种算法。 两阶段提交的执行过程 在两阶段提交过程中，主要分为了两种角色协调者（coordinator）和参与者（participants），协调者主要就是起到协调参与者是否需要提交事务或者中止事务，参与者主要就是接受协调者的响应并回复协调者是否...
Java事务处理总结
zhongxiangbo的博客
04-28 8115
一、什么是Java事务 事务必须服从ISO/IEC所制定的ACID原则。ACID是原子性（atomicity）、一致性（consistency）、隔离性（isolation）和持久性（durability）的缩写。事务的原子性表示事务执行过程中的任何失败都将导致事务所做的任何修改失效。一致性表示当事务执行失败时，所有被该事务影响的数据都应该恢复到事务执行前的状态。隔离性表示在事务执行过程中对数据
Two-phase commit
miller_lover的专栏
10-11 754
concept In transaction processing, databases, and computer networking, the two-phase commit protocol (2PC) is a type of atomic commitment protocol (ACP). It is a distributed algorithm that coordinate
ORACLE EBS常用表及查询语句（最终整理版） .
03-19 2985
参考一：                                                              call fnd_global.APPS_INITIALIZE(1318,50583,401) select fnd_profile.VALUE('ORG_ID') FROM DUAL select * from hr_operating
EMERGENCY! EUREKA MAY BE INCORRECTLY CLAIMING INSTANCES ARE UP WHEN THEY'RE NOT. RENEWALS ARE LESSER THAN THRESHOLD AND HENCE THE INSTANCES ARE NOT BEING EXPIRED JUST TO BE SAFE.解决方法
最新发布
06-06
针对这个紧急情况，需要进行以下几个步骤： 1. 确认Eureka服务的可用性和稳定性，以确保它...4. 如果以上措施无法解决问题，则需要进一步分析系统日志和调试信息，以找出问题的根本原因，并采取针对性的措施解决问题。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值