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

Perfect28
– Perfect28

2014-06-30 12:41:54 +00:00
Commented Jun 30, 2014 at 12:41 — Perfect28
– Perfect28, Commented Jun 30, 2014 at 12:41
how to add jdbc driver to class path in netbeans

user3615401
– user3615401

2014-06-30 12:50:48 +00:00
Commented Jun 30, 2014 at 12:50 — user3615401
– user3615401, Commented Jun 30, 2014 at 12:50

Vivek Kumar Singh · Accepted Answer · 2017-03-12 17:46:24Z

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, 2017 at 17:46

user2768308

answered Sep 24, 2016 at 9:37

Vivek Kumar Singh

1561 silver badge6 bronze badges

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

1 Comment

intumwa Over a year ago

Straight, slick and nifty

Fhamtaom · Accepted Answer · 2017-09-21 16:07:22Z

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, 2017 at 16:07

Fhamtaom

961 silver badge3 bronze badges

1 Comment

Robby Alvian Jaya Mulia Over a year ago

Works like charm, this guy saved my night. Hell yeah

rpirez · Accepted Answer · 2014-07-01 07:30:25Z

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 1, 2014 at 7:30

rpirez

4312 gold badges8 silver badges21 bronze badges

9 Comments

user3615401 Over a year ago

ok sorry for late reply i could not connect the net. wait i will check it and say...

user3615401 Over a year ago

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....

rpirez Over a year ago

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.

user3615401 Over a year ago

now what i have to proceed. if you know could you tell me.

rpirez Over a year ago

why you want to run .Jar from desktop?

|

CertainPerformance · Accepted Answer · 2019-10-13 22:51:32Z

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, 2019 at 22:51

CertainPerformance

373k55 gold badges354 silver badges359 bronze badges

answered Oct 13, 2019 at 14:39

Chung Dao Tran

312 bronze badges

Comments

Sergio Perez · Accepted Answer · 2023-03-24 15:03:56Z

1

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

answered Mar 24, 2023 at 15:03

Sergio Perez

6617 silver badges7 bronze badges

Comments

SparkOn · Accepted Answer · 2014-06-30 12:42:42Z

0

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

answered Jun 30, 2014 at 12:42

SparkOn

8,9665 gold badges31 silver badges36 bronze badges

2 Comments

user3615401 Over a year ago

how to include the mysql connector.jar in classpath while run that

SparkOn Over a year ago

refer this it will make you more clear

naeem1098 · Accepted Answer · 2019-08-10 11:51:22Z

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, 2019 at 11:51

naeem1098

1232 silver badges9 bronze badges

Comments

MosesK · Accepted Answer · 2020-12-03 18:42:43Z

0

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.

answered Dec 3, 2020 at 18:42

MosesK

3593 silver badges7 bronze badges

Comments

Mario Pascolat · Accepted Answer · 2022-04-27 15:27:12Z

0

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

answered Apr 27, 2022 at 15:27

Mario Pascolat

133 bronze badges

Collectives™ on Stack Overflow

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

9 Answers 9

1 Comment

1 Comment

9 Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

1 Comment

1 Comment

9 Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related