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

[Anthony Tuininga]

SQL*Plus has autocommit but the OCI does not support it so it would have
to be coded explicitly in DCOracle for it to be available. As mentioned,
DDL has an implicit commit in it and terminating the session will also
implicitly commit any outstanding changes.

On Wed, 2003-02-26 at 04:45, Andy Todd wrote:
> 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/
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig
-- 
Anthony Tuininga
anthony@computronix.com
 
Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com