You also know that Group.id will contain the result from the selectKey statement :)

Jeff Butler skrev:
The return value from the insert method is the number of rows inserted
(in iBATIS3).

Ibator will generated the proper code for generated keys - see the
<generatedKey> configuration element in the documentation.

Jeff Butler


2009/11/14 Tomáš Procházka <t.procha...@centrum.cz>:
What contain return int value for this mapper method:

int insert(Group record);

with this mapping delcaration:

 <insert id="insert" parameterType="test.model.Group" >
   insert into `group` (id, name, type,
     locked, lockedby_user)
   values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, 
#{type,jdbcType=CHAR},
     #{locked,jdbcType=BIT}, #{lockedbyUser,jdbcType=INTEGER})
 </insert>

?

A prefer automatically return last insert id, it's possible?

I tried this:

               <selectKey keyProperty="id" resultType="integer">
                        SELECT LAST_INSERT_ID();
               </selectKey>

It update field in Group instance which was used to call insert method, But has 
no result to insert method return value.


               <selectKey keyProperty="id" resultType="integer"> SELECT 
LAST_INSERT_ID();</selectKey>

This should be automatically generated by Ibator. It's very important for easy 
way to build related DB data.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org

Reply via email to