Transaction Support

The CData Virtuality Server utilizes XA transactions for participating in global transactions and for demarcating its local and command-scoped transactions. The CData Virtuality Server uses JBoss Transactions as a transaction manager.

Here are the CData Virtuality Server transaction scopes:

Scope	Description
`Command`	Treats the user command as if all source commands are executed within the scope of the same transaction. The `AutoCommitTxn` execution property controls the behaviour of command-level transactions
`Local`	The transaction boundary is locally defined by a single client session
`Global`	The CData Virtuality Server participates in a global transaction as an XA Resource.

The default transaction isolation level for the CData Virtuality Server is READ_COMMITTED.