This was exactly the problem; I didn't realize the 'static' variables are
persisted between page views in ASP.Net
Adding an '_instance = null;' fixed the issue.
Thanks muchly.
Cheers,
Doug.
On Tue, Jul 19, 2011 at 11:58 AM, Joe Mistachkin wrote:
>
> After reading the code, I noticed the follow
After reading the code, I noticed the following:
1. From the static Dump method, an instance of the DbLogger class is
created via the static Get method and stored in the _instance static
variable.
2. The connection itself is opened in the constructor for the DbLogger
class via the InitDb method.
On 19 Jul 2011, at 4:07am, Doug wrote:
> I'm pretty sure the issue is something to do with file handles. For the same
> reason after loading the page (from an IIS server) and then closing the
> page, waiting 1 minute or two and then attempting to remove the db.sqlite
> file, I get an "error, file
{
>using (SQLiteCommand cmd = _cnn.CreateCommand())
>{
> cmd.CommandText = "COMMIT";
> cmd.ExecuteNonQuery();
>}
> }
> _cnn._transactionLevel--;
> _cnn = null;
>}
>
>
>
> Michael D.
@sqlite.org] on
behalf of Doug [douglas.lin...@gmail.com]
Sent: Monday, July 18, 2011 1:34 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] Handle leak using IIS on windows 7?
Hi there,
I've searched around and found a few threads like this:
http://sqlite.phxsoftware.com/forums/t/2480.aspx
Hi there,
I've searched around and found a few threads like this:
http://sqlite.phxsoftware.com/forums/t/2480.aspx
Basically, I have the same issue.
When access the sqlite database via a website (MVC3 running on IIS) the
first time, sqlite works fine.
I properly call connections.Close() when I
6 matches
Mail list logo