Owner

jOOQ

3 indexed repositories · View on GitHub

jOOQ
jOOQ is the best way to write SQL in Java

Java · 6790 stars
jOOQ-mcve
A simple example project that can be used to create MCVE's to report jOOQ issues

Kotlin · 32 stars
demo
A jOOQ demo working with the Sakila database

Scala · 18 stars

Beginner friendly Everything

Open All

Add an inclusive variant of the synthetic SEEK clause (>= instead of >) Open

T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 55/100

jOOQ/jOOQ#20253 · Opened Sep 18, 2026
Add a way for a transactionPublisher to stream uncommitted intermediary output Open

C: Functionality E: All Editions P: High T: Defect

Difficulty 5/5 Over a week Newbie friendliness 45/100

jOOQ/jOOQ#20199 · 1 comment · Opened Sep 9, 2026
Implicit path join elimination doesn't happen with many-to-many relationships when the unnecessary parent table is in a one-to-one relationship with a child table Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#20181 · Opened Sep 7, 2026
Add implicit join specific error message when path root is not declared Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 3/5 1-2 days Newbie friendliness 52/100

jOOQ/jOOQ#20163 · 2 comments · Opened Aug 31, 2026
Add Settings.renderImplicitJoinPathElimination to allow for opting out of JOIN elimination with path joins Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 3/5 1-2 days Newbie friendliness 65/100

jOOQ/jOOQ#20162 · Opened Aug 31, 2026
AbstractName::equalsIgnoreCase should not call Name::getName, which incurs a String[] allocation Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 58/100

jOOQ/jOOQ#20157 · 2 comments · Opened Aug 31, 2026
Add support for ASOF JOIN Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 3/5 1-2 days Newbie friendliness 72/100

jOOQ/jOOQ#20146 · 1 comment · 9 reactions · Opened Aug 21, 2026
Add SQLDialect.DUCKDB_2_0 Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 3/5 1-2 days Newbie friendliness 48/100

jOOQ/jOOQ#20139 · 1 reaction · Opened Aug 18, 2026
ThreadLocalTransactionProvider permanently poisons a thread when nested transaction rollback throws on a broken connection Open

T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#20138 · 1 comment · Opened Aug 17, 2026
Potentially costly call to Connection::getTransactionIsolation when using transactions API Open

C: Performance E: All Editions P: High T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 52/100

jOOQ/jOOQ#20135 · 1 reaction · Opened Aug 13, 2026
Configuration.derive() clones Settings unconditionally even when reusing the same Settings reference (via DSLContext.transaction()) Open

C: Functionality E: All Editions P: High T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 58/100

jOOQ/jOOQ#20104 · 11 comments · Opened Jul 30, 2026
Add parser support for Oracle style UDT constructor calls Open

C: Parser E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#20088 · Opened Jul 2, 2026
Add support for Oracle 23.26.2 nested WITH Open

C: Functionality E: Enterprise Edition E: Professional Edition P: Medium T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

jOOQ/jOOQ#20074 · Opened Jun 24, 2026
Allow Converter / ContextConverter to run after connection is released (post-fetch conversion phase) Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#20058 · 1 comment · Opened Jun 15, 2026
jOOQ-codegen-gradle: CodegenTask's "configuration" @Input embeds the absolute basedir, breaking remote build cache relocatability Open

C: Code Generation E: All Editions P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 55/100

jOOQ/jOOQ#20050 · 3 comments · Opened Jun 10, 2026
Wrong MERGE emulation of INSERT .. ON CONFLICT DO UPDATE .. WHERE clause column reference translations Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#20022 · 1 comment · Opened Jun 2, 2026
Add experimental support for pgjdbc SQLData, SQLInput, SQLOutput Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#20000 · Opened May 19, 2026
Various set(Record) methods do not respect Settings.updatablePrimaryKeys Open

C: Functionality E: All Editions P: Medium T: Defect T: Incompatible change

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#19999 · Opened May 19, 2026
Upgrade errorprone to 2.50.0 to mitigate CVE-2026-0994 from the transitive protobuf dependency Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

jOOQ/jOOQ#19996 · 3 comments · Opened May 18, 2026
Add support for inline index comments Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 3/5 1-2 days Newbie friendliness 52/100

jOOQ/jOOQ#19991 · Opened May 12, 2026
Add support for constraint VALIDATE and NOVALIDATE clauses Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 55/100

jOOQ/jOOQ#19983 · Opened May 12, 2026
Add HANA support for temporal tables Open

C: Functionality E: Enterprise Edition P: Medium T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 45/100

jOOQ/jOOQ#19972 · Opened May 8, 2026
Support computed columns in MERGE .. INSERT for dialects with no support for correlated derived tables Open

C: Functionality E: Enterprise Edition E: Professional Edition P: Medium T: Defect

Difficulty 5/5 Over a week Newbie friendliness 35/100

jOOQ/jOOQ#19947 · 1 comment · Opened May 6, 2026
Add parser support for Oracle's JOIN TO ONE syntax Open

C: Parser E: All Editions P: Medium T: Enhancement

Difficulty 3/5 1-2 days Newbie friendliness 58/100

jOOQ/jOOQ#19942 · Opened May 5, 2026
JDBC backed MetaImpl returns the wrong string length for CockroachDB STRING data types Open

