Our Training Programs

All contents are copyright of their authors.

SqLite DataBase Locked Exception

SqLite DataBase Locked Exception

aman deep

9yAsked Jul 5, 2017, 10:13 AM6.3kVisual Basic .NET

My Code Is following i wants to retun a SqLiteDataReader From My Function But I got DataBase Lockked Exception

Following is My Code

public static SQLiteDataReader getAction(string Qry)

{

SQLiteConnection m_dbConnection;

SQLiteDataReader reader = null;

m_dbConnection = new SQLiteConnection(Connn);

m_dbConnection.Open();

SQLiteCommand command = new SQLiteCommand(Qry, m_dbConnection);

reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);

return reader;

}

..
Please Help ...

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Manikandan Murugesan9y ago
Refer the following Link : https://stackoverflow.com/questions/17592671/sqlite-database-locked-exception

https://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked
aman deep9y ago
How Can I cheeck It ,,,????
on server side for the process name/id that obtained lock on the database?
aman deep9y ago
This Is My Query
---> select tag from EndUser
Tapan Patel9y ago
May be it would be wild guess but can you check on server side for the process name/id that obtained lock on the database?also, what is your query? Is that something that puts the lock on DB and never releases?