Mybatis-plus: 3.1.1，mybatis 3.5.1中对于java.time包LocalDateTime,LocalDate,LocalTime类型的处理与mybatis 3.5.0有所不同

Created on 7 May 2019  ·  22Comments  ·  Source: baomidou/mybatis-plus

当前使用版本(必须填写清楚，否则不予处理)

3.1.1

该问题是怎么引起的？(最新版上已修复的会直接close掉)

mybatis-plus 3.1.1版本更新了mybatis的版本，由原先的3.5.0更新到了3.5.1，但是因为mybatis 3.5.1版本对于java.time包下LocalDateTime,LocalDate,LocalTime类型的转换交由了JDBC，若JDBC组件不支持对于LocalDateTime类型的处理则会报错。现在项目中运用的是alibaba druid数据库连接池，在druid最新版本中尚不支持对于LocalDateTime的处理，会throw SQLFeatureNotSupportedException，提请注意。

image

image

重现步骤

1.定义实体类中某一字段类型为LocalDateTime或LocalDate或LocalTime
2.查询

报错信息

org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'creation_time' from result set. Cause: java.sql.SQLFeatureNotSupportedException
; null; nested exception is java.sql.SQLFeatureNotSupportedException
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:96)
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.$Proxy72.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
at com.sun.proxy.$Proxy77.selectOne(Unknown Source)
at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.getOne(ServiceImpl.java:259)
at com.baomidou.mybatisplus.extension.service.IService.getOne(IService.java:192)
at top.uravity.iden.kernel.service.impl.SysUserServiceImpl.getSysUserByUsername(SysUserServiceImpl.java:148)
at top.uravity.iden.system.controller.SysLoginController.login(SysLoginController.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
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:892)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
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.doGet(FrameworkServlet.java:897)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
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)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at top.uravity.iden.kernel.xss.XssFilter.doFilter(XssFilter.java:26)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

picture SanStoneY

Most helpful comment

druid 1.1.21解决了这个问题，亲测

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.21</version>
</dependency>
picture fangtianq on 5 Feb 2020
👍5

All 22 comments

问题不是mybatis-plus自身导致的，是druid 1.1.16导致的，究其原因，是因为3.1.1版本引用的mybatis 3.5.1修改了对于LocalDateTime的处理，然而druid还没有支持对于LocalDateTime，所以就报错了，如果有什么描述不清楚的，还请见谅，-_-

SanStoneY picture SanStoneY on 7 May 2019

换连接池

miemieYaho picture miemieYaho on 7 May 2019

一定要换连接池嘛，这么极端的嘛

SmNiuhe picture SmNiuhe on 21 May 2019

HikariCP 值得用，百度下

qmdx picture qmdx on 21 May 2019

3.1.0 是正常的

hocgin picture hocgin on 26 May 2019

durid的问题？？？为什么 我的mybatis-plus 3.1.1 +hikari 也不行。。。
image。我把mybatis-plus换到3.1.0 ，不换连接池，问题还在。。。

huluobo11 picture huluobo11 on 6 Jun 2019
👍2

image
上面的写法会报错的，换成双冒号写法时，是正常的。。。

huluobo11 picture huluobo11 on 6 Jun 2019

连接池 换成 hicaricp 3.3.1 ,没有解决问题。只能将mp降回 3.1.0 了

5468sun picture 5468sun on 20 Jul 2019

连接池 换成 hicaricp 3.3.1 ,没有解决问题。只能将mp降回 3.1.0 了

jdbc 驱动换成新的，低版本的可能还没有做支持

qmdx picture qmdx on 20 Jul 2019

连接池 换成 hicaricp 3.3.1 ,没有解决问题。只能将mp降回 3.1.0 了

jdbc 驱动换成新的，低版本的可能还没有做支持

管用。多谢。

5468sun picture 5468sun on 21 Jul 2019

mysql.connector.java 8.0.17
druid 1.1.20
mybatis.plus 3.2.0

可以

cloud915 picture cloud915 on 10 Oct 2019

mysql.connector.java 8.0.17
druid 1.1.20
mybatis.plus 3.2.0

可以

我的还是不行，报错

rbw204 picture rbw204 on 25 Oct 2019

mysql.connector.java 8.0.17
druid 1.1.20
mybatis.plus 3.2.0
可以

我的还是不行，报错

我也不行

yao00jun picture yao00jun on 29 Oct 2019

mysql.connector.java 8.0.17
druid 1.1.20
mybatis.plus 3.2.0 试了可以感谢

ChubChen picture ChubChen on 14 Nov 2019

mysql.connector.java 8.0.17
druid 1.1.21
mybatis.plus 3.2.0
可以的

chgmxx picture chgmxx on 3 Dec 2019

druid 1.1.21解决了这个问题，亲测

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.21</version>
</dependency>
fangtianq picture fangtianq on 5 Feb 2020
👍5

@fangtianq thanks, you save me a lot!

yusiwen picture yusiwen on 1 Apr 2020

druid 1.1.21解决了这个问题，亲测

<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid-spring-boot-starter</artifactId>
  <version>1.1.21</version>
</dependency>

完美解决

leoFitz1024 picture leoFitz1024 on 11 Apr 2020
👍1

也可以通过引入依赖解决


org.mybatis
mybatis-typehandlers-jsr310
1.0.1

https://www.jb51.net/article/123127.htm

stjava picture stjava on 9 May 2020

问题不是mybatis-plus自身导致的，是druid 1.1.16导致的，究其原因，是因为3.1.1版本引用的mybatis 3.5.1修改了对于LocalDateTime的处理，然而druid还没有支持对于LocalDateTime，所以就报错了，如果有什么描述不清楚的，还请见谅，-_-
可以了，给druid改成最新的就可以

cutety picture cutety on 3 Sep 2020

这个问题最终结论是啥呢？

hdwmp123 picture hdwmp123 on 6 Feb 2021

这个问题最终结论是啥呢？

更新druid版本到最新

cutety picture cutety on 6 Feb 2021
Was this page helpful?
0 / 5 - 0 ratings

Related issues

liangzhi2019 picture liangzhi2019  ·  3Comments
UnknownDeveloper007 picture UnknownDeveloper007  ·  8Comments
zzdehao picture zzdehao  ·  6Comments
juzi214032 picture juzi214032  ·  3Comments
xlb picture xlb  ·  6Comments