I've gotten to the point in my project where I want to use transactions. I'm using MySQL as my database backend. I understand that for transactions I need to turn off autoCommit (and cache).
Normally this is done by appending '?autoCommit=0' to the end of your dburi string. However, the SQLObject interface to MySQL is broken in regard to this. If you use this method, you will get a TypeError exception, because the string '0' is not converted to an int where needed. Using just '?autoCommit=' also does not work. There is a ticket for this issue in the SQLObject bug tracking system. So, I need an alternate method of turning autoCommit off for my DB connection, and I've not found it yet. Does anyone know how to do this?
