Andy Dustman wrote:
There are two factors which determine whether or not transactions can be supported. Actually, there's only one, but it can't be directly tested for:
1) If the server version (easily obtained upon establishing the connection) is < 3.23.15, transactions are definitely not supported.
2) If the database in use employs BDB tables, transactions are definitely supported.
AFAIK the transaction support is enabled on table-by-table basis, so there is no way to know for sure if transactions are supported/partially-supported/unsupported for a particular set of queries
The problem is: Support for the transaction manager is done with a MixIN class, so the decision on whether or not transactions should be supported in the DA comes before the connection object is created.
But after the connection is established you could probably change the mixin class, at least if it is really a proxy wrapper of some other class. Python is _very_ dynamic language. ------------ Hannu