Hello :)

I have a problem with MyBatis, I can't give names for variables and so on... Confidential data, I prefer not to give :) I have this error :

org.apache.ibatis.builder.BuilderException: Error evaluating expression ''. Return value ( //all values in list separated with comma here// ) was not iterable.

Java :

List<BigDecimal> <liste_name> = Stream.of(<one String variable>.split(",")).map(BigDecimal.new).collect(Collectors.toList());
    BigDecimal <one_id> = [recuperation here of the id...]
    Map<String, Object> map = new HashMap<>();
    map.put("<liste_name>", <liste_name>);
    map.put("<one_id>",<one id>);
    return <call here SQL request>(map);

SQL

[begining of SQL request...]
WHERE <col number 1> = <one_id>
AND <col number 2> IN
<foreach open="(" separator="," close=")" collection="<liste_name>" item="<item_name>">
    #{<item_name>}
</foreach>
[end of SQL request...]

For example, replace "" by "myListOfCars" and so on...

Thank you very, very, very much to help me :)

Comment From: harawata

Hello @Etienne-Wattebled ,

I have added a comment on your question on Stack Overflow. I'll close this issue and wait for your response there.