Mybatis自定义SQL更新JSON字段抛错

最新推荐文章于 2025-06-04 10:31:04 发布

原创

最新推荐文章于 2025-06-04 10:31:04 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

在使用Mybatis进行数据库操作时遇到错误：Type handler was null on parameter mapping for property 'carouselPic'。该问题涉及到JSON类型的字段更新，解决方案是在SQL中指定jdbcType为VARCHAR并使用JacksonTypeHandler。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property ‘carouselPic’. It was either not specified and/or could not be found for the javaType ([Ljava.lang.String;) : jdbcType (VARCHAR) combination.] with root cause

java.lang.IllegalStateException: Type handler was null on parameter mapping for property ‘carouselPic’. It was either not specified and/or could not be found for the javaType ([Ljava.lang.String;) : jdbcType (VARCHAR) combination.

UPDATE mf_shopping.product

VISITS_NUM = #{visitsNum},

CAROUSEL_PIC = #{carouselPic},

WHERE ID = #{id}

其中CAROUSEL_PIC字段类型为JSON，修改如下即可解决

CAROUSEL_PIC = #{carouselPic,jdbcType=VARCHAR,type