It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection pooling " Watch "Connection pooling " New topic

Connection pooling

A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 980
You have 2 options for Connection pooling

a) make use of connection pooling
created & maintained by application server & access it using JNDI....

b) If datasource is not created in application server
make use of connection pooling by DBCP or C3PO

Among a & b which is the recommended approach??
And in b) which is the better option in production??
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

a) so that non-developers change the database connection.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Connection pooling
It's not a secret anymore!