ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dannystommen <da...@techconnect.nl>
Subject <generate> tag not working
Date Tue, 01 Sep 2009 13:07:50 GMT

Hi there,

I'm trying to use parameterMaps with the <generate> tag, but it is not
working. I have a databse with table 'test_table' and 2 colums: id & name

    <resultMap id="TestResult" class="Test">
      <result property="ID" column="id" />
      <result property="Name" column="name" />

    <parameterMap id="insert" class="Test">
      <result property="Name" column="name" />

    <parameterMap id="update" class="Test" extends="insert">
      <result property="ID" column="id" />

    <!--Insert description-->
    <insert id="Insert" parameterMap="insert">
      <selectKey property="ID" type="post" resultClass="int">
        select LAST_INSERT_ID() as value
      <generate table="test_table" />

    <update id="Update" parameterMap="update">
      <generate table="test_table" by="id" />


the first error occurs when I try to configure Ibatis (first use).
"Specified argument was out of the range of valid values.\r\nParameter name:
index". This happens in de update tag. When I comment this generate tag out,
the configuration succeeds. Why is this happening, I don't have any
parameter that is named 'index'.

Secondly, when I try to execute the insert statement, it fails with the
message dat column 'name' has no default value. After some debugging, I saw
that ibatis generated the next insert statement: "INSERT INTO test_table ()
VALUES ()", while it should be: "INSERT INTO test_table (name) VALUES

Why is this happening?

View this message in context: http://www.nabble.com/%3Cgenerate%3E-tag-not-working-tp25240019p25240019.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-cs-help@ibatis.apache.org

View raw message