A frequently encountered doubt people have when using jOOQ is to decide when a "complex" query should be written using jOOQ API vs. when it should be implemented using native SQL. The jOOQ manual is full of side by side examples of the same query, e.g. Using jOOQ: ctx.select(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME, count()) .from(AUTHOR) .join(BOOK).on(AUTHOR.ID.eq(BOOK.AUTHOR_ID)) .groupBy(AUTHOR.ID, AUTHOR.FIRST_NAME, … Continue reading When to Use jOOQ and When to Use Native SQL
Tag: JdbcTemplate
A nice way of using jOOQ with Spring
This blog post is outdated. For a more up-to-date example of how to integrate jOOQ with Spring, please consider the relevant sections of the jOOQ manual! A nice way of using jOOQ with Spring was recently discussed on Stack Overflow by Adam Gent: http://adamgent.com/post/31128631472/getting-jooq-to-work-with-spring-correctly The essence of it was given here in this gist: package … Continue reading A nice way of using jOOQ with Spring