查询oracle是否开启xa,XA模式，Oracle数据源，多个服务不能操作同一数据库？

最新推荐文章于 2021-11-12 16:43:44 发布

weixin_39632327

最新推荐文章于 2021-11-12 16:43:44 发布

阅读量958

点赞数

文章标签：查询oracle是否开启xa

这篇博客记录了一次Seata在整合Oracle数据库时遇到的全局事务ID异常，具体表现为Spring Transaction创建交易失败，原因在于尝试连接分布式事务资源时发生资源管理器错误。文中详细分析了异常堆栈，包括SQLException和Oracle错误码，以及Seata RM（Resource Manager）处理过程。

摘要由CSDN通过智能技术生成

same problem

全局事务id ：192.168.202.58:8091:69346279655972864

2020-11-10 08:37:21.480 ERROR 20012 --- [:20881-thread-8] o.a.dubbo.rpc.filter.ExceptionFilter : [DUBBO] Got unchecked and undeclared exception which called by 192.168.202.58. service: io.seata.samples.integration.common.dubbo.OrderDubboService, method: createOrder, exception: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: failed to start xa branch 192.168.202.58:8091:69346279655972864 since XAErr (-3): A resource manager error has occured in the transaction branch. ORA-2079 SQLErr (0), dubbo version: 2.7.7, current host: 192.168.202.58

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: failed to start xa branch 192.168.202.58:8091:69346279655972864 since XAErr (-3): A resource manager error has occured in the transaction branch. ORA-2079 SQLErr (0)

at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305) ~[spring-jdbc-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) ~[spring-tx-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:574) ~[spring-tx-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:361) ~[spring-tx-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) ~[spring-tx-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.8.RELEASE.jar:5.2.8.RELEASE]

at io.seata.samples.integration.order.service.TOrderServiceImpl$$EnhancerBySpringCGLIB$$483b7dbd.createOrder() ~[classes/:na]

at io.seata.samples.integration.order.dubbo.OrderDubboServiceImpl.createOrder(OrderDubboServiceImpl.java:27) ~[classes/:na]

at org.apache.dubbo.common.bytecode.Wrapper2.invokeMethod(Wrapper2.java) ~[dubbo-2.7.7.jar:2.7.7]

at org.apache.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47) ~[dubbo-2.7.7.jar:2.7.7]

at org.apache.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:84) ~[dubbo-2.7.7.jar:2.7.7]

at org.apache.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:56) ~[dubbo-2.7.7.jar:2.7.7]

at org.apache.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:56) ~[dubbo-2.7.7.jar:2.7.7]

at com.alibaba.dubbo.rpc.Invoker$CompatibleInvoker.invoke(Invoker.java:55) ~[dubbo-2.7.7.jar:2.7.7]

at io.seata.integration.dubbo.alibaba.AlibabaDubboTransactionPropagationFilter.invoke(AlibabaDubboTransactionPropagationFilter.java:45) ~[seata-all-1.3.0.jar:1.3.0]

at com.alibaba.dubbo.rpc.Filter.invoke(Filter.java:29) ~[dubbo-2.7.7.jar:2.7.7]