dbTalk Databases Forums  

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

comp.databases.informix comp.databases.informix


Discuss Re: How to clean connection pool with Informix .NET provider(Client SDK)? in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sheshnarayan Agrawal
 
Posts: n/a

Default Re: How to clean connection pool with Informix .NET provider(Client SDK)? - 06-22-2007 , 07:17 AM






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 (AT) gmail (DOT) com
Sent by: informix-list-bounces (AT) iiug (DOT) org
21/06/2007 20:34

To
informix-list (AT) iiug (DOT) 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 :
Quote:
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 (AT) gmail (DOT) com
Sent by: informix-list-bounces (AT) iiug (DOT) org
21/06/2007 17:01

To
informix-list (AT) iiug (DOT) 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 (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.