Driver not found mysql java

Question

i have an problem with my java program i'm trying to connect to an MYSQL database but it says driver not found i've imported mysql-connector-java into the project even with output set so it exports with the program

the class:

package com.CloudyProductions.GCDSS;

import java.sql.*;


public class mysql {

    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");
            c = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}

I've added the mysql-connector to the project via maven and did what you said but now get this error:

java.lang.ClassNotFoundException: com.mysql.cj.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)

Then almost certainly your MySQL driver JAR is not on the classpath when you are running this program. Please tell us how you are running this code, from an IDE or from the command line. — Tim Biegeleisen, Jan 30 '19 at 14:25
i export it and then run it via command prompt because i need it to run it on that way it's going to be an sort of server manager — Cloudy Productions, Jan 30 '19 at 14:26
i won't work not gonna use it if it isn't working even tried setting up new program and there in maven still doesn't work — Cloudy Productions, Jan 31 '19 at 15:02
If you use maven you read this also https://stackoverflow.com/questions/12811392/java-classnotfoundexception-with-maven-dependency — Petter Friberg, Jan 31 '19 at 15:15

ScanQR · Answer 1 · 2019-01-30T14:38:14.353

0

You need to set your mysql driver jar into the classpath through command line as follows.

//for windows
set CLASSPATH=PATH_TO_JAR

//for unix
export CLASSPATH=PATH_TO_JAR

Or you can add it during execution of your application directly using -cp as,

java -cp PATH_TO_JAR your_class_app

or -classpath

java -classpath PATH_TO_JAR your_class_app

edited Jan 30 '19 at 14:38

answered Jan 30 '19 at 14:31

ScanQR

3,740
1
13
30

i do this java -cp connector.jar -jar GCDSS.jar but gives me te error classnotfound – Cloudy Productions Jan 30 '19 at 14:39
have now the problem invalid or corrupt jarfiel – Cloudy Productions Jan 30 '19 at 14:45
but i have placed the manifest.mf and export it – Cloudy Productions Jan 30 '19 at 14:46
i'm getting te error classnotfoundexception: com.mysql.cj.jdbc.Driver – Cloudy Productions Jan 30 '19 at 14:56
what do i have to do now – Cloudy Productions Jan 30 '19 at 14:58
Your java -cp connector.jar -jar GCDSS.jar will work only if the connector.jar is in the same directory in which your GCDSS.jar is placed. In your case you have to provide the complete path e.g. -cp C:\your_dir_path_to_connector.jar and execute. – ScanQR Jan 31 '19 at 07:26
still getting the error classnotfoundexception – Cloudy Productions Jan 31 '19 at 14:22
what is the version of your jar? I think you are using different jar. You need to use latest connector. Try using 5.1.6 of mysql conncetor. – ScanQR Jan 31 '19 at 15:04

score 0 · Answer 2 · answered Jan 30 '19 at 14:31

0

From this answer:

You will have to include driver jar for MySQL MySQL Connector Jar in your classpath.

If you are using command line include the path to the driver jar using the -cp parameter of java.

For example:

java -cp C:\path\to\connector.jar Main

answered Jan 30 '19 at 14:31

Hannes Schneidermayer

4,729
2
28
32

the commandline can't find the main class – Cloudy Productions Jan 30 '19 at 14:36
i export it as an jar file – Cloudy Productions Jan 30 '19 at 14:36
You just have to add `-cp C:\path\to\connector.jar` to your current command. Please show me how you run it on the command line. – Hannes Schneidermayer Jan 30 '19 at 14:37
java -jar GCDSS.jar – Cloudy Productions Jan 30 '19 at 14:38
How about `java -jar GCDSS.jar -cp C:\path\to\connector.jar` then? – Hannes Schneidermayer Jan 30 '19 at 14:38
i have now the problem invalid or corrupt jarfile – Cloudy Productions Jan 30 '19 at 14:43
so i got it running again get again the error classnotfoundexception: com.mysql.cj.jdbc.Driver – Cloudy Productions Jan 30 '19 at 14:49
added it now via Maven stil doesn't work – Cloudy Productions Jan 30 '19 at 14:53
@CloudyProductions Which driver did you download? Which platform are you on? What does your command look like now? – Hannes Schneidermayer Jan 30 '19 at 15:18
command is java -cp connector2.jar -jar GCDSS.jar i'm using windows and for database xampp mysql – Cloudy Productions Jan 30 '19 at 15:29
driver is use now is mysq;-connector-java-5.1.47-bin – Cloudy Productions Jan 30 '19 at 15:30
the crazy thing is i did this erlier with an spigot plugin it worked without the connector there – Cloudy Productions Jan 30 '19 at 15:35
@CloudyProductions Is the error message stillt `classnotfoundexception`? – Hannes Schneidermayer Jan 31 '19 at 15:12

Driver not found mysql java

2 Answers2