The jOOQ User Manual Code generation Advanced generator configuration Generate Extended types

previous : next

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:

• interval types (i.e. org.jooq.types.Interval and subtypes)
• json types (i.e. org.jooq.JSON and org.jooq.JSONB)
• spatial types (i.e. org.jooq.Spatial and subtypes)
• xml types (i.e. org.jooq.XML)

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

<configuration>
  <generator>
    <generate>
      <intervalTypes>false</intervalTypes>
      <jsonTypes>false</jsonTypes>
      <spatialTypes>false</spatialTypes>
      <xmlTypes>false</xmlTypes>
    </generate>
  </generator>
</configuration>

new org.jooq.meta.jaxb.Configuration()
  .withGenerator(
    new Generate()
      .withIntervalTypes(false)
      .withJsonTypes(false)
      .withSpatialTypes(false)
      .withXmlTypes(false)
  )

import org.jooq.meta.jaxb.*


configuration {
  generator {
    generate {
      isIntervalTypes = false
      isJsonTypes = false
      isSpatialTypes = false
      isXmlTypes = false
    }
  }
}

configuration {
  generator {
    generate {
      intervalTypes = false
      jsonTypes = false
      spatialTypes = false
      xmlTypes = false
    }
  }
}

generationTool {
  generator {
    generate {
      intervalTypes = false
      jsonTypes = false
      spatialTypes = false
      xmlTypes = false
    }
  }
}

The jOOQ User Manual Code generation Advanced generator configuration Generate Extended types

previous : next