All Classes and Interfaces

Class
Description
A convenient base implementation for custom bindings, simplifies the implementation.
A base implementation for Configuration classes, implementing the usual convenience API.
 
 
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
A common base class for stored procedures
A binding that binds JAXB-annotated Object types to SQLXML types from your database.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.
An aggregate function.
Allow a set of SQLDialect to be supported by any jOOQ statement in the scope of this annotation.
This annotation allows Allow.PlainSQL API usage within the scope of where it is placed.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER DATABASE statement.
A step in the construction of the ALTER DOMAIN statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER DOMAIN statement.
A step in the construction of the ALTER DOMAIN statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER INDEX statement.
A step in the construction of the ALTER INDEX statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER SCHEMA statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER SEQUENCE statement.
A step in the construction of the ALTER SEQUENCE statement.
The step in the ALTER TABLE DSL used to ADD columns.
The step in the ALTER TABLE DSL used to ALTER constraints.
The step in the ALTER TABLE DSL used to ALTER columns.
The step in the ALTER TABLE DSL used to DROP columns or constraints.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
The step in the ALTER TABLE DSL used to RENAME columns.
The step in the ALTER TABLE DSL used to RENAME constraints.
The step in the ALTER TABLE DSL used to RENAME indexes.
The step in the ALTER TABLE statement where the action can be decided.
The step in the ALTER TABLE … ADD CONSTRAINT statement where an optional index can be specified to enforce the constraint.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER TYPE statement.
A step in the construction of the ALTER TYPE statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the ALTER VIEW statement.
The SQL standard ARRAY_AGG() function.
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), or an associative array, additionally providing some convenience methods.
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.
A common base class for Oracle ARRAY types
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
A "record" that encapsulates an Oracle-style associative array, additionally providing some convenience methods.
A common base class for Oracle associative array types
An unqualified asterisk.
An object in jOOQ that can have an underlying Configuration attached or detached.
A type that is both Attachable and a QueryPart.
AuditGenerator<R extends Record,X extends Table<R>,T>
A Generator that can be used for audit columns, whose values are defined by Configuration.auditProvider().
An SPI to provide audit fields.
The type of the audit info produced by an AuditGenerator.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A base class for automatic conversion using Configuration.converterProvider().
Java class for BackslashEscaping.
A wrapper for a JDBC batch operation.
This type is used for the Batch's DSL API.
An operation that can run code and statements, buffering all consecutive and identical SQL strings in a BatchedPreparedStatement, delaying their execution.
A batching connection.
A batched statement.
An operation that can run code and statements, buffering all consecutive and identical SQL strings in a BatchedPreparedStatement, delaying their execution.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
An intermediate DSL type for the construction of a BETWEEN predicate.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The bind context is used for binding QueryPart's and their contained values to a PreparedStatement's bind variables.
An SPI (Service Provider Interface) that exposes all low-level interactions with JDBC bind variables.
A container type for Binding.get(BindingGetResultSetContext) arguments.
A container type for Binding.get(BindingGetSQLInputContext) arguments.
A container type for Binding.get(BindingGetStatementContext) arguments.
A container type for Binding.register(BindingRegisterContext) arguments.
A Scope that lives in the context of a data type Binding operation.
A container type for Binding.set(BindingSetSQLOutputContext) arguments.
A container type for Binding.set(BindingSetStatementContext) arguments.
A container type for Binding.sql(BindingSQLContext) arguments.
A binding that takes binary values but binds them as Blob to at the JDBC level.
A procedural block.
An internal marker subtype of DefaultDataType, to be used only by built-in data types in SQLDataType and dialect specific data type classes, such as e.g.
The parameter object passed to the CacheProvider.provide(CacheContext) method.
A provider for cache implementations to replace the default.
The set of internal cache types.
A step in the construction of the CALL statement.
An ExecuteListener that allows for functional composition.
A FormattingProvider that allows for functional composition.
A ParseListener that allows for functional composition.
A RecordListener that allows for functional composition.
A TransactionListener that allows for functional composition.
A VisitListener that allows for functional composition.
The SQL case statement.
The final step in creating a case statement of the type
An intermediary step in creating a case statement of the type
The final step in creating a case statement of the type
A catalog.
Java class for Catalog complex type.
A common base class for database catalogs
A MetaProvider that provides its meta data based on (possibly generated) catalogs.
Java class for ChangeType.
A character set.
A provider of a default Charset to be used when converting between String data and byte[] data.
A CSV formatting type, which can be used to configure chart exports.
 
The chart output format.
 
Check<R extends Record>
A check constraint.
Java class for CheckConstraint complex type.
Simple version of the JSR 305 annotation that allows for inspecting jOOQ code and detect accidentally omitted calls to Query.execute() and the likes in IntelliJ.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7258] - This part of the VisitListener SPI is deprecated.
A binding that takes binary values but binds them as Clob to at the JDBC level.
A resourceful DSLContext that should be closed in a try-with-resources statement.
A Query that holds a reference to the underlying PreparedStatement without closing it, for reuse.
A ResultQuery that holds a reference to the underlying PreparedStatement without closing it, for reuse.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A collation.
Java class for Column complex type.
A common base type for Comment and other, potential future types where DSL API accepts all types alike.
A comment.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the COMMENT ON TABLE statement.
A commit in a version control system.
An SPI that allows for providing a graph of versions.
A (sub) set of commits.
Java class for CommitType complex type.
A common table expression.
A comparator to be used in conditions to form comparison predicates.
 
