commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "MC Sekhar" <>
Subject [dbcp] BasicDataSource Hangs
Date Mon, 11 Oct 2004 03:56:01 GMT

	We have a product in healthcare completely written using J2EE. We are
currently running the product on Oracle 9iAS and Oracle database
enterprise edition. We are using the Thin driver to connect to the database.
Due to teh problems with Oracle's connection cache implementations, wer
switched to DBCP for the connection pooling. At our development labs, we
donot have any issues and the pooling works fine. But when we put DBCP in
our production sites we are having a major problem, even with a concurrent
user load of 20 to 50(we are unable to simulate this in our development

	From the feedback we have got from the customer, when there is a resource
intensive query, taking up much of the resources on the database server,
DBCP refuses any new connection requests. This has been reported even when
there are about  10 Db connections in the pool. But they are able to connect
to the database using the SQLPlus Client. The following is the datasource

			name = "BasicDataSource"
			class = "org.apache.commons.dbcp.BasicDataSource"
			connection-driver = "oracle.jdbc.driver.OracleDriver"
			url = "jdbc:oracle:thin:@<machine_ip>:<port_no>:<sid>"
			connection-retry-interval = "1"
			location = "jdbc/OracleDS"

			<property name="username" value="<user_id>" />
			<property name="password" value="<password>" />
			<property name="url"
value="jdbc:oracle:thin:@<machine_ip>:<port_no>:<sid>" />
			<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"

			<property name="defaultAutoCommit" value="true" />

			<property name="initialSize" value="10" />
			<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 1 from dual" />
			<property name="testOnBorrow" value="true" />
			<property name="testOnReturn" value="true" />
			<property name="testWhileIdle" value="true" />
			<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="180" />
			<property name="logAbandoned" value="true" />


 Any suggestions ??

 Thanks in advance.

 Chandra Sekhar

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message