No suitable driver problem

Hi, This is my first servlet program. I wanted to try to
connect to oracle database. I have tomcat5.5.9 , JDK1.4,
oracle9i installed. I have copied the ojdbc14.jar file in
the common/lib folder. But I get the error as
SQLException: No suitable driver SQLState: 08001 VendorError: 0
I'm not sure why this occurs. I have learnt that ojdbc14
has the appropriate oracle driver. Please help.
The servlet code is as follows

import java.io.*;
 
import javax.servlet.*;
import javax.servlet.http.*;
 
import java.sql.*;
 
public
    class HelloWorldServlet extends HttpServlet {
 
public void doGet (HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException {
    res.setContentType("text/html");
 
    ServletOutputStream out1 = res.getOutputStream();
    out1.println("<html>");
    out1.println("<head><title>Hello World</title></head>");
    out1.println("<body>");
 
    try {
// The newInstance() call is a work around for some
// broken Java implementations
        out1.println("Set up the oracle driver");
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
                  out1.println("Class found");
                  
    }
    catch (Exception E) {
out1.println("Unable to load driver.");
E.printStackTrace();
    }
 
            out1.println("<br><hr>");
 
    try {
String url = "jdbc :-o	 racle:thin:@DCXHEILER:1521 :-o	 rcl";
                        out1.println(url);
Connection Conn =
  //  DriverManager.getConnection("jdbc:mysql://sql.useractive.com/USERNAME?user=USERNAME&password=PASSWORD");
DriverManager.getConnection("url", "system", "password");
                out1.println("\n got the connection");
// Do something with the Connection
Statement Stmt = Conn.createStatement();
                out1.println("Created the statement");
ResultSet RS = Stmt.executeQuery("SELECT * from Candidate");
                out1.println("created resultset");
                out1.println("Displaying the result set");
 
while (RS.next()) {
    out1.println(RS.getString(1));
}
                out1.println("Displayed the resultset");
// Clean up after ourselves
RS.close();
Stmt.close();
Conn.close();
 
    }
    catch (SQLException SE) {
out1.println("SQLException: " + SE.getMessage());
out1.println("SQLState:     " + SE.getSQLState());
out1.println("VendorError:  " + SE.getErrorCode());
                SE.printStackTrace();
    }
    out1.println("<h1>Hello World. Sun... 1.4</h1>");
    out1.println("</body></html>");
}
 
public String getServletInfo() {
  return "Create a page that says <i>Hello World</i> and send it back";
}
    }

Acording to this, if the driver fails to load, the exception will be reported but the code will continue to run. One problem may be failing to load the Class which then reports 'not suitable driver' when you go looking for it.

Hi David O'Meara,
Thanks for the reply. But, that part of the code is executed, since I get the "Class found" statement on the browser.

I got it working. It was the problem with the double quotes for url ...

Oh of course

Nice catch, thanks for reporting back.

Dave