mybatis 批量新增需要返回id时候，如何处理？nested exception is org.apache.ibatis.binding.BindingException: Parameter

迈不过友情╰ 2023-07-25 08:59 4阅读 0赞

解决方法：

mybatis 3.3.0以后的版本才支持批量新增返回id，修改版本
    mybatis和mybatis-spring版本也要匹配，不然报错异常
    java.lang.AbstractMethodError: org.mybatis.spring.transaction.SpringManagedTransaction.
    getTimeout()Ljava/lang/Integer;
    
    
    <dependency>
    	<groupId>org.mybatis</groupId>
    	<artifactId>mybatis</artifactId>
    	<version>3.4.6</version>
    </dependency>
    
    <dependency>
    	 <groupId>org.mybatis</groupId>
    	<artifactId>mybatis-spring</artifactId>
    	<version>1.3.2</version>
    </dependency>

1.问题复现：pom.xml配置

<dependency>
    	<groupId>org.mybatis</groupId>
    	<artifactId>mybatis</artifactId>
    	<version>3.2.4</version>
    </dependency>
    
    <dependency>
    	<groupId>org.mybatis</groupId>
    	<artifactId>mybatis-spring</artifactId>
    	<version>1.2.2</version>
    </dependency>

调用方法相关代码

![20200413203328914.png][]

void insertBatch(List<VideoMarkPojo> videoMarkPojoList);

<insert id="insertBatch" parameterType="java.util.List" useGeneratedKeys="true"  keyProperty="id" >
    	   INSERT INTO t_video_mark 
    	   		(user_id,course_package_id,video_id,title,time,create_time)
    	   VALUES
    	   		<foreach collection="list" item="item" index = "index" separator=",">
    	   		 (#{item.userId},#{item.coursePackageId},#{item.videoId},#{item.title},#{item.time},NOW())
    	   		</foreach>
    	</insert>

执行方法异常

[nested exception is org.apache.ibatis.binding.BindingException: Parameter 'id' not found.][nested exception is org.apache.ibatis.binding.BindingException_ Parameter _id_ not found.]

3.升级mybatis 和mybatis-spring版本之后id有返回

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70][]

[20200413203328914.png]: /images/20230528/57a2377bc2c343d4b5bc64feedaf7af5.png
[nested exception is org.apache.ibatis.binding.BindingException_ Parameter _id_ not found.]: https://www.cnblogs.com/caoyajun33-blog/p/6875169.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70]: /images/20230528/52190ee530ef459da1be6a58b61efa1c.png