Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pool and Tomcat" Watch "Connection Pool and Tomcat" New topic
Author

Connection Pool and Tomcat

Usambara Veilchen
Greenhorn

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?
Thanks!
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?
thanks
karthik.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Pool and Tomcat