Connection pooling options with JDBC: DBCP vs C3P0

Posted by Dema on Stack Overflow See other posts from Stack Overflow or by Dema
Published on 2009-02-06T14:57:19Z Indexed on 2010/03/12 22:07 UTC
Read the original article Hit count: 801

Filed under:

jdbc

|

dbcp

|

c3p0

|

java

|

connection-pooling

What is the best connection pooling library available for Java/JDBC?

I'm considering the 2 main candidates (free / open-source):

Apache DBCB - http://commons.apache.org/dbcp/
C3P0 - http://sourceforge.net/projects/c3p0

I've read a lot about them in blogs and other forums but could not reach a decision.

Is there any relevant alternatives to this two?

© Stack Overflow or respective owner

Related posts about jdbc

JDBC: What is the correct JDBC URL to connect to a RAC database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We were connecting to Oracle from our code with a simple (custom) JDBC connector class. This class reads the connection properties from a resource file and tries to make a connection to Oracle (thin connection). However, recently the database have moved to a RAC and now the application is unable… >>> More
JDBC Licensing - Packaging jdbc in jar

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there. I'm packaging my open-source non-commercial java application in a .jar and I'd like to package the JDBC mysql-connector with it as it is a dependency. The issue that I am having is that I'm uncertain whether or not this is frowned upon or even illegal due to the JDBC license. I've also… >>> More
jdbc:jtds:sqlserver driver problem

as seen on Stack Overflow - Search for 'Stack Overflow'
sonar.jdbc.url: jdbc:jtds:sqlserver://127.0.0.1/SQL2008:1433/Sonar sonar.jdbc.driverClassName: net.sourceforge.jtds.jdbc.Driver sonar.jdbc.validationQuery: select 1 sonar.jdbc.username: Sonar sonar.jdbc.password: … >>> More
Memory Leak Issue in Weblogic, SUN, Apache and Oracle classes Options

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please find below the description of memory leaks issues. Statistics show major growth in the perm area (static classes). Flows were ran for 8 hours , Heap dump was taken after 2 hours and at the end. A growth in Perm area was identified Statistics show from our last run 240MB growth… >>> More
?????????????????????????|WebLogic Channel|??????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Java EE????????·????????????????/??????????????????????·?????????????????????????WebLogic Server?????????????WebLogic Server???????????????????·??????????????????????????????????????????????????????????(???)???????WebLogic Server???????　????WebLogic Server 11g(10.3.5)??????????????????????… >>> More

Related posts about dbcp

Server overloaded: DBCP issue on Mysql.

as seen on Server Fault - Search for 'Server Fault'
Hi, I have 2 setups tomcat5.5.20 on Redhat and mysql 4.1.22 on another Redhat server. Recently i started getting the repeating error(each seconds) in catalina.out: DBCP object created 2010-12-22 13:33:12 by the following code was never closed: java.lang.Exception at org.apache.tomcat.dbcp.dbcp… >>> More
Connection pooling options with JDBC: DBCP vs C3P0

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the best connection pooling library available for Java/JDBC? I'm considering the 2 main candidates (free / open-source): Apache DBCB - http://commons.apache.org/dbcp/ C3P0 - http://sourceforge.net/projects/c3p0 I've read a lot about them in blogs and other forums but could not reach… >>> More
OSGI & Apache Commons-DBCP Classloading Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I inherited some code that is using the Apache commons-dbcp Connection pools in an OSGi bundle. This code works fine with Eclipse/Equinox OSGi version 3.4.3 (R34x_v20081215), commons-dbcp 1.2.2 and the postgres jdbc3 8.3.603 bundles from springsource.org. I wanted to modernize, maybe this was my… >>> More
Where is org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory for tomcat?

as seen on Server Fault - Search for 'Server Fault'
On this page: http://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html it describes how to set up a JNDI name for a DataSource resource. It tells you that Tomcat's standard data source factory is org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory, but I've searched every single jar file on… >>> More
oracle hibernate + maven dependenciesm dbcp.basicdatasource exception

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to create a web application using maven, tomcat and hibernate. Now I'm getting a cannot find class for org.appache.commons.dbcp.basicdatasource for bean with name datasource... exception. Without the hibernate aspects it works fine, but if I add … >>> More