ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: ResultMap groupBy with outer join
Date Mon, 10 Dec 2007 19:25:38 GMT
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