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?
>
> Regards,
> Karthik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
