RE: Tomcat infinitely waits for connection!

[Chandolu, Yuva]

OK, I got it now, if we have maxWait<=0, tomact waits until a connection is
realeased by some other process.

-----Original Message-----
From: Chandolu, Yuva [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 7:05 PM
To: [EMAIL PROTECTED]
Subject: Tomcat infinitely waits for connection!


Hi,

I have installed Tomcat 4.1.17, JDK 1.4.1. I have apache collections 2.0,
pool 1.0, dbcp1.0 jars and Oracle's classes12.jar in common\lib. I have the
following config for my connection pool

<Resource name="jdbc/dbpool" auth="Container"
              type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/dbpool">
  <parameter>
    <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:@1.1.1.1:1521:testdb</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>username</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>password</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>20</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>10</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>0</value>
  </parameter>
</ResourceParams>

I wrote a jsp that opens a connection each time accessed and does not close
it. As you see max connections in the pool are 20. After 20 accesses Tomcat
is infinitely waiting for the connection, but I set maxWait to 0. Is this a
bug in Tomcat connection pool or is my config wrong? Please help me.

Thanks
Yuva

===================
Jsp Code:
Connection conn = null;
try
{
        Context initCtx = new InitialContext();
        DataSource ds =
(DataSource)initCtx.lookup("java:comp/env/jdbc/dbpool");
        conn = ds.getConnection();
        System.out.println("conn = "+conn.getClass().getName());
}
catch(Exception exc)
{
}
finally
{
}
===================