If you are using 4.1.12 I don't think you need the BasicDataSourceFactory
> -----------------------------------------------
> When replying to the digest, please quote only
> relevant material, and edit the subject line to
> reflect the message you are replying to.
> -----------------------------------------------
> 
> The URL for this list is:
> http://p2p.wrox.com/list.asp?list=apache_tomcat
> APACHE_TOMCAT Digest for Monday, December 30, 2002.
> 
> 1. Tomcat connection pool exception: Closed Connection
> 
> ----------------------------------------------------------------------
> 
> Subject: Tomcat connection pool exception: Closed Connection
> From: "Lakshmi" <lbalasubramanyam@y...>
> Date: Mon, 30 Dec 2002 21:26:06
> X-Message-Number: 1
> 
> 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
> 
> 
> ---
> 
> END OF DIGEST
>