Re: Cannot get a connection, pool exhausted

2007-04-23 Thread Larry Meadors
Simple question - are there more than 100 requests active when this happens? Larry On 4/21/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Now instead of set connection static i just create a new one for each query to perform, so if there are concurrent queries it shouldn't cause any problem

Re: Cannot get a connection, pool exhausted

2007-04-23 Thread David Smith
What you have below looks good as far as I can tell. Connections appear to be returned ASAP after using them. Do all your calls to the database follow this pattern? Are there any places where the connection isn't closed immediately and within a finally block? As an aside, you can store the

Re: Cannot get a connection, pool exhausted

2007-04-21 Thread Rashmi Rubdi
On 4/21/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: is there anything else i should change for getting the pool connection to work? Thanks in advance. Most of the best practices and common mistakes to avoid are covered here: http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-exampl