JOOQ and Spring

Question

Has anyone tried using JOOQ with the Spring framework or am I breaking new ground?

http://www.jooq.org

Answer 1

Yes, many people have (by now). And the jOOQ manual includes a tutorial about how to get started using jOOQ, Spring, Spring-TX and BoneCP:

• http://www.jooq.org/doc/latest/manual/getting-started/tutorials/jooq-with-spring/

There is also a very good tutorial by Petri Kainulainen, explaining every step to set up a project, here:

• Using jOOQ with Spring: Configuration
• Using jOOQ with Spring: Code Generation
• Using jOOQ with Spring: CRUD
• Using jOOQ with Spring: Sorting and Pagination

Here's a blog post about how to use jOOQ with Spring Boot, especially useful when you need the commercial distributions of jOOQ:

• https://blog.jooq.org/2019/06/26/how-to-use-jooqs-commercial-distributions-with-spring-boot/

Answer 2

I was looking to use jOOQ as an builder library for providing queries to Spring's JdbcTemplate and related classes. Unfortunately, jOOQ appears to combine two concepts into the same set of classes: SQL generation and query execution. In my case, I want the former but want to let Spring handle the latter. It does work, though. For example, you can do something like this (using jOOQ 2.x API):

Factory create = new Factory(null, SQLDialect.ORACLE); getJdbcTemplate().query(     create.select(create.field(ID_COL),                   create.field(VALUE_COL))         .from(FOO_TABLE)         .where(create.field(ID_COL).equals("ignored"))         .getSQL(),     myRowMapper,     id);