difference between PoolingDataSource and BasicDataSource

[Md Saim]

what is the basic difference between org.apache.commons.dbcp

p.PoolingDataSource and org.apache.commons.dbcp

p.BasicDataSource?

Thanks in advance.

[georgemc]

One of them pools connections. Can you guess which one?

[Md Saim]

Thanks for reply..

PoolingDataSource is pools connections

If the BasicDataSource does not use connection pooling then why does it have properties like "maxActive" which specifies "the maximum number of active connections that can be allocated from this pool at the same time".

[georgemc]

Actually, I tell a lie - both seem to pool connections. Which renders your question re-unanswered, I guess!

[Md Saim]

Yes.........

But PoolingDataSource is not working in struts1.1 connection pooling.
Because driverClassName, url, username & password parameters are not available in PoolingDataSource.

Where do we use PoolingDataSource ?

[georgemc]

Hmm. Looking at the source, PoolingDataSource is just a thin wrapper over a generic pool that you, the developer, has to provide already full of connections, and the PDS just carries out some basic management of that. Just use the BasicDataSource, it seems to do much more.