Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
Commercial only features
Applies to ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The commercial jOOQ editions give access to drivers for certain commercial RDBMS as well as to commercial only features, which are not available in the jOOQ Open Source Edition. These features mostly involve:
- Advanced model API usage, traversal, and transformation
- Advanced SQL transformation features
- Procedural language support (procedures, functions, triggers, anonymous blocks)
- Spatial extension support
- Computed column support (server side and client side)
- Advanced SQL parser features
- Advanced diagnostics
- Code generation extensions, e.g. for synthetic objects
- Advanced embeddable types
The below list of sections documents all the sections about commercial only features in jOOQ:
- SQL building : The DSLContext API : Custom Settings : Auto-inline bind values
- SQL building : The DSLContext API : Custom Settings : Computed column activation
- SQL building : The DSLContext API : Custom Settings : Computed column emulation
- SQL building : The DSLContext API : Custom Settings : Dialect compatibility
- SQL building : The DSLContext API : Custom Settings : Execute Logging SQL Exceptions
- SQL building : The DSLContext API : Custom Settings : Readonly column behaviour
- SQL building : The model API : Traversal
- SQL building : The model API : Replacement
- SQL building : The model API : Replacement : Pattern transformation Replacer
- SQL building : The model API : Replacement : Table mapping Replacer
- SQL building : The model API : Replacement : Listening Replacer
- SQL building : The model API : Replacement : Decomposing Replacer
- SQL building : SQL Statements (DML) : The SELECT statement : CONNECT BY clause
- SQL building : SQL Statements (DML) : The SELECT statement : FOR clause
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE FUNCTION
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE FUNCTION : Scalar functions
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE FUNCTION : CREATE OR REPLACE FUNCTION
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE FUNCTION : SQL data access characteristics
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE FUNCTION : DETERMINISTIC characteristic
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE FUNCTION : ON NULL INPUT characteristic
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE PROCEDURE
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE PROCEDURE : CREATE OR REPLACE PROCEDURE
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE PROCEDURE : SQL data access characteristics
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TABLE : Computed columns
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER : Events
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER : REFERENCING clause
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER : STATEMENT vs ROW triggers
- SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER : WHEN clause
- SQL building : SQL Statements (DDL) : The DROP statement : DROP FUNCTION
- SQL building : SQL Statements (DDL) : The DROP statement : DROP PROCEDURE
- SQL building : SQL Statements (DDL) : The DROP statement : DROP TRIGGER
- SQL building : Procedural statements
- SQL building : Procedural statements : CALL statement
- SQL building : Procedural statements : CONTINUE statement
- SQL building : Procedural statements : EXECUTE statement
- SQL building : Procedural statements : EXIT statement
- SQL building : Procedural statements : FOR statement
- SQL building : Procedural statements : GOTO statement
- SQL building : Procedural statements : IF statement
- SQL building : Procedural statements : Labels
- SQL building : Procedural statements : LOOP statement
- SQL building : Procedural statements : REPEAT statement
- SQL building : Procedural statements : SIGNAL
- SQL building : Procedural statements : Variables
- SQL building : Procedural statements : WHILE statement
- SQL building : Table expressions : Joined tables : JOIN hints : HASH JOIN
- SQL building : Table expressions : Joined tables : JOIN hints : LOOP JOIN
- SQL building : Table expressions : Joined tables : JOIN hints : MERGE JOIN
- SQL building : Table expressions : Temporal tables
- SQL building : Column expressions : Hidden columns
- SQL building : Column expressions : Readonly columns
- SQL building : Column expressions : Computed columns
- SQL building : Column expressions : Spatial functions
- SQL building : Column expressions : Spatial functions : ST_Area
- SQL building : Column expressions : Spatial functions : ST_AsText
- SQL building : Column expressions : Spatial functions : ST_Boundary
- SQL building : Column expressions : Spatial functions : ST_Centroid
- SQL building : Column expressions : Spatial functions : ST_Difference
- SQL building : Column expressions : Spatial functions : ST_Dimension
- SQL building : Column expressions : Spatial functions : ST_Distance
- SQL building : Column expressions : Spatial functions : ST_EndPoint
- SQL building : Column expressions : Spatial functions : ST_ExteriorRing
- SQL building : Column expressions : Spatial functions : ST_GeometryN
- SQL building : Column expressions : Spatial functions : ST_GeometryType
- SQL building : Column expressions : Spatial functions : ST_GeomFromText
- SQL building : Column expressions : Spatial functions : ST_InteriorRingN
- SQL building : Column expressions : Spatial functions : ST_Intersection
- SQL building : Column expressions : Spatial functions : ST_Length
- SQL building : Column expressions : Spatial functions : ST_NumGeometries
- SQL building : Column expressions : Spatial functions : ST_NumInteriorRings
- SQL building : Column expressions : Spatial functions : ST_NumPoints
- SQL building : Column expressions : Spatial functions : ST_Perimeter
- SQL building : Column expressions : Spatial functions : ST_PointN
- SQL building : Column expressions : Spatial functions : ST_SRID
- SQL building : Column expressions : Spatial functions : ST_StartPoint
- SQL building : Column expressions : Spatial functions : ST_Transform
- SQL building : Column expressions : Spatial functions : ST_Union
- SQL building : Column expressions : Spatial functions : ST_X
- SQL building : Column expressions : Spatial functions : ST_XMax
- SQL building : Column expressions : Spatial functions : ST_XMin
- SQL building : Column expressions : Spatial functions : ST_Y
- SQL building : Column expressions : Spatial functions : ST_YMax
- SQL building : Column expressions : Spatial functions : ST_YMin
- SQL building : Column expressions : Spatial functions : ST_Z
- SQL building : Column expressions : Spatial functions : ST_ZMax
- SQL building : Column expressions : Spatial functions : ST_ZMin
- SQL building : Column expressions : Aggregate functions : COLLECT
- SQL building : Conditional expressions : Spatial predicates
- SQL building : Conditional expressions : Spatial predicates : ST_Contains
- SQL building : Conditional expressions : Spatial predicates : ST_Crosses
- SQL building : Conditional expressions : Spatial predicates : ST_Disjoint
- SQL building : Conditional expressions : Spatial predicates : ST_Equals
- SQL building : Conditional expressions : Spatial predicates : ST_Intersects
- SQL building : Conditional expressions : Spatial predicates : ST_IsClosed
- SQL building : Conditional expressions : Spatial predicates : ST_IsEmpty
- SQL building : Conditional expressions : Spatial predicates : ST_IsRing
- SQL building : Conditional expressions : Spatial predicates : ST_IsSimple
- SQL building : Conditional expressions : Spatial predicates : ST_IsValid
- SQL building : Conditional expressions : Spatial predicates : ST_Overlaps
- SQL building : Conditional expressions : Spatial predicates : ST_Touches
- SQL building : Conditional expressions : Spatial predicates : ST_Within
- SQL building : SQL Parser : SQL Parser Listener
- SQL building : QueryParts : SQL transformation : ANSI JOIN to table lists
- SQL building : QueryParts : SQL transformation : Table lists to ANSI JOIN
- SQL building : QueryParts : SQL transformation : ROWNUM to LIMIT
- SQL building : QueryParts : SQL transformation : QUALIFY to derived table
- SQL building : QueryParts : SQL transformation : IN condition subquery with LIMIT to derived table
- SQL building : QueryParts : SQL transformation : GROUP BY <column index>
- SQL building : QueryParts : SQL transformation : Inline CTE
- SQL building : QueryParts : SQL transformation : Unnecessary arithmetic expressions
- SQL building : QueryParts : SQL transformation : Pattern based transformation
- SQL building : QueryParts : Policies
- SQL building : QueryParts : Policies : Configuration
- SQL building : QueryParts : Policies : Implementation
- SQL building : QueryParts : Policies : Inheritance
- SQL building : QueryParts : Policies : Security considerations
- SQL execution : Diagnostics : Consecutive aggregation
- SQL execution : Diagnostics : Concatenation in predicates
- SQL execution : Diagnostics : Possibly wrong expressions
- SQL execution : Diagnostics : Trivial condition
- SQL execution : Diagnostics : Transform patterns
- SQL execution : Logging with SQLExceptionLoggerListener
- Code generation : Advanced generator configuration : Database : Comments
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic columns
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic readonly columns
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic readonly ROWIDs
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic defaults
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic enums
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic unique keys
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic foreign keys
- Code generation : Advanced generator configuration : Database : Synthetic objects : Synthetic synonyms
- Code generation : Advanced generator configuration : Database : Hidden columns
- Code generation : Advanced generator configuration : Database : Readonly columns
- Code generation : Advanced generator configuration : Database : Forced types : Client side computed columns
- Code generation : Advanced generator configuration : Database : Forced types : Audit columns
- Code generation : Advanced generator configuration : Database : Forced types : Hidden columns
- Code generation : Advanced generator configuration : Database : Forced types : Visibility Modifier (per forced type)
- Code generation : Embeddable types : Overlapping embeddable types
- Code generation : Embeddable types : Field replacement
- Code generation : Embeddable types : Embedded keys
- Code generation : Embeddable types : Embedded domains
- Reference : Commercial only features
- Reference : Data types : Spatial data types
See also the Feature comparison for a high-level description.
Feedback
Do you have any feedback about this page? We'd love to hear it!