nested exception is org.apache.ibatis.type.TypeException: JDBC requires that the JdbcType must be specified for all nullable parameters
问题解决:
其实很简单就是可以为空的字段需要配上JdbcType 映射,当然了最好全部配上
<insert id="addtest">
insert into test(age,name,status)
values
<foreach item="item" index="index" collection="list" separator=",">
(#{item.age,jdbcType=BIGINT},#{item.name,jdbcType=STRING},#{item.age,jdbcType=BIT})
</foreach>
</insert>
相关映射关系:
ps:最后送上解决问题的地址JdbcType很详细
https://blog.csdn.net/weixin_43727372/article/details/100513553