java.lang.classnotfoundexception:com.MYSQL.jdbc Driver in netbeans

Question

i did project in netbeans 7.3.1 version and converted as jar if i run the jar from the dist folder means its work properly. if i copy and paste in desktop and run means it shows java.lang.classnotfoundexception:com.mysql.jdbc driver message will show. i could not find exactly. why it shows like that and what is the solution for it. please help me. am new to this netbeans... but added the mysql connector jar file in project. but it shows that error. please help me here is my code

package aam;
import java.sql.*;
import javax.swing.*;
public class Connect {
Connection con=null;
public static Connection ConnectDB(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tnpcb","root","");      
return con;

}
catch(ClassNotFoundException | SQLException e){
JOptionPane.showMessageDialog(null, e);
return null;
}      
}
}

possible duplicate of [Adding jdbc driver to classpath](http://stackoverflow.com/questions/6434213/adding-jdbc-driver-to-classpath) — Perfect28, Jun 30 '14 at 12:41

score 13 · Answer 1 · edited Mar 12 '17 at 17:46

13

Right click on Libraries > Click on Add Library.
Scroll down to find MySQL JDBC driver.
Press Shift + F11. (Clean and Build)
Run

edited Mar 12 '17 at 17:46

answered Sep 24 '16 at 09:37

Vivek Kumar Singh

156
1
6

Straight, slick and nifty – intumwa Feb 02 '17 at 10:29

score 5 · Answer 2 · answered Sep 21 '17 at 16:07

5

Setting the classpath :

Download the JDBC MySQL Driver : https://dev.mysql.com/downloads/connector/j/
Copy file in subfolder of project (ex: libs) (not 'src')
Project->Properties->Libraries->Add Jar/Folder->Select file

And packaging dependent librairies with relative path in 'dist' :

Project->Build->Packaging->Check "Copy Dependent Librairies"
"Clean and Build"

answered Sep 21 '17 at 16:07

Fhamtaom

96
1
3

Works like charm, this guy saved my night. Hell yeah – Robby Alvian Jaya Mulia Oct 26 '22 at 17:02

score 1 · Answer 3 · answered Jul 01 '14 at 07:30

1

Right click in libraries
Add Jar/Folder
Add your mysql-connector-java-5.1.13-bin.jar
right click in you project; click on "Clean and Build";
After that go to the netbeans project folder;
It creats a new folder called:"Dist" In this folder will have a file ProjectName.Jar (Does an executable of your application);
In netbeans when you created the Jar a line appears in output and that you can copy and run in cmd.

If there is any error will appear and the Stacktrace code. And then we can better analyze the situation.

answered Jul 01 '14 at 07:30

rpirez

431
2
8
20

ok sorry for late reply i could not connect the net. wait i will check it and say... – user3615401 Jul 02 '14 at 00:05
i tried this are you said this line ah... java -jar "D:\project\aam\dist\aam.jar" if i run this line in cmd it run the jar file.... – user3615401 Jul 02 '14 at 00:17
Because then it's okay. I've also had this problem. I could not paste. Jar on the desktop and run it. I had to install a software and create an installer of my application. – rpirez Jul 02 '14 at 08:06
now what i have to proceed. if you know could you tell me. – user3615401 Jul 02 '14 at 08:21
why you want to run .Jar from desktop? – rpirez Jul 02 '14 at 09:56
if we want to give our project to any office. have to change that to exe file. to change that jar as exe file have to take separately and put in third party tool afterwards only given to office na. – user3615401 Jul 02 '14 at 10:18
The only solution I know is to transform this .Jar in an application, ie, create an installer of your application, and then you can use the application where you want. But your database is not localhost? – rpirez Jul 02 '14 at 11:07
See this tutorial: It helps you. http://www.youtube.com/watch?v=G8ccin6w4JM&index=114&list=PLB04B4E5D9B58C13D – rpirez Jul 02 '14 at 11:09
actually now only i came to online. i just downloading that video now. not yet starts to work – user3615401 Jul 02 '14 at 15:57

score 1 · Answer 4 · edited Oct 13 '19 at 22:51

1

1/ Click libraries http://prntscr.com/pio7pr

2/ Add libraries : http://prntscr.com/pio80y

3/ Scroll down to find MySQL JDBC driver :http://prntscr.com/pio8e0

edited Oct 13 '19 at 22:51

CertainPerformance

356,069
52
309
320

answered Oct 13 '19 at 14:39

Chung Dao Tran

31
2

score 0 · Answer 5 · answered Jun 30 '14 at 12:42

0

Include the dependent mysql-connector.jar in the classpath while running your application

answered Jun 30 '14 at 12:42

SparkOn

8,806
4
29
34

how to include the mysql connector.jar in classpath while run that – user3615401 Jun 30 '14 at 12:48
refer [this](http://stackoverflow.com/questions/945962/java-problem-running-a-jar-file-in-command-line) it will make you more clear – SparkOn Jun 30 '14 at 12:57

score 0 · Answer 6 · answered Aug 10 '19 at 11:51

0

If you are using MySQL 8.0, then use this driver name: "com.mysql.cj.jdbc.Driver". First of all download the libraries from the MySQL website then include them into your project. It will work smoothly.

answered Aug 10 '19 at 11:51

naeem1098

123
2
9

score 0 · Answer 7 · answered Dec 03 '20 at 18:42

I was working on Linux and encountered same error even after adding the jar and safely connecting from Services > Database window.

If you have obtained the jar and are getting same error after testing the Connection from Services > Database Window and it reports back connection success most likely you have not added the Jar in your libaries.

Go to Windows > Project > MyExampleProject > Libraries

Then Right Click > Add JAR/Folder

Add you sql-connector.jar

Now your jar is part of the libraries, now run your connection script again.

score 0 · Answer 8 · answered Apr 27 '22 at 15:27

I'had this problem, and i found a solution that worked for me, if you have a maven project you have to follow this steps in order to add a dependency:

1 - right click on the the "dependecies" foleder.

2 - click "add dependency"

3 - write this inside the window that is gonna open:

Values

score 0 · Answer 9 · answered Mar 24 '23 at 15:03

You can add driver to Pom:

Edit Pom.xml
Add the follow code between </properties> and </project>

<dependencies>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.24</version>
    </dependency>
</dependencies>

Clean and Build
Verify "mysql-connector-java.jar" into ypur project Dependencies

java.lang.classnotfoundexception:com.MYSQL.jdbc Driver in netbeans

9 Answers9