分散式事務ORA-24784報錯

banq發表於2018-10-12
分散式
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修改過]

相關文章