 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | JSP - A mailing list about Java Server Pages specification and reference | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | AW: Connection Pooling | AW: Connection Pooling 2006-11-14 - By Eickvonder Bjoern
Back
Hi,
>
> <Resource name="jdbc/JSNDB" auth="Container"
> type="javax.sql.DataSource  "
> maxActive="50" maxIdle="30" maxWait="10000"
> removeAbandoned="true"
> removeAbandonedTimeout="10" logAbandoned="true"
> username="root" password="letmein2006"
> driverClassName="com.mysql.jdbc.Driver "
>
url="jdbc:mysql://localhost:3306/kurdishglobe_net?autoReconnect=true"/>
> 1- does this mean that 50 connections will be made available
> when the web app is loaded?
No, "maxActive" - as the name says - is only the maximum number of
connections. "initialSize" would create them on startup.
> 2- what happens if all the 50 connections are used up and
> there are more db connection requests?
Your requesting thread would wait 10000 ms (defined by maxWait) for a
connection. If time is over an exception is thrown.
> 3- what about the maxIdle="30"; there cannot be more than 30
> idle connections ?
Yes, so in total for your configuration it means that your pool will
have 0 to 30 idle connections but is able to open up to 50 connections
if there is a really high load. The pool will - as far as I know - not
decrease idle connections in your configuration as
"timeBetweenEvictionRunsMillis" is not set.
Moreover connections that are not properly returned to the pool (by
closing it) will be considered abandoned after 10 seconds and then
closed/removed. Moreover this event will be logged out to the console
together with a stacktrace of the application code that failed to close
the connection.
For more information see
http://jakarta.apache.org/commons/dbcp/configuration.html
Bjoern
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich
erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail bzw. Inhalte
hieraus ist nicht gestattet.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
|
|
|