C: Functionality E: Enterprise Edition E: Professional Edition P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 55/100

jOOQ/jOOQ#19931 · Opened Apr 30, 2026
Wrong inlining of SQLDataType.DECIMAL_INTEGER type Open

C: Functionality E: Enterprise Edition P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 55/100

jOOQ/jOOQ#19904 · 3 comments · Opened Apr 28, 2026
Correctly fetch LengthUnit information in MetaImpl domains and routine parameters Open

C: Functionality E: All Editions P: Low T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

jOOQ/jOOQ#19894 · Opened Apr 23, 2026
Most Settings.paramType configurations have no effect Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#19879 · Opened Apr 20, 2026
Cannot run DDL statements using JDBC batch in HANA Open

C: Functionality E: Enterprise Edition P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 52/100

jOOQ/jOOQ#19850 · Opened Apr 2, 2026
Add Settings to apply native JSR 310 data type binding for LocalDateTime Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#19844 · 3 comments · Opened Apr 2, 2026
Support CockroachDB table valued functions Open

C: Code Generation E: Enterprise Edition E: Professional Edition P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#19843 · 4 comments · Opened Apr 1, 2026
Fall back to ordinary update counts if large update counts aren't supported by a driver Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 52/100

jOOQ/jOOQ#19830 · Opened Mar 31, 2026
Add HANA support for LOB comparisons Open

C: Functionality E: Enterprise Edition P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#19825 · 2 comments · Opened Mar 31, 2026
Bind variable casts truncate VARCHAR(n) ARRAY contents instead of letting the target INSERT raise an error Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 38/100

jOOQ/jOOQ#19814 · 2 comments · Opened Mar 26, 2026
Add TXTFormat::valueFormat, CSVFormat::valueFormat, and ChartFormat::valueFormat to allow for specifying which type of a Converter should be serialised Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

jOOQ/jOOQ#19806 · Opened Mar 25, 2026
`Converter` does not reliably convert DTO to `Record` for UDT with one field / table with one column Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 55/100

jOOQ/jOOQ#19792 · 2 comments · Opened Mar 24, 2026
Lack of proper dialect support in DSL::time, DSL::date, DSL::localTime, DSL::localDate, etc. Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 45/100

jOOQ/jOOQ#19789 · Opened Mar 23, 2026
Continue work on public query object model API Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 20/100

jOOQ/jOOQ#19788 · Opened Mar 23, 2026
Various parser bugs / missing features Open

C: Parser E: All Editions P: Medium T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 20/100

jOOQ/jOOQ#19787 · Opened Mar 23, 2026
Add more startup tips to be logged with the jOOQ logo Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#19786 · Opened Mar 23, 2026
Db2 doesn't support ALTER TABLE .. DROP CONSTRAINT .. CASCADE syntax Open

C: Functionality E: Enterprise Edition P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 45/100

jOOQ/jOOQ#19784 · Opened Mar 19, 2026
Automatically add NOT NULL constraints on Nullability.DEFAULT columns in Db2, if they have a UNIQUE or PRIMARY KEY on them Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 3/5 1-2 days Newbie friendliness 52/100

jOOQ/jOOQ#19783 · 1 comment · Opened Mar 19, 2026
Emulate moving objects between schemas if not supported natively Open

C: Functionality E: Enterprise Edition E: Professional Edition P: Medium T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 30/100

jOOQ/jOOQ#19766 · 1 comment · Opened Mar 17, 2026
`MergeUsingStep` and chained method descendants should support varargs `Condition... conditions` Open

C: Functionality E: All Editions P: Low T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

jOOQ/jOOQ#19761 · 3 comments · Opened Mar 13, 2026
Add support for identities in code generator and MetaImpl for Databricks Open

C: Functionality E: Enterprise Edition P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

jOOQ/jOOQ#19732 · Opened Mar 10, 2026
Add support ARRAY_REPLACE_AT(arr, index, newValue) and use that for UPDATE .. SET arr[index] = newValue emulation Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 42/100

jOOQ/jOOQ#19723 · Opened Mar 10, 2026
Oracle DB `merge into` and Audit columns lead to `ORA-06550` / `PLS-00435` Open

C: Functionality E: Enterprise Edition E: Professional Edition P: Medium T: Defect

Difficulty 4/5 3-5 days Newbie friendliness 35/100

jOOQ/jOOQ#19715 · 7 comments · 3 reactions · Opened Mar 6, 2026
Generating reactive Spring DAO Open

C: Functionality E: All Editions P: Medium T: Enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

jOOQ/jOOQ#19714 · 1 comment · Opened Mar 6, 2026
Add runtime flag to treat identity as readonly Open

C: Functionality E: Enterprise Edition E: Professional Edition P: Medium T: Enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

jOOQ/jOOQ#19713 · Opened Mar 5, 2026
Known issues when projecting Row[N] types as SelectField Open

C: Functionality E: All Editions P: Medium T: Defect

Difficulty 5/5 Over a week Newbie friendliness 25/100

jOOQ/jOOQ#19712 · Opened Mar 4, 2026

Showing the newest 100

This page lists what was indexed most recently. Advanced filter has the whole inventory, narrowed by language, difficulty and how long a task takes.

Open advanced filter

jOOQ

Showing the newest 100

Get new issues in your inbox