Re: [DBCP]

[Dirk Verbeeck]

Yes, they aren't exposed by the BasicDataSourceFactory so not directly 
usable from (tomcat) JNDI.

http://cvs.apache.org/viewcvs.cgi/jakarta-commons/dbcp/src/java/org/apache/commons/dbcp/BasicDataSourceFactory.java?rev=1.3&content-type=text/vnd.viewcvs-markup

Dirk

Rodney Waldhoff wrote:

What part of this is not in the v1.0 release?  Is it that
the JNDI/DataSource doesn't expose these properties?
On Thu, 4 Sep 2003, Dirk Verbeeck wrote:

 

Hi Mark

DBCP has the requested feature. It is not included in v1.0 so you need a
nightly build.
The parameters you are looking for are:
(A) timeBetweenEvictionRunsMillis: The number of milliseconds to sleep
between runs of the idle object evictor thread.
(B) numTestsPerEvictionRun: The number of objects to examine during each
run of the idle object evictor thread (if any).
(C) minEvictableIdleTimeMillis : The minimum amount of time an object
may sit idle in the pool before it is eligable for eviction by the idle
object evictor (if any).
Every "A" milliseconds, "B" idle connections are tested, if they are
idle for more then "C" milliseconds then they will be removed from the pool
Typical values are:
(A) timeBetweenEvictionRunsMillis: 60000   (default is disabled)
(B) numTestsPerEvictionRun: 3     (=default)
(C) minEvictableIdleTimeMillis : 1800000  (=1000 * 60 * 30)  (=default)
Regards,
Dirk
Keates, Mark wrote:

   

Hi,

I'm using pooling within a Servlet (under Tomcat) against Oracle with
'maxIdle=3' and 'maxActive=4' settings.
I do see the 4 connections drop down to 3 but the remaining connections
persist against the database.
Does anyone have a method by which these will disconnect if the connection
is idle for a given time,
i.e. no activity? If this is done on the Oracle side, then it can't be
global, i.e. affect other users.
Regards,

Mark

        <Resource name="jdbc/TestServlet" auth="Container"
                  type="javax.sql.DataSource"/>
        <ResourceParams name="jdbc/TestServlet">
                <parameter>
                        <name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                </parameter>
                <parameter>
                        <name>username</name>
                        <value>xxx</value>
                </parameter>
                <parameter>
                        <name>password</name>
                        <value>yyy</value>
                </parameter>
                <parameter>
                        <name>driverClassName</name>
                        <value>oracle.jdbc.driver.OracleDriver</value>
                </parameter>
                <parameter>
                        <name>url</name>
                        <value>jdbc:oracle:thin:@host:port:instance</value>
                </parameter>
                <parameter>
                        <name>validationQuery</name>
                        <value>SELECT 1 FROM DUAL</value>
                </parameter>
                <parameter>
                        <name>maxActive</name>
                        <value>4</value>
                </parameter>
                <parameter>
                        <name>maxIdle</name>
                        <value>3</value>
                </parameter>
                <parameter>
                        <name>maxWait</name>
                        <value>30000</value>
                </parameter>
                <parameter>
                        <name>removeAbandoned</name>
                        <value>true</value>
                </parameter>
                <parameter>
                        <name>logAbandoned</name>
                        <value>true</value>
                </parameter>
                <parameter>
                        <name>removeAbandonedTimeout</name>
                        <value>120</value>
                </parameter>
        </ResourceParams>
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************

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




     



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

 





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