使用mybatis批量操作数据时,输出如下异常:
nested exception is org.apache.ibatis.binding.BindingException: Parameter 'oType' not found. Available parameters are [list, param1]
原因是mybatis 批量插入中的参数获取出错,下为原配置:
int insertTestObjects( List<TestObject> objectList);
<insert id="insertTestObjects" parameterType="com.xxx.TestObject">
insert into testObject (o_id,o_type, create_time)
values
<foreach collection="list" item="item" separator=",">
(#{item.oId,jdbcType=BIGINT}, #{oType,jdbcType=INTEGER},
#{item.createTime,jdbcType=TIMESTAMP})
</foreach>
</insert>
原因是批量插入的参数oType前缀忘了加了,批量操作必须使用foreach的item对应参数获取对象字段,改为item.oType就可以了:
<insert id="insertTestObjects" parameterType="com.xxx.TestObject">
insert into testObject (o_id,o_type, create_time)
values
<foreach collection="list" item="item" separator=",">
(#{item.oId,jdbcType=BIGINT}, #{item.oType,jdbcType=INTEGER},
#{item.createTime,jdbcType=TIMESTAMP})
</foreach>
</insert>