"Jia Lu" <Ro*****@gmail.comwrote in message
news:11**********************@79g2000cws.googlegro ups.com...
Hi all.
I use cx_Oracle to connect to an Oracle9i DB. And I want to turn on
AUTOCOMMIT function.
I see that cur.execute("SET AUTOCOMMIT ON") cannot work. Is there any
method to do that ??
Thanks a lot!
AUTOCOMMIT is a dangerous crutch, beware. Ok for single record updates, but
if you need to update 2 records in synch, AUTOCOMMIT leaves you open to
hard-to-debug bugs (will work ok in development under light load, then fail
intermittently with concurrent users).
-- Paul