Connecting to SQL databases using jOOQ

jOOQ is a persistence framework that allows you to define SQL queries using the Java Programming Language. It has many capabilities and this section, we will only show a few of them.

As always, you can start by adding the required dependencies to start using jOOQ:

<dependency>
    <groupId>org.jooq</groupId>
    <artifactId>jooq</artifactId>
    <version>3.9.5</version>
</dependency>
<dependency>
    <groupId>org.jooq</groupId>
    <artifactId>jooq-codegen</artifactId>
    <version>3.9.5</version>
</dependency>

You can find all the code developed in this section in the Data-centric-Applications-with-Vaadin-8/chapter-06/jooq-example Maven project.

Defining a...