The jOOQ User Manual SQL execution Fetching Auto data type conversion

previous : next

Auto data type conversion

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

Many native SQL data types can be automatically converted from one another, such as VARCHAR to INTEGER and vice versa.

The jOOQ API also supports a variety of such auto conversions through the org.jooq.tools.Convert utility API, which implements the following rules:

• null is always converted to null, or the primitive default value, or Optional.empty(), regardless of the target type.
• Identity conversion (converting a value to its own type) is always possible.
• Primitive types can be converted to their wrapper types and vice versa
• All types can be converted to String
• All types can be converted to Object
• All Number types can be converted to other Number types
• All Number or String types can be converte to Boolean. Possible (case-insensitive) values for true:
  • 1
  • 1.0
  • y
  • yes
  • true
  • on
  • enabled
  
  Possible (case-insensitive) values for false:
  • 0
  • 0.0
  • n
  • no
  • false
  • off
  • disabled
  
  All other values evaluate to null
• All java.util.Date subtypes (java.sql.Date, java.sql.Time, java.sql.Timestamp), as well as most java.time.temporal.Temporal subtypes (java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime, java.time.OffsetDateTime, as well as java.time.Instant) can be converted into each other.
• byte[] can be converted into String, using the platform's default charset
• Object[] can be converted into any other array type, if array elements can be converted, too

This auto conversion can be applied explicitly, but is also available through a variety of API, in particular anywhere a java.lang.Class reference can be provided, such as:

Record record = ...
int i = record.get(0, int.class);
String s = record.get(1, String.class);

The jOOQ User Manual SQL execution Fetching Auto data type conversion

previous : next