You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by Hari Haran <ha...@gmail.com> on 2004/09/11 11:18:37 UTC

DBCP Connection pooling problem (V 1.2.1)

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

Re: DBCP Connection pooling problem (V 1.2.1)

Posted by Dirk Verbeeck <di...@pandora.be>.
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