Hi Francesco,
This might be a domain related bug. Can you please provide a complete
reproducer here?
https://github.com/jOOQ/jOOQ/issues/new/choose
Thanks,
Lukas
On Wed, Dec 20, 2023 at 9:27 AM Francesco Buda <franc.b...@gmail.com> wrote:
> I have a java web application with Postgresql as its underlying database,
> on which I have defined a custom Domain "customtype" as "tstzrange".
>
> I've added a dependency to:
>
> <dependency>
> <groupId>org.jooq.pro</groupId>
> <artifactId>jooq-postgres-extensions</artifactId>
> <version>3.18.7</version>
> </dependency>
>
> and my code generator looks like:
> <generator>
> <database>
> <name>org.jooq.meta.postgres.PostgresDatabase</name>
> <includes>.*</includes>
> <excludes></excludes>
> <inputSchema>myschema</inputSchema>
> </database>
> <target>
> <packageName>mypackage.jooq.generated</packageName>
> <directory>src/main/java</directory>
> </target>
> </generator>
>
> Code generation seems to work correctly in fact on the log I read:
> myschema.customtype to
> <priority>-2147483648</priority><userType>org.jooq.postgres.extensions.types.OffsetDateTimeRange</userType><binding>org.jooq.postgres.extensions.bindings.OffsetDateTimeRangeBinding</binding><includeTypes>tstzrange</includeTypes><nullability>ALL</nullability><objectType>ALL</objectType>
>
> and I have the java Domain:
> public static final Domain<OffsetDateTimeRange> CUSTOMTYPE =
> Internal.createDomain(
> schema()
> , DSL.name("timeperiod")
> ,
> org.jooq.impl.DefaultDataType.getDefaultDataType("\"myschema\".\"tstzrange\"")
>
> , new OffsetDateTimeRangeBinding()
> );
>
>
> It's not clear to me if I have to configure something else to have
> OffsetDateTimeRange when querying on columns which uses my customtype as
> dataType, or if it's even possible.
> For instance a query like "Result<org.jooq.Record> r = dsl.fetch("select *
> from mytable");", in which column1 is of type "customtype", it shows
> Pgobject as column1's data type.
>
> Thanks in advance,
> Francesco
>
> --
> 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 jooq-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/8a6bae58-14f0-469e-80fb-01a0cd416aa3n%40googlegroups.com
> <https://groups.google.com/d/msgid/jooq-user/8a6bae58-14f0-469e-80fb-01a0cd416aa3n%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 jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO6OhOFDL8UmEefCFJ2uOcfbYd3rbhAVA_jMADd4gpJjtw%40mail.gmail.com.
