All versions: 3.11 | 3.10 | 3.9 | 3.8 | 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | Development versions: 3.12 | Unsupported versions: 3.2 | 3.1 | 3.0 | 2.6

The SQL standard specifies ARRAY data types, that can be mapped to Java arrays as such:

Field<Integer[]> intArray;

The above array type is supported by these SQL dialects:

  • H2
  • HSQLDB
  • Postgres

Oracle typed arrays

Oracle has strongly-typed arrays and table types (as opposed to the previously seen anonymously typed arrays). These arrays are wrapped by org.jooq.ArrayRecord types.

The jOOQ Logo