[teiid-issues] [JBoss JIRA] (TEIID-142) Introduce a mechanism to allow single source updates without an xa txn.

Introduce a mechanism to allow single source updates without an xa txn. ----------------------------------------------------------------------- Key: TEIID-142 URL: https://issues.jboss.org/browse/TEIID-142 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 9.x Reporter: Steven Hawkins Priority: Minor Defect Tracker #24910: txnAutoWrap = OFF in 5.5 disables the use of local transactions. This was primarily done to support customers who 1. weren't paying for the transactional product 2. weren't using an XA connection for an update The concern of 1 goes away in 5.6 as all customers will have a transactional product. The secondary concern requires either a connection property that either ignores autocommit or the generic support of 1 phase commit on connectors supporting update and local transactions. The latter solution would allow non-XA aware connectors to seem XA aware as long as all updates went to a single source. Arjuna would also need to be configured to support the one phase commit optimization.