Fetching results from multiple tables and map it to a java calss

[ankur.bha...@gmail.com]

Hi All, 

I am using jooq with play framework I have a situation here 

See below code it is working fine I can fetch the result in form of list as below and I can easily populate on my author.scala.html template : 

DSLContext jOOQDslCtx = getJooqDslCtx(getDBConnection("mytestdb")); 

List<AuthorRecord> authList =  jOOQDslCtx.select().from(Author.AUTHOR).fetchInto(AuthorRecord.class);

but what I should do if I want the results (multiple columns from different table in query) into same list form. 

should I create my own POJO to map it or I can use java collection API for this purpose. 

please advice!

Thanks, 

Ankur

[Lukas Eder]

Hello,

This seems to be the same question as that one here:

https://groups.google.com/forum/#!topic/jooq-user/EiBGfsmtFtc

Answers to be found on the other thread

Thanks,
Lukas

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.