Re: DBCP POOL -Standard Pool Parameters for users around 500

[raj <ra...@yahoo.com>]

Hello Dirk and Other Experts,

I need help in indentifying stand DBCP POOl parameters
for approxly 200 users(using DB transaction via
connaction pooling ) and other 200 other means of DB
trasactions .
We are using JRUN 3x, Iplanet 4.1 servicepack 5,
Oracle 8.1.7. and 
commons-pool-1.1.jar and commons-dbcp-1.1.jar.

The current parameter are ..

connectionPool.setTestOnBorrow(true);
connectionPool.setTestOnReturn(true);
connectionPool.setMaxActive(400);
connectionPool.setMaxIdle(40);
connectionPool.setMinIdle(20);
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_GROW);
connectionPool.setNumTestsPerEvictionRun(20);
connectionPool.setMinEvictableIdleTimeMillis(600000);
connectionPool.setTimeBetweenEvictionRunsMillis(10000);
// 10 sec

Could some one confirm these and also specify any
potential problems as well as specify your
recommendations.

I appreciate your time and help in this regard.

Thanks in Advance.
Regards..RAJ




	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

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