File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 3740

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

[OCA 8 Book] [Blog]
It is sorta covered in the JavaRanch Style Guide.
subject: Connection pooling