The jOOQ User Manual : Code generation : Advanced generator configuration : Database : Unsigned types

previous : next

Unsigned types

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

The JDBC and Java type system don't know any unsigned integer data types, but some databases do, most importantly MySQL. This flag allows for overriding the default mapping from unsigned to signed integers and generates jOOU types instead:

• org.jooq.types.UByte
• org.jooq.types.UShort
• org.jooq.types.UInteger
• org.jooq.types.ULong

Those types work just like ordinary java.lang.Number wrapper types, except that there is no primitive version of them. The configuration looks like follows:

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

new org.jooq.util.jaxb.Configuration()
  .withGenerator(new Generator()
    .withDatabase(new Database()
      .withUnsignedTypes(true)
    )
  )

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

The jOOQ User Manual : Code generation : Advanced generator configuration : Database : Unsigned types

previous : next