Skip to content

Tag: jooq

Unknown column sql error while using jooq

Query: Error: Database: MYSQL, Database Name: ‘users’, JOOQ Version: 3.16.6 Answer Correlating derived tables isn’t supported in MySQL 5.7. Support has been added only in MySQL 8.0.14: https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html jOOQ currently can’t work around this lim…

Implement batchMerge() in JOOQ

I need to “upsert” a List of items. If an item’s id and anotherId is already existing, other values should be replaced by the new item. If it’s not, item should be inserted as new record. I came across JOOQ’s batchMerge and I thought it is similar to “upsert”. Unfortu…

SQL row value expression with null failing in where-in query

I am struggling to understand why this where-in query is failing when there are nulls in the row value expression. The query is not returning a single record from the below table. I expected each row value expression to match exactly one record. I appears the null spoils the fun and I don’t understand w…

Create Athena table using JOOQ java

How can I create a Athena table using jooq library in java. Since Athena table uses syntax like create external table and we need to specifiy s3 bucket path also. I have a list of string from which i want to create the athena table. Can somebody suggest a way how i can do it with jooq library. Answer Amazon

JOOQ “IN” Query throws null pointer exception

When we try to fetch data with Null values field(TABLE_NAME.COLUMN_NAME.in(null)) with IN clause getting null pointer exception. Maybe because of this. In the database, we can provide null in IN clause. There is an existing “won’t fix” issue in jooq https://github.com/jOOQ/jOOQ/issues/3867 T…