ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Insert statement returns generated key
Date Fri, 28 Aug 2009 15:07:20 GMT
Couldn't you call it just as a procedure?

Larry


On Fri, Aug 28, 2009 at 9:02 AM, Clinton Begin<clinton.begin@gmail.com> 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)
> <NBeary@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 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 is
>> required in the PCDATA section outside of <selectKey>, I just put a ;
>> there.  So it looks like this:
>>
>> <insert id="insert-xxx" parameterClass="xxx">
>>         ;
>> <selectKey resultClass="int" keyProperty="ID">
>>                 exec insert_macro(…)
>>         </selectKey>
>> </insert>
>>
>> Does anybody know a more elegant/less hacky solution to this?
>>
>> We are using Teradata 12.0.
>>
>> Thanks!
>> Nick
>>
>>
>>
>

---------------------------------------------------------------------
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