unsubscribe Thanks & Regards Sandeep Shukla. REALResolution Development.
-----Original Message----- From: Phil Steitz [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 11:40 AM To: Jakarta Commons Developers List Subject: Re: [DBCP] Connection gets blocked on 9th connection. On 8/8/07, Dave, Tushar <[EMAIL PROTECTED]> wrote: > 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. > You can't set this pool parameter using BasicDataSource directly. If you really need to change the default (WHEN_EXHAUSTED_BLOCK), then you either have to follow the pattern in the ManualPoolingDataSourceExample, creating the pool yourself and setting its properties before using it to create a PoolingDataSource, or subclass BasicDataSource and add a setter that sets this property on the (protected) connectionPool member. Phil 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ******************************************************************************************************** This E-mail message and its attachments, if any are intended solely for the use of the addressee hereof. In addition, this message and the attachments, if any may contain information that is confidential, privileged and exempt from disclosure under applicable law. If you are not the intended recipient of this message, you are prohibited from reading, disclosing, reproducing, distributing, disseminating or otherwise using this transmission. Delivery of this message to any person other than the intended recipient is not intended to waive any right or privilege. If you have received this message in error, please promptly notify the sender by reply E-mail and immediately delete this message from your system. Instructions transmitted over this system are not binding on us until they are confirmed by us. Message transmission is not guaranteed to be secure or free of software virus. While Ocwen Financial Corporation and its subsidiaries collectively "Ocwen" takes every reasonable precaution to minimize such risks, Ocwen cannot accept liability for any damage sustained by you or any third party as a result of software viruses. ************************************************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]