ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Pablo Araya <juanpablo.ar...@gmail.com>
Subject Re: how to use selectKey where property is an object‏
Date Thu, 20 May 2010 10:29:58 GMT
As far as I know you have two choices:

1. Set another property for Event class:

Public IdInserted { get { return Identifier.Id; } set { Identifier.Id
= value; }  }  -> null reference if Identifier is not instanced.

2. Create an insert procedure and pass the class for parameterMap,
setting the type @proced_Id as output and mapp it to Identifier.Id.

Greetings and sorry for my poor english!

2010/5/19 wekasalim <wekasalim@hotmail.com>:
>
> I'm using SQL Server 2008..
>
> Is there a way of not using the selectKey but instead the whole insert is
> returning int like:
>
>>  <insert id="InsertEvent" parameterClass="Event" resultClass="int">
>>      INSERT INTO nxEvent
>>      (Title, Time)
>>      VALUES
>>      (#Title#, #Time#)
>>        select @@IDENTITY as value
>>  </insert>
>
> Because setting it on the object is not important for me anyway..
>
> Thanks
>
>
> Michael McCurrey-3 wrote:
>>
>> What DB platform are you running on?
>>
>>
>> On Wed, May 19, 2010 at 4:15 PM, wekasalim <wekasalim@hotmail.com> wrote:
>>
>>>
>>> Hi guys,
>>>
>>> I want to use selectKey to get the inserted id, however the property of
>>> the
>>> id on my class (Event) is actually an object as well. The name is
>>> Identifier
>>> and it has int property named Id. The following does not work:
>>>
>>>  <insert id="InsertEvent" parameterClass="Event">
>>>      INSERT INTO nxEvent
>>>      (Title, Time)
>>>      VALUES
>>>      (#Title#, #Time#)
>>>      <selectKey resultClass="int" type="post" property="Identifier.Id"
>
>>>        select @@IDENTITY as value
>>>      </selectKey>
>>>  </insert>
>>>
>>> It says Event does not have Set member for 'Identifier.Id' Is there a way
>>> to
>>> do this?
>>>
>>> Thanks,
>>> Willy
>>> --
>>> View this message in context:
>>> http://old.nabble.com/how-to-use-selectKey-where-property-is-an-object%E2%80%8F-tp28615389p28615389.html
>>> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
>>> For additional commands, e-mail: user-cs-help@ibatis.apache.org
>>>
>>>
>>
>>
>> --
>> Michael J. McCurrey
>> Read with me at http://www.mccurrey.com
>> http://chaoticmindramblings.blogspot.com/
>>
>>
>
> --
> View this message in context: http://old.nabble.com/how-to-use-selectKey-where-property-is-an-object%E2%80%8F-tp28615389p28616859.html
> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-cs-help@ibatis.apache.org
>
>



-- 
Juan Pablo Araya
787 76 034

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


Mime
View raw message