Tomcat connection pool parameters??

[Lakshmi Balasubramanyam]

We are implementing the Tomcat 4.1.12 connection pooling. We have 4
different datasources bound to different databases with the same
connection pooling parameters except for the database url. We are into a
strange problem where Tomcat closes the connection after a period of
inactivity(around 2 mins) and when we try to establish a connection to
it, an Exception saying closed connection is thrown. Some times  it says
SQlException: Exhausted ResultSet and if the jsp page which is trying to
retrieve the connection is refreshed after a while I get an Exception
saying End of TNS data channel. 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 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

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>