MySQL emoji 表情问题 Java大神请进

sinat_19250161 2017-07-27 11:35:52

报错信息



严重: Servlet.service() for servlet [springMVC] in context with path [/travel] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: 

### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'requestURL' at row 1

### The error may involve log.saveLog-Inline

### The error occurred while setting parameters

### SQL: INSERT INTO common_clientlog(clientIp,requestURL,timeConsuming,createTime)   VALUES (?,?,?,NOW())

### Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'requestURL' at row 1

; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x98\x82' for column 'requestURL' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'requestURL' at row 1] with root cause

java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'requestURL' at row 1

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

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)

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

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

	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)

	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)

	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

	at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:497)

	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:55)

	at com.sun.proxy.$Proxy39.execute(Unknown Source)

	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)

	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)

	at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:497)

	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)

	at com.sun.proxy.$Proxy37.update(Unknown Source)

	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)

	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)

	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137)

	at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:497)

	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)

	at com.sun.proxy.$Proxy16.insert(Unknown Source)

	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)

	at com.frontdo.travel.dao.impl.LogDaoImpl.saveObject(LogDaoImpl.java:27)

	at com.frontdo.travel.dao.impl.LogDaoImpl.saveObject(LogDaoImpl.java:1)

	at com.frontdo.travel.interceptor.AuthInterceptor.postHandle(AuthInterceptor.java:91)

	at org.springframework.web.servlet.HandlerExecutionChain.applyPostHandle(HandlerExecutionChain.java:149)

	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:928)

	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)

	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)

	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)

	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at com.frontdo.travel.filter.RequestParameterFilter.doFilter(RequestParameterFilter.java:45)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at com.frontdo.travel.filter.LoginFilter.doFilter(LoginFilter.java:52)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)

	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

	at java.lang.Thread.run(Thread.java:745)

DEBUG[com.frontdo.travel.interceptor.AuthInterceptor]-信息:request /travel/action/sendOrgMessage,prcess time :1ms

#本地环境
DBUrl=jdbc:mysql://localhost:3306/travel?

my.ini文件

[client]

# pipe
# socket=0.0
port=3306
default-character-set = utf8mb4
[mysql]
no-beep

default-character-set=utf8mb4

[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking

# enable-named-pipe

# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use
# socket=MYSQL

# The TCP/IP Port the MySQL Server will listen on
port=3306

# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files/MySQL/MySQL Server 5.7/"

# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 5.7\Data

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8mb4
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# Enable Windows Authentication
# plugin-load=authentication_windows.dll

# General and Slow logging.
log-output=FILE
general-log=0
general_log_file="DESKTOP-B37Q65G.log"
slow-query-log=1
slow_query_log_file="DESKTOP-B37Q65G-slow.log"
long_query_time=10

但就是还报错，请问为什么？

...全文