Choose your jOOQ Edition

Choose your jOOQ Edition depending on the types of databases that you want to support.

Use this free edition with your favourite Open Source DB using the popular Apache Software License 2.0!
You're a small startup or an individual, working with Oracle Express, SQL Server Express, and/or MS Access?
You're a small or medium-sized company wanting to work with Oracle, SQL Server, and/or MS Access and you're looking for basic support?
You're a large company working with many types of enterprise databases and you're looking for premium support?

jOOQ 3.19.16

for unlimited use

free

99 € excl. VAT

per floating developer workstation and year
including ongoing maintenance and support
Secure Online Payments and Credit Card Processing by BlueSnap

399 € excl. VAT

per floating developer workstation and year
including ongoing maintenance and support
Secure Online Payments and Credit Card Processing by BlueSnap

799 € excl. VAT

per floating developer workstation and year
including ongoing maintenance and support
Secure Online Payments and Credit Card Processing by BlueSnap

These are our most popular price plans.

We also offer volume discounts, site licenses, and monthly or unlimited price plans.

Already licensed? Download your jOOQ version from here.

Database Dialect Support

The jOOQ Open Source Edition supports the latest version from the commercial editions. Commercial editions support a variety of SQL dialect versions backwards compatibly.

See this page for a more detailed version support matrix

jOOQ Open Source Logo
  • ClickHouse (latest versions) [6]
  • Derby (latest versions)
  • DuckDB (latest versions) [5]
  • Firebird (latest versions)
  • H2 (latest versions)
  • HSQLDB (latest versions)
  • MariaDB (latest versions)
  • MySQL (latest versions)
  • PostgreSQL (latest versions)
  • SQLite (latest versions)
  • Trino (latest versions) [5]
  • YugabyteDB (latest versions) [4]
jOOQ Express Logo
  • ClickHouse 24 and later [6]
  • Derby 10.10 and later
  • DuckDB 0.10.0 and later [5]
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5 and later
  • PostgreSQL 9.3 and later
  • SQLite 3
  • Trino 414 and later [5]
  • YugabyteDB 2.9 and later [4]

  • Microsoft Access 2013 and later
  • Oracle Express Edition 10g and later
  • SQL Server Express Edition 2008 and later
  • Java (to generate jOOQ code) [4]
jOOQ Professional Logo
  • ClickHouse 24 and later [6]
  • Derby 10.10 and later
  • DuckDB 0.10.0 and later [5]
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5 and later
  • PostgreSQL 9.3 and later
  • SQLite 3
  • Trino 414 and later [5]
  • YugabyteDB 2.9 and later [4]

  • Microsoft Access 2013 and later
  • Oracle (All editions) 10g and later
  • SQL Server (All editions) 2008 and later
  • Java (to generate jOOQ code) [4]

  • Amazon Redshift
  • Aurora MySQL Edition [1]
  • Aurora PostgreSQL Edition [1]
  • Azure SQL Database
  • Azure SQL Datawarehouse [1]
  • CockroachDB 19.2 and later [3]
  • MemSQL [2]
jOOQ Enterprise Logo
  • ClickHouse 24 and later [6]
  • Derby 10.10 and later
  • DuckDB 0.10.0 and later[5]
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5 and later
  • PostgreSQL 9.3 and later
  • SQLite 3
  • Trino 414 and later [5]
  • YugabyteDB 2.9 and later [4]

  • Microsoft Access 2013 and later [1]
  • Oracle (All editions) 10g and later
  • SQL Server (All editions) 2008 and later
  • Java (to generate jOOQ code) [4]

  • Amazon Redshift
  • Aurora MySQL Edition [1]
  • Aurora PostgreSQL Edition [1]
  • Azure SQL Database
  • Azure SQL Datawarehouse [1]
  • CockroachDB 19.2 and later [3]
  • MemSQL [2]

  • BigQuery [4]
  • DB2 LUW 9.7 and later
  • Exasol [4]
  • HANA (All editions)
  • Informix 12.10 and later
  • Snowflake [4]
  • Sybase ASE 15.5 and later
  • Sybase SQL Anywhere 12 and later
  • Teradata 16 and later [1]
  • Vertica 7.1 and later

Feature Comparison

Code generation

Base feature set
 
 
 
 
 
 
 
 
 
 
 
 
 
 

DML support

Base feature set
 
 
 
 
 
 
 
 
 

DDL support

Base feature set
 
 
 
 

Parser

Base feature set
 
 

Parser

Base feature set
 

Parser

Base feature set
 

Parser

Base feature set
 

SQL transformations

Base feature set
 
 
 
 
 
 
 
 
 
 

Stored procedures

Base feature set
 
 
 

Stored procedures

Base feature set
 

Stored procedures

Base feature set
 

Stored procedures

Base feature set
 

License Terms

License

Apache-2.0
Unlimited free dev workstations
Unlimited free server workstations
No custom license terms
No payment required
No renewal required

License

jOOQ Floating Workstation License
Any no of licensed dev workstations
Unlimited free server workstations
No custom license terms
Payment via Bluesnap
Automatic renewal if applicable

License

jOOQ Floating Workstation License
Any no of licensed dev workstations
Unlimited free server workstations
No custom license terms
Payment via Bluesnap
Automatic renewal if applicable

License

jOOQ Floating Workstation License
Any no of licensed dev workstations
Unlimited free server workstations
Custom license terms
Payment via Bluesnap or PO
Automatic or manual renewal

DB Support

All Open Source databases
No commercial databases

DB Support

All Open Source databases
Some commercial databases

DB Support

All Open Source databases
Some commercial databases

DB Support

All Open Source databases
All commercial databases

E-Mail Support

Best effort
No incidents
English

E-Mail Support

Best effort
No incidents
English

E-Mail Support

3 business days
3 incidents per license and year
English, German, French

E-Mail Support

1 business day
10 incidents per license and year
English, German, French

Maintenance

No warranty
Maintenance Upgrades

Maintenance

Warranty included
Maintenance Upgrades

Maintenance

Warranty included
Priority release access

Maintenance

Warranty included
Priority bug fix requests

Other price plans

Haven't found a price plan that suits your needs? Contact us for an individual price plan.

Archived versions and paid downloads

If you're looking for an old version or if you have already purchased a license, click here to download your version from the archive.

Our Preferred Resellers

Let us know if you need to get a contact from any of the above resellers, or if you want to work with a different reseller.

The jOOQ Logo