The sqlite3.7 is giving this issue specifically for windows box on NTFS file system . it works fine on Ubuntu. I see there are many post regarding this but none of them gives a clear answer. Do we have a solution for this?
Dont use SQLite when using multithreaded access to DB.
The locking in Sqlite is directly lockinbg Database and not granular like locking table or even more fine-grained at row level like most of the other DBMS server.