| Version | Change log |
| 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 | |
| jOOQ 3.19.0 Dec 16, 2023 |
