gradle-jooq-plugin | Gradle plugin that integrates jOOQ | Plugin library

Why are you doing this?

You should add postgres driver dependency to jooqRuntime configuration as well jooqRuntime 'org.postgresql:postgresql:42.2.14'

UPDATE: You should add postgres driver to your buildscript classpath if you want to use it in gradle script outside of the tasks provided by nu.studer.jooq plugin

In your jooq configuration, the sample function you are using is set as string and not function.

Check at the documentation here: https://github.com/etiennestuder/gradle-jooq-plugin

You should have this:

From the information provided, the project is perfectly buildable, to some certain extend. First of all, project['a.b.c'] is Groovy syntax to access properties from the project object. They're referred to as project properties.

They can be set via

1. Project properties via command line: gradle -Ppostgresql.jdbc=x.y.z
2. System properties via command line: gradle -Dorg.gradle.project.postgresql.jdbc=x.y.z
3. System properties via gradle.properties: org.gradle.project.postgresql.jdbc=x.y.z

All 3 properties (postgresql.jdbc, flywaydb.plugin.version, jooq.plugin.version) denote the version numbers of the particular build script dependencies. However, which versions to use best is beyond my knowledge. I would certainly consult the respective project websites, Maven artifact search or simply ask the company.

• org.postgresql:postgresql is the database JDBC driver and certainly depends on the database version.
• org.flywaydb:flyway-gradle-plugin is for database migrations. Try with the latest version.
• I wasn't able to find gradle-jooq-plugin on Maven central. It's most likely available on the Gradle Plugin Portal.