Version Support Matrix
The commercial jOOQ distributions maintain versioned RDBMS support. The jOOQ Open Source Edition always supports the latest dialect version.
If a dialect is not listed here, it is not versioned yet. Please refer to https://www.jooq.org/download/#databases.
CockroachDB
| jOOQ version | Minimum versions (commercial editions) |
|---|---|
| 3.19 (dev) | 20, 21, 22, 23 |
| 3.18 (latest) | 20, 21, 22 |
| 3.17 | 20, 21 |
| 3.16 | 20, 21 |
| 3.15 | 20, 21 |
| 3.14 | 20 |
| 3.13 | 20 |
| 3.12 | |
| 3.11 | |
| 3.10 | |
| 3.9 | |
| 3.8 | |
| 3.7 | |
| 3.6 |
Db2
| jOOQ version | Minimum versions (commercial editions) |
|---|---|
| 3.19 (dev) | 9, 10, 11 |
| 3.18 (latest) | 9, 10, 11 |
| 3.17 | 9, 10, 11 |
| 3.16 | 9, 10, 11 |
| 3.15 | 9, 10, 11 |
| 3.14 | 9, 10, 11 |
| 3.13 | 9, 10, 11 |
| 3.12 | 9, 10, 11 |
| 3.11 | 9, 10, 11 |
| 3.10 | 9, 10 |
| 3.9 | 9, 10 |
| 3.8 | 9, 10 |
| 3.7 | 9, 10 |
| 3.6 | 9, 10 |
Firebird
| jOOQ version | Minimum versions (commercial editions) | Minimum version (OSS edition) |
|---|---|---|
| 3.19 (dev) | 2.5, 3, 4 | 4 |
| 3.18 (latest) | 2.5, 3, 4 | 4 |
| 3.17 | 2.5, 3, 4 | 4 |
| 3.16 | 2.5, 3, 4 | 4 |
| 3.15 | 2.5, 3 | 3 |
| 3.14 | 2.5, 3 | 3 |
| 3.13 | 2.5, 3 | 3 |
| 3.12 | 2.5, 3 | 3 |
| 3.11 | 2.5, 3 | 3 |
| 3.10 | 2.5, 3 | 3 |
| 3.9 | 2.5, 3 | 3 |
| 3.8 | 2.5, 3 | 3 |
| 3.7 | 2.5 | 2.5 |
| 3.6 | 2.5 | 2.5 |
H2
| jOOQ version | Minimum versions (commercial editions) | Minimum version (OSS edition) |
|---|---|---|
| 3.19 (dev) | 1.4.197, 1.4.200, 2.0.202, 2.1.214, 2.2.224 | 2.2.224 |
| 3.18 (latest) | 1.4.197, 1.4.200, 2.0.202, 2.1.214 | 2.1.214 |
| 3.17 | 1.4.197, 1.4.200, 2.0.202, 2.1.214 | 2.1.214 |
| 3.16 | 1.4.197, 1.4.200, 2.0.202 | 2.0.202 |
| 3.15 | 1.4.197, 1.4.200 | 1.4.200 |
| 3.14 | 1.4.197, 1.4.200 | 1.4.200 |
| 3.13 | 1.4.197, 1.4.200 | 1.4.200 |
| 3.12 | 1.4.197 | 1.4.197 |
| 3.11 | 1.4.197 | 1.4.197 |
| 3.10 | 1.4.197 | 1.4.197 |
| 3.9 | 1.4.197 | 1.4.197 |
| 3.8 | 1.4.197 | 1.4.197 |
| 3.7 | 1.4.197 | 1.4.197 |
| 3.6 | 1.4.197 | 1.4.197 |
MariaDB
| jOOQ version | Minimum versions (commercial editions) | Minimum version (OSS edition) |
|---|---|---|
| 3.19 (dev) | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7 | 10.7 |
| 3.18 (latest) | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7 | 10.7 |
| 3.17 | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7 | 10.7 |
| 3.16 | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6 | 10.6 |
| 3.15 | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5 | 10.5 |
| 3.14 | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5 | 10.5 |
| 3.13 | 10.0, 10.1, 10.2, 10.3, 10.4, 10.5 | 10.5 |
| 3.12 | 10.0 | 10.0 |
| 3.11 | 10.0 | 10.0 |
| 3.10 | 10.0 | 10.0 |
| 3.9 | 10.0 | 10.0 |
| 3.8 | 10.0 | 10.0 |
| 3.7 | 10.0 | 10.0 |
| 3.6 | 10.0 | 10.0 |
MySQL
| jOOQ version | Minimum versions (commercial editions) | Minimum version (OSS edition) |
|---|---|---|
| 3.19 (dev) | 5.6, 5.7, 8.0, 8.0.19, 8.0.20, 8.0.31 | 8.0.31 |
| 3.18 (latest) | 5.6, 5.7, 8.0, 8.0.19, 8.0.20, 8.0.31 | 8.0.31 |
| 3.17 | 5.6, 5.7, 8.0, 8.0.19, 8.0.20 | 8.0.20 |
| 3.16 | 5.6, 5.7, 8.0, 8.0.19 | 8.0.19 |
| 3.15 | 5.6, 5.7, 8.0, 8.0.19 | 8.0.19 |
| 3.14 | 5.6, 5.7, 8.0, 8.0.19 | 8.0.19 |
| 3.13 | 5.6, 5.7, 8.0, 8.0.19 | 8.0.19 |
| 3.12 | 5.6, 5.7, 8.0 | 8.0 |
| 3.11 | 5.6, 5.7, 8.0 | 8.0 |
| 3.10 | 5.6, 5.7, 8.0 | 8.0 |
| 3.9 | 5.6, 5.7 | 5.7 |
| 3.8 | 5.6, 5.7 | 5.7 |
| 3.7 | 5.6, 5.7 | 5.7 |
| 3.6 | 5.6, 5.7 | 5.7 |
Oracle
| jOOQ version | Minimum versions (commercial editions) |
|---|---|
| 3.19 (dev) | 10g, 11g, 12c, 18c, 19c, 21c, 23c |
| 3.18 (latest) | 10g, 11g, 12c, 18c, 19c, 21c |
| 3.17 | 10g, 11g, 12c, 18c, 19c, 21c |
| 3.16 | 10g, 11g, 12c, 18c, 19c, 21c |
| 3.15 | 10g, 11g, 12c, 18c, 19c |
| 3.14 | 10g, 11g, 12c, 18c, 19c |
| 3.13 | 10g, 11g, 12c, 18c |
| 3.12 | 10g, 11g, 12c, 18c |
| 3.11 | 10g, 11g, 12c |
| 3.10 | 10g, 11g, 12c |
| 3.9 | 10g, 11g, 12c |
| 3.8 | 10g, 11g, 12c |
| 3.7 | 10g, 11g, 12c |
| 3.6 | 10g, 11g, 12c |
PostgreSQL
| jOOQ version | Minimum versions (commercial editions) | Minimum version (OSS edition) |
|---|---|---|
| 3.19 (dev) | 9.3, 9.4, 9.5, 10, 11, 12, 13, 14, 15 | 15 |
| 3.18 (latest) | 9.3, 9.4, 9.5, 10, 11, 12, 13, 14, 15 | 15 |
| 3.17 | 9.3, 9.4, 9.5, 10, 11, 12, 13, 14 | 14 |
| 3.16 | 9.3, 9.4, 9.5, 10, 11, 12, 13, 14 | 14 |
| 3.15 | 9.3, 9.4, 9.5, 10, 11, 12, 13 | 13 |
| 3.14 | 9.3, 9.4, 9.5, 10, 11, 12 | 12 |
| 3.13 | 9.3, 9.4, 9.5, 10, 11 | 11 |
| 3.12 | 9.3, 9.4, 9.5, 10, 11 | 11 |
| 3.11 | 9.3, 9.4, 9.5, 10 | 10 |
| 3.10 | 9.3, 9.4, 9.5 | 9.5 |
| 3.9 | 9.3, 9.4, 9.5 | 9.5 |
| 3.8 | 9.3, 9.4, 9.5 | 9.5 |
| 3.7 | 9.3, 9.4, 9.5 | 9.5 |
| 3.6 | 9.3, 9.4 | 9.4 |
SingleStore
| jOOQ version | Minimum versions (commercial editions) |
|---|---|
| 3.19 (dev) | 6, 7, 8 |
| 3.18 (latest) | 6, 7, 8 |
| 3.17 | 6, 7 |
| 3.16 | 6, 7 |
| 3.15 | 6, 7 |
| 3.14 | 6, 7 |
| 3.13 | 6, 7 |
| 3.12 | 6, 7 |
| 3.11 | |
| 3.10 | |
| 3.9 | |
| 3.8 | |
| 3.7 | |
| 3.6 |
SQL Server
| jOOQ version | Minimum versions (commercial editions) |
|---|---|
| 3.19 (dev) | 2008, 2012, 2014, 2016, 2017, 2019, 2022 |
| 3.18 (latest) | 2008, 2012, 2014, 2016, 2017, 2019, 2022 |
| 3.17 | 2008, 2012, 2014, 2016, 2017, 2019 |
| 3.16 | 2008, 2012, 2014, 2016, 2017, 2019 |
| 3.15 | 2008, 2012, 2014, 2016, 2017, 2019 |
| 3.14 | 2008, 2012, 2014, 2016, 2017, 2019 |
| 3.13 | 2008, 2012, 2014, 2016, 2017 |
| 3.12 | 2008, 2012, 2014, 2016, 2017 |
| 3.11 | 2008, 2012, 2014, 2016, 2017 |
| 3.10 | 2008, 2012, 2014, 2016 |
| 3.9 | 2008, 2012, 2014 |
| 3.8 | 2008, 2012, 2014 |
| 3.7 | 2008, 2012, 2014 |
| 3.6 | 2008, 2012, 2014 |
SQLite
| jOOQ version | Minimum versions (commercial editions) | Minimum version (OSS edition) |
|---|---|---|
| 3.19 (dev) | 3.25, 3.28, 3.30, 3.39, 3.40 | 3.40 |
| 3.18 (latest) | 3.25, 3.28, 3.30, 3.39 | 3.39 |
| 3.17 | 3.25, 3.28, 3.30 | 3.30 |
| 3.16 | 3.25, 3.28, 3.30 | 3.30 |
| 3.15 | 3.25, 3.28, 3.30 | 3.30 |
| 3.14 | 3.25, 3.28, 3.30 | 3.30 |
| 3.13 | 3.25, 3.28, 3.30 | 3.30 |
| 3.12 | 3.25, 3.28 | 3.28 |
| 3.11 | 3.25 | 3.25 |
| 3.10 | 3.25 | 3.25 |
| 3.9 | 3.25 | 3.25 |
| 3.8 | 3.25 | 3.25 |
| 3.7 | 3.25 | 3.25 |
| 3.6 | 3.25 | 3.25 |
Sybase ASE
| jOOQ version | Minimum versions (commercial editions) |
|---|---|
| 3.19 (dev) | 12.5, 15.5, 15.7, 16.0 |
| 3.18 (latest) | 12.5, 15.5, 15.7, 16.0 |
| 3.17 | 12.5, 15.5, 15.7, 16.0 |
| 3.16 | 12.5, 15.5, 15.7, 16.0 |
| 3.15 | 12.5, 15.5, 15.7, 16.0 |
| 3.14 | 12.5, 15.5, 15.7, 16.0 |
| 3.13 | 12.5 |
| 3.12 | 12.5 |
| 3.11 | 12.5 |
| 3.10 | 12.5 |
| 3.9 | 12.5 |
| 3.8 | 12.5 |
| 3.7 | 12.5 |
| 3.6 | 12.5 |
YugabyteDB
