I wrote the following basic servlet. Most of is MyElipse generated code. One the last line where it says,
"Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");", it gives me the following error,
"Unhandled exception type ClassNotFoundException". It apparently cannot find the 'Class' class anywhere. I tried to do shift-ctrl-O, but it won't find it either. Since this is very basic java sql, does anyone have any idea why it won't find the 'Class' clas?
*****************************************************************************
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class dbServlet extends HttpServlet {
Connection dbConnection;
// constructor
public dbServlet() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the GET method");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
System.out.println(getServletName() + "Initializing");
String driverClassName = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbURL = "jdbc:odbc:data";
String username = "dbusername";
String password = "dbpassword";
// Load the driver class
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
}
************************************************************************** |