As a sanity check regarding the groupBy behavior I'm getting, here are
some log entries:
15:37:30,172 [main] DEBUG java.sql.ResultSet - {rset-100006} Header:
[category_id, category_keyword_id, category_id, keyword, vendor_name]
15:37:30,172 [main] DEBUG java.sql.ResultSet - {rset-100006} Result:
[category2, catkeyword2, category2, Dog, Amacai]
15:37:30,173 [main] DEBUG java.sql.ResultSet - {rset-100006} Result:
[category2, catkey1, category2, Oompa loopa, null]
Does the resultMap's groupBy get confused by two columns with the same
name in the result set?
On Wed, 2006-05-10 at 15:17 -0600, Christopher Lamey wrote:
> Hello,
>
> I have a couple questions:
>
> 1) Is svn.apache.org, both HTTP and SVN, down?
>
> 2) Can I use the groupBy attribute of a resultMap to collapse down rows
> from a query that uses a bunch of outer joins? For example, I have a
> query hits a couple directly associated tables, a join table, and a
> table off the join table. I can't get it work right now, but I can't
> get any groupBy stuff to work and I'm thinking that's because I'm using
> the 2.1.7 release, which has a busted groupBy attribute.
>
> Thanks,
> Chris