Choosing DataSource e for Postgre database

Hi all!

We have a web application for Postgre database. During the testing we used org.apache.commons.dbcp.BasicDataSource. Now we need moving to production and we should change this basic datasource with some other one. For Oracle we use oracle.ucp.jdbc.PoolDataSourceFactory.

What is the best datasource for Postgre, considering that our application has approximately 500 users? Should it be enough if we use c3p0 ComboPooledDataSource datasource?

Thank you in advance,

Alexandr

What is wrong with the apache one is being used in production all over...

If you want something faster you could try BoneCP or the new tomcat-pool.

Thank you very much for help. We will certainly try BoneCP, their bencmark looks good.