Thanks Michael.

Indeed the first option and much more interesting.

Thanks for the tip.


Michael McCurrey-3 wrote:
> 
> All depends on how you are going to be getting your primary key and how
> you
> would like it hydrated into your child tables.
> There are 2 ways to handle this,
> the first is to handle the inserts through a parent transaction and then
> do
> the subsequent insert calls through seperate mapper.Insert(...)
> You can get your auto-incremented primary key back using the selectKey
> element and push it back into your object.
> 
> OR,
> 
> It is possible to group multiple insert statements into one insert
> element,
> but its not very elegant or nice to your maint. developers :)
> 
> 
> On Sun, Oct 4, 2009 at 1:20 PM, jmsandy <jmsa...@gmail.com> wrote:
> 
>>
>> Hi guys,
>>
>> How do I break an object into multiple tables with iBatis. For example,
>> suppose the following object:
>>
>> Message: dtMsg, Msg, annex, annex.
>>
>> How would you write the fields: dtMsg and message, in message table and
>> the
>> fields: annex, in other table.
>>
>> How can I map this situation. The second table must have a foreign key to
>> the first table(message).
>>
>> This is an simple example. I have a complex object that should  to be
>> mapped
>> in multiple tables.
>>
>> How do this mapping? Can anyone give me an example please.
>>
>> Thank you.
>> --
>> View this message in context:
>> http://www.nabble.com/Object-in-multiple-tables-tp25741806p25741806.html
>> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
>> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>>
>>
> 
> 
> -- 
> Michael J. McCurrey
> Read with me at http://www.mccurrey.com
> http://chaoticmindramblings.blogspot.com/
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Object-in-multiple-tables-tp25741806p25743218.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.


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

Reply via email to