kotlin, spring, mybatis cannot execute foreach

Viewed 25

I tried to execute this sql but Exception happened.

source code is here

    @Select(
        """
            SELECT 
                COUNT(*)
            FROM 
                order
            WHERE 
                order_id IN 
            <foreach item="id" collection="orderIds" open="(" separator="," close=")" >
                #{id}
            </foreach>
        """
    )
    fun findByOrderIds(@Param(value = "orderIds") orderIds: List<String>): Int

Error message is here↓ nested exception is org.apache.ibatis.binding.BindingException: Parameter 'id' not found. Available parameters are [orderIds, param1]

I cannot find wrong point. If you have idea please let me know.

0 Answers
Related