A condition or predicate.
Deprecated, for removal: This API element is subject to removal in a future version.
- 2.6.0 [#1881] - This type will be removed from the public API, soon.
A Configuration configures a DSLContext, providing it with information for query rendering and execution.
The Configuration was set up in a way that does not allow for a particular operation.
An operation that can run code and statements against a provided JDBC Connection.
A connection lifecycle handler API.
An operation that can run code and statements against a provided JDBC Connection.
Some publicly available constants used in jOOQ
A DDL constraint.
The step in the Constraint construction DSL API that allows for adding ENFORCED and NOT ENFORCED clauses.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
The step in the Constraint construction DSL API that allows for adding ON DELETE and ON UPDATE clauses.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.
The step in the Constraint construction DSL API that allows for specifying the constraint type.
Container factory for creating containers for JSON object and JSON array.
A simplified and stoppable SAX-like content handler for stream processing of JSON text.
Context<C extends Context<C>>
A context type that is used for rendering SQL or for binding.
An FunctionalInterface that wraps transactional code.
An FunctionalInterface that wraps transactional code.
A step in the construction of an CONTINUE statement where a WHEN clause can be added.
An exception that is used to influence control flows.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#11898] This class will be removed in the future.
A Converter for data types.
A Scope that models the life cycle of a data type conversion call to Converter.from(Object) or Converter.to(Object).
A ConverterProvider provides Converter implementations for any combination of types <T> and <U>.
A chain of converters.
An unknown type that is used when users do not provide any explicit user type Class reference e.g.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the CREATE DOMAIN statement.
A step in the construction of the CREATE DOMAIN statement.
A step in the construction of the CREATE DOMAIN statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the CREATE FUNCTION statement.
A step in the construction of the CREATE FUNCTION statement.
A step in the construction of the CREATE FUNCTION statement.
A step in the construction of the CREATE FUNCTION statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the CREATE INDEX statement.
A step in the construction of the CREATE INDEX statement.
A step in the construction of the CREATE INDEX statement.
A step in the construction of the CREATE PROCEDURE statement.
A step in the construction of the CREATE PROCEDURE statement.
A step in the construction of the CREATE PROCEDURE statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the CREATE SEQUENCE statement.
A step in the construction of the CREATE TABLE statement.
A step in the construction of the CREATE TABLE statement.
A step in the construction of the CREATE TABLE statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the CREATE TABLE statement.
A step in the construction of the CREATE TABLE statement.
A step in the construction of the CREATE TABLE statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
A step in the construction of the CREATE TRIGGER statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A Query that can create types.
A Query that can create views.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A CSV formatting type, which can be used to configure CSV imports / exports.
When to apply the quote
A very simple CSV parser released under a commercial-friendly license.
A very simple CSV reader released under a commercial-friendly license.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13.0 - [#9403] - This dialect is hardly used by anyone with jOOQ or without jOOQ and will be removed in the near future.
Cursor<R extends Record>
Cursors allow for lazy, sequential access to an underlying JDBC ResultSet.
A base class for custom Condition implementations in client code.
A base class for custom Field implementations in client code.
A base class for custom QueryPart implementations in client code.
A base class for custom TableRecord implementations in client code.
A base class for custom Statement implementations in client code.
A base class for custom Table implementations in client code.
DAO<R extends TableRecord<R>,P,T>
A generic DAO interface for a pojo and a primary key type.
A common base implementation for generated DAO.
The DataAccessException is a generic RuntimeException indicating that something went wrong while executing a SQL statement from jOOQ.
An error occurred while storing a record with optimistic locking active, whose underlying data had already been changed.
An error occurred while running DDL statements in DSLContext.meta(org.jooq.Source...) and related API.
The DataException is jOOQ's equivalent of JDBC's SQLDataException.
An error occurred while running a Migration.
An error occurred while running Migration.validate().
A default implementation for a pooled DataSource-oriented ConnectionProvider
A common interface to all dialect-specific data types.
An error occurred while handling data types.
A binding that implements the date-as-timestamp semantics of the jOOQ code generator.
A date part can be used with SQL functions such as extract().
Deprecated.
- 3.15.0 - [#11505] - Use Converter.ofNullable(Class, Class, Function, Function) instead, e.g.
An implementation for the SQL standard INTERVAL DAY TO SECOND data type.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
A configuration type for use with the various Meta.ddl() methods.
Whether to inline foreign key constraint definitions with the table definition.
 
A marker interface for all DDL queries.
A local variable declaration.
 
 
 
 
 
 
A default JDBC CallableStatement implementation delegating all JDBC 4.0 calls to an internal delegate.
An extension of DefaultDSLContext that implements also the CloseableDSLContext contract.
A default implementation of the CommitProvider SPI, which provides a materialisation of the currently available database version graph.
A default implementation for configurations within a DSLContext, if no custom configuration was supplied to DSL.using(Configuration).
A default JDBC Connection implementation delegating all JDBC 4.0 calls to an internal delegate.
A default R2DBC Connection implementation delegating all R2DBC calls to an internal getDelegate().
A default implementation for ConnectionProvider.
A default converter provider offering the functionality of Convert.
A common base class for data types.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for DiagnosticsListenerProvider.
A default implementation for DSLContext.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for ExecuteListenerProvider.
A default Executor implementation.
A default ExecutorProvider implementation, providing a DefaultExecutor instance.
A default implementation for the FormattingProvider.
A default implementation of the MetaProvider SPI, which provides meta data information based on the JDBC DatabaseMetaData API.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for MigrationListenerProvider.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for ParseListenerProvider.
A default JDBC PreparedStatement implementation delegating all JDBC 4.0 calls to an internal delegate.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for RecordListenerProvider.
This is the default implementation for RecordMapper types, which applies to Record.into(Class), Result.into(Class), and similar calls.
A default RecordMapperProvider implementation, providing a DefaultRecordMapper instance.
A default implementation for unmapping a custom type to a Record.
A default RecordUnmapperProvider implementation, providing a DefaultRecordUnmapper instance.
A default JDBC ResultSet implementation delegating all JDBC 4.0 calls to an internal delegate.
A default JDBC Statement implementation delegating all JDBC 4.0 calls to an internal delegate.
A default R2DBC Statement implementation delegating all R2DBC calls to an internal getDelegate().
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for TransactionListenerProvider.
A default implementation for the TransactionProvider SPI.
 
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for VisitListenerProvider.
 
Delete<R extends Record>
A DELETE statement.
This type is used for the Delete's DSL API.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the Delete's DSL API.
This type is used for the Delete's DSL API.
A DELETE statement (model API).
This type is used for the Delete's DSL API.
This type is used for the Delete's DSL API.
This type is used for the Delete's DSL API.
This type is used for the Delete's DSL API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
An operation was invoked on a detached object (Query, QueryPart, or UpdatableRecord).
Java class for DiagnosticsConnection.
A parameter object that is passed to DiagnosticsListener methods.
A diagnostics listener.
A provider for TransactionListener instances.
A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.
 
An intermediate type for the construction of a relational division.
An intermediate type for the construction of a relational division
An intermediate type for the construction of a relational division
DMLQuery<R extends Record>
A marker interface for all DML queries (namely Insert, Update, Delete, and Merge).
The meta model of a SQL DOMAIN
Java class for Domain complex type.
Java class for DomainConstraint complex type.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the DROP DOMAIN statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the DROP INDEX statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the DROP INDEX statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the DROP SCHEMA statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the DROP TABLE statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A Query that can drop types.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A DSL "entry point" providing implementations to the org.jooq interfaces.
A contextual DSL providing "attached" implementations to the org.jooq interfaces.
Java class for ElementType complex type.
An embeddable record.
A record implementation for a record originating from a single table
EnumConverter<T,U extends Enum<U>>
A base class for enum conversion.
A SQL enum type.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
 
A context object for Query execution passed to registered ExecuteListener's.
The batch mode, which helps interpret the contents of ExecuteContext.batchQueries().
An event handler implementing ExecuteListener events.
An event listener for Query, Routine, or ResultSet render, prepare, bind, execute, fetch steps.
A provider for ExecuteListener instances.
A Scope that knows its ExecuteContext.
The type of database interaction that is being executed with this context.
Java class for ExecuteWithoutWhere.
The ExecutorProvider SPI can be used to provide jOOQ with custom asynchronous execution behaviour.
A step in the construction of an EXIT statement where a WHEN clause can be added.
Results of an DSLContext.explain(Query) call.
A Condition that always yields false.
Java class for FetchIntermediateResult.
A column expression.
An object that can behave like a field (a field-like object).
Deprecated.
- 3.17.0 - [#13005] - Use TableElement instead.
A common base type for Field and Row where DSL API accepts both types alike.
A common base type for Field, Row, and Select where DSL API accepts all types alike.
A common super type for various types that can provide a set of fields, similar to a Table or a Record.
A source of migration content.
A utility class that can traverse a directory structure given some ant-style file patterns, or classpath resources.
The sort algorithm to be applied to directory contents.
A set of files that are in a specific order.
Java class for FileType complex type.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
The step in the creation of a FOR LOOP statement where the BY clause can be supplied.
ForeignKey<R extends Record,O extends Record>
A ForeignKey is an object referencing a UniqueKey.
The step in the creation of a FOR LOOP statement where the IN clause can be supplied.
A type that can format its contents.
An SPI that allows for overriding certain formatting defaults.
A function of degree 0.
A function of degree 1.
A function of degree 10.
A function of degree 11.
A function of degree 12.
A function of degree 13.
A function of degree 14.
A function of degree 15.
A function of degree 16.
A function of degree 17.
A function of degree 18.
A function of degree 19.
A function of degree 2.
A function of degree 20.
A function of degree 21.
A function of degree 22.
A function of degree 3.
A function of degree 4.
A function of degree 5.
A function of degree 6.
A function of degree 7.
A function of degree 8.
A function of degree 9.
Utilities related to the construction of functions.
Generator<R extends Record,X extends Table<R>,T>
A generator can be used with DataType.generatedAlwaysAs(Generator) to implement dynamic, client side computed columns, i.e.
GeneratorContext<R extends Record,X extends Table<R>,T>
A GeneratorContext is an argument object that is passed to a Generator when generating client side computed columns.
The statement type of a GeneratorContext.
A wrapper type for spatial data obtained from the database.
A wrapper type for spatial data obtained from the database.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the GRANT statement.
A step in the construction of the GRANT statement.
A step in the construction of the GRANT statement.
MySQL's GROUP_CONCAT function.
MySQL's GROUP_CONCAT function.
An expression to be used exclusively in GROUP BY clauses.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Identity<R extends Record,T>
An Identity is an object representing an IDENTITY column as understood by the SQL:2003 standard.
A converter that doesn't convert anything.
An intermediate step in building a procedural IF statement.
An intermediate step in building a procedural IF statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A DDL index definition.
Java class for Index complex type.
Java class for IndexColumnUsage complex type.
Java class for anonymous complex type.
A MetaProvider that provides its meta data based on JAXB-annotated InformationSchema meta information.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Insert<R extends Record>
An INSERT statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
An INSERT statement (model API).
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's alternative DSL API.
This type is used for the Insert's alternative DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
This type is used for the Insert's DSL API.
The IntegrityConstraintViolationException is jOOQ's equivalent of JDBC's SQLIntegrityConstraintViolationException.
A utility class that grants access to internal API, to be used only by generated code.
Deprecated.
- 3.17.0 - [#13071] - Use ApiStatus.Internal instead.
Java class for InterpreterNameLookupCaseSensitivity.
A schema that is on the search path.
A substitute for JDBC's missing java.sql.Interval data type.
Static utility methods pertaining to int primitives, that are not already found in either Integer or Arrays.
An unexpected result was encountered after executing a Query.
Java class for InvocationOrder.
The jOOQ IOException is a wrapper for a IOException.
Deprecated.
- 3.15.0 - [#11618] - This type is no longer used by jOOQ and will be removed in the future.
Deprecated.
- 3.15.0 - [#11618] - This type is no longer used by jOOQ and will be removed in the future.
Deprecated.
- 3.15.0 - [#11618] - This type is no longer used by jOOQ and will be removed in the future.
JDBC-related utility methods.
The type of join.
The jOOQ logger abstraction.
Deprecated.
- Use Log.Level instead
A converter that delegates data type conversions to a JPA AttributeConverter.
A JSON wrapper type for JSON data obtained from the database.
A JSON array.
A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.
A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.
A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.
A step in the construction of the JSON ARRAY function.
A step in the construction of the JSON ARRAY function.
A JSON wrapper type for JSONB data obtained from the database.
A JSON entry for JSON objects.
A step in the creation of JSONEntry values.
A step in the construction of DSL.jsonExists(Field, Field) or DSL.jsonbExists(Field, Field) functions where the ON ERROR clause can be defined.
A JSON formatting type, which can be used to configure JSON imports / exports.
The format of individual JSON records.
A JSON object.
A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.
A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.
A step in the construction of the JSON OBJECT function.
A step in the construction of the JSON OBJECT function.
Parser for JSON text.
A step in the construction of an JSON_TABLE expression.
A step in the construction of an JSON_TABLE expression.
A step in the construction of an JSON_TABLE expression.
A step in the construction of an JSON_TABLE expression.
 
A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined for default values.
A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined.
A step in the construction of the JSON VALUE function.
Key<R extends Record>
A Key is an object representing a UNIQUE KEY, a PRIMARY KEY, or a FOREIGN KEY.
Java class for KeyColumnUsage complex type.
A SQL keyword.
A label for use in procedural code.
The current language context of some ParseContext or RenderContext.
A schema that references a lazy initialisable Catalog singleton, for use in generated code.
A schema that references a lazy initialisable Schema singleton, for use in generated code.
A lazy supplier
A step in the construction of the LIKE function.
A database link reference.
Loader<R extends Record>
The Loader API is used for configuring data loads.
The LoaderConfigurationException indicates that a Loader was executed with an illegal execution configuration.
A context object that provides information about a loader's current state to LoaderRowListener.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
An error that occurred during loading.
A field mapper that produces Field references for Loader target tables.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
A listener for Loader progress.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
The Loader API is used for configuring data loads.
A binding that implements the date-as-timestamp semantics of the jOOQ code generator.
 
A common logger abstraction API for jOOQ's internal logging.
The log level.
A default ExecuteListener that just logs events to java.util.logging, log4j, or slf4j using the JooqLogger
An R2DBC Batch proxy that logs all statements that are prepared or executed using it.
A JDBC Connection proxy that logs all statements that are prepared or executed using it.
An R2DBC Connection proxy that logs all statements that are prepared or executed using it.
A default implementation of a DiagnosticsListener that logs diagnostics.
 
An R2DBC Statement proxy that logs all statements that are prepared or executed using it.
Static utility methods pertaining to long primitives, that are not already found in either Long or Arrays.
An intermediate step in building a procedural LOOP statement.
A catalog mapping configuration.
A schema mapping configuration.
A table mapping configuration.
An error occurred while fetching data into a user defined Java object with any of these methods: ResultQuery.fetchInto(Class) Cursor.fetchInto(Class) Result.into(Class) Record.into(Class) ...
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The SQLDialect.MARIADB specific DSL.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Merge<R extends Record>
A MERGE statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
This type is used for the H2-specific variant of the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
This type is used for the Merge's DSL API.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
This type is used for the H2-specific variant of the Merge's DSL API.
A wrapping object for DatabaseMetaData or for other sources of database meta information (e.g.
An SPI that can produce dynamic catalog, schema, table meta data information.
An executable migration between two Commit instances.
A configuration type for use with the various Meta.migrateTo(Meta) methods.
The context in which a Migration is executed.
A listener for Migration lifecycles.
A provider for MigrationListener instances.
The public API entry point for jOOQ migrations.
The experimental migrations API.
A migration schema configuration.
Java class for MigrationsType complex type.
The migration schema and table configuration.
This class allows for mashalling / unmarshalling XML content to jOOQ configuration objects.
Various utilities related to MockDataProvider.
A mock Array.
An FunctionalInterface that wraps mockable code.
A mock configuration.
A mock connection.
A mock connection provider.
A data provider for mock query executions.
A mock execution context.
A file-based MockDataProvider.
A configuration object for the MockFileDatabase.
An unexpected result can be encountered while loading a file-based MockDataProvider.
A mock result.
A mock result set.
A mock result set meta data object.
An FunctionalInterface that wraps mockable code.
 
A mock statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The SQLDialect.MYSQL specific DSL.
An identifier.
A flag indicating whether the name is quoted or not.
A common base type for all qualifiable, named objects.
A binding that takes binary values but binds them as NClob to at the JDBC level.
Java class for NestedCollectionEmulation.
An "empty" implementation that is never connected.
No rows were returned from a ResultQuery, when exactly one row was expected.
Node<N extends Node<N>>
An abstraction over directed, acyclic graph models.
An "empty" implementation that is never transactional.
A Condition that always yields null.
An enum that specifies the nullability of a DataType.
This object contains factory methods for each Java content interface and Java element interface generated in the org.jooq.conf package.
This object contains factory methods for each Java content interface and Java element interface generated in the org.jooq.migrations.xml.jaxb package.
This object contains factory methods for each Java content interface and Java element interface generated in the org.jooq.util.xml.jaxb package.
Java class for ObjectType.
An operator used for combining conditions.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The SQLDialect.ORACLE specific DSL.
Oracle AQ related features are located here.
A flag corresponding to DBMS_AQ.DEQUEUE_OPTIONS_T.DELIVERY_MODE and to DBMS_AQ.ENQUEUE_OPTIONS_T.DELIVERY_MODE.
A flag corresponding to DBMS_AQ.DEQUEUE_OPTIONS_T.DEQUEUE_MODE.
A RECORD corresponding to DBMS_AQ.DEQUEUE_OPTIONS_T.
A RECORD corresponding to DBMS_AQ.ENQUEUE_OPTIONS_T.
A RECORD corresponding to DBMS_AQ.MESSAGE_PROPERTIES_T.
A flag corresponding to DBMS_AQ.DEQUEUE_OPTIONS_T.NAVIGATION.
A flag corresponding to DBMS_AQ.ENQUEUE_OPTIONS_T.SEQUENCE_DEVIATION.
A flag corresponding to DBMS_AQ.DEQUEUE_OPTIONS_T.VISIBILITY and to DBMS_AQ.ENQUEUE_OPTIONS_T.VISIBILITY.
A flag corresponding to DBMS_AQ.DEQUEUE_OPTIONS_T.WAIT.
An ordered-set aggregate function.
An ordered-set aggregate function.
A QueryPart to be used exclusively in ORDER BY clauses.
A container for stored procedures and functions
A default implementation for packages (containers of stored procedures and functions)
A named parameter and/or bind value.
Java class for ParamCastMode.
A parameter to a stored procedure or function.
Java class for Parameter complex type.
Java class for ParameterMode.
The mode of a Param.
A common super type of Param and Variable.
Java class for ParamType.
Java class for ParentType complex type.
A publicly available API for the internal parse context that allows for parsing SQL fragements.
ParseException explains why and where the error occurs in source JSON text.
A listener that allows for parsing custom SQL.
A provider for ParseListener instances.
Java class for ParseNameCase.
A SQL parser.
A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.
 
An exception that arises while parsing SQL through DSLContext.parser().
A schema that is on the search path.
Java class for ParseUnknownFunctions.
Java class for ParseUnsupportedSyntax.
Java class for ParseWithMetaLookups.
A period specification for usage in temporal tables.
A specification of a Period application for use in Select queries.
 
 
This implements a class that handles the PostgreSQL interval type.
PGobject is a class used to describe unknown types An unknown type is any type that is unknown by JDBC Standards.
This type is used for the Oracle PIVOT clause DSL API, pivoting Table objects to new tables.
This type is used for the Oracle PIVOT clause DSL API, pivoting Table objects to new tables.
This annotation marks all methods and types that allow for producing a QueryPart that generates "plain SQL" inside of an AST.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The SQLDialect.POSTGRES specific DSL.
A collection of utilities to cover the Postgres JDBC driver's missing implementations.
A privilege for use in GRANT and REVOKE statements.
An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.
A bridge from Flow.Publisher to Publisher for compatibility purposes.
A draft of the new query object model API.
QOM.Abs<T extends Number>
The ABS function.
The ACOS function.
The ACOSH function.
The ACOTH function.
The ADD operator.
A QueryPart that may associate an QOM.Aliasable.$alias() with the QOM.Aliasable.$aliased() part.
The ALTER DATABASE statement.
The ALTER DOMAIN statement.
The ALTER INDEX statement.
The ALTER SCHEMA statement.
The ALTER SEQUENCE statement.
The ALTER TYPE statement.
The ALTER VIEW statement.
The AND operator.
The ANY VALUE function.
 
 
The ARRAY APPEND function.
The ARRAY CONCAT function.
The ARRAY GET function.
The ARRAY OVERLAP function.
The ARRAY PREPEND function.
 
The ARRAY REMOVE function.
The ARRAY REPLACE function.
The ASCII function.
The ASIN function.
The ASINH function.
 
The ATAN function.
The ATAN2 function.
The ATANH function.
The AVG function.
The BETWEEN predicate.
The BIT AND operator.
The BIT AND AGG function.
The BIT COUNT function.
The BIT GET function.
The BIT LENGTH function.
The BIT NAND operator.
The BIT NAND AGG function.
The BIT NOR operator.
The BIT NOR AGG function.
The BIT NOT operator.
QOM.BitOr<T extends Number>
The BIT OR operator.
The BIT OR AGG function.
The BIT SET function.
The BIT X NOR operator.
The BIT X NOR AGG function.
The BIT XOR operator.
The BIT XOR AGG function.
The BOOL AND function.
The BOOL OR function.
The CALL statement.
The CARDINALITY function.
The Cascade type.
 
 
 
QOM.Ceil<T extends Number>
The CEIL function.
The CHAR LENGTH function.
 
 
The CHR function.
 
 
 
 
A Condition consisting of two Condition operands and a binary logic Operator.
The COMMENT ON TABLE statement.
The COMMIT statement.
A Condition consisting of two Field operands and a Comparator operator.
 
The FIELD function.
The CONNECT BY ISCYCLE function.
The CONNECT BY ISLEAF function.
The CONNECT BY ROOT function.
The CONTAINS operator.
The CONTAINS IGNORE CASE operator.
 
 
The CORR function.
The COS function.
The COSH function.
The COT function.
The COTH function.
The COUNT function.
 
The COVAR POP function.
The COVAR SAMP function.
The CREATE DATABASE statement.
The CREATE DOMAIN statement.
The CREATE FUNCTION statement.
The CREATE INDEX statement.
The CREATE PROCEDURE statement.
The CREATE SCHEMA statement.
The CREATE SEQUENCE statement.
The CREATE TABLE statement.
The CREATE TRIGGER statement.
The CREATE TYPE statement.
The CREATE VIEW statement.
 
 
 
 
The CURRENT CATALOG function.
 
The CURRENT SCHEMA function.
 
 
The CURRENT USER function.
The CycleOption type.
 
The DATE ADD function.
 
 
 
The DEGREES function.
The DELETE statement.
An DELETE statement with a RETURNING clause.
The DELETING function.
 
 
The Deterministic type.
The DIGITS function.
The DIV operator.
The DocumentOrContent type.
The DROP DATABASE statement.
The DROP DOMAIN statement.
The DROP FUNCTION statement.
The DROP INDEX statement.
The DROP PROCEDURE statement.
The DROP SCHEMA statement.
The DROP SEQUENCE statement.
The DROP TABLE statement.
The DROP TRIGGER statement.
The DROP TYPE statement.
The DROP VIEW statement.
 
 
The ENDS WITH operator.
The ENDS WITH IGNORE CASE operator.
The EQ operator.
The EQ operator.
The E function.
The EXCLUDED function.
The EXECUTE function.
The EXISTS function.
 
The EXP function.
 
A Condition that is always FALSE.
 
The CONDITION function.
 
 
QOM.Floor<T extends Number>
The FLOOR function.
 
The FrameExclude type.
The FrameUnits type.
The FromFirstOrLast type.
 
 
The GE operator.
 
The GenerationLocation type.
The GenerationOption type.
The GE operator.
The GOTO function.
The GRANT statement.
 
 
The GT operator.
The GT operator.
A table with a MySQL style index access hint.
The IdentityRestartOption type.
 
 
The IN operator.
The IN predicate accepting a list of values.
The INSERT statement.
The INSERTING function.
An INSERT statement with a RETURNING clause.
The IS DISTINCT FROM operator.
The IS DOCUMENT operator.
The IS JSON operator.
The IS NOT DISTINCT FROM operator.
The IS NOT DOCUMENT operator.
The IS NOT JSON operator.
The IS NOT NULL operator.
The IS NULL operator.
QOM.Join<R extends Record>
 
QOM.JoinTable<R extends Record,J extends QOM.JoinTable<R,J>>
 
The JSON ARRAY function.
 
The JSONB GET ATTRIBUTE function.
The JSONB GET ATTRIBUTE AS TEXT function.
The JSONB GET ELEMENT function.
The JSONB GET ELEMENT AS TEXT function.
The JSONB INSERT function.
The JSONB KEYS function.
The JSONB REMOVE function.
The JSONB REPLACE function.
The JSONB SET function.
The JSON GET ATTRIBUTE function.
The JSON GET ATTRIBUTE AS TEXT function.
The JSON GET ELEMENT function.
The JSON GET ELEMENT AS TEXT function.
The JSON INSERT function.
The JSON KEYS function.
The JSON OBJECT function.
 
The JSONOnNull type.
The JSON REMOVE function.
The JSON REPLACE function.
The JSON SET function.
 
 
 
 
 
The LE operator.
 
 
The LEFT function.
 
 
 
The LE operator.
The LEVEL function.
The LIKE operator.
The LIKE IGNORE CASE operator.
The LIKE operator.
A table with a database link.
The LN function.
The LOG function.
The LOG10 function.
 
The LOWER function.
The LPAD function.
The LT operator.
The LT operator.
The LTRIM function.
The Materialized type.
The MAX function.
The MD5 function.
The MEDIAN function.
The MIN function.
QOM.Mod<T extends Number>
The MOD operator.
 
The MUL operator.
 
 
 
 
 
 
The NE operator.
 
The NE operator.
The NOT operator.
The NOT operator.
The NOT IN operator.
The NOT IN predicate accepting a list of values.
The NOT LIKE operator.
The NOT LIKE IGNORE CASE operator.
The NOT LIKE operator.
The NOT SIMILAR TO operator.
The NOT SIMILAR TO operator.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#12425] - 3.16.0 - Missing implementations should be added as soon as possible!
 
 
A Condition that is always NULL.
The NullCallClause type.
The NULLIF function.
The NullOrdering type.
 
The NullTreatment type.
The NVL function.
 
The OCTET LENGTH function.
The OR operator.
 
The OVERLAY function.
 
The PI function.
The PLUS operator.
The POSITION function.
The POWER operator.
 
The PRIOR function.
The PRODUCT function.
 
The ROWID operator.
 
 
 
The Quantifier type.
The RADIANS function.
The RAND function.
 
 
 
The REGR AVGX function.
The REGR AVGY function.
The REGR COUNT function.
The REGR INTERCEPT function.
The REGR R2 function.
The REGR SLOPE function.
The REGR SXX function.
The REGR SXY function.
The REGR SYY function.
The RELEASE SAVEPOINT statement.
The REPEAT function.
The REPLACE function.
The ResultOption type.
The RETURN_ function.
The REVERSE function.
The REVOKE statement.
The RIGHT function.
 
The ROLLBACK statement.
 
QOM.Round<T extends Number>
The ROUND function.
 
 
QOM.RowEq<T extends Row>
The ROW EQ operator.
QOM.RowGe<T extends Row>
The ROW GE operator.
QOM.RowGt<T extends Row>
The ROW GT operator.
 
 
QOM.RowLe<T extends Row>
The ROW LE operator.
QOM.RowLt<T extends Row>
The ROW LT operator.
QOM.RowNe<T extends Row>
The ROW NE operator.
The ROWNUM function.
 
 
 
 
The RPAD function.
The RTRIM function.
The SAVEPOINT statement.
 
 
 
The SET CATALOG statement.
The SET statement.
The SET SCHEMA statement.
QOM.Shl<T extends Number>
The SHL operator.
QOM.Shr<T extends Number>
The SHR operator.
The SIGN function.
The SIGNAL SQL STATE function.
The SIMILAR TO operator.
The SIMILAR TO operator.
The SIN function.
The SINH function.
The SPACE function.
The SPLIT PART function.
The SQLDataAccess type.
The SQRT function.
The SQUARE function.
The ST AREA function.
The STARTS WITH operator.
The STARTS WITH IGNORE CASE operator.
The START TRANSACTION statement.
The ST ASBINARY function.
The ST ASTEXT function.
The ST CENTROID function.
The ST CONTAINS function.
The ST CROSSES function.
The STDDEV POP function.
The STDDEV SAMP function.
The ST DIFFERENCE function.
The ST DISJOINT function.
The ST DISTANCE function.
The ST ENDPOINT function.
The ST EQUALS function.
The ST EXTERIORRING function.
The ST GEOMETRYN function.
The ST GEOMETRYTYPE function.
The ST GEOMFROMTEXT function.
The ST GEOMFROMWKB function.
The ST INTERIORRINGN function.
The ST INTERSECTION function.
The ST INTERSECTS function.
The ST ISCLOSED function.
The ST ISEMPTY function.
The ST LENGTH function.
The ST NUMGEOMETRIES function.
The ST NUMINTERIORRING function.
The ST NUMPOINTS function.
The ST OVERLAPS function.
The ST POINTN function.
 
The ST SRID function.
The ST STARTPOINT function.
The ST TOUCHES function.
The ST UNION function.
The ST WITHIN function.
The ST X function.
The ST Y function.
The ST Z function.
The SUB operator.
The SUBSTRING function.
The SUBSTRING INDEX function.
The SUM function.
The SYS CONNECT BY PATH function.
 
 
The TableCommitAction type.
The EQ operator.
The NE operator.
The TAN function.
The TANH function.
The TAU function.
 
The TO CHAR function.
The TO DATE function.
The TO HEX function.
The TO TIMESTAMP function.
The TRANSLATE function.
The TRIM function.
A Condition that is always TRUE.
QOM.Trunc<T extends Number>
The TRUNC function.
The TRUNCATE statement.
A generic tuple of degree 2 for use in QOM types.
The UNIQUE function.
 
An unmodifiable Collection of QueryPart elements.
An unmodifiable List of QueryPart elements.
An unmodifiable Map of QueryPart keys and values.
The UPDATE statement.
An UPDATE statement with a RETURNING clause.
The UPDATING function.
The UPPER function.
The UUID function.
 
The VAR POP function.
The VAR SAMP function.
The WIDTH BUCKET function.
 
A WITH clause of a Select, QOM.Insert, QOM.Update, or QOM.Delete statement.
A collection derived table or table valued function with a WITH ORDINALITY clause.
The WithOrWithoutData type.
A table with a T-SQL style WITH hint.
 
The XMLCOMMENT function.
The XMLCONCAT function.
The XMLDOCUMENT function.
 
 
The XMLFOREST function.
 
The XMLPassingMechanism type.
The XMLPI function.
 
The XMLSERIALIZE function.
The XOR operator.
A QueryPart that is Named and located in a Schema.
A qualified asterisk.
A record that has a RecordQualifier (a UDTRecord or a TableRecord).
A quantified select for use in quantified comparison predicates.
A wrapper for a collection of queries.
Any query.
The common base type for all objects that can be used for query composition.
Base functionality declaration for all query objects
Java class for QueryPoolable.
Queue<R extends UDTRecord<R>>
An Oracle AQ specification.
A common base class for AQ.
A database result record.
A model type for a records with degree 1
A model type for a records with degree 10
A model type for a records with degree 11
A model type for a records with degree 12
A model type for a records with degree 13
A model type for a records with degree 14
A model type for a records with degree 15
A model type for a records with degree 16
A model type for a records with degree 17
A model type for a records with degree 18
A model type for a records with degree 19
A model type for a records with degree 2
A model type for a records with degree 20
A model type for a records with degree 21
A model type for a records with degree 22
A model type for a records with degree 3
A model type for a records with degree 4
A model type for a records with degree 5
A model type for a records with degree 6
A model type for a records with degree 7
A model type for a records with degree 8
A model type for a records with degree 9
A context object for Record manipulation passed to registered RecordListener's.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#11902] - Use Iterable.forEach(Consumer) based methods, instead.
A listener for manipulation events on UpdatableRecords.
A provider for RecordListener instances.
A RecordMapper is a mapper that can receive Record objects, when fetching data from the database, transforming them into a custom type <E>.
A provider for RecordMapper instances.
A UDT or Table.
Common utilities related to Record types and constructing RecordMapper.
A record type for Table, Cursor, Result and other objects.
A RecordUnmapper is a mapper that can receive user objects and convert them back to Record.
A provider for RecordUnmapper instances.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Java class for ReferentialConstraint complex type.
A wrapper for an Object or Class upon which reflective calls can be made.
A unchecked wrapper for any of Java's checked reflection exceptions:
 
The render context is used for rendering QueryPart's to SQL.
The cast mode for bind values.
Java class for RenderDefaultNullability.
All sorts of formatting flags / settings.
Java class for RenderImplicitJoinType.
Java class for RenderImplicitWindowRange.
Java class for RenderKeywordCase.
Deprecated.
The runtime schema and table mapping.
Java class for RenderNameCase.
Deprecated.
Java class for RenderOptionalKeyword.
Java class for RenderQuotedNames.
Java class for RenderTable.
An intermediate step in building a procedural REPEAT statement.
An API for QueryPart.$replace(Replacer) query part transformations.
A set of Replacer constructor methods.
Require a set of SQLDialect to be supported by any jOOQ statement in the scope of this annotation.
A scope that can manage resources.
Result<R extends Record>
A wrapper for database results returned by SelectQuery.
A type that contains either a Result, an update count, or an exception.
A query that can return results.
A list of Result and update counts that can be returned by ResultQuery.fetchMany() calls and other calls that produce multiple cursors and update counts.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the REVOKE statement.
A step in the construction of the REVOKE statement.
A privilege for use in GRANT and REVOKE statements.
A step in the construction of the ROLLBACK statement.
A routine is a callable object in your RDBMS.
Java class for Routine complex type.
Java class for RoutineType.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
Any query that is not a ResultQuery, and thus possibly produces a row count as a result, instead of a Result.
A data type corresponding to JDBC's Types.ROWID.
A row value expression.
An auxiliary class for constructing Row collections.
A schema.
Java class for Schema complex type.
A common base class for database schemata
Deprecated, for removal: This API element is subject to removal in a future version.
- 2.0.5 - Use runtime configuration Settings instead
A MetaProvider that provides its meta data based on (possibly generated) schemas.
Scope implementations provide access to a variety of objects that are available from a given scope.
Select<R extends Record>
A SELECT statement.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
A QueryPart to be used exclusively in SELECT clauses.
A QueryPart to be used exclusively in SELECT clauses.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
A SELECT statement (model API).
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
This type is used for the Select's DSL API when selecting generic Record types.
Sequence<T extends Number>
A sequence.
Java class for Sequence complex type.
A common base class for sequences
Settings that influence the way jOOQ renders SQL code.
Convenience methods for jOOQ runtime settings.
A step in the construction of the SIGNAL SQL STATE function.
A DataSource that wraps a single connection, preventing its closing when it is obtained from this data source.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A sort specification.
The sorting order used in ORDER BY clauses.
A source of text data.
A wrapper type for spatial data obtained from the database.
A plain SQL QueryPart.
The SQL standard data types, as described in Types.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Dialects and dialect families as supported by jOOQ.
 
A category for SQLDialect.
An exception thrown if an SQL construct is used, which is not supported by the dialect set in Configuration.dialect()
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The SQLDialect.SQLSERVER specific DSL.
The class of the SQL state as specified by the SQL:2011 standard, or by individual vendors.
The subclass of the SQL state class as specified by the SQL standard, or by individual vendors.
A statement that can be placed inside of a Block, but not executed on its own.
Java class for StatementType.
A time measuring device
A default ExecuteListener that just logs events to java.util.logging, log4j, or slf4j using the JooqLogger.
A query storing objects to the database.
An XmlAdapter that implements useful features after parsing XML strings with JAXB.
A container for annotations on stringly typed API.
The annotated string type represents a keyword Comment, which will be wrapped by DSL.comment(String).
The annotated string type represents a keyword Keyword, which will be wrapped by DSL.keyword(String).
The annotated string type represents an identifier, i.e.
The annotated string type represents a bind variable, i.e.
The annotated string type represents a plain SQL template, i.e.
Operations on String that are null safe.
A formal declaration of whether any API element is supported by a given SQLDialect
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Table<R extends Record>
A table.
Java class for Table complex type.
Java class for TableConstraint complex type.
Java class for TableConstraintType.
A common base type for Field, Constraint, and Index where DSL API accepts all types alike.
TableField<R extends Record,T>
A field contained in a table.
TableImpl<R extends Record>
A common base type for tables
TableLike<R extends Record>
An object that can behave like a table (a table-like object).
A MetaProvider that provides its meta data based on (possibly generated) schemas.
An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
An intermediate type for the construction of a JOIN clause, where there must be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field).
An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)
A description of various additional Table options to describe the table runtime meta model.
The ON COMMIT flag for TableOptions.TableType.TEMPORARY tables.
A description of the type of a Table.
An intermediate type for the construction of a partitioned SQLDialect.ORACLE OUTER JOIN clause.
An intermediate type for the construction of a partitioned SQLDialect.ORACLE OUTER JOIN clause.
A record originating from a single table
A record implementation for a record originating from a single table
Java class for TableType.
An exception that occurs with plain SQL templating.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A TransactionProvider that implements thread-bound transaction semantics.
Java class for ThrowExceptions.
Deprecated.
- 3.15.0 - [#11505] - Use Converter.ofNullable(Class, Class, Function, Function) instead, e.g.
Deprecated.
- 3.15.0 - [#11505] - Use Converter.ofNullable(Class, Class, Function, Function) instead, e.g.
Too many rows (more than 1) were returned from a ResultQuery.
A custom transaction object.
An FunctionalInterface that wraps transactional code.
An FunctionalInterface that wraps transactional code for reactive usage.
An FunctionalInterface that wraps transactional code.
A context object that is used to pass arguments to the various methods of TransactionProvider.
The TransactionListener SPI is used to intercept the TransactionProvider's transaction events.
A provider for TransactionListener instances.
The TransactionProvider SPI can be used to implement custom transaction behaviour that is applied when calling DSLContext.transactionResult(TransactionalCallable) or DSLContext.transaction(TransactionalRunnable).
Java class for Transformation.
An SPI to provide SQL transformation configuration and behaviour.
Java class for TransformUnneededArithmeticExpressions.
An API for QueryPart.$traverse(Traverser) query part traversals.
A set of Traverser constructor methods.
Deprecated.
- 3.8.0 - [#4550] Do not reference this type directly.
A Condition that always yields true.
Truncate<R extends Record>
A step in the construction of the TRUNCATE statement.
A step in the construction of the TRUNCATE statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the TRUNCATE statement.
A text formatting type, which can be used to configure text imports / exports.
A marker interface for all query parts that have a DataType.
The unsigned byte type
UDT<R extends UDTRecord<R>>
UDT definition.
UDTField<R extends UDTRecord<R>,T>
A field contained in a UDT.
UDTImpl<R extends UDTRecord<R>>
A common base type for UDT's
An object holding data of a UDT
A record implementation for a record originating from a single UDT
The unsigned int type
The unsigned long type
UniqueKey<R extends Record>
A UniqueKey is an object representing a UNIQUE KEY or a PRIMARY KEY.
A utility class for static access to unsigned number functionality.
A base type for unsigned numbers.
An unwrapper SPI that can be used to override the default unwrapping algorithm.
A provider for the Unwrapper SPI which is used to override the default behaviour when unwrapping JDBC types through Wrapper.unwrap(Class).
A common interface for records that can be stored back to the database again.
A record implementation for a record holding a primary key
Update<R extends Record>
An UPDATE statement.
This type is used for the Update's DSL API.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the Update's DSL API.
This type is used for the Update's DSL API.
This type is used for the Update's DSL API.
An UPDATE statement (model API).
This type is used for the Update's DSL API.
This type is used for the Update's DSL API.
This type is used for the Update's DSL API.
This type is used for the Update's DSL API.
This type is used for the Update's DSL API.
Java class for UpdateUnchangedRecords.
This type is used for the Update's DSL API.
A privilege for use in GRANT and REVOKE statements.
The unsigned short type
A local variable reference.
A version ID attached to a Meta description of a database.
A directed, acyclic graph of Version objects.
This type is used for the Oracle VERSIONS clause DSL API, providing access to the flashback versions query clauses.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more vendor specific DSL API will be added.
Java class for View complex type.
A context object for QueryPart traversal passed to registered VisitListener's.
A listener for QueryPart traversal events.
A provider for VisitListener instances.
This type is used for the window function DSL API.
A window definition.
This type is used for the window function DSL API.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
A window specification.
An intermediate step in the construction of a WindowSpecification.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
An intermediate step in the construction of a WindowSpecification.
An intermediate step in the construction of a WindowSpecification.
An intermediate step in the construction of a WindowSpecification.
An intermediate step in the construction of a WindowSpecification.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
Java class for WriteIfReadonly.
An XML wrapper type for XML data obtained from the database.
The SQL standard ARRAY_AGG() function.
Interface to be implemented by JAXB annotated Java classes which are serialized to XML using XMLBuilder.
A binding that binds Node types to SQLXML types from your database.
A type modelling XML attributes for use in DSL.xmlelement(Name, XMLAttributes, Field...).
Wrapper around a StringBuilder which can be used to serialize a JAXB-annotated Java object graph to XML.
A step in the construction of an XMLEXISTS predicate.
An XML formatting type, which can be used to configure XML imports / exports.
The format of individual XML records.
A step in the construction of an XMLQUERY expression.
A step in the construction of an XMLTABLE expression.
A step in the construction of an XMLTABLE expression.
A step in the construction of an XMLTABLE expression.
A step in the construction of an XMLTABLE expression.
A step in the construction of an XMLTABLE expression.
A base class for XML to JAXB POJO conversion.
An implementation for the SQL standard INTERVAL YEAR TO MONTH data type.