Am 31.03.2010 um 15:14 schrieb Dan Kennedy:
>
>
> Begin forwarded message:
>
>> From: "Periasamy, Karthikeyan" <karthikeyan.perias...@adc.com>
>> Date: March 31, 2010 7:52:55 PM GMT+07:00
>> To: "danielk1...@gmail.com" <danielk1...@gmail.com>
>> Subject: Re: [sqlite] Sqlite3 crashing on multithreaded program
>>
>> Hi,
>>
>> Thanks for your reply.
>>
>> In our application the block of code which access the DB looks like
>> this,
>>
>> QueryDB(char *queryStr)
>> {
>> result = dbi_conn_query(DbConnection, queryStr);
>> if (result)
>> {
>> if(ZERO_RESULT == dbi_result_get_numrows(result))
>> {
>> syslog( LOG_DEBUG,"[%s:%s] Empty Result. Freeing result pointer
>> \n", __FILE__, __FUNCTION__);
>> dbi_result_free(result);
>> result = NULL;
>> }
>> }
>> return result;
>> }
>>
>> In threads,
>>
>> dbi_result result = QueryDB(queryStr);
>> if (NULL != result)
>> {
>> while (dbi_result_next_row(result))
>> {
>> varibale = dbi_result_get_<type> (...);
>> ... /* Do some processing */
>> }
>> dbi_result_free(result);
>> }
>>
>> We do not know what we are doing wrong. Do we have to take care of
>> locking across threads in our application?
Did you read <http://www.sqlite.org/threadsafe.html>?
How did you build your SQLite libraries?
Is DbConnection a shared object?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
