RE: Insert statement returns generated key

2009-08-28 Thread Jose Lora
Thanks for sharing this Nick. Not good for documenting your intentions but could you also use a mapped SELECT statement instead? From: Clinton Begin [mailto:clinton.be...@gmail.com] Sent: Friday, August 28, 2009 11:02 AM To: user-java@ibatis.apache.org Subject: Re: Insert statement returns

Re: Insert statement returns generated key

2009-08-28 Thread Larry Meadors
Couldn't you call it just as a procedure? Larry On Fri, Aug 28, 2009 at 9:02 AM, Clinton Begin wrote: > I don't, but that's pretty awesome that you figured that out and it works... > LOL.  :-) > > Clinton > > On Fri, Aug 28, 2009 at 8:56 AM, Beary, Nick (EHQ) > wrote: >> >> Hello, I looked arou

Re: Insert statement returns generated key

2009-08-28 Thread Clinton Begin
I don't, but that's pretty awesome that you figured that out and it works... LOL. :-) Clinton On Fri, Aug 28, 2009 at 8:56 AM, Beary, Nick (EHQ) < nbe...@express-scripts.com> wrote: > Hello, I looked around for an answer to this but didn’t see anything. To > insert objects in our database, I

Insert statement returns generated key

2009-08-28 Thread Beary, Nick (EHQ)
Hello, I looked around for an answer to this but didn't see anything. To insert objects in our database, I have to use a macro that returns the key of the newly inserted object. This means that the entirety of my insert statement is located in the selectKey section. Because an SQL statement i