On 1/31/06, Mark Ramm <[EMAIL PROTECTED]> wrote: > > > Interesting. In your session there, you didn't get debug output for > > the COMMIT. I did when I ran it. Which version of sqlite/pysqlite do > > you have? > > > > Kevin > > In this case, I just easy_installed pysqlite on windows with the > whatever sqlite comes in the egg.
It occurred to me that the COMMIT log message would actually come from SQLObject anyhow, so the sqlite version shouldn't make a difference. Here's a few more things to look at: In [2]:hub.uri Out[2]:'sqlite:///tmp/book.db?debug=1' In [3]:hub.supports_transactions Out[3]:True In [7]:Bookmarks.select().count() (some output) In [8]:hub.threadingLocal.connection Out[8]:<sqlobject.dbconnection.Transaction object at 0x111f290> Assuming those things all match up, commit *should* work. If one of those things doesn't match up, commit won't do anything (which is what you're seeing). Kevin
