mybatis using dynamic sql foreach

Question

How to use foreach in mybatis mapper? I mean what parameters I should send there?

For example I've got this select statement

<select id="findObjectsWithIds" resultMap="SimpleObjectResult">
    SELECT * FROM testschema."XSimpleTable"
    WHERE ID in
    <foreach item="item" index="index" collection="list" 
        open="(" separator="," close=")">
            #{item}
    </foreach>
</select>

I've got interface with method

List<SimpleObject> findObjectsWithIds(List<String> ids);

I've got implementation of the interface

@Override
public List<SimpleObject> findObjectsWithIds(List<String> ids) {
    SqlSession sqlSession = MyBatisSqlSessionFactory.openSession();
    try {
        SimpleMapper simpleMapper = sqlSession.getMapper(SimpleMapper.class);
        return simpleMapper.findObjectsWithIds(ids);
    } finally {
        sqlSession.close();
    }
}

And when I make an attempt to run - I've got this error

enter image description here

How to use foreach properly?

lapots · Accepted Answer · 2014-05-20 07:48:07Z

2

The problem is solved.

I added annotation param

List<SimpleObject> findObjectsWithIds(@Param("list") List<Integer> ids);

And also I sent String representation of indices instead of Integer.

answered May 20, 2014 at 7:48

lapots

13.5k40 gold badges136 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mybatis using dynamic sql foreach

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related