Frequently we were getting "Cannot get a connection, pool exhausted" error
on production. I know in our application, we are closing the connection
after each connection. Here is our context.xml parameters and values. We set
maxActive connection to 100. Please let me know what we are doing wrong or
if you need more information.
<?xml version='1.0' encoding='utf-8'?>
<Context displayName="TestWeb" docBase="test" path="/test"
workDir="work\Catalina\localhost\test">
<Resource name="jdbc/TestDataSource" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDataSource">
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@test.com:1521:test</value>
</parameter>
<parameter>
<name>password</name>
<value>test123</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
</ResourceParams>
</Context>
Thanks
Kumar
---------------------------------------------------------------------------------------------------------
This e-mail message may contain privileged and/or confidential information, and
is intended to be received only by persons entitled to receive such
information. If you have received this e-mail in error, please notify the
sender immediately. Please delete it and all attachments from any servers, hard
drives or any other media. Other use of this e-mail by you is strictly
prohibited.
All e-mails and attachments sent and received are subject to monitoring,
reading and archival by Monsanto. The recipient of this e-mail is solely
responsible for checking for the presence of "Viruses" or other "Malware".
Monsanto accepts no liability for any damage caused by any such code
transmitted by or accompanying this e-mail or any attachment.
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
