idea-shiro项目报错BigInteger cannot be cast to java.lang.Long

最新推荐文章于 2024-05-06 18:35:17 发布

m0_37904237

最新推荐文章于 2024-05-06 18:35:17 发布

阅读量265

点赞数

CC 4.0 BY-SA版权

分类专栏： JavaEE 文章标签： java mysql jdbc

本文链接：https://blog.csdn.net/m0_37904237/article/details/109442249

JavaEE 专栏收录该内容

1 篇文章

订阅专栏

在使用Shiro连接MySQL8.0数据库时遇到错误：BigInteger cannot be cast to java.lang.Long。该问题源于MySQL版本不匹配，解决方案是升级到兼容MySQL8.0的JDBC驱动。在Maven项目中，需更新pom.xml中的mysql-connector配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用shiro连接数据库报错BigInteger cannot be cast to java.lang.Long

[com.alibaba.druid.pool.DruidDataSource]create connection error, url: jdbc:mysql://localhost:3306/crab?&characterEncoding=utf-8&serverTimezone=GMT, errorCode 0, state S1009
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:1041)
	at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3481)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown Source)
	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:399)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)
	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:785)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1410)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464)
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1969)
Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
	at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:992)
	... 20 more

经在百度搜索，出现此处问题是由于mysql的版本问题，因为本地使用的mysql版本是8.0版本，故连接数据的jar需要升级成8的，因项目使用maven构建的，故在pom.xml中修改对应的mysql-connector配置，如下：

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