[EMAIL PROTECTED] wrote:
Hi all,

I'm trying SQLite with Zope

You're using PySQLite, right?


and it works fine, but  when I use the browser's
[Stop] button to interrupt the request it  gives me the message:

"database is locked" [...]

This happens when you have a connection that is within a transaction (i. e. you haven't issued .commit() or .rollback() on the connection object, yet) and you're trying to open a second connection to the same database.


The solution is to assure that you always .commit() or .rollback(). I don't know where to put that in a ZOPE database adapter, perhaps you should check the sources of a different ZOPE DA.

But it's hard to tell without knowing your sources and without sufficent knowledge about Zope database adapters ;-)

Or are you using PySQLite not from within a DA, but otherwise?

-- Gerhard


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to