Re: How can I use db pool and ...?

[Aaron Mulder <am...@alumni.princeton.edu>]

1) As far as I know tomcat doesn't have built-in support for database
pools.  However, you can include the Oracle thin JDBC driver in the tomcat
classpath and make Oracle connections - you just need to handle any
pooling yourself.

2) Tomcat is made to work with Apache on port 80.  It also comes with its
own HTTP server, which can listen on a different port.  To set it up with
apache, edit the .conf file that comes with tomcat (under etc/ I think) to
list the "web apps" that you want to make visible to Apache, install the
mod_jserv module in your Apache modules directory, and include the tomcat
.conf in your httpd.conf for apache.
	I don't know of a way to make Tomcat aware of URLs at the highest
level (/foo.jsp as opposed to /webapp/foo.jsp).  Perhaps that's
possible if you make a generic .jsp handler (which I think is the
default).  Maybe someone else can indicate whether you can do that for
servlets?

3) I have had no stability problems in the real world, running a
low-traffic web site with Tomcat handling the servlets.  Everything I have
read here has led me to believe Tomcat is not yet ready for heavy-traffic
web sites, though.  At work, we're using WebLogic for EJB+Servlets with
Oracle.  That'll set you back some cash, but if you're running Oracle, you
must have some cash to spare.

Aaron

On Fri, 10 Mar 2000, DonS, Choi wrote:
> Hi,
> 
> I am testing jakarta-tomcat.
> I have some question.
> 
> 1. My company use oracle DB. Is it possible tomcat to use db pool for
> connecting oracle DB? 2. I want to setting tomcat to cooperate with
> the apache webserver. Is it possible for tomcat to use port 80?
>     I mean apache use port 80 and also tomcat use port 80. For example
> when user connect http://a.com/jsp, Tomcat serves that request and
> user connect http://a.com/foo apache serves the request.
> 
> 3. Is tomcat stable enough in real world?  Is tomcat performance good
> in heavy traffic?
> 
> Thanks advance.
>