Top Description Interfaces Annotations Classes Enums
module org.jooq

Package org.jooq


This package contains jOOQ's public API.

This package mostly contains interfaces that are implemented by the org.jooq.impl package. These interfaces are constructed mostly through the org.jooq.impl.DSL and org.jooq.DSLContext classes, which hide implementation facts from the public API.

Interface Summary

Modifier and TypeInterface and Description
public interface
AggregateFilterStep<T>

Deprecated as a consequence of WindowBeforeOverStep being deprecated.
The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.
public interface
AggregateFunction<T>

Deprecated as a consequence of AggregateFilterStep being deprecated.
An aggregate function.
public interface
AlterDatabaseFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER DATABASE statement.
public interface
AlterDatabaseStep

A step in the construction of the ALTER DATABASE statement.

public interface
AlterDomainDropConstraintCascadeStep

Deprecated as a consequence of AlterDomainFinalStep being deprecated.
A step in the construction of the ALTER DOMAIN statement.
public interface
AlterDomainFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER DOMAIN statement.
public interface
AlterDomainRenameConstraintStep

A step in the construction of the ALTER DOMAIN statement.

public interface
AlterDomainStep<T>

A step in the construction of the ALTER DOMAIN statement.

public interface
AlterIndexFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER INDEX statement.
public interface
AlterIndexOnStep

A step in the construction of the ALTER INDEX statement.

public interface
AlterIndexStep

A step in the construction of the ALTER INDEX statement.

public interface
AlterSchemaFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER SCHEMA statement.
public interface
AlterSchemaStep

A step in the construction of the ALTER SCHEMA statement.

public interface
AlterSequenceFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER SEQUENCE statement.
public interface
AlterSequenceFlagsStep<T extends Number>

Deprecated as a consequence of AlterSequenceFinalStep being deprecated.
A step in the construction of the ALTER SEQUENCE statement.
public interface
AlterSequenceStep<T extends Number>

Deprecated as a consequence of AlterSequenceFlagsStep being deprecated.
A step in the construction of the ALTER SEQUENCE statement.
public interface
AlterTableAddStep

Deprecated as a consequence of AlterTableFinalStep being deprecated.
The step in the ALTER TABLE DSL used to ADD columns.
public interface
AlterTableAlterConstraintStep

The step in the ALTER TABLE DSL used to ALTER constraints.

public interface
AlterTableAlterStep<T>

The step in the ALTER TABLE DSL used to ALTER columns.

public interface
AlterTableDropStep

Deprecated as a consequence of AlterTableFinalStep being deprecated.
The step in the ALTER TABLE DSL used to DROP columns or constraints.
public interface
AlterTableFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
The final step in the ALTER TABLE DSL.
public interface
AlterTableRenameColumnToStep

The step in the ALTER TABLE DSL used to RENAME columns.

public interface
AlterTableRenameConstraintToStep

The step in the ALTER TABLE DSL used to RENAME constraints.

public interface
AlterTableRenameIndexToStep

The step in the ALTER TABLE DSL used to RENAME indexes.

public interface
AlterTableStep

The step in the ALTER TABLE statement where the action can be decided.

public interface
AlterTableUsingIndexStep

Deprecated as a consequence of AlterTableFinalStep being deprecated.
The step in the ALTER TABLE … ADD CONSTRAINT statement where an optional index can be specified to enforce the constraint.
public interface
AlterTypeFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER TYPE statement.
public interface
AlterTypeRenameValueToStep

A step in the construction of the ALTER TYPE statement.

public interface
AlterTypeStep

A step in the construction of the ALTER TYPE statement.

public interface
AlterViewFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the ALTER VIEW statement.
public interface
AlterViewStep

A step in the construction of the ALTER VIEW statement.

public interface
ArrayAggOrderByStep<T>

Deprecated as a consequence of AggregateFilterStep being deprecated.
The SQL standard ARRAY_AGG() function.
public interface
Asterisk

An unqualified asterisk.

public interface
Attachable

An object in jOOQ that can have an underlying Configuration attached or detached.

public interface
AttachableQueryPart

A type that is both Attachable and a QueryPart.

public interface
Batch

A wrapper for a JDBC batch operation.

public interface
BatchBindStep

This type is used for the Batch's DSL API.

public interface
BatchedCallable<T>

An operation that can run code and statements, buffering all consecutive and identical SQL strings in a BatchedPreparedStatement, delaying their execution.

public interface
BatchedRunnable

An operation that can run code and statements, buffering all consecutive and identical SQL strings in a BatchedPreparedStatement, delaying their execution.

public interface
BetweenAndStep<T>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep1<T1>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep2<T1, T2>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep3<T1, T2, T3>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep4<T1, T2, T3, T4>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep5<T1, T2, T3, T4, T5>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep6<T1, T2, T3, T4, T5, T6>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep7<T1, T2, T3, T4, T5, T6, T7>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep8<T1, T2, T3, T4, T5, T6, T7, T8>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStep9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStepN

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BetweenAndStepR<R extends Record>

An intermediate DSL type for the construction of a BETWEEN predicate.

public interface
BindContext

The bind context is used for binding QueryPart's and their contained values to a PreparedStatement's bind variables.

public interface
Binding<
The database type - i.e. any type available from SQLDataType
T
,
The user type
U
>

An SPI (Service Provider Interface) that exposes all low-level interactions with JDBC bind variables.

public interface
public interface
public interface
public interface
public interface
BindingScope

A Scope that lives in the context of a data type Binding operation.

public interface
public interface
public interface
BindingSQLContext<U>

A container type for Binding#sql(BindingSQLContext) arguments.

public interface
Block

A procedural block.

public interface
CacheContext

The parameter object passed to the CacheProvider#provide(CacheContext) method.

public interface
CacheProvider

A provider for cache implementations to replace the default.

public interface
Case

The SQL case statement.

public interface
CaseConditionStep<
The type returned by this case statement
T
>

Deprecated as a consequence of Field being deprecated.
The final step in creating a case statement of the type

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
public interface
CaseValueStep<
The type of values being compared in this case statement
V
>

An intermediary step in creating a case statement of the type


CASE x WHEN 1 THEN 'one'
       WHEN 2 THEN 'two'
       ELSE        'three'
END
public interface
CaseWhenStep<
The type of values being compared in this case statement
V
,
The type returned by this case statement
T
>

Deprecated as a consequence of Field being deprecated.
The final step in creating a case statement of the type

CASE x WHEN 1 THEN 'one'
       WHEN 2 THEN 'two'
       ELSE        'three'
END
public interface
Catalog

A catalog.

public interface
CharacterSet

A character set.

public interface
CharsetProvider

A provider of a default Charset to be used when converting between String data and byte[] data.

public interface
Check<
The CHECK's owner table record
R extends Record
>

A check constraint.

public interface
CloseableDSLContext

A resourceful DSLContext that should be closed in a try-with-resources statement.

public interface
CloseableQuery

A Query that holds a reference to the underlying PreparedStatement without closing it, for reuse.

