Purpose:

Show how to develop web application like JSP/Servlet that is connected to Oracle database via JDBC-Thin. Then show how to complier and create WAR file and finally deploy it to Jakarta-Tomcat 4.1.12 Servlet/JSP container.

Attendees:

J2EE Beginner

Prerequisites:

1. Jakarta-Tomcat 4.1.12. Download from Jakarta-Tomcat Apache.
2. ANT 1.5.1 tool for building the WAR file. Download from ANT Jakarta Apache.
3. J2SE SDK. Download from Java Sun.
4. Oracle JDBC driver. Download from OTN.

Assumption:

Oracle database server is available and already startup.

Steps to do:

1. Install and configure software
2. Design working directory structure
3. Create developing environment
4. Develop web application
5. Deploy web application to Jakarta-Tomcat
6. Test web application

Details:

Download the document (pdf 66kb)

Note:

If you get "Can't find Servlet" message when deploying Tomcat 4.1.12, please make sure you have already added "<servlet-mapping>" entry in "web.xml".

Download sample code:

- simple_jsp_01.jsp **
- HowToOracleServlet.java **
- Build.xml
- Web.xml
- simpleWar.war

** IE users need to right-click and 'Save Target As' to download the file.

Reference:

- http://jakarta.apache.org/ant/manual/index.html
- http://jakarta.apache.org/tomcat/tomcat-4.1-doc/index.html

More Information:

- http://jakarta.apache.org/

Keywords:

Catalina, CATALINA_HOME, oracle, jdbc, tomcat , tomcat 4.1.12, java, jsp, servlet, WAR, ANT, container , classes12.jar, nls_charset12.jar