firebird-net-provider

[Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

I usually use pooled connections in my web applications, but I don't
understand how and when they are released (looking at my Linux server
processes, seems never).
I think the Connection Lifetime parameter can help me in this, but how? In
the help file is reported to be working when a connection is returned to the
pool, but is it also working when web applications aren't in use (like a
separate thread doing the job)?
For example imagine the following scenario:
10 users are using my web application. At 6 pm they stop working and go
having fun :-).
Setting the Connection Lifetime to 20, I imagine all the connections being
closed at 6.20 pm... am I right?

TIA.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> I usually use pooled connections in my web applications, but I don't
> understand how and when they are released (looking at my Linux server
> processes, seems never).
> I think the Connection Lifetime parameter can help me in this, but how? In
> the help file is reported to be working when a connection is returned to the
> pool, but is it also working when web applications aren't in use (like a
> separate thread doing the job)?

Connection Lifetime is specified in seconds, there are a cleanup thread 
that is running at every 10 seconds.

I'm thinking on rework the connection pool in 1.6 for allow max and min 
pool sizes, ...

Can you retry with latest CVS sources i think it will work correctly now 
:) if not let me know, please.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> Connection Lifetime is specified in seconds

A lifetime of 0 means that the connection never dies in the pool.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3FE...@te......
>
> Connection Lifetime is specified in seconds, there are a cleanup thread
> that is running at every 10 seconds.

Perfect!

> I'm thinking on rework the connection pool in 1.6 for allow max and min
> pool sizes, ...
>
> Can you retry with latest CVS sources i think it will work correctly now
> :) if not let me know, please.

Not at all, because the applications I'm referring to have been built with
the 1.0 version of the provider. Maybe I'll try with that version.

Thanks.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> Not at all, because the applications I'm referring to have been built with
> the 1.0 version of the provider. Maybe I'll try with that version.

1.0 needs to work ok :) the bug was added by me in 1.5 version, when i 
moved the lifetime stuff to GdsAttachParams :(




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3FE...@te......

> Can you retry with latest CVS sources i think it will work correctly now
> :) if not let me know, please.

It seems it is not working, using IBExpert I see the user under active
users.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

""Alessandro Petrelli"" <pet...@in...> wrote in message
news:brv0hd$7ha$1...@ne......
> "Carlos Guzmán Álvarez" <car...@te...> wrote in message
> news:3FE...@te......
>
> > Can you retry with latest CVS sources i think it will work correctly now
> > :) if not let me know, please.
>
> It seems it is not working, using IBExpert I see the user under active
> users.

I also noticed that the connection pool is not application-wide.. connecting
from different classes results in having different connections. Is this as
designed (or probably my fault-design)?

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

""Alessandro Petrelli"" <pet...@in...> wrote in message
news:brv0ud$7lf$1...@ne......
> ""Alessandro Petrelli"" <pet...@in...> wrote in message
> news:brv0hd$7ha$1...@ne......
> > "Carlos Guzmán Álvarez" <car...@te...> wrote in message
> > news:3FE...@te......
> >
> > > Can you retry with latest CVS sources i think it will work correctly
now
> > > :) if not let me know, please.
> >
> > It seems it is not working, using IBExpert I see the user under active
> > users.
>
> I also noticed that the connection pool is not application-wide..
connecting
> from different classes results in having different connections. Is this as
> designed (or probably my fault-design)?

I feel a bit stupid... sorry, I was not disposing the connection :-)...
don't know the reason, I hope to find one asap :-))))

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> I also noticed that the connection pool is not application-wide.. connecting
> from different classes results in having different connections. Is this as
> designed (or probably my fault-design)?

Different connection strings will result in different connections, if 
finally i change the Connection Pool in the 1.6 sources different 
connection string will result in different Connection Pools as in 
SqlClient provider ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> I'm thinking on rework the connection pool in 1.6 for allow max and min 
> pool sizes, ...

I have added an initial implementation of this on 1.6 CVS sources, i 
have done only some basic tests, i will try to do some tests this weekend ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain