To use Java Server Pages with JDBC, you will need multiple source files. We illustrate this with two example files:

First, make sure that your tomcat access is set up according to the information provided here, and that you've followed the instructions to set up your account for oracle here.

Then, install the samplejdbc.jsp file into your jsp subdirectory. As always you need to set the permissions so this file is readable. Change access mode for the .jsp and .class in the command line like this:

chmod 755 Filename.
This means the file can be read and executed by the world.

Next, change the username and password inside the java file; Compile this java file, put the compiled .class file under Romulus:
/ug/resource/tomcat_webapps/<YOUR_USER_ID>/WEB-INF/classes/ProjectConnection/
(You need to create the ProjectConnection directory)

It is convenient to use a ConnectionBean so that you can avoid writing the same code whenever you are trying to connect to the database.