Are there any actual examples of RecordMapper working with fetchMap() on results of joins? I can map a direct select to a string (name field), but not for a join. I've wondered through the code for DefaultRecordMapper, Record and RecordType but still haven't managed to get a usable mapper the will fetchMap() my select/join results to a string (the name field of the record)
On Monday, July 22, 2013 at 3:41:44 AM UTC-6, Lukas Eder wrote: > > Hi Ryan, > > Unlike most JPA-based ORMs, jOOQ cleanly separates querying from mapping. > There is no implicit knowledge about relations between your document and > annotation tables, unless you explicitly join the two tables in your SQL > statement. Once the result is fetched, you have lots of means of mapping > the flat result set onto your custom domain model (i.e. your existing > POJOs). jOOQ supports a default mapping algorithm that is described here: > http://www.jooq.org/javadoc/latest/org/jooq/impl/DefaultRecordMapper.html > > Since jOOQ 3.1, you can globally override the DefaultRecordMapper and > inject your own mapping strategies, using tools like > - http://modelmapper.org > - https://code.google.com/p/orika > - Your own implementation of jOOQ's RecordMapper > > Some documentation: > http://www.jooq.org/doc/3.1/manual/sql-execution/fetching/recordmapper > http://www.jooq.org/doc/3.1/manual/sql-execution/fetching/pojos > > http://www.jooq.org/doc/3.1/manual/sql-execution/fetching/pojos-with-recordmapper-provider > > Hope this helps > Lukas > > > 2013/7/19 Ryan Cornia <[email protected] <javascript:>> > >> I have an application with existing POJO's (and many hand coded SQL >> statements) I would like to try JOOQ on. >> >> I can't find any examples of how to do this? Do I need to configure JOOQ >> programmatically so it knows, for instance, I have a Document table and >> Annotation table, and how they are related? Where would I find an example >> of that? >> >> Or is code generation needed to get full feature type checking queries? >> Right now the data is mostly read only, so I am looking for the most >> maintainable way to do queries. >> >> Thanks, >> Ryan >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- 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.
