Connection pool problems

From: Geraldine Hobley (GeraldineHobley_at_discussions.microsoft.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 09:33:09 -0800

Hello,
       In my program I am doing a lot of connections to the database one
after the other and retrieving lots of records from the database. However I
am getting the message below when sometimes running this program. It would
appear that I have too many connections open. Is there any way that I can get
around this, or increase the number of connections, or close connections
after they are used.

Thanx in advance
Geri

Additional information: Timeout expired. The timeout period elapsed prior
to obtaining a connection from the pool. This may have occurred because all
pooled connections were in use and max pool size was reached.

Relevant Pages

  • Re: EntLib for .NET 2.0 - January 2006 and MySQL
    ... Who created the concrete implementation for the MySql database? ... all pooled connections were in use and max pool size was reached. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: gdb help: debugging a segfault in boost::shared_ptr
    ... I am developing a database connectivity plugin for the Remedy Action ... I've developed a database pool for the plugin so the time ... The pool will also check if the connections are ... Thread-safe means that shared_ptr handle ...
    (comp.os.linux.development.apps)
  • Re: determining max pool size
    ... the larger the pool size, the more requests can be server. ... 500 open connections to SQL server I awfully lot.... ... close the connection without even executing the sql statement). ...
    (microsoft.public.dotnet.framework.aspnet)
  • JNDI Connection Pool issue
    ... I have found something strange with the jdk jndi connection pool. ... If you do not iterate over all the results returned by the query, ... private static HashMap connections; ... SearchResult searchResult= ...
    (comp.lang.java.programmer)
  • Re: MaxPoolSize - Recommendations
    ... Perhaps the pool is not leaking, ... using connections efficiently. ... for average 80 concurrent users. ... Microsoft doesn't have any recommendations concerning "max pool size" ...
    (microsoft.public.dotnet.framework.adonet)