You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I wanna batch updating the records with dynamic columns
Here is the example:
UPDATE xxx
SET
${field} = CASE id
WHEN #{item.id} THEN #{item[${field}]}
END
WHERE xxx.id IN
#{item.id}
I definitely declare correct params of the function in mapper with the @param annotation.
The inner loop with foreach tag can't be iterated.
The exception like follow:
nested exception is org.apache.ibatis.binding.BindingException: Parameter 'item' not found. Available parameters are [updateColumnList, itemList, param1, param2]