Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

2013-07-23 Thread Loren Keagle
[mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Loren Keagle Sent: Monday, July 22, 2013 2:38 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite-users Digest, Vol 67, Issue 18 The sqlite3_reset() function is called to reset a prepared statement object back to its initial state

Re: [sqlite] sqlite-users Digest, Vol 67, Issue 18

2013-07-22 Thread Loren Keagle
they could block sqlite in creating new statement? 2013/7/17 Loren Keagle loren.kea...@braemarllc.com Hi everyone, I have an interesting locking problem that I'm wondering if someone can help with some insight. I have a master database with some metadata, and several sub

Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

2013-07-19 Thread Loren Keagle
; charset=us-ascii On 16 Jul 2013, at 11:24pm, Loren Keagle loren.kea...@braemarllc.com wrote: Begin EXCLUSIVE TRANSACTION; insert several rows of data; Commit transaction; Prepare query statement; Iterate through one or more rows; Reset statement; Attempt to begin transaction

[sqlite] Sqlite locking issue with ATTACH'ed databases

2013-07-17 Thread Loren Keagle
Hi everyone, I have an interesting locking problem that I'm wondering if someone can help with some insight. I have a master database with some metadata, and several sub-databases to store logging events. I have one reader object and one writer object that attach to the sub-databases and