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 <[email protected]>: > > 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: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
