java.sql.SQLException: Unsupported character encoding 'utf8mb4'.

最新推荐文章于 2024-08-12 19:12:39 发布

微wx笑

最新推荐文章于 2024-08-12 19:12:39 发布

阅读量2.4w

点赞数 4

分类专栏： MySQL JAVA 文章标签： MySQL exception JDBC utf8mb4 emoji

本文链接：https://blog.csdn.net/testcs_dn/article/details/76199827

版权

博客讲述了在使用Java (JDBC) 连接MySQL时遇到'utf8mb4'字符集不支持的问题，导致SQL更新数据库失败。问题源于为处理emoji表情而在JDBC连接字符串中指定的编码。解决方案是切换到utf8mb4字符集，这是支持4字节UTF-8 Unicode编码的方法，以确保表情等特殊字符的正确存储。

摘要由CSDN通过智能技术生成

四月 12, 2017 3:47:52 下午 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet [SpringMVC] in context with path [/yuyi] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unsupported character encoding 'utf8mb4'.)

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unsupported character encoding 'utf8mb4'.)] with root cause

java.sql.SQLException: Unsupported character encoding 'utf8mb4'.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)

at com.mysql.jdbc.StringUtils.getBytes(StringUtils.java:572)

at com.mysql.jdbc.StringUtils.getBytes(StringUtils.java:717)

at com.mysql.jdbc.Buffer.writeStringNoNull(Buffer.java:700)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2720)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)