How to turn AUTOCOMMIT ON with cx_Oracle

[Paul McGuire]

"Jia Lu" <Roka100 at gmail.com> wrote in message 
news:1164964822.037946.172490 at 79g2000cws.googlegroups.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