That's perfect. I'll give that a shot. Thanks On Wednesday, April 13, 2016 at 1:41:47 AM UTC-5, Lukas Eder wrote: > > Hi James, > > Thanks for your question. jOOQ does ship with Tuple types. They're called > Record, though. Specifically, Record1<T1> through Record22<T1, T2, .., T22>: > http://www.jooq.org/doc/latest/manual/sql-execution/fetching/record-n > > Just adapt your example to this, instead: > > // pseudocode > final Record3<Long, UUID, Integer> record = dslContext > .select(TABLE1.FIELD1, TABLE2.FIELD2, TABLE3.FIELD3) > .from(TABLE1) > .join(TABLE2).on(...) > .join(TABLE3).on(...) > .fetchOne(); > > The generic <R> type that binds to Record3<Long, UUID, Integer> because of > your select() method call will be maintained until the end of the DSL > method chain, when you call one of the fetch() methods. You probably just > picked the wrong one. > > Hope this helps, > Lukas > > 2016-04-12 21:19 GMT+02:00 <[email protected] <javascript:>>: > >> Is it possible to fetch two or more fields from different tables into a >> Tuple like? >> >> // pseudocode >> final Tuple3<Long, UUID, Integer> record = dslContext >> .select(TABLE1.FIELD1, TABLE2.FIELD2, TABLE3.FIELD3) >> .from(TABLE1) >> .join(TABLE2).on() >> .join(TABLE3).on() >> .fetchOneInto(); >> >> I'm trying to avoid having to create a small intermediate POJO. I've >> scanned the jOOQ docs and can't find an example. >> Being able to do something like this would be awesome. I'm assuming >> something like this exists; I just can't find it. >> >> Thanks again, >> James Lorenzen >> >> -- >> 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/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.
