ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris O'Connell" <oconn...@gorillachicago.com>
Subject Re: reading an identity column and inserting it in to other table
Date Tue, 24 Feb 2009 15:13:10 GMT
Stored procedure.

On Tue, Feb 24, 2009 at 8:42 AM, Rashid Jilani <jilani@lifebiosystems.com>wrote:

> Hi: Mario thanks for response. I am already doing exactly what you have
> told, and it is working, but I was looking to do every thing in 1 call
> instead of 2 calls.
>
> Right now I first call the statement inseretIntoUser, and then invoke other
> call to store the id attribute returned by sqlmap.insert(). I thought there
> must be more elegant way to do all this in 1 call?
>
> Regards,
> RJ.
>
> -----Original Message-----
> From: Mario Ds Briggs [mailto:mario.briggs@in.ibm.com]
> Sent: Monday, February 23, 2009 10:06 PM
> To: user-java@ibatis.apache.org
> Cc: user-java@ibatis.apache.org
> Subject: Re: reading an identity column and inserting it in to other table
>
> Aside to mysql identity semantics, in all cases iBatis will return the db
> generated value as the return of the sqlmap.insert() call.
>
> Additionally in your use case below, if the 'RegisteredUser'  object has a
> 'ID' attribute, ibatis will set it to the db generated value. You can also
> control the attribute that ibatis will set the value into using
> 'keyProperty' of <selectkey>
>
> Mario
>
>


-- 
-- 
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19

Mime
View raw message