'The database file is locked' with System.Data.SQLite

I am suddenly getting the following errors from SQLite after adding a new transaction:

The database file is locked database is locked

Has anyone seen this? I added an update transaction (following some successful selects/inserts). I can't find anything different about this one...

Answers


I figured it out. From looking at this [really old] thread on the phxsoftware site, it seems like there can be locking problems if you don't immediately dispose of readers and commands after executing them.

I fixed my problem by making sure to not keep commands or readers around and surrounding them with using statements.


Need Your Help

Set tab above action bar

android tabs actionbarsherlock android-actionbar

I have some issues with action bar and tabs navigation. Actually I want to set my tabs to be above my Action Bar. (I used Sherlock Action Bar).

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.