classnotfoundexception: com.mysql.jdbc.Driver for java program

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, Jan 30 '19 at 16:14
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(); } — Cloudy Productions, Jan 30 '19 at 16:15
the connector JAR name needs to appear in the classpath. you don't appear to have the correct file name. — duffymo, Jan 30 '19 at 16:18

score 0 · Answer 1 · answered Jan 30 '19 at 16:20

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 '19 at 16:20

shasr

325
2
5

score -1 · Answer 2 · answered Jan 30 '19 at 17:32

-1

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

answered Jan 30 '19 at 17:32

D.Badreddine

1
1

ojdbc7 is for Oracle, the error indicates the OP wants to use MySQL... – Mark Rotteveel Jan 30 '19 at 18:34
Sorry i meant mysql-connector-java-8.x.jar – D.Badreddine Jan 30 '19 at 22:51

classnotfoundexception: com.mysql.jdbc.Driver for java program

2 Answers2