DataRetrieving from oracle database using servlets

[Rajasekhar Pentakota]

//DataRetrieving.class file
import java.io.*;
import java.sql.*;
 
import javax.servlet.*;
import javax.servlet.http.*;
 
public class DataRetrieving extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response)throws 
                               ServletException, IOException{  
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    out.println("A program for connecting oracle database");
    try 
    {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection con = DriverManager.getConnection("jdbc :-o	 racle:thin:@localhost:1521 :-o	 RCL", "scott","tiger");
      Statement stmt = con.createStatement();
      ResultSet r = stmt.executeQuery ("SELECT ename,job,sal,comm,deptno FROM emp");
      while ( r.next() ) 
      {
      String bar = r.getString("ename");
      String bar1 = r.getString("job");
      float bar2 = r.getInt("sal");
      float bar3 = r.getInt("comm");
      int bar4 = r.getInt("deptno");
      //out.println(r.getString(0)+" "+r.getString("ename"));
      out.println("hi");
      out.println(bar1);
      }     
      r.close();
      stmt.close();
      con.close();
    } 
    catch (Exception e) 
    { 
      out.println("ERROR : " + e);
      
    }
    
  }
} 
 

//web.xml file
 

<?xml version="1.0" encoding="ISO-8859-1"?>
<!--<!DOCTYPE web-app
 PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd"> -->
 
<web-app>
 <servlet>
  <servlet-name>Hello</servlet-name>
  <servlet-class>DataRetrieving</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>Hello</servlet-name>
 <url-pattern>/DataRetrieval</url-pattern>
 </servlet-mapping>
</web-app> 
 

while running the servlet , i am unable to retrieve the data


The error message i am getting is

A program for connecting oracle database
ERROR : java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

after running the servlet.
what could be the problem?

[Freddy Wong]

Have you included the Oracle driver into your classpath?