ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL

by

Your error clearly says casting is not possible, because a java.math.BigInteger class instance is not an instance of java.lang.Long class.

Now the question arises who is doing casting at what level, when we ask the JDBC driver to make a connection, it is doing lot of work behind the scene before it actually give us back the proper working object of connection.

The problem seems with your version of MySQL in combination with your version of mysql-connector.jar. Try a newer version of MySQL Connector/J (see https://dev.mysql.com/downloads/connector/j/ for the latest version), for example upgrade to 5.1.47 or 8.0.12 if you are using an older version.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. Multiple queries executed in java in single statement
  6. Java: Insert multiple rows into MySQL with PreparedStatement
  7. Handling MySQL datetimes and timestamps in Java
  8. MySQL and JDBC with rewriteBatchedStatements=true
  9. Closing JDBC Connections in Pool
  10. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  11. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  12. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  13. Returning a ResultSet
  14. How to change MySQL timezone in a database connection using Java?
  15. How to configure Tomcat to connect with MySQL
  16. Retrieve an Image stored as BLOB on a MYSQL DB
  17. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  18. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  19. mysql prepared statement error: MySQLSyntaxErrorException
  20. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  21. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  22. MySQL connector error “The server time zone value Central European Time” [duplicate]
  23. How to correctly write UTF-8 strings into MySQL through JDBC interface
  24. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  25. java.sql.SQLException: Before start of result set [duplicate]
  26. Stumped SQL Exception for JDBC
  27. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  28. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  29. java.sql.SQLException: No database selected – why?
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment