File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes Connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Connection pool" Watch "Connection pool" New topic

Connection pool

Ken Shamrock
Ranch Hand

Joined: Jan 23, 2002
Posts: 139
In the past, I used to make use of connection pool when connecting to MySQL using Servlet; now, I will connect Oracle via Servlet, I wonder if I still need to make a connecting pool in Servlet? Or Oracle already have this kind of function so that I don't need to take care of this when programming? Thanks

Thanks everyone who helped me
Ray Stojonic
Ranch Hand

Joined: Aug 08, 2003
Posts: 326
It's my understanding that a DataSource is the preferred way to connect to a database from Servlets. It will do it's own pooling, so you don't have to worry about it.

How to Setup (and use) a DataSource on Tomcat
I agree. Here's the link:
subject: Connection pool
Similar Threads
Tomcat 6.0.32 only connects to first deployed application configuration
how get the database connection in eclipse IDE
Store Connection Pool
recreating damaged connection in pool
connection pool ? (JBoss / DBCP / c3po )