Hi Dominik, Sorry for the delay. I'll get to this issue soon.
Best, Lukas On Sat, Aug 30, 2025 at 7:08 PM Dominik Hirt <[email protected]> wrote: > Today, I took another closer look at the problem I had already reported in > https://github.com/jOOQ/jOOQ/issues/18793. > The issue is, that when using a UDT in Postgresql, the jOOQ code generator > creates record classes with compile errors. > > Our workaround so far has been to correct the incorrectly generated record > classes using Linux CLI sed. However, this now requires adjustments to the > Docker image for the CI pipeline and much more, so today I took the trouble > to build an MVE with jbang so that it can be reproduced quickly. (see > attachment jbang-udt.zip) > > Here are the steps to reproduce: > > 1) We create a UDT in PostgreSQL for a monetary amount consisting of > amount and currency, using that UDT for a column within the *invoice* > table and insert a value. > > create type monetary_value as ( > amount numeric(14,2), > currency varchar(4) > ); > > create table invoice ( > id int not null primary key generated by default as identity, > amount monetary_value > ); > > insert into invoice (amount) values ('(42,EUR)'); > > 2) The jOOQ code generator is now configured and started for this database: > > <generator> > <database> > <inputSchema>public</inputSchema> > <includeUDTs>true</includeUDTs> > <forcedTypes> > <forcedType> > <userType>javax.money.MonetaryAmount</userType> > > <converter>de.todo42.test.MonetaryValueConverter</converter> > <includeExpression>amount</includeExpression> > <objectType>COLUMN</objectType> > </forcedType> > </forcedTypes> > </database> > <generate> > <pojos>true</pojos> > </generate> > <target> > <packageName>de.todo42.test</packageName> > <directory>.</directory> > </target> > </generator> > > 3) The code generator now generates, among other things, the > InvoiceRecord.java for the INVOICE table. > This class has the following as its last method: > > /** > * Create a detached, initialised InvoiceRecord > */ > public InvoiceRecord(de.todo42.test.tables.pojos.Invoice value) { > super(Invoice.INVOICE); > > if (value != null) { > setId(value.getId()); > setAmount(value.getAmount() == null ? null : new > MonetaryAmount(value.getAmount())); > resetTouchedOnNotNull(); > } > } > > There is now a compile error here because the used constructor > > new MonetaryAmount(value.getAmount())); > > does not exist. > > 4) As can be seen above, POJO generation was enabled. These are essential > for our project. However, if this is deactivated in the configuration by > > <pojos>false</pojos> > > > then this incorrect method is NOT generated and no compile errors occur. > > > Our workaround now consists of using a sed call to replace the line > > setAmount(value.getAmount() == null ? null : new > MonetaryAmount(value.getAmount())); > > with the line > > setAmount(value.getAmount()); > > This also corresponds to the generated assignments for all other table > columns/class attributes that are not UDTs. > > However, the generation of POJOs is essential for us and we cannot do > without it. > > How can I generate record classes without compile errors, even with POJO > generation enabled ? > > Kind regards > Dominik > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/jooq-user/57186e6a-31dc-46e5-9b2d-7312afc752c9n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/57186e6a-31dc-46e5-9b2d-7312afc752c9n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO77PpeHcjN1CBX5Kk9ajhbPDn-P03LT%3DLz1mJ7yqcLC9g%40mail.gmail.com.
