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

最新推荐文章于 2025-10-13 10:33:30 发布

原创

最新推荐文章于 2025-10-13 10:33:30 发布 · 2.4w 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #exception #JDBC #utf8mb4 #emoji

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

四月 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)