JDBC connection with MySQL:: Error

Hi. I'm trying to get information from my DB using this JDBC example and the error says that the connection could not be created to the database server. I believe that the problem is on how I imported the .jar library to the IDE. I'm new on IntelliJ.

<CODE>

package jdbcexercise;
import java.sql.*;

public class JDBCExercise {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/sga?useSSL=false";

try{
Class.forName("com.mysql.jdbc.Driver");
//Create a connection object
Connection connection = (Connection) DriverManager.getConnection(url,"root","p4assword");
Statement instruction = connection.createStatement();

String sql = "SELECT idpersona, name, lastname FROM person";
ResultSet result = instruction.executeQuery(sql);
while(result.next()){
System.out.println("Idperson: " +result.getInt(1));
System.out.println("Name: "+result.getString(2));
System.out.println("Lastname: "+result.getString(3));
}
result.close();
instruction.close();
connection.close();

}catch (ClassNotFoundException | SQLException e){
e.printStackTrace();
}

}
}



The exception that was thrown is the next.

/Library/Java/JavaVirtualMachines/jdk-11.0.2.jdk/Contents/Home/bin/java "-javaagent:/Applications/IntelliJ IDEA CE.app/Contents/lib/idea_rt.jar=61610:/Applications/IntelliJ IDEA CE.app/Contents/bin" -Dfile.encoding=UTF-8 -classpath /Users/emmanuielcuevasaparicio/Documents/GitHub/Java-projects/JDBCexercise/out/production/JDBCexercise:/Users/emmanuielcuevasaparicio/Documents/GitHub/JDBC/mysql-driver.jar jdbcexercise.JDBCExercise
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at jdbcexercise.JDBCExercise.main(JDBCExercise.java:11)
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:3005)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1916)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1845)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1215)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2255)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
... 13 more
 
Process finished with exit code 0
 
And this is the library configuration.
 
Image 1. Modules configured in the project structure.
 
Image 2. Libraries configured in the project structure.
0

Please sign in to leave a comment.