[sqlite] Locked Database Problem

2010-06-19 Thread Martin Sigwald
Hi, I'm running two different processes, both access the same database at given times, without synchronization. In order to handle a simultaneous access, I was testing for the BUSY condition. However, one of the processes is receiving a LOCKED status form SQLITE, resulting in a eternal deadlock. Ac

Re: [sqlite] Locked database problem

2008-06-22 Thread Igor Tandetnik
"Lothar Behrens" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have s question about avoiding locked database errors by closing a > connection in these circumstances. Opening a connection doesn't acquire any locks, and closing doesn't release any. Starting and finishing transact

[sqlite] Locked database problem

2008-06-22 Thread Lothar Behrens
Hi, I have s question about avoiding locked database errors by closing a connection in these circumstances. In my test application this works and I also can see that the related data has been inserted. But in my main application I also close the connection without success. Is it possible, that