mysql connectivity problem

[vinuharan haran]

I try to query mysql server through servlet.I get an exception.
Exception:com.mysql.jdbc.Driver
I use tomcat.
Here is the Connection part of jdbc code...

   public class Alljdbc{
   Connection con;
    
  public  void Connect() {
              
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      con = DriverManager.getConnection("jdbc:mysql://localhost:3306/vinu",
        "root", "vinu");
} catch(Exception e) {
      //System.err.println("Exception: " + e.getMessage());
    }}
 

Here is the portion of servlet code...

 public class Validator extends HttpServlet
{   
Alljdbc jdbcobj;
    public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
 {
 
    jdbcobj=new Alljdbc();
     jdbcobj.Connect();  

I'm confused...
please help me out...
Thanks,
vinu.
[ July 17, 2006: Message edited by: vinuharan haran ]

[Paul Clapham]

You don't get that output from the code you posted. But let's suppose that your real code doesn't have anything commented out. You should change it to something that tells you the actual exception, like this:

catch(Exception e) {
  e.printStackTrace();
}

My prediction is that the full error reporting will tell you that a ClassNotFoundException is being thrown. If that is the case, then make sure that the jar file containing the MySQL driver is in your classpath.