Hi, One of the main points of connection pooling is to bound the number of connections you have. It's a bad design to define a connection pool that doesn't meet expected loads. If you know your app will need 10 connections concurrently, define 10 as maxActive. Don't define 5 and ask it to grow ;)
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Cristiano Moreira Silva [mailto:crisbrsp@;yahoo.com.br] >Sent: Thursday, October 24, 2002 8:24 AM >To: [EMAIL PROTECTED] >Subject: Tomcat's connection pooling > >Hello. I've installed and tested successfully an >example of JDBC access using the Tomcat's >connection pooling (JNDI + Datasource), showed at >http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples- >howto.html.However, >I've some doubts... >I'd like to know if in Tomcat's connection pooling I >can increase the number of >connections if it hasn't anyone available. You know >that in my server.xml I set >three important parameters: ># maxActive - The maximum number of active instances >that can be allocated from this pool at the same time. ># maxIdle - The maximum number of connections that can >sit idle in this pool at the same time. ># maxWait - The maximum number of milliseconds that >the pool will wait (when there are no available >connections) for a connection to be returned before >throwing an exception. >When I've seen the parameter maxWait, I've understood >that the Tomcat's Connection Pooling doesn't create >more connections if there are no >more available. Is that true or not? >Thanks in advance. > > >===== >____________________________________________________________ >Cristiano Moreira Silva >Site - http://computologo.vila.bol.com.br >E-mail - [EMAIL PROTECTED] >"Tudo posso nAquele que me fortalece." Fp. 4:13 > >_______________________________________________________________________ >Yahoo! GeoCities >Tudo para criar o seu site: ferramentas f�ceis de usar, espa�o de sobra e >acess�rios. >http://br.geocities.yahoo.com/ > >-- >To unsubscribe, e-mail: <mailto:tomcat-user- >[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:tomcat-user- >[EMAIL PROTECTED]>
This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you.
-- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
