DBCP could not obtain an idle db connection, pool exhausted

[Galbayar]

How to solve this problem?

I'm using
Tomcat 4.1.27
J2SDK (build 1.4.1_03-b02
Tyrex 1.0
Commons DBCP 1.1
MySQL ConnectorJ version 3.0.8


My server.xml configuration

<Context ...>
<Resource name="jdbc/sss" auth="Container" type="javax.sql.DataSource"/>
  
  <ResourceParams name="jdbc/sss">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>

    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>

    <parameter>
      <name>maxIdle</name>
      <value>20</value>
    </parameter>

    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>


    <parameter>
     <name>username</name>
     <value>username</value>
    </parameter>

    <parameter>
     <name>password</name>
     <value>password</value>
    </parameter>

    
    <parameter>
       <name>driverClassName</name>
       <value>ocom.mysql.jdbc.Driver</value>
    </parameter>

    <parameter>
      <name>url</name>
      <value>jdbc:mysql://localhost:3306/sss?autoReconnect=true</value>
    </parameter>
  </ResourceParams>
  </Context>
  
  

Galbayar. D
Senior software engineer
Mobile Business Development
Business Development Division
 
MobiCom Corporation
Peace Avenue 3/1
P.O Box 20A
Ulaanbaatar 210620
Mongolia


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]