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

Greenhorn

Posts: 12

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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..

Jan Cumps

Bartender

Posts: 2662

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

OCUP UML fundamental and ITIL foundation

Rax Wer

Greenhorn

Posts: 12

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

Switching from electric heat to a rocket mass heater reduces your carbon footprint as much as parking 7 cars. Tiny ad:

Smokeless wood heat with a rocket mass heater

https://woodheat.net