classnotfoundexception: com.mysql.jdbc.Driver for java program [duplicate]

Question

i have an problem could anyone help me? i'm trying to connect to mysql using java but get an error

the error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)

code :

public static Connection c;

static String host = "localhost";
static String port = "3306";
static String database = "";
static String username = "root";
static String password = "";

public static void connect() {
    try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();

        c = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
    } catch (Exception ex) {
        ex.printStackTrace();
    }
}

i've added it into my project it exports with it and to run it i use this command java -cp connector2 -jar GCDSS.jar — Cloudy Productions
– Cloudy Productions, Commented Jan 30, 2019 at 16:14
the connector JAR name needs to appear in the classpath. you don't appear to have the correct file name. — duffymo
– duffymo, Commented Jan 30, 2019 at 16:18

shasr · Accepted Answer · 2019-01-30 16:20:19Z

0

Error trace shows its not able to resolve "com.mysql.jdbc.Driver"

Check whether dependency for mysql.jar is provided in class path. If its maven project check pom.xml for mysql dependency provided

answered Jan 30, 2019 at 16:20

shasr

3752 silver badges7 bronze badges

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

Comments

D.Badreddine · Accepted Answer · 2019-01-30 17:32:52Z

-1

Just download "ojdbc7.jar" and import that jar to your project.

answered Jan 30, 2019 at 17:32

D.Badreddine

11 bronze badge

2 Comments

Mark Rotteveel Over a year ago

ojdbc7 is for Oracle, the error indicates the OP wants to use MySQL...

D.Badreddine Over a year ago

Sorry i meant mysql-connector-java-8.x.jar

Collectives™ on Stack Overflow

classnotfoundexception: com.mysql.jdbc.Driver for java program [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related