Mybatis BindingException Parameter '__frch_e_0' not found

Question

I'm trying to insert a list to Mybatis and getting the foloowing error:

org.apache.ibatis.binding.BindingException: Parameter '__frch_e_0' not found. Available parameters are [list]

Can you please let know what I'm missing. Thanks

DAO interface:

void saveErrorMessageList(List<ErrorMessage> emList);

XML:

<insert id="saveErrorMessageList" parameterType="java.util.List">
        {call
        declare
            ID PLS_INTEGER;
        begin
        <foreach collection="list" item="e" index="index" >
            SELECT SEQ_ERR_ID.NEXTVAL into ID FROM DUAL;

            INSERT INTO ERR (ERR_ID, CREAT_TS, 
            MSG_CD, MSG_TXT) values (ID,CURRENT_TIMESTAMP, 
            #{e.code}, #{e.message});
        </foreach>
        end
        }
    </insert>

Error Message:

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter '__frch_e_0' not found. Available parameters are [list]
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
    at com.sun.proxy.$Proxy11.insert(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
    at com.sun.proxy.$Proxy12.saveBeneErrorMessageList(Unknown Source)
    at ...
    ... 35 more

Sorry @Arsen....nope. I had to do indivdual inserts....didn't affect the performance much as the data size was small — Harry, Mar 09 '16 at 17:01

score 1 · Accepted Answer · answered Aug 17 '16 at 12:25

1

check column name and bean field name in sql
try to update mybatis version. when i use 3.3.0 have this error, but use 3.4.1 it is ok

answered Aug 17 '16 at 12:25

Yifan

1,185
12
18

Sorry for the late response...but upgrading the version to 3.4.2 fixed the issue. So I'm going to mark this as correct. Thanks – Harry Apr 05 '17 at 19:48

score 0 · Answer 2 · answered Dec 21 '15 at 11:35

0

Please check foreach tag for collection attribute. I feel value should be "emList" or add @Param (org.apache.ibatis.annotations.Param) in interface method.

    <foreach collection="emList" item="e" index="index" >

        INSERT INTO ERR (ERR_ID, CREAT_TS, 
        MSG_CD, MSG_TXT) values (CURRENT_TIMESTAMP, 
        #{e.code}, #{e.message});
    </foreach>

</insert>

answered Dec 21 '15 at 11:35

Sunny

111
7

void saveList(@Param("emList") List emList); – Harry Dec 22 '15 at 16:45
... – Harry Dec 22 '15 at 16:45
Not sure but you can try this. remove parameterType from insert tag and keep everything same as above. – Sunny Dec 23 '15 at 03:12
Why does it work in other methods without `@Param`? – Alex78191 Sep 11 '19 at 18:19

Mybatis BindingException Parameter '__frch_e_0' not found

2 Answers2