python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - jooq

JOOQ -> Convert alias to datatype

I have a query that returns a field of type array, and I used .as('Names'), to give it an alias. Now I need to assign this to a class. How can I convert the AliasField to datatype MutableSet? I tried ...
test-img

JaneD

java

kotlin

jooq

Votes: 0

Answers: 1

Latest Answer

Just keep a reference to your field expression and use that to read values from the record, e.g.: val names = MY_COLUMN.as("names") val record = ctx.select(names).from(...).fetchOne() myClas...
test-img

Lukas Eder

Execute JOOQ's batchInsert fetching results

Is there any way of executing a batchInsert in JOOQ getting the results as you would in a regular insertInto().set().returning()? E.g: Having an entity as follows: data class Person( val id: Int, ...
test-img

Alejandro Lorefice

postgresql

jooq

Votes: 0

Answers: 1

Latest Answer

As of jOOQ 3.16, there isn't yet, see this pending feature request: https://github.com/jOOQ/jOOQ/issues/3327 However, you can bulk insert your records instead, and return generated values. Since Postg...
test-img

Lukas Eder

Jooq order by not in jsonArrayArg

The query statement which need to be executed is dslContext.select( jsonObject( key("id").value(ENTITY.ID), key("name").value(ENTITY.NAM...
test-img

Sai Uttej

spring-boot

jooq

Votes: 0

Answers: 1

Latest Answer

Use the ORDER BY clause on JSON_ARRAYAGG: jsonArrayAgg(...).orderBy(...)
test-img

Lukas Eder

Jooq code generation from multiple databases

How can I configure my maven to generate code from different databases? I have this configuration: <plugin> <groupId>org.jooq</groupId> <artifactId>jooq-codegen-maven&l...
test-img

alf3ratz

java

jooq

jooq-codegen-maven

Votes: 0

Answers: 1

Latest Answer

When I have multiple databases I usually configure Jooq programmatically. This is my kotlin code: val DB1JooqCodeGenConfig = JooqConfiguration() .withJdbc( Jdbc().apply { ...
test-img

HSLM

Posts

Questions

Blogs

Jobs