Unable to create records using custom generator strategy for getter names

I’m on jOOQ 3.13.1, dropwizard 2.0.7. To make jOOQ and dropwizard together, I am using (https://droptools.bendb.com/jooq/). I am using custom generation strategy to maintain camel case for my setters …

NoSuchMethod in JOOQ 3.14 InsertQuery with Postgresql

I’m trying to use Jooq’s InsertQuery to insert a record into PostgresQL database, but I’m running into following error: java.lang.NoSuchMethodError: ‘org.jooq.UniqueKey org.jooq.impl.Internal….

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 …