Questions tagged [jooq]
jOOQ stands for JOOQ Object Oriented Querying. jOOQ effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.
jooq
2,719
questions
1
vote
1
answer
24
views
How to convert a row from a table to ENUM in JOOQ?
JOOQ does not convert rows from a table to enum
I tried different conversion methods, but they either didn't do anything, or they displayed errors, I tried to add codegen jooq, but I can't do it, I ...
- 23
1
vote
1
answer
19
views
Adding a prefix or suffix to the names of POJOs generated with jooq maven plugin
I have the maven plugin set up so it generates jooq classes including POJOs from a Postgres database. My config looks like this:
<generator>
<generate>
<pojos>true</...
- 341
1
vote
0
answers
39
views
How to use case_() in JOOQ? [duplicate]
I get an error(java.lang.IllegalArgumentException: Cannot interpret argument of type class org.org.impl.CompareCondition as Field: id_ml_model_value = null) when using case_() in jooq, I think it's ...
- 23
0
votes
1
answer
24
views
java.lang.NoSuchMethodError in jOOQ with Vertx
I'm trying to do CRUD operations using jOOQ generated DAO class. insert() works fine. But I'm getting following exception when I try to call findAll() method in jOOQ DAO class. What could be the ...
- 1,182
1
vote
0
answers
32
views
jOOQ throws error cannot access java.util.concurrent.Flow with 3.19.10
As the title says, I am unable to build my maven module using jOOQ as a dependency (3.19.10) even after using java version 17 to build my code. The pom.xml file also specifies java 17 as the source ...
0
votes
0
answers
17
views
record content lost with jooq 18 + spring boot 3.2 + jpa annotations [updated]
I'm working on a small tutorial project that will have both jooq and various spring database implementations. The idea is to demonstrate a core module with nearly everything plus minimal, easily ...
- 1,210
0
votes
1
answer
69
views
How to Convert Optional<String> to a Fixed UUID Value for Nulls in jOOQ During INSERT Operations?
I am working with a database that handles null values very poorly. Instead of using nullable strings, I want to use a fixed, very rare value (essentially a UUID) as a placeholder for null.
My goal is ...
- 829
0
votes
0
answers
13
views
Jooq using coalesce in numerical expressions [duplicate]
How do you use coalese with Jooq in numerical expressions?
For example, I want something like .where(TEST_TABLE.NUMBER).eq(5.minus(DSL.coalesce(TEST_TABLE.OTHERNUMBER, 0)))
but minus is expecting an ...
- 1
1
vote
1
answer
18
views
JOOQ Multiset is coming back as json array instead of Record
I have simpler examples where using a multiset works fine, however I am now nesting it in a CTE and JOOQ seems to be converting it to an array rather than keeping it as a record.
This is about as ...
- 11
1
vote
1
answer
27
views
JOOQ codegen not working when added fields in both includes and excludes in pom
When I have tables in and columns in . Somehow its excluding all columns.
My requirement is to create pojo for only 5 tables so included them in at the same time I want only few columns from these ...
- 15
1
vote
1
answer
24
views
Creating fully qualified column name in jooq/java
I am getting null with below syntax
public static final Field<String> COLUMN=field(name("myid"), SQLDataType.VARCHAR)
public static final String TABLE_NAME = "mytable";
...
- 2,473
1
vote
1
answer
27
views
Does JOOQ support creating PostgreSQL index with varchar_pattern_ops option?
I want to upgrade my PostgreSQL DB schema using a migrator running in Java and I'm using JOOQ for generating Java files for my project. Currently, to upgrade my DB schema I must drop the old index and ...
- 11
1
vote
0
answers
27
views
Creating JOOQ objects during the Docker image build process using a PostgreSQL container
I'm working on a side project and I want to create a docker-compose in order to deploy the project locally successfully.
The main flow is:
Deploy a PostgresSQL container with init.sql file
Generate ...
- 109
1
vote
1
answer
22
views
jOOQ: How do I set up Catalog and Schema Version Providers for Liquibase?
We have a build, where we generate a PostgreSQL database with a single schema using Liquibase. From that database, we generate Java source code using jOOQ. The build uses Maven and the jooq-codegen-...
- 8,855
1
vote
1
answer
40
views
Gradle task error when generating jooq classes
I want generate my classes with jooq and gradle, but when I execute the task jooq-codegen-primary, I got this error :
> Task :jooq-codegen-primary FAILED
FAILURE: Build failed with an exception.
*...
- 527