I have downloaded the java connector and added it to my external library, however I am still unable to connect to my database. The error occurs at
Class.forName(driver);
Error:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
I've attached a screenshot which should show everything that you need to know.
SOLUTION: Turns out, you have to put the entire downloaded file in the External Library, not just the folder that its located in
you can add mysql connector via maven dependency like this:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.22</version>
</dependency>
or you can download jar file manually at here or search on internet
then add downloaded jar file to your lib directory in project
right click on file at intellij and select 'Add as library'
I faced similar issue and this is what worked for me . Right- Click on your Project --> Maven --> Reload Project . Now the mysql-connector dependency was added under the External Libraries. enter image description here I am now able to establish connection to my MySQL DB.
I had the same issue. Just leaving this here in case it helps someone.
In my case, I cloned the repo that had the pom.xml file with an old driver that is not compatible with my local database. After cloning, I opened IntelliJ, ran the project and got the same error. Then I changed the pom.xml file with a newer driver and got into this rabbit hole.
The simple fix:
I don't know what IntelliJ does when opening a project for the first time that I cannot change afterwards. I'm sure there must be a settings somewhere that fixes since I can't find it this but this tricked helped me .
https://www.youtube.com/watch?v=T5Hey0e2Y_g
This will definitely work. But if you get an error saying,'Exporting a package from system module is not allowed with --release', then you should do the following.
Go to File->Settings->Build, Execution, Deployment->Compiler->Java Compiler: Under 'Project bytecode version' write the version of java you are using. But keep in mind that you should be using java version 11+. I've tried it and it worked perfectly.
What you can do is, in your "External Libraries Folder", there is a folder that contains various Jars provided by java. Right click on that folder (highlighted in picture attached) and click on "Open Library Settings".
It will open up a new window that will have all the jars listed up. Just below the list of all the jars you will find "+" and "-" symbols, click on the "+" symbol and add the mysql-connector jar by selecting it from the File Explorer.
Your application should work now, I am not really sure if it's the correct way to do it, but it works.
pom.xmlI think it is needless to add any path to the project structure.
Just do this thing if you are using IntelliJ Ultimate.
I just added this dependency to my project's pom.xml and my project started working properly:⤵️
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
<scope>runtime</scope>
</dependency>
