Available in versions: Dev (3.18) | Latest (3.17) | 3.16

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

Extended types

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

In addition to all the data types specified by the JDBC specification such as SMALLINT, INTEGER, BIGINT, VARCHAR, and many more, jOOQ includes support for additional standard SQL data types, which JDBC ignores.

These data types are very convenient when they work out of the box, although you may prefer to roll your own, e.g. using converters or bindings.

Specifically, in the case of spatial types, which are available to the commercial editions only, you may want to opt out of jOOQ's code generation support when you're using the jOOQ Open Source Edition.

Support for these four data types can be configured in code generation:

By default, all of the above data types are supported, and support is enabled. To disable support, use:

XML (standalone and maven)
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.18.0.xsd">
new org.jooq.meta.jaxb.Configuration()
    new Generate()
myConfigurationName(sourceSets.main) {
  generator {
    generate {
      intervalTypes = false
      jsonTypes = false
      spatialTypes = false
      xmlTypes = false


Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo