[SQLObject] MySQL and transactions

[John A. B. <ja...@os...>]

Hi,

I noticed something strange when looking at the MySQL query log: after
every query by SQLObject, a COMMIT was being issued.  I tracked it down
to the _runWithConnection method in the DBAPI class, which calls
conn.commit() in line 3.  I'm baffled as to why this is necessary.  I'm
not sure about Postgres, but in MySQL a COMMIT is ignored unless you're
using InnoDB and AUTOCOMMIT=3D0.  Any clues?

Speaking of InnoDB, it's becoming more and more popular, so shouldn't
MySQL transactions be supported in SQLObject?  It won't break things
with non-InnoDB tables, it'll just be silently ignored.  Would a patch
for this be accepted?

-jab

--=20
John A. Barbuto	                                ja...@os...
Senior System Administrator,
Open Source Development Network                 http://www.osdn.com/