开发者

sqlite database lock

开发者 https://www.devze.com 2023-03-02 08:55 出处:网络
I am developing c# application , in which the backend is sqlite. multiple threads are running at a time.so when i perform CRUD operation it always shows me the error message as database is locked.When

I am developing c# application , in which the backend is sqlite. multiple threads are running at a time.so when i perform CRUD operation it always shows me the error message as database is locked.When i perform the Crud operation same time sync process(creating local db from remote db) is going on,in this case the lock error always occurs.it happens when cmd.ExecuteNonquery method is开发者_如何学运维 calling.

Server is console application.Client is windows application here sync will happen means from server it takes remote database and create local databse and insert data to local db.

Through server we can perform CRUD operation to remote databse.This will throw lock error. For crud operation we using simple UI IN browser.

can anyone plz help me in this, coz this very critical for me.

Thank you

regards sangita


Have you read http://sqlite.org/threadsafe.html?

Also read: http://www.stackoverflow.com/questions/2775595/sqlite-multi-process-access

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号