Re: [sqlite] Why SQLITE_LOCKED here?

2008-12-09 Thread Marcus Grimm
> Marcus Grimm wrote: >> I skipped to use the busy handler and the busy timeout and do >> the handling by my selve. typically like: > > Are you aware that your code is very similar to the default SQLite busy > handler if you set a busy timeout? I'd argue that the one shipped with > SQLite is

Re: [sqlite] Why SQLITE_LOCKED here?

2008-12-09 Thread Roger Binns
Marcus Grimm wrote: > I skipped to use the busy handler and the busy timeout and do > the handling by my selve. typically like: Are you aware that your code is very similar to the default SQLite busy handler if you set a busy timeout? I'd argue that the one shipped with SQLite is better since it

Re: [sqlite] Why SQLITE_LOCKED here?

2008-12-09 Thread Igor Tandetnik
Marco Bambini <[EMAIL PROTECTED]> wrote: > I have several threads inside an application and each thread opens a > connection to the same database. > The application has been compiled with SQLITE_THREADSAFE = 1. > One of the threads (just one) open another database connection to the > same database

Re: [sqlite] Why SQLITE_LOCKED here?

2008-12-09 Thread Marcus Grimm
Hi, I also spend some time with a similar application and sqlite is doing quite well so far, however you will get BUSY states and LOCK states under "normal" condition and you will need to handle them. I skipped to use the busy handler and the busy timeout and do the handling by my selve.

[sqlite] Why SQLITE_LOCKED here?

2008-12-09 Thread Marco Bambini
I have several threads inside an application and each thread opens a connection to the same database. The application has been compiled with SQLITE_THREADSAFE = 1. One of the threads (just one) open another database connection to the same database used by ALL threads for all the writing