Currently i am mapping from list of pojos to Record, and i want to be able to insert multiple rows at once. how can i do that in JOOQ with one transaction? List<Record> recordList = receive...

Anyone ever seen this? I'm using MS SQL Server 2008, and I've tried it with two different JDBC drivers (jtds, and Microsoft's). I run a simple statement to update a row, and it does update it, but ...

I need example of configuration gradle build file for jOOQ with Testcontainers and Flyway, in official repository of jOOQ I found only maven example and can't translate it to gradle, I try to conve...

I have Spring application that regularly inserts records in a PostgreSQL-DB. Now, after a scheduled set of imports is done it takes a few seconds until I get the following warning: com.zaxxer.hika...

Is there any way to disable jooQ from printing the tip of the day?

I want to tell JOOQ not to quote the identifiers in the SQL it generates as per the answer here: https://mcmap.net/q/1146608/-how-to-avoid-quotes-around-table-aliases-in-jooq But given I'm letting...

I have app backend on php. But recently i created same backend on Quarkus and deployed it on kubernetes with database MYSQL. I'm routing half users on php backend and half qaurkus from app. PHP bac...

I have a table USER_ROLES that has 5 columns. Also, a class UserRole that has the same number of fields and names as USER_ROLES. I'm trying to insert a row without specifying the column names: U...

Quite frequently, I'd like to retrieve only the first N rows from a query, but I don't know in advance what N will be. For example: try(var stream = sql.selectFrom(JOB) .where(JOB.EXECUTE_AFTER.le...

Sometimes we want to have a suspend function that calls other suspend functions inside of a transaction: suspend fun mySuspendFunction(jooqContext: DSLContext) { jooqContext.transaction { config -...

Issue with unit test is that the same collection is processed differently in a stream and in a for loop. The collection in both cases is empty (data.size() = 0), but in the Case 1 that collection i...

create.batchUpdate(gameOrders .stream() .map(x -> { var game = new GameRecord(); game.setOrder(x.newOrder()); game.setId(x.id()); <------- this // Prevent setting the ID to itself gam...

I have column with type timestamp with time zone. The table contains the following value "2022-06-30 22:56:29.183764 +00:00". I want to do a date-only search. how to compare only by date ...

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)) .fetchOptionalInto(User.class); Now, supp...

When would you use Spring Data JPA over Spring Boot with JOOQ and vice versa? I know that Spring Data JPA can be used for completing basic CRUD queries, but not really for complex join queries whi...

Here's what I mean. How can I write a docker-compose.yaml file so that when one of the services is "built", it first runs another service? I'll try to be even more specific. I'm trying to build a...

I currently use this code with JOOQ: Condition condition = DSL.trueCondition(); if( isNotBlank(email) ){ condition = condition.and(APP_USER.EMAIL.likeRegex(email)); } That ends up issuing Postg...

I am trying to get Jooq working with GIS queries and found some samples on SO. I have a question regarding one of the samples. I found the following function which builds a Polygon (How to select p...

I have a very similar issue as the following post, but slight variation. Update only changed fields in JOOQ record using POJO I get the same JSON object both for create and update call. In the upda...

I'm using JOOQ with plain/raw SQL, so that means i'm not using any code generation or the fluid DSL thingy. The following code works: Connection connection = ...; DSLContext context = DSL.using...

Is there anything else need to get Spring Boot working with JOOQ? I am receiving the errors below, although I generated my classes correctly. Project builds, compiles, runs for 3 seconds and ...

I am using jooq with a custom binding that converts all JTS geometry types to appropriate Postgis data types. This allows me to write and read JTS geometry types seamlessly, yet I fail to execute q...

In my Vaadin and Spring Boot application, I have updated from jOOQ 3.14.12 to 3.15.0. After this update my application is not starting up again. This is the error I get: ***************************...

We are splitting read and write side of our DB queries. Achieved that as mentioned jooQ spring boot Multiple Schema(Read Write Split) Our config: We are using 2 dslContext. Writer is default dslCo...

I have data class data class Author( val id: String, val name: String, val books: MutableList<Book> = mutableListOf() ) {} And I wrote request using jooq val resultSet = dsl.select(author...