CODEWITHSUNDEEP
javadatabaseconnection-poolingc3p0
jtbradle
jtbradle

Reputation: 2508

c3p0 Connection Checkin

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 = new ComboPooledDataSource();
cpds.setDriverClass(driverClass);
cpds.setJdbcUrl(url);
cpds.setUser(username);
cpds.setPassword(password);
Connection conn = cpds.getConnection(username, password);

But I am having trouble finding out how to "checkin" an already used Connection to go back into the pool. How would I go about doing this? Is there something that I'm doing wrong here?

Upvotes: 5

Views: 3458

Answers (2)

PeterMmm
PeterMmm

Reputation: 24630

Freeing up is totally transparent to the user. See here for further explanation.

Be shure to close() the Connection and hold no further reference (that would avoid proper GC).

Upvotes: 6

Kevin
Kevin

Reputation: 30419

I believe the connection is returned to the pool when you close it.

Upvotes: 4

Related Questions