I wouldn't expect that to make a difference as you have described it so far, but without some more context, I can't say for sure.
Maybe you can provide some more info - data structures, mapped statements, and result maps would be a good start. I would expect this to work pretty easily (I know I have done groupBy with outer joins), but the one gotcha I saw was that if the outer table (votes in your case) had no matches, then the main object (stakeholder) had a list with one (all null) element in it...which makes sense if you think about it - since that is what is in the result set. Larry On 5/29/06, Eric Bauld <[EMAIL PROTECTED]> wrote:
This will work for group by resultmaps ? A vote is not an int, a vote is a object. A stakeholder object holds a list of vote objects. Do you mean just changing all my basic accessors to use objects instead of primitives for this to work ? - Eric Sven Boden wrote: > Use Integer instead of int in your domain objects, Float instead > float, ... > > Regards, > Sven > > Eric Bauld wrote: > >> I am trying to get a query to run that has the following >> Get a list of stakeholders >> Each stakeholder can have many votes >> >> I want all stakeholders even if they do not have a vote. >> >> I have the query done and will get all stakeholders and all of their >> votes loaded properly. But if a stakeholder has no votes ibatis >> explodes because it cannot assign any votes to that stakeholder. How >> can I get around these null values and have it build a stakeholder >> object and not load it with votes ? >> >> - Eric >> >>
