Type handler was null on parameter mapping for property '__frch_uid

本文链接：https://blog.youkuaiyun.com/u012726702/article/details/78224865

本文解决了一个具体的MyBatis使用问题：当尝试通过ID列表查询数据库时出现的参数映射错误。主要介绍了如何正确配置foreach标签来避免Type Handler为空的异常，并提供了两种解决方案。

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

nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_uid_0'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.
### Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_uid_0'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

### Error querying database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_uid_0'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.

这个在

 select * from table  where id in

<foreach collection="yourList" index="index" item="item" open="(" separator="," close=")">
               #{item}       
       </foreach>

你的这个yourList  如果传递过来的是 对象的集合。那么 你应该获取的是 item.id否则就报错 
 修改为   #{item.id}

2.或者你直接把 id查出来放到集合中。那么久直接用了。不会报错。