ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Lamey <cla...@localmatters.com>
Subject Re: ResultMap groupBy with outer join
Date Mon, 10 Dec 2007 20:24:47 GMT
Yea, I'm working with some legacy stuff that I don't want to change, so I
can't post-process:(

Thanks,
Chris


On 12/10/07 12:25 PM, "Larry Meadors" <lmeadors@apache.org> wrote:

> Yep. :)
> 
> The problem is that the result set coming back includes the data, but
> all the values are null, so iBATIS creates the object that way.
> 
> So yes, your options are a row handler or to post-process the data and
> check for empty null values in factId.
> 
> Larry
> 
> 
> On Dec 10, 2007 11:12 AM, Christopher Lamey <clamey@localmatters.com> wrote:
>> Heya,
>> 
>> I essentially have a star schema - a fact table with various detail tables
>> hanging off of it.  Each detail table has the fact_id as FK in it.
>> 
>> Since not all the details will be filled out, I'm using an outer join to
>> pull them in and the `groupBy="factId"` on the resultMap.
>> 
>> The problem I'm seeing is that iBATIS is trying to create empty detail
>> objects with null values.
>> 
>> I'm guessing the answer to this question is "use a RowHandler", but I
>> thought I'd ask anyway.
>> 
>> Cheers,
>> Chris
>> 
>> 


Mime
View raw message