commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: [DBCP]
Date Thu, 04 Sep 2003 21:48:31 GMT
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: commons-user-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>      
>>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
>>    
>>
>
>  
>




---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message