You just inserted it into the domain object that you sent into the query
:) That's the whole point of the selectKey:
<selectKey keyProperty="id" resultType="integer">
SELECT LAST_INSERT_ID();
</selectKey>
This means that the result from LAST_INSERT_ID() is inserted into the id
field.
Just check your domain object after calling insert.
-- Edvin
Ron H skrev:
well, the question is how to retrieve this Group.id?
Edvin Syse wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
