My application calls sqlite3_finalize() after insertion of 10,000
record(loop). Is there any other reason?
On Mon, Mar 31, 2014 at 3:23 PM, d b <va230...@gmail.com> wrote:
> sqlite3_bind_text() returned 21 error. It is throwing for all insertions
> once error introduced.
>
> For ex: Here, Inserted first 10 records successfully. then it was started
> throwing error 21 for 11th record on-wards till last record(10,000 record).
> I was able to insert the records successfully after restart the application
> only.
>
>
> On Mon, Mar 31, 2014 at 2:23 PM, d b <va230...@gmail.com> wrote:
>
>> Hi,
>>
>> I am getting sqlite error 21.
>>
>>
>> There is only one sqlite prepared statement for insertion. It's not
>> multi threaded app. The below function repeatedly calling for every record
>> insertion. This app was running from last 4 days. On third, it was started
>> throwing error 21. What could be the reason?
>>
>> steps from application:
>>
>> bool stmt::execute(const char* const insertquery, listofinputparams)
>> {
>>
>> insertquery is insert or replace into mystuff(id, name, value)
>> values(?,?,?);
>>
>> bool r = false;
>>
>> sqlite3_stmt s = find(insertquery);
>>
>> while(enumerate listofinputparams)
>> {
>> bind each argument for insert statement s
>> }
>>
>> sqlite3_step(s);
>>
>> sqlite3_reset(s);
>>
>> return r;
>> }
>>
>> Thanks,
>> a v
>>
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
