Armalai,
This is some of the parameters I noted you didn't have, BUT,
they are from the Tomcat 5, so check the docs. Just by looking at the
verbiage of the tags, they look like they might be helpful.
Tom Kochanowicz
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<!-- Maximum time to wait for a dB
connection to become available
in ms, in this example 10 seconds. An
Exception is thrown if
this timeout is exceeded. Set to -1 to
wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- To configure a DBCP DataSource so
that abandoned dB connections
are removed and recycled
-->
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
-----Original Message-----
From: armalai [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 7:53 AM
To: Tomcat Users List
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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
