Yes, all command have been disposed; everything works until I close the connection. Then when I open it again it the same application; either I get a "database is locked" when trying to write to it or I get "SQL queries are still processing" when I just opened it and send a VACUUM pragma to it.
Simply put, it's only possible to open a database once in the application for writing; it's like the lock doesn't get released until the application is closed. On Tue, Sep 11, 2012 at 5:59 PM, Joe Mistachkin <sql...@mistachkin.com>wrote: > > Serge Fournier wrote: > > > > Simply put, I open a database and then close it in an application then I > > reopen it again, > > I cannot write to it anymore; it is always locked. I tried doing a close, > > dispose and shutdown > > to my connection and then reopning it and do a simple vaccum; it tell me > > that there's still > > sql queries in progress when none were sent to the database. > > > > Have all the SQLiteDataReader and SQLiteCommand objects been properly > disposed? What is the exception you are seeing? > > -- > Joe Mistachkin > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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