ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Lamey <cla...@localmatters.com>
Subject ResultMap groupBy with outer join
Date Mon, 10 Dec 2007 18:12:15 GMT

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.


View raw message