Class not found Exception

[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);

}

}

[wsaryada]

You can place you JDBC drivers jar file in the WEB-INF/lib folder of you web application. Placing any jar file inside this folder will make it available to you web application.

[surendra]

i already put that jar file under Web Content->WEB-INF->lib
but still it is not working.and give the exception:;;

java.lang.Error: Unresolved compilation problems:
Unhandled exception type ClassNotFoundException
Unhandled exception type SQLException

thanks

[maruthi_s]

Ok I don't think theres an issue with the jar file, its because the IDE which compiles your code expects the exception to be handled just add throws exception to your method and just start the server the issue will be resolved

[srithota]

Please put the statement Class.forName("oracle.jdbc.driver.OracleDriver"); within the try - catch statements and withing the catch, please catch the Exception... this should work.