Sounds like a leak in you program. Check to make sure the connection,
resultset and statement are being closed.
A work around is to add:
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
To reclaim abandoned connections.
Doug
www.parsonstechnical.com
----- Original Message -----
From: "armalai" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Thursday, March 25, 2004 8:52 AM
Subject: Connection Pool
Environement: Tomcat4.x ,Windows 2000 , Oracle9i
I'm using 75 concurrent users to hit my application using Jmeter.
After 5 hours i'm getting this below error.
ERROR: Cannot get a connection, pool exhausted
1.Can you please give me an idea to tune up my settings?
2.This is something sue to server's unavailable state?
this is my data base connection setting.
<Resource name="jdbc/CONTROLLER" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/CONTROLLER">
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:oci:@CURACC_DEV</value>
</parameter>
<parameter>
<name>username</name>
<value>sysadm</value>
</parameter>
<parameter>
<name>password</name>
<value>sysadmawbs</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
</ResourceParams>
Thanks.,
MALAI
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
