File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pooling" Watch "Connection Pooling" New topic
Author

Connection Pooling

glenn spjuver
Greenhorn

Joined: Jun 29, 2004
Posts: 11
I was wondering which connection pool to use.
I'm using Tomcat, and apparantly it provides a "DBCP" connection pool. Hibernate on the other hand, which I'm also using, has built in support for the "C3PO" connection pool. Then there is the "org.apache.commons.dbcp.BasicDataSource" which I could also use.

- What's the pros- and cons of the different pools, or is there an obvious choice?

- I could use both "C3PO" and "org.apache.commons.dbcp.BasicDataSource" in a non managed environment if I wanted to, right?

Regards
 
 
subject: Connection Pooling
 
Similar Threads
No error/exception in log on insert yet no row inserted to db
Best Connection pool API for hibernate
JPA + Pool
Error in allocating a connection. Cause: In-use connections equal
communication link failure revised