Can anyone tell me how to setup Tomcat and Oracle on the same machine so that they both can be accessed through port 80.

I am using Tomcat 5.0.24 and Oracle 9i.

I would be glad if anyone can send me links to useful resources !!!

Thanks !!!!

Use server.xml in Tomcat folder to change the port no.

Open server.xml in %TOMCAT_HOME%\conf directory and edit the <Connector> element.
For SimpleTcpConnector, change the sub-element "port" value to 80. Yes, You got it


Gokulan Ethiraj

Hi,
Thank you much for your reply. Actaually, I couldn't find anything by name SimpleTcpConnector in server.xml. I searched the whole file.

Right now I am running my Tomcat on port#7000. I want it to run on port#80 because my network admin has set firewall on port#7000.

Do u know anyway of connecting Tomcat and oracle so that they both can run on same port or is there any other way out ?????

Thanks !!!

Search thru contropanel, web services like IIS, and different sercies running and get hold of port nos.


Gokulan Ethiraj

Hello,

Im not sure I understand your problem, are you asking how to change the port tomcat runs on, if so you just edit the server xml file.

When you say you want to run oracle and tomcat on the same port, do you want to access the database through tomcat, if so this can be done.

If however you want to run 2 different applications on the same port I dont think it can be done.

Hi,
Yes, this is what i want :

"When you say you want to run oracle and tomcat on the same port, do you want to access the database through tomcat, if so this can be done."

Ya, I want to access the database through Tomcat.

Thanks !!!

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:

Tomcat 5.0\common\lib

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;
    try{
        con = DriverManager.getConnection(databaseName, "dbUserName","dbPassword");

        String query = "select image from images where id ="1";
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery(query);
    rs.next();


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.

Hello again,

see you were a thrown by a previous post. The line you need to alter in server.xml is:

  <Connector port="80" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" redirectPort="8443" acceptCount="100" debug="0" connectionTimeout="20000" disableUploadTimeout="true" />

in folder:

Tomcat 5.0/conf