ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lieven De Keyzer" <lieven_dekey...@hotmail.com>
Subject Re: selectKey and MySql problem
Date Fri, 29 Apr 2005 15:08:56 GMT
Right, should have read the API doc. It's because in the JPetStore example 
all inserts are done with the update() method. Thanks a lot.

>From: Larry Meadors <larry.meadors@gmail.com>
>Reply-To: lmeadors@apache.org
>To: ibatis-user-java@incubator.apache.org
>Subject: Re: selectKey and MySql problem
>Date: Fri, 29 Apr 2005 08:45:32 -0600
>
>Shouldn't you be calling insert instead of update?
>
>The update method always returns the number of rows updated.
>
>The select key statement will not be executed unless you call the insert
>method.
>
>Larry
>
>
>On 4/29/05, Lieven De Keyzer <lieven_dekeyzer@hotmail.com> wrote:
> >
> > I've searched the archive for this issue, but still couldn't solve it.
> > I'm working on a webbased application using Struts 1.2.4, iBatis SQL 
>Maps
> > 2.0 and iBatis DAO Framework. I also try to stick close to the concept 
>of
> > JPetStore 4.0.5.
> >
> > The problem I encounter is with the <selectKey> stanza.
> >
> > These are in Folder.xml
> >
> > <typeAlias alias="folder" type="com.vub.bookmarked.domain.Folder"/>
> >
> > <resultMap id="folderResult" class="folder">
> > <result property="folderId" column="folder_id"/>
> > <result property="parentId" column="parent_id"/>
> > <result property="owner" column="owner"/>
> > <result property="foldername" column="foldername"/>
> > </resultMap>
> >
> > <insert id="insertFolder" parameterClass="folder">
> > INSERT INTO folder (parent_id, owner, foldername)
> > VALUES (#parentId#, #owner#, #foldername#)
> > <selectKey resultClass="int" keyProperty="folderId">
> > SELECT LAST_INSERT_ID() AS folderId
> > </selectKey>
> > </insert>
> >
> > I catch this key in FolderSqlMapDao.java:
> >
> > public int insertFolder(Folder folder) {
> > int key = update("insertFolder", folder);
> > return key;
> > }
> >
> > But this key always seems to be the first inserted element, so 1 . For 
>all
> > the folders that get inserted afterwards, selectKey always returns this 
>1.
> >
> >



Mime
View raw message