Mybatis-Plus SQLFeatureNotSupportedException: getObject with type问题解决

偏执的太偏执、 2023-09-27 16:37 87阅读 0赞

## 问题描述： ##

Error attempting to get column 'modify\_time' from result set. Cause: java.sql.SQLFeatureNotSupportedException: getObject with type  
; getObject with type; nested exception is java.sql.SQLFeatureNotSupportedException: getObject with type, stackTraceorg.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'modify\_time' from result set. Cause: java.sql.SQLFeatureNotSupportedException: getObject with type

## 问题分析： ##

1、mybatis-plus和shardingsphere集成，数据库datetime类型转java的LocalDateTime类型时调用org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult方法，会导致找不到LocalDateTime类型的ResultSet.getObject()方法。

解决办法：

（1）增加mybatis-typehandlers-jsr310依赖，该依赖重写了LocalDateTimeTypeHandler类，不过要加在mybatis-plus-boot-starter依赖之前。

<dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-typehandlers-jsr310</artifactId>
                <version>1.0.1</version>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
            </dependency>

（2）自己重写LocalDateTimeTypeHandler类，具体步骤请参考以下博客。

[Mybatis 自定义LocalDateTime类型处理器handler\_旭东怪的博客-CSDN博客人生低谷不可怕，可怕的是坚持不到人生转折点的那一天。重写LocalDateTimeTypeHandler ，解决shardingsphere + mybatis LocalDateTime转换问题。旭东怪的个人空间-旭东怪个人主页-哔哩哔哩视频。![favicon32.ico][]https://blog.csdn.net/qq\_38974638/article/details/129762669?spm=1001.2014.3001.5501][Mybatis _LocalDateTime_handler_-CSDN_LocalDateTimeTypeHandler _shardingsphere _ mybatis LocalDateTime_-_-_favicon32.ico_https_blog.csdn.net_qq_38974638_article_details_129762669_spm_1001.2014.3001.5501]

[旭东怪的个人空间-旭东怪个人主页-哔哩哔哩视频哔哩哔哩旭东怪的个人空间，提供旭东怪分享的视频、音频、文章、动态、收藏等内容，关注旭东怪账号，第一时间了解UP注动态。人生低谷不可怕，可怕的是坚持不到人生转折点的那一天![1d5330f89298af44e002d6b2230b47659e28c05a.jpg][]https://space.bilibili.com/484264966?spm\_id\_from=333.337.search-card.all.click][-_-_UP_1d5330f89298af44e002d6b2230b47659e28c05a.jpg_https_space.bilibili.com_484264966_spm_id_from_333.337.search-card.all.click]

[favicon32.ico]: https://g.csdnimg.cn/static/logo/favicon32.ico
[Mybatis _LocalDateTime_handler_-CSDN_LocalDateTimeTypeHandler _shardingsphere _ mybatis LocalDateTime_-_-_favicon32.ico_https_blog.csdn.net_qq_38974638_article_details_129762669_spm_1001.2014.3001.5501]: https://blog.csdn.net/qq_38974638/article/details/129762669?spm=1001.2014.3001.5501
[1d5330f89298af44e002d6b2230b47659e28c05a.jpg]: https://i1.hdslb.com/bfs/face/1d5330f89298af44e002d6b2230b47659e28c05a.jpg
[-_-_UP_1d5330f89298af44e002d6b2230b47659e28c05a.jpg_https_space.bilibili.com_484264966_spm_id_from_333.337.search-card.all.click]: https://space.bilibili.com/484264966?spm_id_from=333.337.search-card.all.click