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/