I'm back again.
I could not ignore such a strong suggestion of not using thread. So I am
planning on a single threaded event driven model for my application. I also
plan to use sqlite3_progress_handler() to handle query cancellation.
I compiled SQLite with the flags SQLITE_THREADSAFE=0. Even the
On Nov 3, 2008, at 9:54 AM, Ken wrote:
> No I would not wrap the querries in a transaction.
>
> I think the problem you are encountering is due to thread
> interaction upon the sqlite structures. Since it was compiled with
> THREADsafety disabled.
>
> If you have two threads that share the sa
when starting transactions and the prepare
and first calls to step (ie for selects).
Hope that helps
--- On Mon, 11/3/08, dbikash <[EMAIL PROTECTED]> wrote:
> From: dbikash <[EMAIL PROTECTED]>
> Subject: Re: [sqlite] "SQL logic error or missing database" with
; for success. If you fail with sqlite busy. Simply sleep a short while
> (hint usleep) loop and try again.
>
> HTH
> Ken
>
>
>
> --- On Fri, 10/31/08, dbikash <[EMAIL PROTECTED]> wrote:
>
>> From: dbikash <[EMAIL PROTECTED]>
>> Subject: Re:
) loop and
try again.
HTH
Ken
--- On Fri, 10/31/08, dbikash <[EMAIL PROTECTED]> wrote:
> From: dbikash <[EMAIL PROTECTED]>
> Subject: Re: [sqlite] "SQL logic error or missing database" with
> multithreaded program
> To: sqlite-users@sqlite.org
> Date: Frid
I use both int sqlite3_errcode() and sqlite3_errmsg(). Here is what they
return (I get 3 different types of errors in different runs):
1, SQL logic error or missing database.
1, unrecognized token "" (there's a non printable character like a rectangle
within the quotes).
1, SQL logic error or miss
On Oct 31, 2008, at 9:46 AM, dbikash wrote:
>
> I get a SQLite error 1 (SQL logic error
> or missing database). What could be the problem?
Is that the error message text that SQLite returns: "SQL logic error
or missing database"? Or is that just the meaning of SQLITE_ERROR
that you looked u
I prepare the statement once. But I use transaction for every bunch of 500
record inserts.
mikewhit wrote:
>
> dbikash <[EMAIL PROTECTED]> writes:
>
>>
>>
>> Hello,
>> ...
>> - Thread 1 inserts 500 records to the database every 30 seconds and then
>> goes to sleep. (I prepare an insert state
dbikash <[EMAIL PROTECTED]> writes:
>
>
> Hello,
> ...
> - Thread 1 inserts 500 records to the database every 30 seconds and then
> goes to sleep. (I prepare an insert statement, BEGIN TRANSACTION, bind
> values, step through the statement, reset the statement, and do END
> TRANSACTION)
> T
Hello,
I am writing a program using SQLite that uses two threads performing the
following operations in an infinite loop:
- Thread 1 inserts 500 records to the database every 30 seconds and then
goes to sleep. (I prepare an insert statement, BEGIN TRANSACTION, bind
values, step through the statem
10 matches
Mail list logo