Re: Gda_ConnectionPool

[rodrigo linuxave net]

Vivien Malerba wrote:

> Hi!
>
> Form what I understand the Gda_ConnectionPool takes care of a list of
> connections and can close all of them. What about when a connection is
> not used anymore? There is no mechanism to care about unused connections
> and destroy them.
>
> Should I add a gda_connection_pool_close() function which, from a client
> point of view will decrease the the reference count and destroy the connection
> when it reaches 0?
>

the Gda_ConnectionPool is just started, so it's missing lots of fonctionality.
What you say is one of them. I had thought that, instead of having the client
call gda_connection_pool_close(), have a timeout for closing the connection. I am
not sure which one is better, since your proposition is ok, but if a client
crashes, the connection will remain open for always, since
gda_connection_pool_close() is never call. And my idea has also drawbacks, since
there could be a client inactive for 20 hours, for example, but it still believes
the connection is established.

so, what do you think?