Thanks a lot Phil. I am using the DriverManagerConnectionFactory instead of DataSourceConnectionFactory and it works fine.
BasicDataSource does not have an option to specify the When Exhausted Action. If I use BasicDataSource then how can I specify this parameter. -----Original Message----- From: Phil Steitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 8:13 PM To: Jakarta Commons Developers List Subject: Re: [DBCP] Connection gets blocked on 9th connection. Tushar, If you want to use BasicDataSource, you need to set the pool properties using its setters (i.e., using the setters on the BasicDataSource instance). It is designed to take care of creating and managing the underlying pool and PoolingDataSource for you. Have a look at the examples here: http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/ The BasicDataSourceExample defaults the pool parameters, but ds.setMaxIdle, etc could be added to the setupDataSource method there to set those parameters. The ManualPoolingDataSourceExample shows how to do it if you want to create the pool yourself and "manually" create the PoolingDataSource from it. Phil --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
