Hello, Out of the box, jOOQ supports in-memory grouping of records into Map<Record, List<Record>> structures via various Result.intoGroups() methods, e.g.: http://www.jooq.org/javadoc/latest/org/jooq/Result.html#intoGroups-org.jooq.Field:A-
This isn't an actual OR-mapping feature, just grouping results by row values. I just realised that there is room for more such intoGroups() methods. I have registered a feature request for that: https://github.com/jOOQ/jOOQ/issues/3626 Of course, you can always implement your own RecordMapper, e.g. via RecordMapperProviders: http://www.jooq.org/doc/latest/manual/sql-execution/fetching/pojos-with-recordmapper-provider/ ... or possibly using a third-party library, like ModelMapper, which has an official jOOQ integration: http://modelmapper.org/user-manual/jooq-integration/ 2014-09-05 18:08 GMT+02:00 Deven Phillips <[email protected]>: > I'm getting bogged down on this, so I thought I would ask the group.. > > I have a query which joins across about 9 tables. The relationship is > essentially a 1 -> Many with associated fields from other tables added. I > would like to map the results using an class which has a field which is a > List of the "Many" relationship... Do I have to create a customer mapper to > accomplish that, or is there a way to make that work? > > So, example: > > Table: Customer 1 ... N Table: Locations and have the associated locations > placed into a single Customer object > > Thanks in advance for any help, > > Deven > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
