java.lang.ClassNotFoundException: com.mysql.jdbc.Driver if the project built into jar

Question

I made my project use NetBeans, when I run it through NetBeans, it can run properly without any errors at all. But, when I build it into a jar file and try to login to my application, I get an error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown Source)

And in cmd :

I have been do this tutorial and it not work. And I have been read and follow tutorial that was similar with this my problem in this website and others website, but nothing work for me.

this is my library :

And this is my code

 package config;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
/**
 *
 * @author nasution
 */
public class Koneksi {
    private static Connection koneksi;
    public static Statement stm;

    public static Connection getKoneksi() throws ClassNotFoundException{
        try{
            Class.forName("com.mysql.jdbc.Driver");
                koneksi = DriverManager.getConnection("jdbc:mysql://localhost/db_surat","root","");
        }catch(SQLException e){
            JOptionPane.showMessageDialog(null, "koneksi gagal"+ e.getMessage());
        }
        return koneksi;
    }

}

this is my project that has been converted to jar :

and this is my library in folder "dist/lib" that was generated when I built the project

You can package all the dependencies with your jar or set the lib path — Thusitha Thilina Dayaratne
– Thusitha Thilina Dayaratne, Commented Nov 5, 2018 at 11:23

Karol Dowbecki · Accepted Answer · 2018-11-05 10:54:22Z

2

You need to declare required libraries in the /META-INF/MANIFEST.MF manifest file. If you look at Adding Classes to the JAR File's Classpath the syntax will be:

Class-Path: lib/mysql-connector-java-5.1.23-bin.jar

How will you modify the /META-INF/MANIFEST.MF depends on your JAR packaging mechanism, most of them give you an option to auto-generate this file.

answered Nov 5, 2018 at 10:54

Karol Dowbecki

45.3k9 gold badges83 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver if the project built into jar

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related