Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT

[lukaseder]

With this schema:

CREATE TYPE monetary_amount AS (amount numeric, currency CHAR(3));

CREATE TABLE transaction (
    transaction_id bigint NOT NULL,
    value_date timestamp without time zone NOT NULL,
    amount monetary_amount NOT NULL,
    last_update timestamp without time zone DEFAULT now() NOT NULL
);

There's a POJO (record) accepting constructor in the generated TransactionRecord class like this:

    public TransactionRecord(org.jooq.demo.java.db.tables.pojos.Transaction value) {
        super(Transaction.TRANSACTION);

        if (value != null) {
            setTransactionId(value.transactionId());
            setValueDate(value.valueDate());
            setAmount(value.getAmount() == null ? null : new MonetaryAmountRecord(value.amount()));
            //              ^^^^^^^^^^^ compilation error here
            setLastUpdate(value.lastUpdate());
            resetChangedOnNotNull();
        }
    }

There is no getter called getAmount() in a Java record for a property called amount. Instead, we should call the method amount() based on the property name, directly. Curiously, this is being done in the constructor for MonetaryAmountRecord !

[lukaseder]

Fixed in versions:

• 3.20.0
• 3.19.2 (Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT - Merge [#16039] #16040)
• 3.18.9 (Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT - Merge [#16039] #16041)
• 3.17.18 (Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT - Merge [#16039] #16042)