Ok, I assume you read the previous post about the file server.xml
Find the line that sets the port and change it to port 80.
You then need to find the appropriate driver for oracle which should be a .jar file. Im not sure where you would get that from. The Jakarta Apache Tomcat site would be a good start, Im pretty sure they have files or links in there somewhere.
Once you have the file, simply drop it into the following directory:
Thats your driver installed!
There are then 2 ways to access your database, one is to code directly in JSP with something like this mySql example
String databaseDriver = "org.gjt.mm.mysql.Driver";
// Open a database connection
Class.forName( databaseDriver );
String databaseName = "jdbc:mysql://localhost/test";
Connection con = null;
con = DriverManager.getConnection(databaseName, "dbUserName","dbPassword");
String query = "select image from images where id ="1";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(query);
This code is not complete, just an example.
I would NOT recomend you do this (code connection in JSP or Beans). You would be much better off using JNDI to set up the database connection. This will allow you to use database pooling later on.
The best tutorial I have found on this is actually within the tomcat documentation. If you connect to the tomcat page on http://localhost
and go to the Tomcat Documentation link in the middle of the page, then go to the JDBC Datasources link down the left hand side it will tell you all you need to know.