weblogic中XAER_RMERR和XAER_NOTA问题

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

背景：业务在提交批量操作时，由于数量操作过大，导致页面提示以下错误，操作少量的时候可以通过驳回，一旦过大 驳回就失败了

**Cause: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'EFMPDB_qdp_ebk_domain': XAER_RMERR : A resource manager error has occured in the transaction branch
weblogic.transaction.internal.ResourceAccessException: Transaction has timed out when making request to XAResource 'EFMPDB_qdp_ebk_domain'.at** weblogic.transaction.internal.XAResourceDescriptor.startResourceUse(XAResourceDescriptor.java:670) at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1246)	at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1180)	at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:300)
	at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:561)
	at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:488)
	at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1673)
	at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1577)
	at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478)
	at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:512)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:106)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	at com.sun.proxy.$Proxy71.prepareStatement(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	at com.sun.proxy.$Proxy72.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
	at com.longtop.efmp.plm.cor.bas.dao.ibatis.LimitSqlExecutor.executeQuery(Unknown Source)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.doQueryIbatis(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.query(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.queryOne(Unknown Source)
	at com.longtop.efmp.ebk.bgt.bs.impl.EbkBgtBSImpl.findBgtItemByItemNo(EbkBgtBSImpl.java:162)
	at com.longtop.efmp.ebk.bgt.bs.impl.EbkBgtBSImpl.releaseOccupyBudget(EbkBgtBSImpl.java:1201)
	at sun.reflect.GeneratedMethodAccessor628.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy84.releaseOccupyBudget(Unknown Source)
	at com.longtop.efmp.ebk.set.bs.impl.EbkSetBSImpl.releaseOccupyBudget(EbkSetBSImpl.java:98)
	at sun.reflect.GeneratedMethodAccessor627.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy85.releaseOccupyBudget(Unknown Source)
	at com.longtop.efmp.ebk.set.service.tx.SET01023000TService.handle06(SET01023000TService.java:82)
	at com.longtop.efmp.plm.cor.bas.bus.service.tx.AbsPlmMultiTService.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.service.template.ReleaseTplService.work06(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.service.template.a.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasServiceDispatcherImpl.doServcie(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasServiceDispatcherImpl.txReqRun(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)at com.sun.proxy.$Proxy62.txReqRun(Unknown Source)at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasControlImpl.doService(Unknown Source) at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasControlImpl.execute(Unknown Source) at com.longtop.efmp.plm.cor.bas.web.action.AbsAction.runService(Unknown Source)
	at com.longtop.efmp.ebk.set.web.action.SET01023000RELEASEAction.handle06(SET01023000RELEASEAction.java:165)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsReleaseAction.work06(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.longtop.intelliweb.util.Misc.invokeMethod(Unknown Source)
	at com.longtop.intelliweb.action.AbstractBaseAction.dispatch(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsAction.dispatch(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.longtop.intelliweb.util.Misc.invokeMethod(Unknown Source)
	at com.longtop.intelliweb.dataengine.b.do(Unknown Source)
	at com.longtop.intelliweb.dataengine.DataEngineServlet.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at com.longtop.intelliweb.common.SetCharacterEncodingFilter.doFilter(Unknown Source)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:86)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: weblogic.transaction.internal.TimedOutException: Transaction has timed out when making request to XAResource 'EFMPDB_qdp_ebk_domain'.
	at weblogic.transaction.internal.XAResourceDescriptor.startResourceUse(XAResourceDescriptor.java:673)
	... 120 more

	at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1678)
	at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1577)
	at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478)
	at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:512)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:106)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	at com.sun.proxy.$Proxy71.prepareStatement(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	at com.sun.proxy.$Proxy72.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
	at com.longtop.efmp.plm.cor.bas.dao.ibatis.LimitSqlExecutor.executeQuery(Unknown Source)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.doQueryIbatis(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.query(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.queryOne(Unknown Source)
	at com.longtop.efmp.ebk.bgt.bs.impl.EbkBgtBSImpl.findBgtItemByItemNo(EbkBgtBSImpl.java:162)
	at com.longtop.efmp.ebk.bgt.bs.impl.EbkBgtBSImpl.releaseOccupyBudget(EbkBgtBSImpl.java:1201)
	at sun.reflect.GeneratedMethodAccessor628.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy84.releaseOccupyBudget(Unknown Source)
	at com.longtop.efmp.ebk.set.bs.impl.EbkSetBSImpl.releaseOccupyBudget(EbkSetBSImpl.java:98)
	at sun.reflect.GeneratedMethodAccessor627.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy85.releaseOccupyBudget(Unknown Source)
	at com.longtop.efmp.ebk.set.service.tx.SET01023000TService.handle06(SET01023000TService.java:82)
	at com.longtop.efmp.plm.cor.bas.bus.service.tx.AbsPlmMultiTService.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.service.template.ReleaseTplService.work06(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.service.template.a.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasServiceDispatcherImpl.doServcie(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasServiceDispatcherImpl.txReqRun(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy62.txReqRun(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasControlImpl.doService(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasControlImpl.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsAction.runService(Unknown Source)
	at com.longtop.efmp.ebk.set.web.action.SET01023000RELEASEAction.handle06(SET01023000RELEASEAction.java:165)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsReleaseAction.work06(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.longtop.intelliweb.util.Misc.invokeMethod(Unknown Source)
	at com.longtop.intelliweb.action.AbstractBaseAction.dispatch(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsAction.dispatch(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.longtop.intelliweb.util.Misc.invokeMethod(Unknown Source)
	at com.longtop.intelliweb.dataengine.b.do(Unknown Source)
	at com.longtop.intelliweb.dataengine.DataEngineServlet.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at com.longtop.intelliweb.common.SetCharacterEncodingFilter.doFilter(Unknown Source)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:86)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

或者提示以下这种：
**

**Cause: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'EFMPDB_qdp_ebk_domain': XAER_NOTA : The XID is not valid
oracle.jdbc.xa.OracleXAException
	at** oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
	at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
	at weblogic.jdbc.jta.DataSource.start(DataSource.java:790)
	at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1247)
	at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1180)
	at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:300)
	at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:561)
	at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:488)
	at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1673)
	at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1577)
	at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478)
	at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:512)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:106)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	at com.sun.proxy.$Proxy71.prepareStatement(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor276.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	at com.sun.proxy.$Proxy72.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
	at com.longtop.efmp.plm.cor.bas.dao.ibatis.LimitSqlExecutor.executeQuery(Unknown Source)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.doQueryIbatis(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.query(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.dao.impl.PlmBasDAOImpl.queryOne(Unknown Source)
	at com.longtop.efmp.ebk.bgt.bs.impl.EbkBgtBSImpl.findBgtItemByItemNo(EbkBgtBSImpl.java:162)
	at com.longtop.efmp.ebk.bgt.bs.impl.EbkBgtBSImpl.releaseOccupyBudget(EbkBgtBSImpl.java:1201)
	at sun.reflect.GeneratedMethodAccessor931.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy84.releaseOccupyBudget(Unknown Source)
	at com.longtop.efmp.ebk.set.bs.impl.EbkSetBSImpl.releaseOccupyBudget(EbkSetBSImpl.java:98)
	at sun.reflect.GeneratedMethodAccessor930.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy85.releaseOccupyBudget(Unknown Source)
	at com.longtop.efmp.ebk.set.service.tx.SET01024000TService.handle06(SET01024000TService.java:84)
	at com.longtop.efmp.plm.cor.bas.bus.service.tx.AbsPlmMultiTService.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.service.template.ReleaseTplService.work06(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.service.template.a.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasServiceDispatcherImpl.doServcie(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasServiceDispatcherImpl.txReqRun(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor929.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy62.txReqRun(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasControlImpl.doService(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.bus.control.PlmBasControlImpl.execute(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsAction.runService(Unknown Source)
	at com.longtop.efmp.ebk.set.web.action.SET01024000APPROVEAction.handle06(SET01024000APPROVEAction.java:154)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsApproveAction.work06(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.longtop.intelliweb.util.Misc.invokeMethod(Unknown Source)
	at com.longtop.intelliweb.action.AbstractBaseAction.dispatch(Unknown Source)
	at com.longtop.efmp.plm.cor.bas.web.action.AbsAction.dispatch(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor664.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.longtop.intelliweb.util.Misc.invokeMethod(Unknown Source)
	at com.longtop.intelliweb.dataengine.b.do(Unknown Source)
	at com.longtop.intelliweb.dataengine.DataEngineServlet.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at com.longtop.intelliweb.common.SetCharacterEncodingFilter.doFilter(Unknown Source)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:86)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
	at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1678)
	at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1577)
	at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478)
	at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:512)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
	at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:106)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	at com.sun.proxy.$Proxy71.prepareStatement(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor276.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	at com.sun.proxy.$Proxy72.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
	at com.longtop.efmp.plm.cor.bas.dao.ibatis.LimitSqlExecutor.executeQuery(Unknown Source)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate

解决思路及方法：
有需要的可以了解一下，这是我觉的写的还不错的博主写的，虽然我也没明白啥意思吧：https://www.ibm.com/developerworks/cn/websphere/techjournal/0907_sood/0907_sood.html
（由于该项目中间件使用的是weblogic我刚开始以为是中间件的问题，调按照从网站上搜索的相关方法，都没有啥作用–这种方法视情况而定
在这里插入图片描述
，但是后来综合分析得出的结论是：单纯的调整weblogic不会起作用，数据库的运算性能较差，资源暂用较高）
于是我们在业务操作该条业务的时候，让数据库管理员取到了当时的awr文件
分析得出在这里插入图片描述
有几个sql占用的cpu都99%了，所以执行任何语句都不会太快，所以把这些涉及的表都添加了索引之后情况得到了缓解
如果想速度快些，索引最好单独加表空间
之所以驳回时操作慢是因为跟数据库响应速度有关，另外中间件weblogic的参数也不一定是值越大越好 因为gc的时间长会影响中间件的性能，而索引也不一定多了就是好，这就是为什么提议索引单独加表空间。
出现这种情况如果for多，请求数据库次数多，也会影响性能，就要看java代码了，所以说，数据库优化只是一部分，另一部分在java

进击中的程序媛
关注
XAException occurred. Error code is: XAER_RMERR
cqw1960的博客
12-21 609
问题提出：ibm portal默认使用内置db2数据库，执行迁移操作到oracle后，无法正常停止portal进程，报如下错误信息： [12/18/09 19:18:39:289 CST] 00000028 Int...
MySQL 报错 java.sql.SQLException: XAER_RMERR: Fatal error occurred in the transaction branch - check
kmswilliam的博客
01-15 5215
java.sql.SQLException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency 原因 MySQL 驱动版本低, 例如: 用的 MySQL 8 驱动版本用的 5
mysql XA RECOVER 执行报XAER_RMERR（1401）错误
jod2149的博客
06-27 4786
mysql XA RECOVER 执行报XAER_RMERR（1401）错误，解决方法 使用数据库版本为8.0.11，由于数据库连接用户没有XA_RECOVER_ADMIN权限导致。 使用授权命令 GRANT XA_RECOVER_ADMIN ON . TO ‘root’@’%’; ...
OracleXAException: XAER_RMERR (Internal XA Error)
vjnjjs的专栏
09-04 640
在wp 里面使用oralce 数据库的时候，有时会出现OracleXAException: XAER_RMERR (Internal XA Error)  这样的xa error 错误解决方法 参考 http://www.wsuc.tw/community/myforum/viewthread?thread=135      http://www.blogjava.net/jncz/archive...
weblogic XA驱动的一个报错
关注系统性能调优
09-10 4631
[ERROR] 2015-08-27 11:49:23:206 org.hibernate.engine.jdbc.spi.SqlExceptionHelper (SqlExceptionHelper.java:144) -  Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XA
struts_ejb.rar_EJB weblogic_ejb_ejb struts _ejb+struts_weblogic
09-22
Struts、EJB（Enterprise JavaBeans）和WebLogic是Java企业级开发中的三大核心组件，它们在构建可扩展且复杂的Web应用程序中起着至关重要的作用。这个名为"struts_ejb.rar"的压缩包文件，显然是为了教授初学者如何将...
weblogic安全补丁_weblogic_11g_1036_20180718
07-19
6. **安装和应用过程**："weblogic_11g_1036_20180718.txt"可能是补丁的安装指南或详细说明，它将指导用户如何下载、验证补丁的完整性，并按照正确的步骤进行安装。这个过程通常包括停服、备份现有配置、应用补丁和...
WebLogic_jdbc.rar_weblogic jd_weblogic jdbc.jar_weblogic.jd
09-14
让我们深入探讨一下WebLogic中的JDBC驱动、数据源、多数据源以及JDBC的相关API和最佳实践。 1. **JDBC驱动**：JDBC驱动是Java程序连接到数据库的关键组件。WebLogic支持四种类型的JDBC驱动，包括Type 1、2、3和4。...
weblogic_12c_patch.rar
06-20
在给定的压缩包文件"weblogic_12c_patch.rar"中，包含的是针对WebLogic服务器的一个重要安全补丁，具体为"p29204657_122130_Generic.zip"，此补丁是为了修复2020年10月被发现的WebLogic反序列化漏洞。 反序列化漏洞...
weblogic_cmd_plus:weblogic完整漏洞利用工具，支持T3XMLDecoder漏洞扫描
04-16
Weblogic_cmd_plus 漏洞信息 *表示利用此漏洞时，目标计算机不需要在网络之外 CVE型 WeblogicVersion 限制 依存关系 CVE-2015-4852 * 10.3.6.0、12.1.2.0、12.1.3.0、12.2.1.0 没有任何 没有任何 CVE-2016-0638 *...
JtaAtomikos的XAER_RMERR: Fatal error occurred in the transaction branch异常处理
天行++的JAVA空间
03-20 3089
当前访问mysql的账号缺少系统权限，userxxxxxxxx账户缺少 “允许执行 XA RECOVER语句”的权限：XA_RECOVER_ADMIN，以root最高权限账号访问mysql，执行“ GRANT XA_RECOVER_ADMIN ON *.* TO userxxxxxxxx@'%' 语句，当然账号和IP需要根据自己的来改，此处为了节省时间直接改为*.*。 现在我的root(即adm...
【MYSQL】XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
最新发布
Chuk
12-04 1447
报错： com.mysql.cj.jdbc.MysqlXAException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency。
MQSeries_XA_RMI XAER_RMERR (-3)
weixin_34010949的博客
09-19 252
替换cics/bin中的amqzsc文件：usr/mqm/lib/amqzsc 连接队列管理器失败2035 转载于:https://www.cnblogs.com/orchid-sky/p/7550204.html
XA_OPEN with ‘oracle_xa' returned XAER_RMERR '-3'
weixin_33933118的博客
10-11 282
XA_OPEN FRO application server *** with ‘oracle_xa' with xa_open string '*****' returned XAER_RMERR '-3' 遇见的问题原因为归档日志已满，用rman删除后解决问题。 另外一种原因是一直尝试使用该用户访问数据库，导致数据库认为该用户有问题，对用户加锁。 转载于:https://...
seata源码分析之-资源管理器详解2
王伟王胖胖的博客
02-13 418
seata源码分析之-资源管理器详解2事务消息处理器回滚消息处理器ResourceManagerXATCCResourceManager 事务消息处理器 上篇说了资源管理器有4种，那这些事务管理器是什么时候调用的，又是被什么事件驱动的呢，这次我们来看看事务消息处理器，也就是处理TC发来的事务消息，同样还是在RM初始化的时候创建的。 貌似一样的套路： 一样的SPI机制： 对应的也是4种处理器，如果有TC的消息来了，就会调用DefaultRMHandler的handle去找出是哪种处理器，进行处理。
mysql中sqlexception分类_使用mysql的系统中常见sql异常
weixin_28864057的博客
01-20 1362
使用mysql的系统中常见sql错误使用mysql的系统中常见的sql错误：1.事务中某些表是非innodb类型。SQLWarning ignored:SQL state 'HY000', error code '1592',message [Unsafe statement written to the binary log using statement format since BINLOG...
mysql错误代码
m0_53639266的博客
04-17 2255
/当前用户和数据库建立的连接已到达数据库的最大连接数，请增大可用的数据库连接数或重启数据库。new MyError(DB_ER_TOO_MANY_USER_CONNECTIONS ,"当前用户和数据库建立的连接已到达数据库的最大连接数，请增大可用的数据库连接数或重启数据库"),//当前用户使用的资源已超过所允许的资源，请重启数据库或重启服务器。//当前用户无权访问数据表。
Spring事务理解和配置
Student108的博客
09-07 2544
文章目录1 Spring事务1.1 事务简介1.1.1 什么是事务1.1.2 事物的特性1.1.3 不考虑事物会引发的安全问题1.1.4 事务隔离级别1.2 事务的传播行为1.3 编程式事务(需要手动写代码,了解)1.3.1 配置平台事务管理器1.3.2 Spring提供了事务管理的模板类1.3.3 在业务层注入事务管理的模板1.3.4 编写事务管理的代码1.4 声明式事务(xml配置)1.4.1 配置事务管理器1.4.2 配置增强1.4.3 AOP的配置1.5 声明式事务(注解)1.5.1 配置事务管理器
weblogic 数据库连接报XAResource.XAER_RMFAIL start()
关注系统性能调优
06-09 1502
weblogic启动之后，点击功能报： Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResourc
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值