> Hi Antonio, > > We're on the same line of thought, about SQL vs. ORM. I had no doubts > about it, but I had to make a clear statement for future readers :-) (e.g. > https://groups.google.com/forum/#!topic/jooq-user/dVw0unCHJGo) >
Yep I think the same :) > Thanks for sharing the link to your jooq4hibernate prototype. I'll be > looking into it sometime these days. > Yes please, when you have some time, I absolutely have to improve drastically those code. > > Regarding your question: > > 2015-04-20 13:07 GMT+02:00 <[email protected] <javascript:>>: > >> @Lukas: Is there a way from the maven plugin jooq-codegen-maven to >> manipulate the prefix of the table? Because actually I have same classname >> with different packages for JPA Entity and Jooq table and I want to avoid >> it with a prefix. >> > > If by "prefix" you mean a prefix for the class names only, then yes. This > is called the generator strategies: > > > http://www.jooq.org/doc/latest/manual/code-generation/codegen-generatorstrategy/ > > http://www.jooq.org/doc/latest/manual/code-generation/codegen-matcherstrategy/ > > Thank you, i didn't search before for those feature :P > I'll get back to you with more feedback once I've seen jooq4hibernate. > Thank you very much. I just find out that in the project QueryDSL, there is a little documentation that describe the same approach. QueryDSL for sure have JPA native support using JPQL and metamodel based on entity (infact in our architecture I discuss with my collegues to use this instead of jOOQ, to rewrite some statements written with Criteria) but it also have SQL support. Here http://www.querydsl.com/static/querydsl/2.1.0/reference/html/ch02s02.html is described how to use SQL metadata to handle query with Hibernate Native Query (in the chapter 2.2.14). I don't know if the returned entities have the association fetched if you join tables or it only fetch the root entity by default (in those case you can always, I think, fetch the association writing by hands the addJoin, that is a little boring). In my case, I try to automatically write addJoin through the analysis of join conditions (i have to review, test and improve those part too). Fun fact is that I called the Query type returned by HibernateDSLContext, HibernateSQLQuery which is exact the same name used in QueryDSL XD Antonio > -- 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.
