tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "p200002" <p200...@hotmail.com>
Subject Re: DBCP - connection pool exhausted
Date Mon, 28 Oct 2002 02:56:25 GMT
1. make sure that you have closed all the resultset, stmt and connections
after use.
2. set removeabandon....to recover those unclosed resource.
3. make sure you are not reading at the end of the result set.

----- Original Message -----
From: "neal" <nealcabage@yahoo.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Sunday, October 27, 2002 10:34 PM
Subject: DBCP - connection pool exhausted


> Does anyone know what causes this error when using DBCP for database
> connection pooling?
>
> "DBCP could not obtain an idle db connection, pool exhausted"
>
> Currently, I have maxActive users set to 100, and currently there are only
2
> people using the site (still in testing).  Here's my server.xml config
> details for DBCP (I replaced the sensitive data with 'xxxxx').  Please let
> me know if anyone knows why I might be having this error.
>
> Thanks!
> Neal
>
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> <Context path="" docBase="" debug="10">
>   <Resource name="jdbc/xxxxx" auth="Container" type="javax.sql.DataSource"
> />
>   <ResourceParams name="jdbc/xxxxx">
>     <parameter>
>       <name>factory</name>
>       <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>     </parameter>
>     <parameter>
>       <name>maxActive</name>
>       <value>100</value>
>     </parameter>
>     <parameter>
>       <name>maxIdle</name>
>       <value>30000</value>
>     </parameter>
>     <parameter>
>       <name>maxWait</name>
>       <value>100</value>
>     </parameter>
>     <parameter>
>      <name>username</name>
>      <value>xxxxx</value>
>     </parameter>
>     <parameter>
>      <name>password</name>
>      <value>xxxxx</value>
>     </parameter>
>     <parameter>
>        <name>driverClassName</name>
>        <value>com.mysql.jdbc.Driver</value>
>     </parameter>
>     <parameter>
>       <name>url</name>
>       <value>jdbc:mysql:///xxxxx</value>
>     </parameter>
>   </ResourceParams>
>
> </Context>
>
>
> --
> To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>
>

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message