Can’t connect to MySQL from Java: NullPointerException inside MySQL driver connection logic

by

It might be because you’re using an older version of the MySQL driver.
You should try using the newest version.

To get the newest version, you can check https://mvnrepository.com/artifact/mysql/mysql-connector-java

As of right now, the newest version is 8.0.11. You can download it here or add this to your pom.xml:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.11</version>
</dependency>

Update

Upon further investigation, it seems that it’s because of a change that was introduced in MySQL 8.0.1:

The issue you reported is related to the changes introduced in MySQL
8.0.1 wrt the character sets and collations support, with the addition of now being ‘utf8mb4’ the default char set. Such changes broke the
way Connector/J initializes connections.

As you know this was fixed in Connector/J 5.1.41 and I’m sure you
already updated your library.

reference

Like mentionned above, an alternative fix to your problem would have been to use the 5.1.41 instead of 5.1.40.

More Related Contents:

  1. MySQL query to get Records in Result set
  2. How to get UTF-8 working in Java webapps?
  3. Using “like” wildcard in prepared statement
  4. Android JDBC not working: ClassNotFoundException on driver
  5. MySQL and JDBC with rewriteBatchedStatements=true
  6. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  7. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  8. Unable to get spring boot to automatically create database schema
  9. Hibernate: Automatically creating/updating the db tables based on entity classes
  10. Returning a ResultSet
  11. How to change MySQL timezone in a database connection using Java?
  12. How to configure Tomcat to connect with MySQL
  13. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  14. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Software caused connection abort: recv failed [duplicate]
  15. Convert BufferedInputStream into image [duplicate]
  16. how to get list of Databases “Schema” names of MySql using java JDBC
  17. Access denied for user ‘root’@’localhost’
  18. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  19. Is there a way to retrieve the autoincrement ID from a prepared statement
  20. Why can Java not connect to MySQL 5.7 after the latest JDK update and how should it be fixed? (ssl.SSLHandshakeException: No appropriate protocol)
  21. Easiest way to convert a Blob into a byte array
  22. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  23. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  24. How to use prepared statement for select query in Java?
  25. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  26. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. Unable to get multiple Table entities through Stored procedure using hibernate
  29. JDBC connection error : unrecognized timezone [duplicate]
  30. Getting last record from mysql

Leave a Comment