[DB-SIG] DCOracle2 in auto-commit mode ?

Andy Todd andy47@halfcooked.com
Wed, 26 Feb 2003 11:45:47 +0000


On Wed, Feb 26, 2003 at 12:05:09PM +0100, M.-A. Lemburg wrote:
> How can I set up a DCOracle2 connection in auto-commit mode ?
> 
> I've looked at the docs, but couldn't find any hint whether this
> is possible and how.
> 
> Thanks,
> -- 
> Marc-Andre Lemburg
> eGenix.com
> 
> Professional Python Software directly from the Source  (#1, Feb 26 2003)
> >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
> >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> ________________________________________________________________________
> Python UK 2003, Oxford:                                     34 days left
> EuroPython 2003, Charleroi, Belgium:                       118 days left
> 
> 

Errm, I don't believe it is, unless Matt has written specific code to do it. 

Oracle doesn't have an auto commit mode, it implicitly starts a transaction with every connection and unless you specifically commit all of your changes are rolled back. Well, with one or two exceptions, e.g. DDL is not controlled by transactions and is immediately applied.

Regards,
Andy
-- 
--------------------------------------------------------------------------------
>From the desk of Andrew J Todd esq - http://www.halfcooked.com/