项目报错: Parameter '__frch_item_0' not found

最新推荐文章于 2024-07-30 17:45:25 发布

明月几时还

最新推荐文章于 2024-07-30 17:45:25 发布

阅读量2.8k

点赞数

分类专栏：项目bug 文章标签： sql

本文链接：https://blog.csdn.net/weixin_43249074/article/details/83751638

版权

项目bug 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

Caused by: org.apache.ibatis.binding.BindingException: Parameter '__frch_item_0' not found. Available parameters are [list]
	at org.apache.ibatis.session.defaults.DefaultSqlSession$StrictMap.get(DefaultSqlSession.java:261)
	at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:44)
	at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:116)
	at org.apache.ibatis.reflection.MetaObject.metaObjectForProperty(MetaObject.java:138)
	at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:109)
	at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:76)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:80)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:61)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:47)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.staples.common.util.MybatisInterceptor.intercept(MybatisInterceptor.java:52)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:60)
	at com.sun.proxy.$Proxy231.update(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
	at com.sun.proxy.$Proxy231.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	... 7 more

原因：

<mapper namespace="com.staples.vp.productsmgm.dao.mapper.VendorBrandAuthMapper">
	<insert id="insertVendorBrandAuthList" parameterType="java.util.List">
		insert into VENDOR_BRAND_AUTHORIZE (VBA_UUID,VENDOR_CODE,BRAND_CODE) values 
			<foreach collection="list" item="item" index="index" separator="," close=";">
				(#{item.VBA_UUID},#{item.VENDOR_CODE},#{item.BRAND_CODE})
			</foreach>
	</insert>
	
</mapper>

中的 (#{item.VBA_UUID},#{item.VENDOR_CODE},#{item.BRAND_CODE})错误。
实体类为

	private String barUUID;
	private String vendorCode;
	private String brandCode;

这里应该是

(#{item.barUUID},#{item.vendorCode},#{item.brandCode})

所以查看参数名是否正确。
这个解决之后

Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

查找半天资料，才知道Oracle不支持像mysql的批量操作，最后修改为：

<insert id="insertVendorBrandAuthList" parameterType="java.util.List">
		insert all 
			<foreach collection="list" item="item">
				 into VENDOR_BRAND_AUTHORIZE (VBA_UUID,VENDOR_CODE,BRAND_CODE) values (#{item.barUUID},#{item.vendorCode},#{item.brandCode})
			</foreach>
		select 1 from dual
	</insert>