jOOQ
jooq.org
Spec sheet
- Purpose
- jOOQ generates Java code from a database and lets developers build type safe SQL queries through a fluent API.Read 8 Oct 2026 · jooq.org
- Integrations
- The licensing page lists dependencies or integrations including Spring, Hibernate, Liquibase, R2DBC, and Reactive Streams.Read 8 Oct 2026 · jooq.org
- Support
- Free community support is offered through GitHub, Stack Overflow, user groups, and Reddit; paying customers also get included email support.Read 8 Oct 2026 · jooq.org
- Headquarters
- St. Gallen, SwitzerlandRead 28 Sep 2026 · jooq.org
- Founded
- 2013Read 28 Sep 2026 · jooq.org
- Code generation
- The code generator creates Java classes from database metadata so Java code can be checked against schema changes at compile time.Read 8 Oct 2026 · jooq.org
- CRUD and records
- Generated Active Records support create, read, update, delete, optimistic locking, foreign key navigation, and POJO mapping.Read 8 Oct 2026 · jooq.org
- Database support
- The Open Source Edition lists ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, and YugabyteDB.Read 8 Oct 2026 · jooq.org
- Licensing and limits
- Commercial licenses are required per developer workstation using jOOQ code, while build, test, and production server licenses are included.Read 8 Oct 2026 · jooq.org
- Multi-tenancy
- jOOQ supports runtime database schema and table overrides and row-level security.Read 8 Oct 2026 · jooq.org
- Query lifecycle
- Its SPI allows custom behavior for logging, transaction management, event triggers, and SQL transformation.Read 8 Oct 2026 · jooq.org
- Security and privacy
- The licensing FAQ states jOOQ does not require a license server and does not call home.Read 8 Oct 2026 · jooq.org
- SQL dialects
- jOOQ can transform SQL expressions into equivalents supported by a target database, and its edition determines the supported dialects and versions.Read 8 Oct 2026 · jooq.org
- SQL DSL
- jOOQ embeds SQL as an internal domain specific language in Java and uses Java's compiler and generics for column type, row value expression, and SQL syntax checks.Read 8 Oct 2026 · jooq.org
- Stored procedures
- The code generator can generate callable methods for routines, and stored functions can be embedded in SQL statements in a type safe manner.Read 8 Oct 2026 · jooq.org
- Who it is for
- The maker describes jOOQ editions for open source database users, power users needing advanced features and versioned support, smaller companies needing basic commercial database support, and large companies seeking premium support.Read 8 Oct 2026 · jooq.org
Plans and prices
Open Source Edition Free Unlimited use Latest versions of listed open source databases · Apache Software License 2.0 Read 8 Oct 2026 · jooq.org
Express Edition €99 a year 99 € excl. VAT per floating developer workstation and year, including ongoing maintenance and support Supports listed databases including Oracle Express Edition, SQL Server Express Edition, and Microsoft Access Read 8 Oct 2026 · jooq.org
Professional Edition €399 a year 399 € excl. VAT per floating developer workstation and year, including ongoing maintenance and support Supports listed commercial databases including Oracle and SQL Server Read 8 Oct 2026 · jooq.org
Enterprise Edition €799 a year 799 € excl. VAT per floating developer workstation and year, including ongoing maintenance and support Broad enterprise database support · Premium support Read 8 Oct 2026 · jooq.org
Where Specifiction places it
- Code Generators#11 of 338.2
