Hi:



I am implementing the Tomcat 4.1.12 connection pooling. I different 
datasources bound to different databases with the same connection pooling 
parameters except for the database url. I am into a strange problem where 
Tomcat closes the connection after a period of inactivity when I refresh 
my jsp page I get a 
java.sql.SQLException: Closed Connection
and some times when I revisit the jsp page after a 2 mins or so i get 
java.sql.SQLException: Exhausted Resultset. 
This happens sporadically. Also I have all my connections. reslutsets. 
statements closed in my code.

Does anyone have a configuration for the Tomcat connection pooling that 
has worked out well..Is there anything that I am not setting right in the 
server.xml?? Any suggestions will be very helpful..

Here is the portion of the server.xml  connection pool settings..

<ResourceParams name="jdbc/classroom">
<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>url not specified here</value>
</parameter>
<parameter>
<name>username</name>
<value>oraclass</value>
</parameter>
<parameter>
<name>password</name>
<value>elite8</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/ejournals" auth="Container" 
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ejournals">
<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>url not specified here</value>
</parameter>
<parameter>
<name>username</name>
<value>ejourn1</value>
</parameter>
<parameter>
<name>password</name>
<value>easy123</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
    <parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>

Thanks
-Lakshmi