Thanks. I tried using PRAGMA jouranl_mode = WAL but still it is getting failed for some time. Find below more details.
Process 1: Fun_Open() sqlite3_open(DATABASE, &dbUpdate); sqlite3_exec(dbUpdate, " PRAGMA jouranl_mode = WAL", NULL, NULL, &sErrMsg); Fun_Update() on TblTest /* Do the periodic update operation by using db handler return from above*/ Process 2: Fun_Open() sqlite3_open(DATABASE, &dbRead); sqlite3_exec(dbRead, " PRAGMA jouranl_mode = WAL", NULL, NULL, &sErrMsg); Fun_Read() on TblTest** /* Do the periodic read operation by using db handler return from above*/ Cheers - Techi On Mon, Aug 26, 2013 at 12:14 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 08/26/2013 01:37 PM, techi eth wrote: > >> Hi, >> >> I come across database file locking error while trying below case with >> Update. >> >> Case: One process is updating a Colum periodically & other process is >> selecting same Colum or other colum in table periodically for read. >> What is the best way to handle so that Update will not get locking error? >> > > Using WAL mode. > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users