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
{
}
===================