Re: Populate List within object in iBatis

2009-06-01 Thread Babitha
Thanks Alin. The solution worked. :) But I was just wondering if applying a join on the 2 tables would be okay. If i have to fetch quite a number of fields, then wouldn't the join be a performance issue? Regards, Babitha Alin Popa wrote: > > Hi Babitha, > > Hopefully that I understand right

Suggest that "resultMap" add a "ignoreNotExists" attribute.

2009-06-01 Thread liangfei
Suggest that "resultMap" add a "ignoreNotExists" attribute: select a, b from x select a, b, c from x

Re: Sharing iBATIS XML files between java applications

2009-06-01 Thread Chad McHenry
I use option 1 and it works well. Your C package embodies all aspects of the model and packages A and B contain controllers and views (in the MVC sense). This also ensures that all aspects of the model are available to A and B whether or not originally needed in both - projects which share common

Sharing iBATIS XML files between java applications

2009-06-01 Thread E
Hi. I have a common library of code "C" that is shared between two separate java applications, "A" and "B". C includes a set of iBATIS XML files and related java classes that are used by both programs. However, each of A and B have some additional classes and XML files that are to be used

Re: Multiple parameters in sqlmap parameters.

2009-06-01 Thread Jeff Stahl
Actually, the easiest way to handle the same thing is to put both parameters into a Map (HashMap works nicely), and pass the Map as the single parameter that iBATIS methods take. Hope This Helps, Jeff Stahl NathanM wrote: Please excuse me if this turns out to be a dumb question. Is it poss

Multiple parameters in sqlmap parameters.

2009-06-01 Thread NathanM
Please excuse me if this turns out to be a dumb question. Is it possible to do something simple like pass two int parameters into a statement? These are the examples I see in the manual: One simple type: select * from PRODUCT where PRD_ID = #value# One complex type: insert i

Re: Populate List within object in iBatis

2009-06-01 Thread Alin Popa
Hi Babitha, Hopefully that I understand right your issue, so, here is how I made it (and I think also this is the iBatis way to handle it) SELECT obj.id as id, obj.name, obj.details, p.id as proper

Nasser Shahcheraghi/SAC/IPS/FHS is out of the office.

2009-06-01 Thread Nasser . Shahcheraghi
I will be out of the office starting 06/01/2009 and will not return until 06/02/2009. I will respond to your message when I return. - This message, together with any attachments, is intended only for the use of the individual

Populate List within object in iBatis

2009-06-01 Thread Babitha
Hi, I have a Dealer bean. The Dealer bean contains a List of DealerContact bean objects. I would have to execute 2 select queries to populate Dealer bean and DealerContact bean. I wish to execute both the select queries in one go, such that all the details of Dealer bean including DealerContact p