[
https://issues.jboss.org/browse/TEIID-3907?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3907:
---------------------------------------
The proposal here would be to update the ExecutionFactory.TransactionSupport enum to
include COMPENSATING. When the engine sees an update against such a source in the scope
of a transaction it will create an undo action tied to a synchronization. The logic will
also automatically change the update into a row-by-row procedure to appropriately capture
the before state.
Support compensating transactions for updatable non-XA sources
--------------------------------------------------------------
Key: TEIID-3907
URL:
https://issues.jboss.org/browse/TEIID-3907
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 9.x
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 11.0
The transaction manager will fully support xa with all xa sources and a single local
transaction resource. Beyond that however there is no built-in support for compensating
transactions with non-XA sources. There has been work in Narayana on compensating
transactions though that could be used by custom web apps consuming Teiid. We would like
to eventually offer compensating options for some of our updatable non-XA sources, but it
hasn't had sufficient priority yet.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)