DruidDataSource CannotGetJdbcConnectionException: Could not get JDBC Connection;

最新推荐文章于 2023-07-12 14:58:01 发布

jackhuclan

最新推荐文章于 2023-07-12 14:58:01 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/jackhuclan/article/details/79160255

Java 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一种常见的MySQL配置错误，即在连接URL中指定字符集时多输入了分号导致的问题，并提供了正确的配置方法。

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

报错如下：

### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unsupported character encoding 'UTF-8;'.
### The error may exist in file [D:\products\seedid.cn\solution\site-service\target\classes\mapper\SiteUserDao.xml]
### The error may involve cn.seedid.site.dao.SiteUserDao.findUser
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unsupported character encoding 'UTF-8;'.

com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2083) create connection error, url: jdbc:mysql://localhost:3306/test?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8;, errorCode 0, state 0S100

java.sql.SQLException: Unsupported character encoding 'UTF-8;'.

错误原因： msyql 的url：characterEncoding=UTF-8;, 多了一个分号，造成报错

所以在数据库配置文件里面只要

url: jdbc:mysql://localhost:3306/test?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8

就好了