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]
