Tomcat connection pool parameters??

[Lakshmi Balasubramanyam <LB...@kumc.edu>]

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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>