The jOOQ User Manual : Code generation : Advanced generator configuration : Generate : Zero Scale Decimal Types

previous : next

Zero Scale Decimal Types

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

A zero-scale decimal, such as DECIMAL(10) or NUMBER(10, 0) is really an integer type with a decimal precision rather than a binary / bitwise precision. Some databases (e.g. Oracle) do not support actual integer types at all, only decimal types. Historically, jOOQ generates the most appropriate integer wrapper type instead of BigDecimal or BigInteger:

• NUMBER(2, 0) and less: java.lang.Byte
• NUMBER(4, 0) and less: java.lang.Short
• NUMBER(9, 0) and less: java.lang.Integer
• NUMBER(18, 0) and less: java.lang.Long

If this is not a desireable default, it can be deactivated either explicitly on a per-column basis using forced types, or globally using the following flag:

<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.13.0.xsd">
  <generator>
    <database>
      <forceIntegerTypesOnZeroScaleDecimals>true</forceIntegerTypesOnZeroScaleDecimals>
    </database>
  </generator>
</configuration>

new org.jooq.meta.jaxb.Configuration()
  .withGenerator(new Generator()
    .withDatabase(new Database()
      .withForceIntegerTypesOnZeroScaleDecimals(true)
    )
  )

myConfigurationName(sourceSets.main) {
  generator {
    database {
      forceIntegerTypesOnZeroScaleDecimals = true
    }
  }
}

The jOOQ User Manual : Code generation : Advanced generator configuration : Generate : Zero Scale Decimal Types

previous : next