Cleaning connection from the pool is one part of the problem, but can we
control the same so that we don't have to come to the stage of looking for
cleaning the pool itself? Means, we can have better control of your number
of connections by using "Min Pool Size/Max Pool Size". I am not aware that
you can have access to pool/poolManager object from Informix .NET Provider
where one can clean up the connections. I believe in general connection
pooling model was/is not designed to have direct control (in terms of
cleaning) once its created.

-Shesh




alexandrostrf@gmail.com
Sent by: informix-list-bounces@iiug.org
21/06/2007 20:34

To
informix-list@iiug.org
cc

Subject
Re: How to clean connection pool with Informix .NET provider (Client SDK)?






Hello Sheshnarayan,
the problem is that i am using connection pooling and when a problem
occurs
i want to clean the connections that are already in the pool.
So is there a way to clear the connections that are already in the
pool ?


Sheshnarayan Agrawal :
> Did you try using "Connection Lifetime" attribute/property? For more
> information refer IBM Informix .NET Provider Reference Guide. You can
also
> check other properties "ConnectionTimeout", "Min Pool Size" and "Max
Pool
> Size" if that helps.
>
> -Shesh
>
>
>
>
> alexandrostrf@gmail.com
> Sent by: informix-list-bounces@iiug.org
> 21/06/2007 17:01
>
> To
> informix-list@iiug.org
> cc
>
> Subject
> How to clean connection pool with Informix .NET provider (Client SDK)?
>
>
>
>
>
>
> Hello ,
> does somebody know how to force to clean the connection pool with
> Informix .NET provider (client sdk) ?
>
> Thank you
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list