commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: DBCP Connection pooling problem (V 1.2.1)
Date Sun, 19 Sep 2004 18:09:40 GMT
Hi,

You should set maxActive & maxIdle to some reasonable values.
Then monitor pool usage to see if there is still a problem.

-- Dirk

Hari Haran wrote:

> Hi,
> 
> I have configured DBCP for Oracle 9iAS (OC4j standalone) 
> we have noticed that, at times the Application performance is hit badly.
> 
> It appears to me that performance is hit when the number of users and
> connections increases.
> 
> Do I need to modify the configuration mentioned below to improve the
> performance.
> 
> Here is the configuration.
> 
> <data-source
> 		name = "BasicDataSource"
> 		class = "org.apache.commons.dbcp.BasicDataSource"
> 		connection-driver = "oracle.jdbc.driver.OracleDriver"
> 		url = "jdbc:oracle:thin:@<host>:1521:<sid>"
> 		connection-retry-interval = "1"
> 		location = "jdbc/OracleDS"
> 		username="<uid>"
> 		password="<pwd>"
> 	>
> 
> 	<property name="username" value="<uid>" />
> 	<property name="password" value="<pwd>" />
> 	<property name="url" value="jdbc:oracle:thin:@<host>:1521:<sid>" />
> 	<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
> 	<property name="defaultAutoCommit" value="true" />
> 	<property name="initialSize" value="0" />
> 	<property name="maxActive" value="0" />	
> 	<property name="maxIdle" value="0" />
> 	<property name="minIdle" value="0" />
> 	<property name="maxWait" value="60" />
> 	<property name="validationQuery" value="Select max(1) from dual" />
> 	<property name="testOnBorrow" value="true" />
> 	<property name="testOnReturn" value="false" />
> 	<property name="testWhileIdle" value="false" />
> 	<property name="timeBetweenEvictionRunsMillis" value="60000" />
> 	<property name="numTestsPerEvictionRun" value="5" />
> 	<property name="minEvictableIdleTimeMillis" value="600000" />
> 	<property name="poolPreparedStatements" value="false" />
> 	<property name="maxOpenPreparedStatements" value="100" />
> 	<property name="accessToUnderlyingConnectionAllowed" value="false" />
> 	<property name="removeAbandoned" value="true" />
> 	<property name="removeAbandonedTimeout" value="60" />
> 	<property name="logAbandoned" value="true" />
> </data-source>
> 
> 
> 
> -Hari Haran
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-dev-help@jakarta.apache.org
> 
> 
> 



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


Mime
View raw message