On Aug 22, 2007, at 3:37 AM, Wolfram Hinderer wrote:
> "Any command that changes the database (basically, any SQL command
> other than SELECT) will automatically start a transaction if one is
> not already in effect. Automatically started transactions are
> committed at the conclusion of the command."
>
> There is no need for a begin, and there is no need for a commit. The
> transaction is already committed when you try to commit. The error
> message tries to say just that.
That's the way that I understood this, but try this: change
dbSQLite.py's commitTransaction() method to simply return instead of
trying to execute a 'COMMIT' call. Now run any Dabo app, and as the
pref engine works away, you'll inevitably get a series of tracebacks,
all with the final line:
dabo.dException.DBQueryException: database is locked
We aren't explicitly beginning any transactions, so it would seem
that executing COMMIT shouldn't be necessary. But these 'locked'
messages seem to indicate otherwise.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
