26
New! Save questions or answers and organize your favorite content.
Learn more.
I'm new in Java, and I need to establish a connection to a MySQL server (local), I have add the libraries in Intellij idea but it seems not work, the IDE can't find the class i think... I become crazy I'm searching since two hours... I come from visual studio/c# dev environment and i think that i should miss something...
Here you can have a pic from my IDE and the simple code that I wanted use. You can also deduce that I have import the jar in my project (mysql-jdbc).
IDE pic
Edit : here is the code, the comment show where the error appear :
import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; import org.*; import com.mysql.jdbc.Driver; public class JdbcLogin { public String Login; public String MotDePasse; private boolean Logged = false; public void StartBdd(){ String driverName = "com.mysql.jdbc.Driver"; Class.forName(driverName); // here is the ClassNotFoundException String serverName = "localhost"; String mydatabase = "suptodo"; String url = "jdbc:mysql://" + serverName + "/" + mydatabase; String username = "root"; String password = "azerty"; Connection connection = DriverManager.getConnection(url, username, password); } }asked Jun 4, 2015 at 18:50
NimpNimp
4411 gold badge4 silver badges15 bronze badges
6
It's easy to configure. First just open the IntelliJ IDE and follow this simple step:
Then click on the plus(+) sign and select From Maven....
After you'll get a search box. There you should put:
mysql:mysql-connector-java:5.1.40
This will solve the issue.
answered Apr 2, 2018 at 6:14
Pronab RoyPronab Roy
1,0181 gold badge14 silver badges18 bronze badges
1
You have to add 'mysql:mysql-connector-java:5.1.40' from maven or add it as java library as shown:
answered Nov 30, 2016 at 2:41
Solution#1:Drop the mysql-connector-java-version-bin.jar file to your project, right click on it, select "Add as library".
Solution#2:Build and run with command line, for example(Windows)
- javac yourclassname
- java -cp".;mysql-connector-java-version-bin.jar" yourclassname
answered Jun 1, 2017 at 8:59
renzherlrenzherl
1511 silver badge3 bronze badges
1
If it says time zone unrecognized you can add this piece of code to the URL:
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost?useTimezone=true&serverTimezone=UTC","USER-NAME","PASSWORD");Don't forget to wrap it with a try-catch.
answered Sep 2, 2019 at 17:01
As an Update this will work with mysql:mysql-connector-java:8.0.18 as the other version will generate a new problem and won't connect to the database server.
answered Jan 8, 2021 at 6:36