| Version | Change log |
| jOOQ 3.20.5 Jun 15, 2025 |
This is a 3.20 patch release with minor improvements and bug fixes: Features and Improvements: 18432 Add a jOOQ-bom module Bug Fixes: 18442 Diff cannot handle name swaps of constraints and indexes 18451 Diff should drop PRIMARY KEY first, then NOT NULL constraint 18457 CockroachDB 24 identity column sequences aren't recognised as system sequences by code generator or runtime Meta 18463 Diff must never drop single column from table 18466 IN list padding generates too large lists in rare edge cases due to floating point rounding errors 18470 Ad-hoc converter receives non-attached records when using implicit join path table projections from within MULTISET 18475 Race condition in TableImpl initialisation leads to wrong INFO log message about duplicate identities in AbstractTable#getIdentity 18482 Diff generates CREATE VIEW statements that depend on not-yet existing tables 18485 Parser doesn't recognise built-in functions when quoted 18495 DDLExportConfiguration::createOrReplaceSynonym returns wrong flag 18496 Diff should export synonyms 18505 Diff may produce DROP TABLE before corresponding DROP SYNONYM statement 18507 Diff should properly sort DDL for Sequences, Schemas, Catalogs 18517 Meta::getDomains methods have insufficient dialect support 18521 Interpreter can only work with the first Settings.interpreterSearchPath 18527 The Settings.migrationDefaultSchema doesn't apply to Diff 18529 Configuration::derive and SettingsTools::clone don't deep-clone all Settings collection properties 18535 Wrong rendering of implicit join in DML when query is wrapped in DSL::queries 18538 Excess semicolon rendered when procedural block is placed inside of DSL::queries 18544 Parser cannot handle left-associative parenthesised nested set operations in derived table 18549 Parser cannot parse non-scalar subquery NULL predicate 18553 Parser cannot parse CAST(? AS <type>) expression in certain DDL contexts 18558 Upgrade Spring dependency to 6.2.7 to mitigate |
| jOOQ 3.19.15 Nov 4, 2024 |
Features and Improvements: <description/> to all pom.xml files Bug Fixes: IndexOutOfBoundsException when calling PostgreSQL table valued function returning empty result, with <tableValuedFunction/> turned off Bad code generated when activating <springDao/> but not <springAnnotations/> Parser should support SQL Server's NTEXT type and parse it into NCLOB Invalid constraint type "n" in jOOQ-meta query on PostgreSQL 17 when trying to fetch pg_get_constraintdef for a NOT NULL constraint on a domain GenerationTool should be more clear about commercial dependencies, when lookups don't work ORA-00904: invalid identifier when trying to insert into tables with lower case identifier in Oracle NullPointerException when using AutoConverter with a custom ConverterProvider Suppressed NoSuchElementException from ThreadLocalTransactionProvider.rollback prevents rollback when commit fails Oracle RETURNING emulation doesn't use configured ConverterProvider from an AutoConverter |
| jOOQ 3.19.14 Oct 21, 2024 |
Bug Fixes: Javadoc typos on trigger related methods Generated trigger names aren't escaped Meta.ddl() includes synonyms or aliases as tables for some dialects IN-list padding truncates row IN lists to 1000 elements in Oracle pre 23ai DefaultGeneratorStrategy should guard against path classes receiving the same name as their enclosing class Wrong XML import in InformationSchemaMetaImpl for trigger table schemas NUMERIC bind values passed to SQL Server VALUES constructor may lose scale if not explicit DataType is supplied VALUES types decimal and int cannot be matched when inlining NUMERIC types in CockroachDB DSLContext::fetchCount for selects with nested records causes DataAccessException Cannot call Record.reset(Field), Record.original(Field), Record.changed(Field) with embeddable field arguments ClassCastException during invocation of double-wrapped ConvertedDataType Wrong field indexes in code generated in record getters and setters for non-replacing embeddables when database reports non-consecutive column ordinals CREATE TABLE and other DDL statements don't qualify tables in BigQuery Diff doesn't export COMMENT ON MATERIALIZED VIEW statements correctly Converter<byte[], U> for binary columns doesn't work from within MULTISET expressions |
| jOOQ 3.19.13 Sep 26, 2024 |
Features and Improvements: MetaImpl exceptions should indicate table and column if applicable, which caused the exception Add a link to DSL::coerce from DSL::cast and Field::cast Bug Fixes: Upgrade Spring dependency from jOOQ-meta-extensions-hibernate to 5.3.39 due to CVE-2024-38808 Upgrade jOOQ-checker's transitive guava dependency to 32.1.3-jre due to CVE-2023-2976 R2DBC Connection leak when cancelling pending connection with ConnectionPool ORA-17068: Invalid arguments in call when calling OracleDatabaseMetaData.getIndexInfo() with quoted object names MetaImpl and code generator should ignore MySQL's dummy REMARKS column on DatabaseMetaData::getTables for views Meta::ddl re-ordering logic cannot parse views from MetaImpl in certain dialects Regression when generating DDL from certain generated views DDL::applyAsPlainSQL should trim plain SQL string to check if it starts with CREATE UserImpl::$replace produces a RoleImpl instance Oracle PL/SQL %ROWTYPE references should be declared as such in anonymous blocks when calling procedures |
| jOOQ 3.19.12 Sep 24, 2024 |
Features and Improvements: Add DataType.isTimestampWithTimeZone() for INSTANT and OFFSETDATETIME and isTimeWithTimeZone() for OffsetTime Revert deprecation of serialization support Log warnings when Java record constructor has more than 254 parameters Add Converter.fromSupported() and Converter.toSupported() default methods Document the fact that org.jooq.Binding does not necessarily have to implement a complete org.jooq.Converter Add new DataType.isDecimal() method to check if DataType.isNumeric() and it has a decimal representation Bug Fixes: Upgrade pgjdbc dependency to 42.7.3 to mitigate CVE-2024-1597 Update DataType.isXYZ() Javadoc with new types TIME(0), LOCALTIME(0), OFFSETDATETIME(0), and INSTANT(0) don't work in DDL statements as the datetime precision is simply omitted Redundant unique index on primary key makes foreign keys disappear in PostgreSQL HANA's WITH ORDINALITY emulation doesn't maintain correct ordering of ORDINALITY Fix R2DBC support for TIMESTAMP WITH TIME ZONE types Fix support for special float values NaN, Infinity in MULTISET usage Implicit path correlation produces correlation predicate in ON clause rather than WHERE clause in some cases Invalid SQL generated for INSERT .. ON DUPLICATE KEY IGNORE or ON DUPLICATE KEY UPDATE emulations using MERGE KotlinGenerator contains incomplete list of Kotlin forbidden identifier characters Bad code generated for enum values containing backslash character CASE expression on BOOLEAN type emulation in JSON constructor causes ORA-40590: invalid format on Oracle XE 18 MySQL boolean type information isn't maintained across expressions when embedded into JSON <unsignedTypes/> flag doesn't work outside of MySQLDatabase Join paths don't work when embeddable keys or domains on keys are present Meta::ddl produces incorrect DDL for SQLite, when there are FOREIGN KEY constraints Using embedded domains with POJO generation results in duplicate getters Overload resolution ambiguity in KotlinGenerator generated |
| jOOQ 3.19.8 May 2, 2024 |
Auto wrap Field arguments to a Routine's Object typed parameter in Field<Object> Work around lack of support for INSERT .. SELECT .. UNION [ ALL ] SELECT in SingleStore DELETE .. ORDER BY .. LIMIT on partitioned tables without unique constraint uses non-unique ctid for self joins Cannot configure matchers using jOOQ-codegen-gradle plugin SAXParseException warnings when using jOOQ-codegen-gradle or any other MiniJAXB.unmarshal() usage Time zone information lost when fetching TIMETZ[] value in PostgreSQL Work around HSQLDB bug where wrong LocalTime value is fetched when using bind values of type LocalTime[] Wrong cast type name when casting value to NCLOB in Firebird Fix order of NOT NULL and DEFAULT clauses in BigQuery CREATE TABLE statements |
| jOOQ 3.19.7 Apr 4, 2024 | |
| jOOQ 3.19.5 Feb 27, 2024 | |
| jOOQ 3.19.4 Feb 20, 2024 | |
| jOOQ 3.19.3 Jan 20, 2024 |
