File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Connection Pool and Tomcat 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 Pool and Tomcat" Watch "Connection Pool and Tomcat" New topic

Connection Pool and Tomcat

Usambara Veilchen

Joined: Dec 07, 2000
Posts: 5
I have an application with JSP and JavaBeans, which use a Oracle8i Database. Now I want to implement connection pooling. I have tested the classes of oracle.jdbc.pool.*.
The Webserver we use is Tomcat.
Now my questions:
Can Tomcat handle connection pool by himself? Or where I have to place the oracle classes, so what the instance of the connection pool is valid over the whole time a user can use the application?
Karthik Guru
Ranch Hand

Joined: Mar 06, 2001
Posts: 1209
No tomcat will not handle datatabase connection pooling for you.
It's the role of the driver. Infact at our place we manage the connection pooling (probably a over kill since the driver manages the same).
So u must have the Oracle Driver in your classpath while
using tomcat.
I have a question here wrt what we do at our company.
We have our database manager which does pooling ..Is this an overkill?? since the driver itself does it?
jQuery in Action, 2nd edition
subject: Connection Pool and Tomcat
Similar Threads
Simple Que Abt Connection Pool
JavaBean in Servlet?
How to open a connection pool to a database?
ConnectionPooling for standalone java app
JDBC driver not loaded...class loader problem?