Re: Oracle and web server

Mikey <mvergaranospamforme_at_ix.netcom.com> wrote:

> I am trying to learn how to set up a web site, using Apache
> as the http server, that can connect through *some kind* of
> pages (html, jsp, something else?), so I can create a java-based
> Oracle app that can run in a user's web browser.
>
> I cannot use Oracle iAS products due to licensing constraints
> (read: $$$), but I can use the Oracle http server.
>
> Can anyone point me towards a 'cookbook' that I can use to
> do and learn at the same time? This is for 8iR3 and/or 9iR2.

AFAIK the 8i and 9i releases of the database do install an HTTP listener that's basically Apache with some added modules, and JServ which is a old servlet engine. I'm not sure I'll recommend developing an app with JServ, since it supports a very old version of the Servlet Specification.

For a low cost solution, I would get a relatively recent version of Tomcat (say, >= 4.0.4) and develop JSPs and servlet with it: you connect your JSPs and servlets to the Oracle database with the Oracle-supplied JDBC driver. Choosing Tomcat has also the benefit that it's relatively well documented and that there are many ready-made frameworks that you can use, they may be of some help. In addition, many people in the various Java newsgroups and forums are familiar with Tomcat, so you'll have plenty of help.

Have a look at <http://jakarta.apache.org/> Hope this helps.

Sebastiano Pilla Received on Wed Sep 11 2002 - 14:23:17 CDT