HQL (and JPQL) both suck because they are not statically typed..."lack of type safety and absence of static query checking" "concatenation of strings which is usually very unsafe "
"Criteria Query API ended up very verbose and practically unreadable. "
https://www.jooq.org/
"jOOQ generates Java code from your database and lets you build type safe SQL queries through its fluent API. "
So this is no ORM framework, it uses your DB as it is, it simply allows you to write safer SQL queries directly in a fluent Java API. No Hocus-Pocus, it's a 1-to-1 mapping between DB and Java.
Here some examples https://www.jooq.org/doc/3.11/manual-single-page/#jooq-in-7-steps
http://www.querydsl.com/
how to use it https://www.baeldung.com/querydsl-with-jpa-tutorial and https://www.baeldung.com/intro-to-querydsl
If you want to use Native SQL or JPQL in Spring: https://www.baeldung.com/spring-data-jpa-query
This is the horribly verbose JPA Criteria API https://www.baeldung.com/hibernate-criteria-queries
" the main and most hard-hitting advantage of Criteria queries over HQL is the nice, clean, Object Oriented API."
Thursday, May 16, 2019
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment