Connect mysql with java

Question

I am trying to connect to mysql in java (I use Wamp) so I used the following code : (I'm using Eclipse)

package genererPlanning;
import java.sql.*;

public class genererPlanning{
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost/mysql";

    static final String USER = "root";
    static final String PASS = "";

    public static void main(String[] args){
        Connection conn = null;
        try {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "");
        }
        catch (SQLException ex){
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: " + ex.getSQLState());
            System.out.println("VendorError: " + ex.getErrorCode());
        }
    }
}

But it returned me this text :

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

Do you know why it does not work?
PS : I looked at theses links but don't find my answer :
- stackoverflow
- stackoverflow
- stackoverflow
- commentcamarche

Thanks for all.

Do you have the mysql driver lib (jar file) in your build path? — aw-think
– aw-think, Commented May 27, 2015 at 10:38
Indeed, this was not mentioned in the tutorial. Can you tell me where to find ( and add) this .jar please ? — Antoine Duval
– Antoine Duval, Commented May 27, 2015 at 10:41
All the linked questions answer the question - apparently you can't recognize it as an answer. Do you know how to work with jar libraries and/or the Java classpath? — Gimby
– Gimby, Commented May 27, 2015 at 11:25

Meghdeep Ray · Accepted Answer · 2015-05-27 10:42:47Z

1

You need to use the mysql-connector.jar

Here's the link with instructions as to how to set it to your classpath.

http://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar&

answered May 27, 2015 at 10:42

Meghdeep Ray

5,6254 gold badges37 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ragu · Accepted Answer · 2015-05-27 10:42:41Z

1

You need mysql jdbc connector..download from this site

answered May 27, 2015 at 10:42

Ragu

3735 silver badges15 bronze badges

Collectives™ on Stack Overflow

Connect mysql with java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related