分布式事务ORA-24784报错

18-10-12 banq
              

XA事务和Dblink事务冲突,在DBlink中启动XA事务了,即使仅仅是查询。也就是说:Weblogic数据源启用XA事务和Oracle的DBLink事务两者只能用一个,另外Oracle不支持临时表的XA事务

An ORA-24784 'Transaction exists' error occurs when using Oracle XA.

An attempt was made to start a transaction, while attached to a non-migrateable transaction

Issuing a query containing a database link starts a distributed transaction that is non-migratable, even if it is only a query. An XA transaction cannot then be started without a commit or rollback being issued first.
[该贴被banq于2018-10-12 16:49修改过]
[该贴被banq于2018-10-14 09:25修改过]
[该贴被banq于2018-10-14 09:26修改过]