SQLException: No suitable driver found for jdbc:mysql://localhost:3306/ SQLState: 08001 VendorError:

Hello All...

I am trying to connect Mysql database in eclipse with Tomcat server..

Getting an error..

Its working fine when i am using DSN name in connection,, But not working with mysql connector. Please Help...

Can anyone tell me the steps to configure all this,,

Thanks and Regards..

Hi Rax.

The error points out that the code you are running does not find the suitable driver for your connection url.
Where and when are you getting this error?
We can probably help you if we know the context.

First of all thanks for replying...

I am trying to learn eclipse, so there i made a simple servlet, made a database in mysql. Added Tomcat Apache server. but i think i am missing some step in procedure.

The Servlet program is given as::

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Third extends HttpServlet {
	
	public void doGet (HttpServletRequest req, HttpServletResponse res)
	    throws ServletException, IOException {
	    res.setContentType("text/html");
	    
	    ServletOutputStream out = res.getOutputStream();
	    out.println("<html>");
	    out.println("<head><title>Hello World</title></head>");
	    out.println("<body>");
	    
	    try {
	        out.println("You can do it man... <br/>");
		Class.forName("com.jdbc.mysql.Driver").newInstance();
	    }
	    catch (Exception E) {
		out.println("Unable to load driver.");
		E.printStackTrace();
	    }
	    
	    out.println("<br><hr>");
	    
	    try {
		Connection Conn = 
		    DriverManager.getConnection("jdbc:mysql://localhost:3306/","root","root");
	        
		// Do something with the Connection
		Statement Stmt = Conn.createStatement();
		ResultSet RS = Stmt.executeQuery("SELECT * from aa");
		
		while (RS.next()) {
		    out.println(RS.getString(1));out.println(RS.getString(2));
		}
		// Clean up after ourselves
		RS.close();
		Stmt.close();
		Conn.close();
		
	    }
	    catch (SQLException E) {
		out.println("SQLException: " + E.getMessage());
		out.println("SQLState:     " + E.getSQLState());
		out.println("VendorError:  " + E.getErrorCode());
	    }
	    
	    out.println("<h1>Hello World. </h1>");
	    out.println("</body></html>");
	}
	
    }

Output is::

You can do it man...
Unable to load driver.

SQLException: No suitable driver found for jdbc:mysql://localhost:3306/ SQLState: 08001 VendorError: 0
Hello World.

Please tell me the steps to setup driver connections in eclipse..

Thanks again.