c3p0 « Connection « Java Database Q&A

1.	Blob
2.	cassandra
3.	column
4.	Connection
5.	Cursor
6.	dao
7.	Data Type
8.	Database
9.	Database Product
10.	DataSource
11.	Date
12.	db2
13.	derby
14.	Development
15.	Driver
16.	Exception
17.	file
18.	hadoop
19.	hbase
20.	hsqldb
21.	ibatis
22.	JDBC
23.	memcached
24.	mongodb
25.	MS Access
26.	mysql
27.	ODBC
28.	Operation
29.	oracle
30.	postgresql
31.	Record
32.	result
33.	Resultset
34.	Schema
35.	SQL
36.	sqlite
37.	SQLserver
38.	Statement
39.	stored procedure
40.	sybase
41.	Table
42.	Transaction
43.	Trigger

Java Database Q&A » Connection » c3p0

1. Connection pooling options with JDBC: DBCP vs C3P0 stackoverflow.com

What is the best connection pooling library available for Java/JDBC? I'm considering the 2 main candidates (free / open-source):

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

I've read a lot ...

2. JDBC Connection pooling using C3P0 stackoverflow.com

Following is my helper class to get DB connection: I've used the C3P0 connection pooling as described here.

public class DBConnection {

    private static DataSource dataSource;
   ...

3. c3p0 Connection Checkin stackoverflow.com

I'm trying to implement a solution with c3p0 for the first time. I understand how to initialize the connection pool and "checkout" a Connection from the pool as follows:

ComboPooledDataSource cpds = ...

4. c3p0 acronym origin - jdbc connection pool name stackoverflow.com

Can anyone share the origin and meaning of the jdbc connection pool named c3p0. Was it inspired from star wars?.

5. What is the best choice for database connection pooling library? (c3p0 problem) stackoverflow.com

I have heavy loaded java application using hirbernate. And I used to use as connection pool DBCP, but it had problems with connections lossing. Than I switched to c3p0. But now ...

6. Too many busy connections using JDBCTemplate and c3p0 stackoverflow.com

I am developing a web application with database access using Spring, JDBCTemplate and c3p0. I often have a server freeze, and I am pretty sure it comes from the number of busy ...

7. Connection pool - Own implementation / DBCP / c3p0 coderanch.com

This falls under the category of 'reinventing the wheel'. There are people spending a lot of time and energy building things like database connection pools and unless you have a strong belief these implementations are flawed, better to use their work. Reminds me of an old programmer adage... "Good programmers write good code, great programmers steal good code. "