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

Question

When connecting to MySQL, I get an error (see below).

Click here for code

I get this output:

run:
Now connecting to databse...

java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
    at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1062)
    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3556)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2513)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at dbms_basic.Dbms_Basic.main(Dbms_Basic.java:28)
Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
    at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1007)
    ... 15 more
BUILD SUCCESSFUL (total time: 0 seconds)

How can I solve this?

Moreover your link to code shows some other error and you have posted something different. — niks
– niks, Commented Sep 9, 2017 at 14:43

Mark Rotteveel · Accepted Answer · 2018-10-01 18:51:48Z

50

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.

edited Oct 1, 2018 at 18:51

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Sep 9, 2017 at 16:28

Rizwan

2,44724 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Rizwan Over a year ago

Bug#13958793 was already logged and resolved around this on mysql connector.

Kirill Starostin Over a year ago

changed connector's jar version from 5.1.21 to 5.1.45 - worked!

Bhaskara Arani Over a year ago

It's saved me lot of time

Rafael Parungao Over a year ago

This answer solved my issue. Thanks! I would like also to add that to easily know the versions of each of the dependencies this Maven command helped a lot. mvn dependency:tree > tree.txt

LiuYan 刘研 Dec 13, 2024 at 6:56

@Rizwan Is 'Bug#13958793' a bug number of mysql bug database? I can't find this bug report.

Sérgio M. · Accepted Answer · 2021-03-11 18:35:15Z

6

Another way, because changing the version from mysql does not worked for me, for help another people:

Long.parseLong(String.valueOf(item[0]);

answered Mar 11, 2021 at 18:35

Sérgio M.

1,3272 gold badges16 silver badges25 bronze badges

Comments

Tom Taylor · Accepted Answer · 2019-04-13 21:16:07Z

5

This issue is not there with 5.1.45 as mentioned in the above comments. Available to download at,

https://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.45/

answered Apr 13, 2019 at 21:16

Tom Taylor

3,6182 gold badges41 silver badges75 bronze badges

1 Comment

Ibrahim.H Over a year ago

Tested on 5.1.47 with no error, however a warning about SSL showed up, I had to include useSSL=false at the url connection to get a rid of it.

Ashutosh K Singh · Accepted Answer · 2020-03-20 19:29:30Z

There is a miss-match between your MySQL version, which might be the latest 8.0.19, but the MySQL driver file is older version may be 5.1.23, which is generally available with the NetBeans IDE. To overcome this, download the mysql-connector-java-5.1.48.jar from this link in your PC download connector/j 5.1.48 zip file (4.6MB)

Now right-click on project name in the netbeans IDE, go to services, in that choose 'Libraries', in it choose 'Add library', then don't opt for available libraries( the drop-down menu will list a JDBCDriver file which has 'mysql-connector-java-5.1.23.jar' file inside it, which is an older version, this is causing the miss-match). Therefore, instead click on 'Create Library', now give it any name of your choice, then click the create button, a browse window will pop-up, go to the directory where you have downloaded the 'mysql-connector-java-5.1.48.zip' folder, open it and select the java jar file 'mysql-connector-java-5.1.48.jar' and click 'ok'. The library folder of your project tree will now show 'JDBCDriver-mysql-connector-java-5.1.48.jar' added in the list of libraries(JDK and Tomcat) . Now try connecting to your database again by clicking on the 'run' button, go to the JSP link, and you see that this time you are connected.

Francois · Accepted Answer · 2019-09-20 15:07:02Z

1

For me updating the connector wasn't enough, I also had to complete my DriverManager.getConnection() url parameter with all the arguments, even if the error message was not mentionning this issue.

In my case this parameters were needed : "jdbc:mysql://127.0.0.1:3306/database?zeroDateTimeBehavior=convertToNull&serverTimezone=UTC"

Connector : mysql-connector-java-8.0.17.jar mysql version : 8.0.17

Using java on netbeans.

answered Sep 20, 2019 at 15:07

Francois

1631 silver badge10 bronze badges

Comments

Ymphaidien Sutong · Accepted Answer · 2021-03-04 08:09:21Z

1

This is a common issue when you use outdated/unsupported mysql connector driver. If youre using x86 version of Netbeans, your driver will usually be found in the Program(x86) folder an not the Program folder. something like this "C:\Program Files (x86)\MySQL\Connector J 8.0\mysql-connector-java-8.0.23.jar"

answered Mar 4, 2021 at 8:09

Ymphaidien Sutong

112 bronze badges

1 Comment

thonnor Aug 7 at 13:53

Yep I've just discovered this when resurrecting an old project and finding all the libs are out of date. MySQL 5.2.x swapped to 8.0.33 and everything has sprung into life

Lisen Saka · Accepted Answer · 2024-06-27 12:48:13Z

0

try to convert the BigInteger value into a long value like this:

**((BigInteger)(valueFromDB)).longValue()**

so first we cast the value returned from db to BigInteger value, and than BigInteger object offers a method longValue() that converts the value to a long type. for me it worked fine!

answered Jun 27, 2024 at 12:48

Lisen Saka

861 silver badge5 bronze badges

Collectives™ on Stack Overflow

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

7 Answers 7

5 Comments

Comments

1 Comment

Comments

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

5 Comments

Comments

1 Comment

Comments

Comments

1 Comment

Comments

Linked

Related