[surendra]

I am using Eclipse 3.1 with tomcat5.5. I am building a dynamic web project,now i have a servlet which act as a controller and in its init() method i want to create connection to database, but classnotfoundException at line Class.forName("oracle.jdbc.driver.OracleDriver"); is thrown when i run this servlet.
I am confused where to put this driver class in my web application directory. or i have put jar file ..
my servlet code is given here.


package com.example.web;

import javax.servlet.http.*;
import javax.servlet.*;
import com.example.model.BeerExpert;
import java.io.*;
import java.sql.*;
import java.util.*;

public class BeerSelect extends HttpServlet {
Connection dbConnection;
public void init()
{
System.out.println(getServletName()+" : Initializing...");

Class.forName("oracle.jdbc.driver.OracleDriver");
// get a database connection
dbConnection = DriverManager.getConnection("jdbcracle:thin:@172 .28.21.25:1521:ram","s1","s1");
System.out.println("Initialized.");
}
//Creates connection in init() Retrieves parameters
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
String c = request.getParameter("color");
// response.setContentType("text/html");
// PrintWriter pw =response.getWriter();
// pw.println("ffffffffffffff"+c);

BeerExpert be = new BeerExpert();
List result = be.getBrands(c);

request.setAttribute("style", result);
RequestDispatcher rd = request.getRequestDispatcher("result.jsp");

rd.forward(request,response);

}

}