
jOOQ Masterclass
By :

In jOOQ, the common interface for all dialect-specific data types is named org.jooq.DataType<T>
, where T
represents the Java type associated with an SQL data type. Each association of a T
Java data type with an SQL data type (generic SQL types, called standard JDBC types) represented by java.sql.Types
is present in jOOQ's org.jooq.impl.SQLDataType
API. The jOOQ Code Generator automatically maps Java types to this SQLDataType
API, which has an almost 1:1 matching to databases' data types for most dialects. Of course, we are not including here some of the vendor-specific data types, such as spatial data types, PostgreSQL's INET
/HSTORE
, nor other non-standard JDBC types (data types not explicitly supported by JDBC).
Roughly, any data type that is not associated in the jOOQ API with a standard JDBC type is considered and treated as a custom data type. However, as Lukas Eder mentions: "There are some data types that I think...