JSP Server Integrated with Oracle8i

Project 2 for CMSC691X, Summer2002, by Ching-li Peng and Ying Zhang.

Goal

Install a JSP server and an Oracle server on linux system. A servlet on JSP server will be written to read request from client's browser, make a TCP/IP connection to Oracle via JDBC, send the query to Oracle and ship the result produced by Oracle back to client in HTML. In this way, the JSP server and Oracle server are integrated together and working cooperatively.

Implementation

(1) Installation of Redhat7.2.
(2) Installation of Tomcat3.3 , which is one implementation of JSP server.
(3) Installation of Oracle8.1.7.
(4) A servlet which retrieves data from Oracle and send it to client's web browser.

Others

The slides of project presentation on 07/16/02.
Oracle8 JDBC guide.