Hello, 2013/12/19 <[email protected]>
> Hi, > > I'd like to know if there is an article or a forum thread about JOOQ > vs.Criteria API (with generated metamodels)? > > What is the main differences between both? What are the advantages of JOOQ? > The simplest answer is: - jOOQ is typesafe SQL - Criteria API is typesafe JPQL >From there on, you can start comparing the expressive power and usefulness of both SQL and JPQL. In other words, before comparing the above APIs, you should really think about a SQL vs. ORM/JPA-based architecture. Being the jOOQ vendor, we believe that JPA / JPQL (and thus Criteria API) will not be able to follow suit with the expressivity of the SQL standard and of various dialects. Our views are documented in various places: - Comparing jOOQ with LINQ, JPA, JDBC: http://www.jooq.org/doc/3.2/manual/preface/ - Comparing jOOQ with JDBC, JPA: http://www.jooq.org/why-jOOQ.pdf - Comparing jOOQ with Hibernate: http://www.hibernate-alternative.com/ - Comparing JPA with the SQL standards: http://blog.jooq.org/2013/11/13/popular-orms-dont-do-sql/ Another point of view has been recently expressed by Vlad Mihalcea: - http://vladmihalcea.wordpress.com/2013/12/10/hibernate-facts-always-check-criteria-api-sql-queries/ Cheers 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
