Mybatis集成MySQL驱动不兼容之 Data truncation: Truncated incorrect DOUBLE value --BUG

Springboot 2.1版本，则数据库默认依赖是mysql8.0，使用旧的配置可能造成mybatis Update无效！，

解决方案两种：1 把项目mysql依赖版本降低，指定数据库为5.X，2升级MySQL为8.0以上即可！

-------------------------------------------------------------------------------------------------------------------

1、开始我怀疑是事务没有提交，但是简单的例子中增删改查，除开update，其余几个接口都是正常的，我也加上了事务配置，问题依然，

2尝试切换数据库update失效问题消失，顿开，数据库连接驱动是该bug的原因，

3总结：遇到意外情况，检查逻辑是否有误？无误，则检查依赖是否不妥，而后密切关注依赖版本与外界组件兼容支持情况，等升级依赖版本，或者外界组件尤其需要注意！

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-parent</artifactId>

<version>2.1.1.RELEASE</version>

</parent>

依赖

数据源配置

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<scope>runtime</scope>

</dependency>

日志：

-------------------------------------------------------------------------------------------------------------

2019-01-07 20:36:41,440 -1 "ERROR" dispatch for POST "/error", parameters={}

2019-01-07 20:36:41,441 -1 Mapped to public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController.error(javax.servlet.http.HttpServletRequest)

2019-01-07 20:36:41,443 -1 Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json]

2019-01-07 20:36:41,443 -1 Writing [{timestamp=Mon Jan 07 20:36:41 CST 2019, status=500, error=Internal Server Error, message=

### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'admin更新'

### The error may involve com.arc.zero.mapper.system.SysUserMapper.update-Inline

### The error occurred while setting parameters

### SQL: UPDATE t_sys_user SET `nickname` = # {nickname,jdbcType=VARCHAR}, `avatar` = # {avatar,jdbcType=VARCHAR}, `username` = ?, `password` = ?, state = ? WHERE id = ?

### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'admin更新'

; Data truncation: Truncated incorrect DOUBLE value: 'admin更新'; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'admin更新', trace=org.springframework.dao.DataIntegrityViolationException:

### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'admin更新'

### The error may involve com.arc.zero.mapper.system.SysUserMapper.update-Inline

### The error occurred while setting parameters

### SQL: UPDATE t_sys_user SET `nickname` = # {nickname,jdbcType=VARCHAR}, `avatar` = # {avatar,jdbcType=VARCHAR}, `username` = ?, `password` = ?, state = ? WHERE id = ?

### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'admin更新'

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)

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

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

at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)

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

at com.arc.zero.service.impl.UserServiceImpl.update(UserServiceImpl.java:39)

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

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

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

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$436/251919996.proceedWithInvocation(Unknown Source)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)

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

at com.arc.zero.controller.system.UserController.update(UserController.java:76)

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

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

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

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

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

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

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

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

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

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

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

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