When you're using JPA - sometimes - JPQL won't do the trick and you'll have to resort to native SQL. From the very beginning, ORMs like Hibernate kept an open "backdoor" for these cases and offered a similar API to Spring's JdbcTemplate, to Apache DbUtils, or to jOOQ for plain SQL. This is useful as … Continue reading Type Safe Queries for JPA’s Native Query API
Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.