Stuart Bishop wrote: > Hi. > > Are there any drivers out there that support two phase commit. > > If so, what syntax do they use?
I'm not aware of any native driver that does support this, except a patched DCOracle2: http://pymqi.sourceforge.net/ You can also use mxODBC with an XA enabled ODBC driver (I think the EasySoft Oracle ODBC driver is capable of doing XA), but the APIs for setting this up are different for each driver. > Is it worth adding a standard API for this as an optional extension to the > DB-API 2.0? Enough backends now support this that I suspect it is worth > doing this now to avoid unnecessary incompatibilities between backend > specific database APIs. I'm not sure I can follow you here: if you do two-phase commit under the control of a transaction manager such as MQSeries or MS DTS, then the transaction manager will take care of the transaction, not the database interface (see e.g. the DCOracle2 XA example in http://pymqi.sourceforge.net/). -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Jun 22 2006) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ 2006-07-03: EuroPython 2006, CERN, Switzerland 10 days left ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! :::: _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