public interface
CloseableResultQuery<R extends Record>

A ResultQuery that holds a reference to the underlying PreparedStatement without closing it, for reuse.

public interface
Collation

A collation.

public interface
ColumnElement

A common base type for Comment and other, potential future types where DSL API accepts all types alike.

public interface
Comment

A comment.

public interface
CommentOnFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the COMMENT ON TABLE statement.
public interface
CommentOnIsStep

A step in the construction of the COMMENT ON TABLE statement.

public interface
Commit

A commit in a version control system.

public interface
CommitProvider

An SPI that allows for providing a graph of versions.

public interface
Commits

A (sub) set of commits.

public interface
CommonTableExpression<R extends Record>

A common table expression.

public interface
Condition

Deprecated as a consequence of Field being deprecated.
A condition or predicate.
public interface
ConditionProvider

Deprecated for removal since 2.6. - 2.6.0 [#1881] - This type will be removed from the public API, soon. Its methods will be pushed down into extending interfaces. Do not reference this type directly.
A common interface for all objects holding conditions (e.g. queries).
public interface
Configuration

A Configuration configures a DSLContext, providing it with information for query rendering and execution.

public interface
ConnectionCallable<T>

An operation that can run code and statements against a provided JDBC Connection.

public interface
ConnectionProvider

A connection lifecycle handler API.

public interface
ConnectionRunnable

An operation that can run code and statements against a provided JDBC Connection.

public interface
Constraint

Deprecated as a consequence of FieldOrConstraint being deprecated.
A DDL constraint.
public interface
ConstraintEnforcementStep

Deprecated as a consequence of ConstraintFinalStep being deprecated.
The step in the Constraint construction DSL API that allows for adding ENFORCED and NOT ENFORCED clauses.
public interface
ConstraintFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
The final step in the Constraint construction DSL API.
public interface
ConstraintForeignKeyOnStep

Deprecated as a consequence of ConstraintEnforcementStep being deprecated.
The step in the Constraint construction DSL API that allows for adding ON DELETE and ON UPDATE clauses.
public interface
ConstraintForeignKeyReferencesStep1<T1>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep2<T1, T2>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep3<T1, T2, T3>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep4<T1, T2, T3, T4>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep5<T1, T2, T3, T4, T5>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep6<T1, T2, T3, T4, T5, T6>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep7<T1, T2, T3, T4, T5, T6, T7>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep8<T1, T2, T3, T4, T5, T6, T7, T8>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStep9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintForeignKeyReferencesStepN

The step in the Constraint construction DSL API that allows for matching a FOREIGN KEY clause with a REFERENCES clause.

public interface
ConstraintTypeStep

Deprecated as a consequence of ConstraintFinalStep being deprecated.
The step in the Constraint construction DSL API that allows for specifying the constraint type.
public interface
Context<C extends Context<C>>

A context type that is used for rendering SQL or for binding.

public interface
ContextConverter<T, U>

A special type of Converter with alternative from(Object, ConverterContext) and to(Object, ConverterContext) methods.

public interface
ContextTransactionalCallable<T>

An FunctionalInterface that wraps transactional code.

public interface
ContextTransactionalRunnable

An FunctionalInterface that wraps transactional code.

public interface
Converter<
The database type - i.e. any type available from SQLDataType
T
,
The user type
U
>

A Converter for data types.

public interface
ConverterContext

A Scope that models the life cycle of a data type conversion call to Converter#from(Object) or Converter#to(Object).

public interface
ConverterProvider

A ConverterProvider provides Converter implementations for any combination of types <T> and <U>.

public interface
CreateDatabaseFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the CREATE DATABASE statement.
public interface
CreateDomainAsStep

A step in the construction of the CREATE DOMAIN statement.

public interface
CreateDomainConstraintStep

Deprecated as a consequence of CreateDomainFinalStep being deprecated.
A step in the construction of the CREATE DOMAIN statement.
public interface
CreateDomainDefaultStep<T>

Deprecated as a consequence of CreateDomainConstraintStep being deprecated.
A step in the construction of the CREATE DOMAIN statement.
public interface
CreateDomainFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the CREATE DOMAIN statement.
public interface
CreateIndexFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the CREATE INDEX statement.
public interface
CreateIndexIncludeStep

Deprecated as a consequence of CreateIndexWhereStep being deprecated.
A step in the construction of the CREATE INDEX statement.
public interface
CreateIndexStep

A step in the construction of the CREATE INDEX statement.

public interface
CreateIndexWhereStep

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
A step in the construction of the CREATE INDEX statement.
public interface
CreateSchemaFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the CREATE SCHEMA statement.
public interface
CreateSequenceFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the CREATE SEQUENCE statement.
public interface
CreateSequenceFlagsStep

Deprecated as a consequence of CreateSequenceFinalStep being deprecated.
A step in the construction of the CREATE SEQUENCE statement.
public interface
CreateTableAsStep

Deprecated as a consequence of CreateTableOnCommitStep being deprecated.
A step in the construction of the CREATE TABLE statement.
public interface
CreateTableCommentStep

Deprecated as a consequence of CreateTableStorageStep being deprecated.
A step in the construction of the CREATE TABLE statement.
public interface
CreateTableElementListStep

Deprecated as a consequence of CreateTableAsStep being deprecated.
A step in the construction of the CREATE TABLE statement.
public interface
CreateTableFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the CREATE TABLE statement.
public interface
CreateTableOnCommitStep

Deprecated as a consequence of CreateTableCommentStep being deprecated.
A step in the construction of the CREATE TABLE statement.
public interface
CreateTableStorageStep

Deprecated as a consequence of CreateTableFinalStep being deprecated.
A step in the construction of the CREATE TABLE statement.
public interface
CreateTableWithDataStep

Deprecated as a consequence of CreateTableOnCommitStep being deprecated.
A step in the construction of the CREATE TABLE statement.
public interface
CreateTypeFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
A Query that can create types.
public interface
CreateTypeStep

A Query that can create types.

public interface
CreateViewAsStep<R extends Record>

A Query that can create views.

public interface
CreateViewFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
A Query that can create views.
public interface
Cursor<
The cursor's record type
R extends Record
>

Cursors allow for lazy, sequential access to an underlying JDBC ResultSet.

public interface
DAO<
The generic record type.
R extends TableRecord<R>
,
The generic POJO type.
P
,
The generic primary key type. This is a regular <T> type for single-column keys, or a Record subtype for composite keys.
T
>

A generic DAO interface for a pojo and a primary key type.

public interface
DataType<
The Java type associated with this SQL data type
T
>

A common interface to all dialect-specific data types.

public interface
DDLQuery

A marker interface for all DDL queries.

public interface
Delete<R extends Record>

A DELETE statement.

public interface
DeleteConditionStep<R extends Record>

Deprecated as a consequence of DeleteOrderByStep being deprecated.
This type is used for the Delete's DSL API.
public interface
DeleteFinalStep<R extends Record>

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
This type is used for the Delete's DSL API.
public interface
DeleteLimitStep<R extends Record>

Deprecated as a consequence of DeleteReturningStep being deprecated.
This type is used for the Delete's DSL API.
public interface
DeleteOrderByStep<R extends Record>

Deprecated as a consequence of DeleteLimitStep being deprecated.
This type is used for the Delete's DSL API.
public interface
DeleteQuery<
The record type of the table being deleted from
R extends Record
>

Deprecated as a consequence of ConditionProvider being deprecated.
A DELETE statement (model API).
public interface
DeleteResultStep<R extends Record>

This type is used for the Delete's DSL API.

public interface
DeleteReturningStep<R extends Record>

Deprecated as a consequence of DeleteFinalStep being deprecated.
This type is used for the Delete's DSL API.
public interface
DeleteUsingStep<R extends Record>

Deprecated as a consequence of DeleteWhereStep being deprecated.
This type is used for the Delete's DSL API.
public interface
DeleteWhereStep<R extends Record>

Deprecated as a consequence of DeleteOrderByStep being deprecated.
This type is used for the Delete's DSL API.
public interface
DerivedColumnList

A derived column list.

public interface
DerivedColumnList1

A derived column list.

public interface
DerivedColumnList10

A derived column list.

public interface
DerivedColumnList11

A derived column list.

public interface
DerivedColumnList12

A derived column list.

public interface
DerivedColumnList13

A derived column list.

public interface
DerivedColumnList14

A derived column list.

public interface
DerivedColumnList15

A derived column list.

public interface
DerivedColumnList16

A derived column list.

public interface
DerivedColumnList17

A derived column list.

public interface
DerivedColumnList18

A derived column list.

public interface
DerivedColumnList19

A derived column list.

public interface
DerivedColumnList2

A derived column list.

public interface
DerivedColumnList20

A derived column list.

public interface
DerivedColumnList21

A derived column list.

public interface
DerivedColumnList22

A derived column list.

public interface
DerivedColumnList3

A derived column list.

public interface
DerivedColumnList4

A derived column list.

public interface
DerivedColumnList5

A derived column list.

public interface
DerivedColumnList6

A derived column list.

public interface
DerivedColumnList7

A derived column list.

public interface
DerivedColumnList8

A derived column list.

public interface
DerivedColumnList9

A derived column list.

public interface
DiagnosticsContext

A parameter object that is passed to DiagnosticsListener methods.

public interface
DiagnosticsListener

A diagnostics listener.

public interface
public interface
DivideByOnConditionStep

An intermediate type for the construction of a relational division.

public interface
DivideByOnStep

An intermediate type for the construction of a relational division

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables.

public interface
DivideByReturningStep

An intermediate type for the construction of a relational division

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables.

public interface
DMLQuery<R extends Record>

A marker interface for all DML queries (namely Insert, Update, Delete, and Merge).

public interface
Domain<T>

The meta model of a SQL DOMAIN

public interface
DropDatabaseFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP DATABASE statement.
public interface
DropDomainCascadeStep

Deprecated as a consequence of DropDomainFinalStep being deprecated.
A step in the construction of the DROP DOMAIN statement.
public interface
DropDomainFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP DOMAIN statement.
public interface
DropIndexCascadeStep

Deprecated as a consequence of DropIndexFinalStep being deprecated.
A step in the construction of the DROP INDEX statement.
public interface
DropIndexFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP INDEX statement.
public interface
DropIndexOnStep

Deprecated as a consequence of DropIndexCascadeStep being deprecated.
A step in the construction of the DROP INDEX statement.
public interface
DropSchemaFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP SCHEMA statement.
public interface
DropSchemaStep

Deprecated as a consequence of DropSchemaFinalStep being deprecated.
A step in the construction of the DROP SCHEMA statement.
public interface
DropSequenceFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP SEQUENCE statement.
public interface
DropTableFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP TABLE statement.
public interface
DropTableStep

Deprecated as a consequence of DropTableFinalStep being deprecated.
A step in the construction of the DROP TABLE statement.
public interface
DropTypeFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
A Query that can drop types.
public interface
DropTypeStep

Deprecated as a consequence of DropTypeFinalStep being deprecated.
A Query that can drop types.
public interface
DropViewFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the DROP VIEW statement.
public interface
DSLContext

A contextual DSL providing "attached" implementations to the org.jooq interfaces.

public interface
EmbeddableRecord<
The embeddable record type
R extends EmbeddableRecord<R>
>

A record originating from a single table

public interface
EnumType

A SQL enum type.

public interface
ExecuteContext

A context object for Query execution passed to registered ExecuteListener's.

public interface
ExecuteEventHandler

An event handler implementing ExecuteListener events.

public interface
ExecuteListener

An event listener for Query, Routine, or ResultSet render, prepare, bind, execute, fetch steps.

public interface
ExecuteListenerProvider

A provider for ExecuteListener instances.

public interface
public interface
ExecutorProvider

The ExecutorProvider SPI can be used to provide jOOQ with custom asynchronous execution behaviour.

public interface
public interface
False

Deprecated as a consequence of Condition being deprecated.
A Condition that always yields false.
public interface
Field<
The field type
T
>

Deprecated as a consequence of FieldOrConstraint being deprecated.
A column expression.
public interface
FieldLike

An object that can behave like a field (a field-like object).

public interface
FieldOrConstraint

Deprecated - 3.17.0 - [#13005] - Use TableElement instead.
A common base type for Field and Constraint where DSL API accepts both types alike.
public interface
FieldOrRow

A common base type for Field and Row where DSL API accepts both types alike.

public interface
FieldOrRowOrSelect

A common base type for Field, Row, and Select where DSL API accepts all types alike.

public interface
Fields

A common super type for various types that can provide a set of fields, similar to a Table or a Record.

public interface
File

A source of migration content.

public interface
Files

A set of files that are in a specific order.

public interface
ForeignKey<
The FOREIGN KEY's owner table record
R extends Record
,
The referenced KEY's owner table record
O extends Record
>

A ForeignKey is an object referencing a UniqueKey.

public interface
Formattable

A type that can format its contents.

public interface
FormattingProvider

An SPI that allows for overriding certain formatting defaults.

public interface
Function0<R>

A function of degree 0.

public interface
Function1<T1, R>

A function of degree 1.

public interface
Function10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, R>

A function of degree 10.

public interface
Function11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, R>

A function of degree 11.

public interface
Function12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, R>

A function of degree 12.

public interface
Function13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, R>

A function of degree 13.

public interface
Function14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, R>

A function of degree 14.

public interface
Function15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, R>

A function of degree 15.

public interface
Function16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, R>

A function of degree 16.

public interface
Function17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, R>

A function of degree 17.

public interface
Function18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, R>

A function of degree 18.

public interface
Function19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, R>

A function of degree 19.

public interface
Function2<T1, T2, R>

A function of degree 2.

public interface
Function20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, R>

A function of degree 20.

public interface
Function21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, R>

A function of degree 21.

public interface
Function22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22, R>

A function of degree 22.

public interface
Function3<T1, T2, T3, R>

A function of degree 3.

public interface
Function4<T1, T2, T3, T4, R>

A function of degree 4.

public interface
Function5<T1, T2, T3, T4, T5, R>

A function of degree 5.

public interface
Function6<T1, T2, T3, T4, T5, T6, R>

A function of degree 6.

public interface
Function7<T1, T2, T3, T4, T5, T6, T7, R>

A function of degree 7.

public interface
Function8<T1, T2, T3, T4, T5, T6, T7, T8, R>

A function of degree 8.

public interface
Function9<T1, T2, T3, T4, T5, T6, T7, T8, T9, R>

A function of degree 9.

public interface
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. computed columns with GenerationLocation#CLIENT.

public interface
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.

public interface
GrantFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the GRANT statement.
public interface
GrantOnStep

A step in the construction of the GRANT statement.

public interface
GrantToStep

A step in the construction of the GRANT statement.

public interface
GrantWithGrantOptionStep

Deprecated as a consequence of GrantFinalStep being deprecated.
A step in the construction of the GRANT statement.
public interface
GroupConcatOrderByStep

Deprecated as a consequence of GroupConcatSeparatorStep being deprecated.
MySQL's GROUP_CONCAT function.
public interface
GroupConcatSeparatorStep

Deprecated as a consequence of AggregateFunction being deprecated.
MySQL's GROUP_CONCAT function.
public interface
GroupField

An expression to be used exclusively in GROUP BY clauses.

public interface
Identity<
The IDENTITY's owner table record
R extends Record
,
The IDENTITY's field type
T
>

An Identity is an object representing an IDENTITY column as understood by the SQL:2003 standard.

public interface
Index

A DDL index definition.

public interface
Insert<R extends Record>

An INSERT statement.

public interface
InsertFinalStep<R extends Record>

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
This type is used for the Insert's DSL API.
public interface
InsertOnConflictConditionStep<R extends Record>

Deprecated as a consequence of InsertReturningStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertOnConflictDoUpdateStep<R extends Record>

This type is used for the Insert's DSL API.

public interface
InsertOnConflictWhereIndexPredicateStep<R extends Record>

This type is used for the Insert's DSL API.

public interface
InsertOnConflictWhereStep<R extends Record>

Deprecated as a consequence of InsertReturningStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertOnDuplicateSetMoreStep<R extends Record>

Deprecated as a consequence of InsertOnConflictWhereStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertOnDuplicateSetStep<R extends Record>

This type is used for the Insert's DSL API.

public interface
InsertOnDuplicateStep<R extends Record>

Deprecated as a consequence of InsertReturningStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertQuery<
The record type of the table being inserted into
R extends Record
>

Deprecated as a consequence of ConditionProvider being deprecated.
An INSERT statement (model API).
public interface
InsertResultStep<R extends Record>

This type is used for the Insert's DSL API.

public interface
InsertReturningStep<R extends Record>

Deprecated as a consequence of InsertFinalStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertSetMoreStep<R extends Record>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's alternative DSL API.
public interface
InsertSetStep<R extends Record>

This type is used for the Insert's alternative DSL API.

public interface
InsertValuesStep1<R extends Record, T1>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep10<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep11<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep12<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep13<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep14<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep15<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep16<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep17<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep18<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep19<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep2<R extends Record, T1, T2>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep20<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep21<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep22<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep3<R extends Record, T1, T2, T3>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep4<R extends Record, T1, T2, T3, T4>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep5<R extends Record, T1, T2, T3, T4, T5>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep6<R extends Record, T1, T2, T3, T4, T5, T6>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep7<R extends Record, T1, T2, T3, T4, T5, T6, T7>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep8<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStep9<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
InsertValuesStepN<R extends Record>

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
This type is used for the Insert's DSL API.
public interface
JSONArrayAggNullStep<T>

Deprecated as a consequence of JSONArrayAggReturningStep being deprecated.
A step in the construction of DSL#jsonArrayAgg(Field) or DSL#jsonbArrayAgg(Field) functions where the NULL clause can be defined.
public interface
JSONArrayAggOrderByStep<J>

Deprecated as a consequence of JSONArrayAggNullStep being deprecated.
A step in the construction of DSL#jsonArrayAgg(Field) or DSL#jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.
public interface
JSONArrayAggReturningStep<T>

Deprecated as a consequence of AggregateFilterStep being deprecated.
A step in the construction of DSL#jsonArrayAgg(Field) or DSL#jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.
public interface
JSONArrayNullStep<T>

Deprecated as a consequence of JSONArrayReturningStep being deprecated.
A step in the construction of the JSON ARRAY function.
public interface
JSONArrayReturningStep<T>

Deprecated as a consequence of Field being deprecated.
A step in the construction of the JSON ARRAY function.
public interface
JSONEntry<T>

A JSON entry for JSON objects.

public interface
JSONEntryValueStep

A step in the creation of JSONEntry values.

public interface
JSONExistsOnStep

Deprecated as a consequence of Condition being deprecated.
A step in the construction of DSL#jsonExists(Field, Field) or DSL#jsonbExists(Field, Field) functions where the ON ERROR clause can be defined.
public interface
JSONObjectAggNullStep<T>

Deprecated as a consequence of JSONObjectAggReturningStep being deprecated.
A step in the construction of DSL#jsonObjectAgg(JSONEntry) or DSL#jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.
public interface
JSONObjectAggReturningStep<T>

Deprecated as a consequence of AggregateFilterStep being deprecated.
A step in the construction of DSL#jsonObjectAgg(JSONEntry) or DSL#jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.
public interface
JSONObjectNullStep<T>

Deprecated as a consequence of JSONObjectReturningStep being deprecated.
A step in the construction of the JSON OBJECT function.
public interface
JSONObjectReturningStep<T>

Deprecated as a consequence of Field being deprecated.
A step in the construction of the JSON OBJECT function.
public interface
JSONTableColumnForOrdinalityStep

A step in the construction of an JSON_TABLE expression.

public interface
JSONTableColumnPathStep

A step in the construction of an JSON_TABLE expression.

public interface
JSONTableColumnsFirstStep

A step in the construction of an JSON_TABLE expression.

public interface
JSONTableColumnsStep

A step in the construction of an JSON_TABLE expression.

public interface
JSONValueDefaultStep<J>

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.

public interface
JSONValueOnStep<J>

Deprecated as a consequence of JSONValueReturningStep being deprecated.
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.
public interface
JSONValueReturningStep<T>

Deprecated as a consequence of Field being deprecated.
A step in the construction of the JSON VALUE function.
public interface
Key<
The KEY's owner table record
R extends Record
>

A Key is an object representing a UNIQUE KEY, a PRIMARY KEY, or a FOREIGN KEY.

public interface
Keyword

A SQL keyword.

public interface
LikeEscapeStep

Deprecated as a consequence of Condition being deprecated.
A step in the construction of the LIKE function.
public interface
Loader<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderContext

A context object that provides information about a loader's current state to LoaderRowListener.

public interface
LoaderCSVOptionsStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderCSVStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderError

An error that occurred during loading.

public interface
LoaderFieldMapper

A field mapper that produces Field references for Loader target tables.

public interface
LoaderJSONOptionsStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderJSONStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderListenerStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderLoadStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderOptionsStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderRowListener

A listener for Loader progress.

public interface
LoaderRowsStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderSourceStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
LoaderXMLStep<R extends Record>

The Loader API is used for configuring data loads.

public interface
Log

A common logger abstraction API for jOOQ's internal logging.

public interface
Merge<R extends Record>

A MERGE statement.

public interface
MergeFinalStep<R extends Record>

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
This type is used for the Merge's DSL API.
public interface
MergeKeyStep1<R extends Record, T1>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep10<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep11<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep12<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep13<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep14<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep15<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep16<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep17<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep18<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep19<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep2<R extends Record, T1, T2>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep20<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep21<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep22<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep3<R extends Record, T1, T2, T3>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep4<R extends Record, T1, T2, T3, T4>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep5<R extends Record, T1, T2, T3, T4, T5>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep6<R extends Record, T1, T2, T3, T4, T5, T6>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep7<R extends Record, T1, T2, T3, T4, T5, T6, T7>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep8<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStep9<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>

Deprecated for removal since 3.14. - [#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.
public interface
MergeKeyStepN<R extends Record>

This type is used for the H2-specific variant of the Merge's DSL API.

public interface
MergeMatchedDeleteStep<R extends Record>

Deprecated as a consequence of MergeMatchedStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeMatchedSetMoreStep<R extends Record>

Deprecated as a consequence of MergeMatchedWhereStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeMatchedSetStep<R extends Record>

This type is used for the Merge's DSL API.

public interface
MergeMatchedStep<R extends Record>

Deprecated as a consequence of MergeNotMatchedStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeMatchedThenStep<R extends Record>

This type is used for the Merge's DSL API.

public interface
MergeMatchedWhereStep<R extends Record>

Deprecated as a consequence of MergeMatchedDeleteStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeNotMatchedSetMoreStep<R extends Record>

Deprecated as a consequence of MergeNotMatchedWhereStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeNotMatchedSetStep<R extends Record>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedStep<R extends Record>

Deprecated as a consequence of MergeFinalStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeNotMatchedValuesStep1<R extends Record, T1>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep10<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep11<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep12<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep13<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep14<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep15<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep16<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep17<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep18<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep19<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep2<R extends Record, T1, T2>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep20<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep21<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep22<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep3<R extends Record, T1, T2, T3>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep4<R extends Record, T1, T2, T3, T4>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep5<R extends Record, T1, T2, T3, T4, T5>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep6<R extends Record, T1, T2, T3, T4, T5, T6>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep7<R extends Record, T1, T2, T3, T4, T5, T6, T7>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep8<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStep9<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedValuesStepN<R extends Record>

This type is used for the Merge's DSL API.

public interface
MergeNotMatchedWhereStep<R extends Record>

Deprecated as a consequence of MergeFinalStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeOnConditionStep<R extends Record>

Deprecated as a consequence of MergeMatchedStep being deprecated.
This type is used for the Merge's DSL API.
public interface
MergeOnStep<R extends Record>

This type is used for the Merge's DSL API.

public interface
MergeUsingStep<R extends Record>

This type is used for the Merge's DSL API.

public interface
MergeValuesStep1<R extends Record, T1>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep10<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep11<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep12<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep13<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep14<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep15<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep16<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep17<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep18<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep19<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep2<R extends Record, T1, T2>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep20<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep21<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep22<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep3<R extends Record, T1, T2, T3>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep4<R extends Record, T1, T2, T3, T4>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep5<R extends Record, T1, T2, T3, T4, T5>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep6<R extends Record, T1, T2, T3, T4, T5, T6>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep7<R extends Record, T1, T2, T3, T4, T5, T6, T7>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep8<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStep9<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>

Deprecated for removal since 3.14. - [#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.
public interface
MergeValuesStepN<R extends Record>

This type is used for the H2-specific variant of the Merge's DSL API.

public interface
Meta

A wrapping object for DatabaseMetaData or for other sources of database meta information (e.g. InformationSchema)

This object can be obtained through DSLContext#meta() in order to provide convenient access to your database meta data.

public interface
MetaProvider

An SPI that can produce dynamic catalog, schema, table meta data information.

public interface
Migration

An executable migration between two Commit instances.

public interface
MigrationContext

The context in which a Migration is executed.

public interface
MigrationListener

A listener for Migration lifecycles.

public interface
public interface
Migrations

The experimental migrations API.

public interface
Name

An identifier.

public interface
Named

A common base type for all qualifiable, named objects.

public interface
Node<N extends Node<N>>

An abstraction over directed, acyclic graph models.

public interface
Null

Deprecated as a consequence of Condition being deprecated.
A Condition that always yields null.
public interface
OrderedAggregateFunction<T>

An ordered-set aggregate function.

public interface
OrderedAggregateFunctionOfDeferredType

An ordered-set aggregate function.

public interface
OrderField<T>

A QueryPart to be used exclusively in ORDER BY clauses.

public interface
Package

A container for stored procedures and functions

This is only supported in the SQLDialect#ORACLE dialect.

public interface
Param<T>

Deprecated as a consequence of ParamOrVariable being deprecated.
A named parameter and/or bind value.
public interface
Parameter<
The parameter type
T
>

A parameter to a stored procedure or function.

public interface
ParamOrVariable<T>

Deprecated as a consequence of Field being deprecated.
A common super type of Param and Variable.
public interface
ParseContext

A publicly available API for the internal parse context that allows for parsing SQL fragements.

public interface
Parser

A SQL parser.

public interface
Privilege

A privilege for use in GRANT and REVOKE statements.

public interface
Publisher<T>

A bridge from java.util.concurrent.Flow.Publisher to org.reactivestreams.Publisher for compatibility purposes.

public interface
Qualified

A QueryPart that is Named and located in a Schema.

public interface
QualifiedAsterisk

A qualified asterisk.

public interface
QualifiedRecord<R extends QualifiedRecord<R>>

A record that has a RecordQualifier (a UDTRecord or a TableRecord).

public interface
QuantifiedSelect<R extends Record>

A quantified select for use in quantified comparison predicates.

public interface
Queries

A wrapper for a collection of queries.

public interface
Query

Any query.

public interface
QueryPart

The common base type for all objects that can be used for query composition.

public interface
QueryPartInternal

Base functionality declaration for all query objects

This interface is for JOOQ INTERNAL USE only.

public interface
Record

A database result record.

public interface
Record1<T1>

A model type for a records with degree 1

public interface
Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

A model type for a records with degree 10

public interface
Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

A model type for a records with degree 11

public interface
Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

A model type for a records with degree 12

public interface
Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

A model type for a records with degree 13

public interface
Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

A model type for a records with degree 14

public interface
Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

A model type for a records with degree 15

public interface
Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

A model type for a records with degree 16

public interface
Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

A model type for a records with degree 17

public interface
Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

A model type for a records with degree 18

public interface
Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

A model type for a records with degree 19

public interface
Record2<T1, T2>

A model type for a records with degree 2

public interface
Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

A model type for a records with degree 20

public interface
Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

A model type for a records with degree 21

public interface
Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

A model type for a records with degree 22

public interface
Record3<T1, T2, T3>

A model type for a records with degree 3

public interface
Record4<T1, T2, T3, T4>

A model type for a records with degree 4

public interface
Record5<T1, T2, T3, T4, T5>

A model type for a records with degree 5

public interface
Record6<T1, T2, T3, T4, T5, T6>

A model type for a records with degree 6

public interface
Record7<T1, T2, T3, T4, T5, T6, T7>

A model type for a records with degree 7

public interface
Record8<T1, T2, T3, T4, T5, T6, T7, T8>

A model type for a records with degree 8

public interface
Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

A model type for a records with degree 9

public interface
RecordContext

A context object for Record manipulation passed to registered RecordListener's.

public interface
RecordHandler<R extends Record>

Deprecated for removal since 3.15. - 3.15.0 - [#11902] - Use Iterable#forEach(Consumer) based methods, instead.
A RecordHandler is a handler that can receive Record objects, when fetching data from the database.
public interface
RecordListener

A listener for manipulation events on UpdatableRecords.

public interface
RecordListenerProvider

A provider for RecordListener instances.

public interface
RecordMapper<R extends Record, E>

A RecordMapper is a mapper that can receive Record objects, when fetching data from the database, transforming them into a custom type <E>.

public interface
RecordMapperProvider

A provider for RecordMapper instances.

public interface
RecordQualifier<R extends Record>

A UDT or Table.

public interface
RecordType<R extends Record>

A record type for Table, Cursor, Result and other objects.

public interface
RecordUnmapper<E, R extends Record>

A RecordUnmapper is a mapper that can receive user objects and convert them back to Record.

public interface
RecordUnmapperProvider

A provider for RecordUnmapper instances.

public interface
RenderContext

The render context is used for rendering QueryPart's to SQL.

public interface
ResourceManagingScope

A scope that can manage resources.

public interface
Result<
The record type contained in this result
R extends Record
>

A wrapper for database results returned by SelectQuery.

public interface
ResultOrRows

A type that contains either a Result, an update count, or an exception.

public interface
ResultQuery<R extends Record>

A query that can return results.

public interface
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.

public interface
RevokeFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the REVOKE statement.
public interface
RevokeFromStep

A step in the construction of the REVOKE statement.

public interface
RevokeOnStep

A step in the construction of the REVOKE statement.

public interface
Role

A privilege for use in GRANT and REVOKE statements.

public interface
RollbackToSavepointStep

A step in the construction of the ROLLBACK statement.

public interface
Routine<T>

A routine is a callable object in your RDBMS.

public interface
Row

A row value expression.

public interface
Row1<T1>

A row value expression.

public interface
Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

A row value expression.

public interface
Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

A row value expression.

public interface
Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

A row value expression.

public interface
Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

A row value expression.

public interface
Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

A row value expression.

public interface
Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

A row value expression.

public interface
Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

A row value expression.

public interface
Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

A row value expression.

public interface
Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

A row value expression.

public interface
Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

A row value expression.

public interface
Row2<T1, T2>

A row value expression.

public interface
Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

A row value expression.

public interface
Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

A row value expression.

public interface
Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

A row value expression.

public interface
Row3<T1, T2, T3>

A row value expression.

public interface
Row4<T1, T2, T3, T4>

A row value expression.

public interface
Row5<T1, T2, T3, T4, T5>

A row value expression.

public interface
Row6<T1, T2, T3, T4, T5, T6>

A row value expression.

public interface
Row7<T1, T2, T3, T4, T5, T6, T7>

A row value expression.

public interface
Row8<T1, T2, T3, T4, T5, T6, T7, T8>

A row value expression.

public interface
Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

A row value expression.

public interface
RowCountQuery

Any query that is not a ResultQuery, and thus possibly produces a row count as a result, instead of a Result.

public interface
RowId

A data type corresponding to JDBC's Types#ROWID.

public interface
RowN

A row value expression.

public interface
Schema

A schema.

public interface
Scope

Scope implementations provide access to a variety of objects that are available from a given scope.

public interface
Select<
The record type being returned by this query
R extends Record
>

A SELECT statement.

public interface
SelectConditionStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectConnectByStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectCorrelatedSubqueryStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectDistinctOnStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectField<T>

A QueryPart to be used exclusively in SELECT clauses.

public interface
SelectFieldOrAsterisk

A QueryPart to be used exclusively in SELECT clauses.

public interface
SelectFinalStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectForStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectForUpdateOfStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectForUpdateStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectForUpdateWaitStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectFromStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectGroupByStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectHavingConditionStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectHavingStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectIntoStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectJoinPartitionByStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectJoinStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectLimitAfterOffsetStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectLimitPercentAfterOffsetStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectLimitPercentStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectLimitStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectOffsetStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectOnConditionStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectOnStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectOptionalOnStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectOptionStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectOrderByStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectQualifyConditionStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectQualifyStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectQuery<R extends Record>

Deprecated as a consequence of ConditionProvider being deprecated.
A SELECT statement (model API).
public interface
SelectSeekLimitStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep1<R extends Record, T1>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep10<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep11<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep12<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep13<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep14<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep15<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep16<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep17<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep18<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep19<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep2<R extends Record, T1, T2>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep20<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep21<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep22<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep3<R extends Record, T1, T2, T3>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep4<R extends Record, T1, T2, T3, T4>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep5<R extends Record, T1, T2, T3, T4, T5>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep6<R extends Record, T1, T2, T3, T4, T5, T6>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep7<R extends Record, T1, T2, T3, T4, T5, T6, T7>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep8<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStep9<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSeekStepN<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectSelectStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectUnionStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectWhereStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectWindowStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectWithTiesAfterOffsetStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
SelectWithTiesStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

public interface
Sequence<T extends Number>

A sequence.

public interface
SortField<
The field type
T
>

A sort specification.

public interface
Spatial

A wrapper type for spatial data obtained from the database.

public interface
SQL

A plain SQL QueryPart.

public interface
Statement

A statement that can be placed inside of a Block, but not executed on its own.

public interface
StoreQuery<
The record type of the table being modified
R extends Record
>

A query storing objects to the database.

public interface
Table<
The record type associated with this table
R extends Record
>

A table.

public interface
TableElement

A common base type for Field, Constraint, and Index where DSL API accepts all types alike.

public interface
TableField<
The record type
R extends Record
,
The field type
T
>

Deprecated as a consequence of Field being deprecated.
A field contained in a table.
public interface
TableLike<
The record type
R extends Record
>

An object that can behave like a table (a table-like object).

public interface
TableOnConditionStep<R extends Record>

An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.

public interface
TableOnStep<R extends Record>

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).

public interface
TableOptionalOnStep<R extends Record>

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)

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables.

public interface
TableOuterJoinStep<R extends Record>

An intermediate type for the construction of a partitioned SQLDialect#ORACLE OUTER JOIN clause.

public interface
TablePartitionByStep<R extends Record>

An intermediate type for the construction of a partitioned SQLDialect#ORACLE OUTER JOIN clause.

public interface
TableRecord<
The record type
R extends TableRecord<R>
>

A record originating from a single table

public interface
Transaction

A custom transaction object.

public interface
TransactionalCallable<T>

An FunctionalInterface that wraps transactional code.

public interface
TransactionalPublishable<T>

An FunctionalInterface that wraps transactional code for reactive usage.

public interface
TransactionalRunnable

An FunctionalInterface that wraps transactional code.

public interface
TransactionContext

A context object that is used to pass arguments to the various methods of TransactionProvider.

public interface
TransactionListener

The TransactionListener SPI is used to intercept the TransactionProvider's transaction events.

public interface
public interface
TransactionProvider

The TransactionProvider SPI can be used to implement custom transaction behaviour that is applied when calling DSLContext#transactionResult(TransactionalCallable) or DSLContext#transaction(TransactionalRunnable).

public interface
True

Deprecated as a consequence of Condition being deprecated.
A Condition that always yields true.
public interface
Truncate<R extends Record>

A step in the construction of the TRUNCATE statement.

public interface
TruncateCascadeStep<R extends Record>

Deprecated as a consequence of TruncateFinalStep being deprecated.
A step in the construction of the TRUNCATE statement.
public interface
TruncateFinalStep<R extends Record>

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly

A step in the construction of the TRUNCATE statement.
public interface
TruncateIdentityStep<R extends Record>

Deprecated as a consequence of TruncateCascadeStep being deprecated.
A step in the construction of the TRUNCATE statement.
public interface
Typed<T>

A marker interface for all query parts that have a DataType.

public interface
UDT<
The record type
R extends UDTRecord<R>
>

UDT definition.

public interface
UDTField<
The record type
R extends UDTRecord<R>
,
The field type
T
>

Deprecated as a consequence of Field being deprecated.
A field contained in a UDT.
public interface
UDTRecord<
The record type
R extends UDTRecord<R>
>

An object holding data of a UDT

public interface
UniqueKey<
The KEY's owner table record
R extends Record
>

A UniqueKey is an object representing a UNIQUE KEY or a PRIMARY KEY.

public interface
Unwrapper

An unwrapper SPI that can be used to override the default unwrapping algorithm.

public interface
UnwrapperProvider

A provider for the Unwrapper SPI which is used to override the default behaviour when unwrapping JDBC types through Wrapper#unwrap(Class).

public interface
UpdatableRecord<
The record type
R extends UpdatableRecord<R>
>

A common interface for records that can be stored back to the database again.

public interface
Update<R extends Record>

An UPDATE statement.

public interface
UpdateConditionStep<R extends Record>

Deprecated as a consequence of UpdateOrderByStep being deprecated.
This type is used for the Update's DSL API.
public interface
UpdateFinalStep<R extends Record>

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
This type is used for the Update's DSL API.
public interface
UpdateFromStep<R extends Record>

Deprecated as a consequence of UpdateWhereStep being deprecated.
This type is used for the Update's DSL API.
public interface
UpdateLimitStep<R extends Record>

Deprecated as a consequence of UpdateReturningStep being deprecated.
This type is used for the Update's DSL API.
public interface
UpdateOrderByStep<R extends Record>

Deprecated as a consequence of UpdateLimitStep being deprecated.
This type is used for the Update's DSL API.
public interface
UpdateQuery<
The record type of the table being updated
R extends Record
>

Deprecated as a consequence of ConditionProvider being deprecated.
An UPDATE statement (model API).
public interface
UpdateResultStep<R extends Record>

This type is used for the Update's DSL API.

public interface
UpdateReturningStep<R extends Record>

Deprecated as a consequence of UpdateFinalStep being deprecated.
This type is used for the Update's DSL API.
public interface
UpdateSetFirstStep<R extends Record>

This type is used for the Update's DSL API.

public interface
UpdateSetMoreStep<R extends Record>

Deprecated as a consequence of UpdateFromStep being deprecated.
This type is used for the Update's DSL API.
public interface
UpdateSetStep<R extends Record>

This type is used for the Update's DSL API.

public interface
UpdateWhereStep<R extends Record>

Deprecated as a consequence of UpdateOrderByStep being deprecated.
This type is used for the Update's DSL API.
public interface
User

A privilege for use in GRANT and REVOKE statements.

public interface
Version

A version ID attached to a Meta description of a database.

public interface
Versions

A directed, acyclic graph of Version objects.

public interface
VisitContext

A context object for QueryPart traversal passed to registered VisitListener's.

public interface
VisitListener

A listener for QueryPart traversal events.

public interface
VisitListenerProvider

A provider for VisitListener instances.

public interface
WindowBeforeOverStep<
The function return type
T
>

Deprecated as a consequence of Field being deprecated.
This type is used for the window function DSL API.
public interface
WindowDefinition

Deprecated as a consequence of WindowSpecificationOrderByStep being deprecated.
A window definition.
public interface
WindowExcludeStep<
The function return type
T
>

Deprecated as a consequence of WindowFinalStep being deprecated.
This type is used for the window function DSL API.
public interface
WindowFinalStep<
The function return type
T
>

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
This type is used for the window function DSL API.
public interface
WindowFromFirstLastStep<
The function return type
T
>

This type is used for the window function DSL API.

public interface
WindowIgnoreNullsStep<
The function return type
T
>

This type is used for the window function DSL API.

public interface
WindowOrderByStep<
The function return type
T
>

Deprecated as a consequence of WindowFinalStep being deprecated.
This type is used for the window function DSL API.
public interface
WindowOverStep<
The function return type
T
>

This type is used for the window function DSL API.

public interface
WindowPartitionByStep<
The function return type
T
>

Deprecated as a consequence of WindowOrderByStep being deprecated.
This type is used for the window function DSL API.
public interface
WindowRowsAndStep<
The function return type
T
>

This type is used for the window function DSL API.

public interface
WindowRowsStep<
The function return type
T
>

Deprecated as a consequence of WindowFinalStep being deprecated.
This type is used for the window function DSL API.
public interface
WindowSpecification

A window specification.

public interface
WindowSpecificationExcludeStep

Deprecated as a consequence of WindowSpecificationFinalStep being deprecated.
An intermediate step in the construction of a WindowSpecification.
public interface
WindowSpecificationFinalStep

Deprecated for removal since 3.15. - [#11329] - 3.15.0 - This type will be removed in the future. Do not reference it directly
An intermediate step in the construction of a WindowSpecification.
public interface
WindowSpecificationOrderByStep

Deprecated as a consequence of WindowSpecificationRowsStep being deprecated.
An intermediate step in the construction of a WindowSpecification.
public interface
WindowSpecificationPartitionByStep

Deprecated as a consequence of WindowSpecificationOrderByStep being deprecated.
An intermediate step in the construction of a WindowSpecification.
public interface
WindowSpecificationRowsAndStep

An intermediate step in the construction of a WindowSpecification.

public interface
WindowSpecificationRowsStep

Deprecated as a consequence of WindowSpecificationFinalStep being deprecated.
An intermediate step in the construction of a WindowSpecification.
public interface
WithAsStep

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep1

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep10

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep11

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep12

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep13

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep14

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep15

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep16

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep17

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep18

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep19

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep2

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep20

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep21

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep22

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep3

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep4

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep5

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep6

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep7

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep8

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithAsStep9

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
WithStep

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

public interface
XMLAggOrderByStep<T>

Deprecated as a consequence of AggregateFilterStep being deprecated.
The SQL standard ARRAY_AGG() function.
public interface
XMLAttributes

A type modelling XML attributes for use in DSL#xmlelement(Name, XMLAttributes, Field...).

public interface
XMLExistsPassingStep

A step in the construction of an XMLEXISTS predicate.

public interface
XMLQueryPassingStep

A step in the construction of an XMLQUERY expression.

public interface
XMLTableColumnForOrdinalityStep

A step in the construction of an XMLTABLE expression.

public interface
XMLTableColumnPathStep

A step in the construction of an XMLTABLE expression.

public interface
XMLTableColumnsFirstStep

A step in the construction of an XMLTABLE expression.

public interface
XMLTableColumnsStep

A step in the construction of an XMLTABLE expression.

public interface
XMLTablePassingStep

A step in the construction of an XMLTABLE expression.

Annotation Summary

Modifier and TypeAnnotation and Description
public @interface
Allow

Allow a set of SQLDialect to be supported by any jOOQ statement in the scope of this annotation.

public @interface
CheckReturnValue

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.

public @interface
Internal

Deprecated - 3.17.0 - [#13071] - Use org.jetbrains.annotations.ApiStatus.Internal instead.
Signifies that an API (public class, method or field) is internal and subject to incompatible changes, or even removal, in a future release.
public @interface
PlainSQL

This annotation marks all methods and types that allow for producing a QueryPart that generates "plain SQL" inside of an AST.

public @interface
Require

Require a set of SQLDialect to be supported by any jOOQ statement in the scope of this annotation.

public @interface
Support

A formal declaration of whether any API element is supported by a given SQLDialect

The annotation is mainly used in three modes:

  • The annotation is absent on a method. This means that the applied SQLDialect is irrelevant for that method. This is mostly the case for jOOQ's general API (creating factories, rendering SQL, binding variables, etc.) as well as utility methods.
  • The annotation is present but "empty" on a method, i.e. it specifies no SQLDialect. This means that all of jOOQ's dialects are supported by this API method. This is typically the case with jOOQ's SQL construction API for very common clauses, such as the creation of SELECT, UPDATE, INSERT, DELETE.
  • The annotation is present and specifies one or more dialects. A method annotated in such a way should be used only along with any of the dialects specified by the annotation. This is typically the case with jOOQ's SQL construction API for less common clauses, such as the creation of MERGE, etc.

    There listed dialects can be either a:

Class Summary

Modifier and TypeClass and Description
pack-priv class
pack-priv class
ArrayConverter<T, U>

A Converter that can convert arrays based on a delegate converter that can convert the array base types.

public class
ChartFormat

A CSV formatting type, which can be used to configure chart exports.

pack-priv class
CLIUtil

Common utilities for ParserCLI, DiffCLI and others.

public class
Constants

Some publicly available constants used in jOOQ

public class
Converters<
The database type - i.e. any type available from SQLDataType
T
,
The user type
U
>

A chain of converters.

public class
CSVFormat

A CSV formatting type, which can be used to configure CSV imports / exports.

public class
DDLExportConfiguration

A configuration type for use with the various Meta#ddl() methods.

public class
DiffCLI

A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.

pack-priv class
pack-priv class
FileComparator

A comparator that compares file names semantically, just like the Windows Explorer.

pack-priv class
FilenameComparator

A comparator that compares file names semantically, just like the Windows Explorer.

public class
FilePattern

A utility class that can traverse a directory structure given some ant-style file patterns, or classpath resources.

pack-priv class
pack-priv class
FlywayVersion

A version of a migration.

public class
Functions

Utilities related to the construction of functions.

public class
Geography

A wrapper type for spatial data obtained from the database.

public class
Geometry

A wrapper type for spatial data obtained from the database.

public class
JSON

A JSON wrapper type for JSON data obtained from the database.

public class
JSONB

A JSON wrapper type for JSONB data obtained from the database.

public class
JSONFormat

A JSON formatting type, which can be used to configure JSON imports / exports.

public class
MigrationConfiguration

A configuration type for use with the various Meta#migrateTo(Meta) methods.

public class
ParserCLI

A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.

public class
Records

Common utilities related to Record types and constructing RecordMapper.

pack-priv class
RenamedCatalog

A mapped catalog

pack-priv class
RenamedSchema

A mapped schema

pack-priv class
RenamedTable<R extends Record>

Deprecated as a consequence of TableImpl being deprecated.
A mapped table
public class
Rows

An auxiliary class for constructing Row collections.

public class
SchemaMapping

Deprecated for removal since 2.0. - 2.0.5 - Use runtime configuration Settings instead
General mapping of generated artefacts onto run-time substitutes.
public class
Source

A source of text data.

public class
Stringly

A container for annotations on stringly typed API.

public class
TableOptions

A description of various additional Table options to describe the table runtime meta model.

public class
TXTFormat

A text formatting type, which can be used to configure text imports / exports.

public class
XML

An XML wrapper type for XML data obtained from the database.

public class
XMLFormat

An XML formatting type, which can be used to configure XML imports / exports.

Enum Summary

Modifier and TypeEnum and Description
public enum
Clause

Deprecated for removal since 3.11. - 3.11.0 - [#7258] - This part of the VisitListener SPI is deprecated.
A listing of clauses that emit events VisitListener.
public enum
Comparator

A comparator to be used in conditions to form comparison predicates.

public enum
public enum
DatePart

A date part can be used with SQL functions such as extract().

public enum
public enum
ExecuteType

The type of database interaction that is being executed with this context.

public enum
GeneratorStatementType

The statement type of a GeneratorContext.

public enum
JoinType

The type of join.

public enum
LanguageContext

The current language context of some ParseContext or RenderContext.

public enum
Nullability

An enum that specifies the nullability of a DataType.

public enum
Operator

An operator used for combining conditions.

public enum
ParamMode

The mode of a Param.

public enum
SortOrder

The sorting order used in ORDER BY clauses.

public enum
SQLDialect

Dialects and dialect families as supported by jOOQ.

public enum