JOOQ materialized views

is it possible to create materialized views using the JOOQ builder? Something like this DSL.createMaterializedView().execute()

Is there a way to query ltrees in JOOQ?

Is there any sort of extension that would allow me to use Postgres ltrees in JOOQ without having to use raw SQL? Any way to make one myself maybe?

In Jooq, how to make the “delete” statement return the deleted records?

In my project, there are 2 tables, orders and order_payments. The latter is a join table with 2 columns, order_id and payment_id. I didn’t use FK for efficiency sake. When I delete some orders from …

Jooq Java CTE wrong render

I have CTE that is been creating from DSL.values: final RowN[] rowNS = tasksId .stream() .map(x -> DSL.row(x.toString())) .toArray(RowN[]::new); …

JOOQ – inline Converter not being applied

In my build.gradle I use a converter in my forcedTypes. This works fine where i need it. forcedType { userType = ‘java.util.List’ converter =…

jooq query for sql query with analytical function

i have sql query like select * from ( select s.*, max(year) over () max_year from Transaction s where s.Account_Number = ‘4234242234’ and s.month in (0,1)) o where o.year=o….

JOOQ: How to resolve foreign keys as objects?

Say I have a table that references another table, in this case “TestScenarios” references “TestSchemas”. So each TestScenario HAS-A TestSchema. I autogenerated DAOs, however, when fetching …

JOOQ MySQL DATETIME Type

I’m trying to generate this simple SQL with JOOQ and for some reason I can’t get it done. I want the following code to be generated for MySQL databases. CREATE TABLE T ( F DATETIME ); I expected …

One-to-many select in Jooq

I am trying out JOOQ and trying to select from 3 tables (Author, Books and Articles) using a join statement. The ERD is as follows: Author —-< Books | | ^ Articles The query I have is ...

jOOQ can I fetch a join of two tables into the respective POJOs

In jOOQ if I want to fetch a row of a table into a jOOQ autogenerated POJOs I do, for instance: dsl.selectFrom(USER) .where(USER.U_EMAIL.equal(email)) ….