ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tomáš Procházka <t.procha...@centrum.cz>
Subject What I miss in Ibator (was: Re: what contain int return value for insert?)
Date Sun, 15 Nov 2009 11:33:25 GMT

Thanks you. This is great, only small problem is that I must define the same think to all
table, but it work!

I already wrote plugin for support limiting result by RowBounds.
Here is:

http://www.atomsoft.cz/projekty/java/ibator-plugins/SelectByLimitPlugin.java

I also implementing generation default value for field. Very simple way for my needs. It can't
be done by plugin so I modify ibator direclty, here is patch:
http://www.atomsoft.cz/projekty/java/ibator-plugins/defaultFieldValue.patch

You can use it as can.


I already miss only support for foreign key for automatic generation something like this:

<resultMap id=”blogResult” type=”Blog”>
  ....
  <association property="author" column="blog_author_id" javaType="Author" 
select=”selectAuthor”/>
</resultMap>

______________________________________________________________
> Od: "Jeff Butler" <jeffgbutler@gmail.com>
> Komu: user-java@ibatis.apache.org
> Datum: 14.11.2009 22:12
> Předmět: Re: what contain int return value for insert?
>
>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.prochazka@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-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

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


Mime
View raw message