Share jOOQ on Facebook
Share jOOQ on Twitter

Licenses

jOOQ Open Source Logo

All of jOOQ is available for free under the terms of various Open Source licenses:

jOOQ runtime ASL 2.0
jOOQ meta ASL 2.0
jOOQ codegen ASL 2.0
jOOQ codegen output Your license

Third-party tools

Third-party tools are included under the terms of their respective license.

JSON Simple ASL 2.0
CSVParser ASL 2.0
Apache Commons ASL 2.0
jOOR ASL 2.0
jOOU ASL 2.0

jOOQ-meta-extensions API depends on

H2 Database MPL 2.0
Hibernate LGPL 2.1
Spring ASL 2.0

jOOQ-checker API depends on

Checker Framework GPL 2.0

The jOOQ documentation also includes

Sakila Database BSD
jOOQ Express Logo   jOOQ Professional Logo   jOOQ Enterprise Logo

jOOQ is dual-licensed. All of jOOQ is available under a commercial license including warranties and professional support.

jOOQ runtime jOOQ License
jOOQ meta jOOQ License
jOOQ codegen jOOQ License
jOOQ codegen output Your license

Third-party tools

The jOOQ License does not affect the licenses of the incorporated third party tools, which are shipped with jOOQ as an internal dependency under their respective license.

JSON Simple ASL 2.0
CSVParser ASL 2.0
Apache Commons ASL 2.0
jOOR ASL 2.0
jOOU ASL 2.0

jOOQ-meta-extensions depends on (doesn't ship with)

H2 Database MPL 2.0
Hibernate LGPL 2.1
Spring ASL 2.0

jOOQ-checker depends on (doesn't ship with)

Checker Framework GPL 2.0

The jOOQ documentation also includes

Sakila Database BSD

FAQ: Commercial Licensing

Q:
How many licenses do I need to buy?

A:
One for every developer workstation which is used to write jOOQ code. Server licenses are included. Examples:
  • You have 5 developers using jOOQ, you run jOOQ on 1 test server and on 1 production server, and you have 100+ clients accessing that production server. You need 5 licenses. Your test server, production server, and client licenses are included.
  • You have 2 backend developers using jOOQ to produce an application run on 5 test servers, which are used by 10 frontend developers developing the frontend application without jOOQ (e.g. using JavaScript). You need 2 licenses. Your test server licenses are included. Your frontend developer workstations do not need to be licensed.

Q:
Can I reassign a workstation to a new employee?

A:
Yes, jOOQ's Workstation License is an "unnamed license" or "floating license". You can reassign them between workstations any time, but you cannot use the same license by multiple users at the same time.

Q:
Do my build servers, test servers, or end users need to be licensed?

A:
They are licensed for free! We only charge for developer workstations, not server workstations.

Q:
Will I still get the jOOQ source code with a commercial license?

A:
Yes, we will ship the source code for documentation and debugging purposes.

Q:
Wow, can I apply fixes to the jOOQ source code myself?

A:
Yes, we trust our customers make good decisions when they fix bugs themselves in the jOOQ sources. If in doubt, contact us or refer to the jOOQ license agreement to learn about the details.

Q:
What if workstation licensing is too much administrative work for us?

A:
We also offer large-volume discounts.

Q:
We're a startup and cannot afford the license for this awesome software.

A:
Contact us for a creative solution.

FAQ: Open Source Licensing

Q:
Can I use "jOOQ Open Source Edition" also in commercial software?

A:
Yes, as any Apache-licensed software, jOOQ can be used in commercial software.

Q:
Can I use "jOOQ Open Source Edition" also with commercial databases?

A:
It is unlikely that you will get the "jOOQ Open Source Edition" to work properly with a commercial database that is not supported by the "jOOQ Open Source Edition". We strongly suggest purchasing commercial licenses.

Q:
Can I donate to jOOQ?

A:
Yes, you can! Please refer to the donations page.

Database Support

jOOQ Open Source Logo
  • CUBRID 8.4 and later
  • Derby 10.10 and later
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5, 5.6, 5.7, 8.0
  • PostgreSQL 9.3 and later
  • SQLite 3
jOOQ Express Logo
  • CUBRID 8.4 and later
  • Derby 10.10 and later
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5, 5.6, 5.7, 8.0
  • PostgreSQL 9.3 and later
  • SQLite 3

  • Microsoft Access 2013 [1]
  • Oracle 10g, 11g Express Edition
  • SQL Server 2008, 2012, 2014 Express Edition
jOOQ Professional Logo
  • CUBRID 8.4 and later
  • Derby 10.10 and later
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5, 5.6, 5.7, 8.0
  • PostgreSQL 9.3 and later
  • SQLite 3

  • Microsoft Access 2013 [1]
  • Oracle 10g, 11g, 12c (All editions)
  • SQL Server 2008, 2012, 2014, 2016 (All editions)

  • Amazon Redshift [4]
  • SQL Azure
jOOQ Enterprise Logo
  • CUBRID 8.4 and later
  • Derby 10.10 and later
  • Firebird 2.5, 3.0
  • H2 1.3, 1.4
  • HSQLDB 2.2 and later
  • MariaDB 5.2 and later
  • MySQL 5.5, 5.6, 5.7, 8.0
  • PostgreSQL 9.3 and later
  • SQLite 3

  • Microsoft Access 2013 [1]
  • Oracle 10g, 11g, 12c (All editions)
  • SQL Server 2008, 2012, 2014, 2016 (All editions)

  • Amazon Redshift [4]
  • SQL Azure

  • DB2 LUW 9.7 and later
  • HANA (All editions) [3]
  • Informix 12.10 and later[2]
  • Ingres 10.1 and later
  • Sybase ASE 15.5 and later
  • Sybase SQL Anywhere 12 and later
  • Vertica 7.1 and later[4]
The jOOQ Logo