Re: [sqlite] database is locked (my solution)

2007-02-06 Thread Ken
Andrew, I wouldn't worry about it too much, at least your contributing. There are quite a few threads regarding locking, concurrency and multi threading. IMHO, everyone would benefit from your modification. I would especially like to be able to deal with Locking issues at the

Re: [sqlite] database is locked (my solution)

2007-02-05 Thread Joe Wilson
--- Andrew Teirney <[EMAIL PROTECTED]> wrote: > If you are interested in the "BEGIN SHARED" transaction i posted a > simple patch to this mailing list within the last month if i recall > correctly. http://www.mail-archive.com/sqlite-users@sqlite.org/msg21260.html Do you find that using this

Re: [sqlite] database is locked (my solution)

2007-02-05 Thread Andrew Teirney
Andrew, Nice modification.. Did you buy any chance post this into the sqlite ticketing system? It would be nice if sqlite would let you acquire a shared lock via the BEGIN statement. No i didn't actually post this to the ticketing system, to be honest i am very new to all this open

Re: [sqlite] database is locked (my solution)

2007-02-05 Thread Ken
Andrew, Nice modification.. Did you buy any chance post this into the sqlite ticketing system? It would be nice if sqlite would let you acquire a shared lock via the BEGIN statement. Andrew Teirney <[EMAIL PROTECTED]> wrote: > I have multiple thread reading the database and a

Re: [sqlite] database is locked (my solution)

2007-02-05 Thread Andrew Teirney
I have multiple thread reading the database and a thread inserting in or updating the database. when i try to simulate this case by executing sqlite3 from shell by beginning a transaction from a shell and retrieving data from other shell eveything works fine. But when it's the cas from my C