Re: [Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi,

I have found that if I run at least 1 call to the database without the
"pooling=false" addition to the connection string then locking of the .gdb
file will occur and I will not be able to delete the file after running my
dot net code.

however as soon as I chage the connection string in web.config to include
the "pooling=false" in the connection string and run a query, agaist the
previously locked file, then the connection pool seems to be cleared.
I not sure if this is because the dot.net project has been recompiled
becasue of the change to web.config or not.

anyway, my problem is solved, but if you do any "cleanPool" functionality to
"fbConnection" then I for one would be interested in using it.

cheers

martin.


"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > This has worked brilliantly, I am now able to delete the file after
running
> > my dot net code. Thank you.
>
> :)
>
> > This particular problem has brought up the issue of the benefits of
using
> > connection pooling on a firebird db.
> > If say I had a busy website using a firebird db as a back end, that was
> > using connection pooling and was visited by a fair amont of people.
>
> Huuummmm a thing you can test is to try to use the Connection Lifetime
> parameter in the connection string, for see if it can help.
>
> > Then supposing I needed to take the website down for a short period of
time,
> > say for routine maintenance, I would have a whole pile of open
connections
> > in my database.
> > I guess that I would need to close the connections gracefully, I'm not
sure
> > how I would do this.
>
> Huummm you can try to create a static method in FbConnection, called for
> example CleanPool, for clean all the connections in the pool, if there
> are more people interested on this i can make it in the provider sources
> :), i can try to review too if there are anything arround this in the
> .NET Framework 1.1 and 1.2 documentation.
>
> > This situation could arise if say a problem arose on my production site
and
> > I wanted to shut my production site down for a while and copy the
production
> > database to my development server, Firstly stoping the firebird service
on
> > the production server. Stopping the service would report "Overlapping
I/O
> > operation."
>
> Huummm if you want to do backups you can do that without make a shutdown
> of the server, but i don't know if you mean this type of maintenance
> tasks :)
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>