Transaction Processing
In an XA environment, transactions are controlled by the TPM. This means that the DB XA Module must omit calls that affect the state of global transactions. Therefore, the following methods should not be called:
*beginTransaction()
*commitTransaction()
*rollbackTransaction()
*autocommit()
Using these functions produces a notSupported error.
We highly discourage the use of any SourcePro DB API that results in the generation of DDL statements (for example, using methods that create, drop, or alter a table, view, procedure, index, et cetera; or granting and revoking privileges). Since DDL statements commit implicitly, they change the transaction state of the database. The database may produce a server error upon the execution of such code. Refer to the DB XA Module Reference Guide for descriptions of which methods should not be used.