Tony Wolski

Integrating JOOQ... easy


Integrating JOOQ into your application is a piece of piss, as I discovered recently when I needed to build some non-ORM/Hibernate database access into some reports. I’m upgrading the reports component of an application I develop and needed to add some performant metrics. I didn’t want to use direct SQL or JDBC, so I decided to see how JOOQ performed… and I was pleasantly surprised at how simple it was to set up and use.

First, add the dependency. I’m not using code generation so I only needed the core library.


This particular application uses CDI/Weld as its dependency injection framework, so I created a Producer method which produces a JOOQ DSLContext using the DataSource injected via JNDI using the @Resource annotation:

  import org.jooq.DSLContext;
  import org.jooq.SQLDialect;
  import org.jooq.impl.DSL;

  public class DSLContextProducer implements Serializable {

  private DataSource ds;

  public DSLContext getDSLContext() throws SQLException {
  	return DSL.using(ds.getConnection(), SQLDialect.MYSQL);

This makes the JOOQ DSLContext easy to access throughout the application by simply injecting it wherever it is needed:

@Inject DSLContext jooq;

And get busy using:

Field<?> AVG = DSL.field("avg(metric)").as("Average Some Metric");
Field<?> YEAR = DSL.field("EXTRACT(YEAR FROM createdDateTime)").as("Year");
Field<?> MONTH = DSL.field("EXTRACT(MONTH FROM createdDateTime)").as("Month");
  .groupBy(MONTH, YEAR)
  .orderBy(YEAR.desc(), MONTH.desc())

There’s a lot more to learn, but with fantastic documentation, I have no doubt JOOQ will become one of my go to Java database tools.

Your thoughts? I'd love to hear them. Please get in contact.