Ibatis insert operation

Question

Hi I am trying to insert a list of object through ibatis but i am getting an exception like org.apache.ibatis.mapping.SqlMapperException: The expression 'boxlist' evaluated to a null value.

<insert id="insertList" parameterType="java.util.List">
    INSERT INTO boxtable (
    size,length)
    VALUES
    <foreach item="box" collection="boxList" separator=",">
        (#{box.size},#{box.length})
    </foreach>
</insert>

My dao class is like

public void insert(List<box> boxList)
        throws SQLException {

    try {                            
        sqlSession = sqlSessionFactory.openSession(AUTO_COMMIT); 
        int status = sqlSession.insert("insertlist", boxList);
        logger.debug("status :: " + status);
        sqlSession.commit();
    } catch (Throwable ee) {
        logger.error("e", ee);
    sqlSession.rollback();
    } finally {
        sqlSession.close();
    }

}

Can anyone help me out???

The error message is pretty clear I think. The value you're sending into the expression evaluates to `null` — NilsH, Apr 15 '13 at 05:22
No list is not empty..I am calling this function from other function and passing the list — Parekh Shah, Apr 15 '13 at 05:24

score 1 · Answer 1 · answered Apr 15 '13 at 05:45

1

If I remember it right you need to pass an object containing boxList property or you could pass a map containing the boxList key. For example

public class Wrapper {
    private List<box> boxList;
}


<insert id="insertList" parameterType="Wrapper">
    INSERT INTO boxtable (
    size,length)
    VALUES
    <foreach item="box" collection="boxList" separator=",">
        (#{box.size},#{box.length})
    </foreach>
</insert>

answered Apr 15 '13 at 05:45

Bhushan Bhangale

10,921
5
43
71

I have to pass a list which contains objects – Parekh Shah Apr 15 '13 at 09:28
create a class like Wrapper and set the box List in that object and pass that object. – Bhushan Bhangale Apr 15 '13 at 09:36

score 0 · Answer 2 · answered Apr 15 '13 at 05:24

0

try using <isPropertyAvailable> before the <foreach> in your sql statement. Also you could try using the <iterate> but don't forget to append [] to ur boxlist (as in #boxlist[]#)

For more on dynamic sql statements in ibatis follow this link

answered Apr 15 '13 at 05:24

pranky64

437
3
18

Ibatis insert operation

2 Answers2