Module org.jooq
Package 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 DSL
and DSLContext
classes, which hide implementation facts from the public API.
-
InterfaceDescriptionThe step in the specification of aggregate functions where the SQL:2003 standard
FILTER clause
can be added.An aggregate function.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER DATABASE
statement.A step in the construction of theALTER DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER DOMAIN
statement.A step in the construction of theALTER DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER INDEX
statement.A step in the construction of theALTER INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AlterSequenceFlagsStep<T extends Number>A step in the construction of theALTER SEQUENCE
statement.AlterSequenceStep<T extends Number>A step in the construction of theALTER SEQUENCE
statement.The step in theALTER TABLE
DSL used toADD
columns.The step in theALTER TABLE
DSL used toALTER
constraints.The step in theALTER TABLE
DSL used toALTER
columns.The step in theALTER TABLE
DSL used toDROP
columns or constraints.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.The step in theALTER TABLE
DSL used toRENAME
columns.The step in theALTER TABLE
DSL used toRENAME
constraints.The step in theALTER TABLE
DSL used toRENAME
indexes.The step in theALTER TABLE
statement where the action can be decided.The step in theALTER TABLE ..
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER TYPE
statement.A step in the construction of theALTER TYPE
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER VIEW
statement.The SQL standardARRAY_AGG()
function.ArrayRecord<E>A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.An unqualified asterisk.An object in jOOQ that can have an underlyingConfiguration
attached or detached.A type that is bothAttachable
and aQueryPart
.A wrapper for a JDBC batch operation.This type is used for theBatch
's DSL API.An operation that can run code and statements, buffering all consecutive and identical SQL strings in aBatchedPreparedStatement
, delaying their execution.An operation that can run code and statements, buffering all consecutive and identical SQL strings in aBatchedPreparedStatement
, delaying their execution.An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep1<T1>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>An intermediate DSL type for the construction of aBETWEEN
predicate.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 aBETWEEN
predicate.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 aBETWEEN
predicate.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 aBETWEEN
predicate.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 aBETWEEN
predicate.BetweenAndStep2<T1,T2>An intermediate DSL type for the construction of aBETWEEN
predicate.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 aBETWEEN
predicate.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 aBETWEEN
predicate.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 aBETWEEN
predicate.BetweenAndStep3<T1,T2,T3>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep4<T1,T2,T3,T4>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep5<T1,T2,T3,T4,T5>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep6<T1,T2,T3,T4,T5,T6>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStepR<R extends Record>An intermediate DSL type for the construction of aBETWEEN
predicate.The bind context is used for bindingQueryPart
's and their contained values to aPreparedStatement
's bind variables.Binding<T,U>An SPI (Service Provider Interface) that exposes all low-level interactions with JDBC bind variables.A container type forBinding.get(BindingGetResultSetContext)
arguments.A container type forBinding.get(BindingGetSQLInputContext)
arguments.A container type forBinding.get(BindingGetStatementContext)
arguments.A container type forBinding.register(BindingRegisterContext)
arguments.A container type forBinding.set(BindingSetSQLOutputContext)
arguments.A container type forBinding.set(BindingSetStatementContext)
arguments.A container type forBinding.sql(BindingSQLContext)
arguments.A procedural block.The parameter object passed to theCacheProvider.provide(CacheContext)
method.A provider for cache implementations to replace the default.A step in the construction of theCALL
statement.The SQL case statement.The final step in creating a case statement of the typeAn intermediary step in creating a case statement of the typeCaseWhenStep<V,T>The final step in creating a case statement of the typeA catalog.A character set.A check constraint.A resourcefulDSLContext
that should be closed in a try-with-resources statement.A collation.A comment.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCOMMENT ON TABLE
statement.A commit in a version control system.An SPI that allows for providing a graph of versions.A (sub) set of commits.CommonTableExpression<R extends Record>A common table expression.A condition or predicate.Deprecated, for removal: This API element is subject to removal in a future version.- 2.6.0 [#1881] - This type will be removed from the public API, soon.AConfiguration
configures aDSLContext
, providing it with information for query rendering and execution.An operation that can run code and statements against a provided JDBCConnection
.A connection lifecycle handler API.An operation that can run code and statements against a provided JDBCConnection
.A DDL constraint.The step in theConstraint
construction DSL API that allows for addingENFORCED
andNOT ENFORCED
clauses.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.The step in theConstraint
construction DSL API that allows for addingON DELETE
andON UPDATE
clauses.The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.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 theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.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 theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep3<T1,T2,T3>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep4<T1,T2,T3,T4>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep5<T1,T2,T3,T4,T5>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep6<T1,T2,T3,T4,T5,T6>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep7<T1,T2,T3,T4,T5,T6,T7>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep8<T1,T2,T3,T4,T5,T6,T7,T8>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.The step in theConstraint
construction DSL API that allows for specifying the constraint type.A context type that is used for rendering SQL or for binding.AnFunctionalInterface
that wraps transactional code.AnFunctionalInterface
that wraps transactional code.A step in the construction of anCONTINUE
statement where aWHEN
clause can be added.Converter<T,U>AConverter
for data types.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE DOMAIN
statement.A step in the construction of theCREATE DOMAIN
statement.A step in the construction of theCREATE DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE FUNCTION
statement.A step in the construction of theCREATE FUNCTION
statement.A step in the construction of theCREATE FUNCTION
statement.A step in the construction of theCREATE FUNCTION
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE INDEX
statement.A step in the construction of theCREATE INDEX
statement.A step in the construction of theCREATE INDEX
statement.A step in the construction of theCREATE PROCEDURE
statement.A step in the construction of theCREATE PROCEDURE
statement.A step in the construction of theCREATE PROCEDURE
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE SEQUENCE
statement.CreateTableAsStep<R extends Record>AQuery
that can create tables.AQuery
that can create tables.AQuery
that can create tables.AQuery
that can create tables.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AQuery
that can create tables.AQuery
that can create tables.AQuery
that can create tables.AQuery
that can create tables.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.A step in the construction of theCREATE TRIGGER
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AQuery
that can create types.CreateViewAsStep<R extends Record>AQuery
that can create views.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Cursors allow for lazy, sequential access to an underlying JDBCResultSet
.DAO<R extends TableRecord<R>,P,T>A generic DAO interface for a pojo and a primary key type.DataType<T>A common interface to all dialect-specific data types.A marker interface for all DDL queries.Declaration<T>A local variable declaration.ADELETE
statement.DeleteConditionStep<R extends Record>This type is used for theDelete
's DSL API.DeleteFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.DeleteLimitStep<R extends Record>This type is used for theDelete
's DSL API.DeleteOrderByStep<R extends Record>This type is used for theDelete
's DSL API.DeleteQuery<R extends Record>ADELETE
statement (model API).DeleteResultStep<R extends Record>This type is used for theDelete
's DSL API.DeleteReturningStep<R extends Record>This type is used for theDelete
's DSL API.DeleteUsingStep<R extends Record>This type is used for theDelete
's DSL API.DeleteWhereStep<R extends Record>This type is used for theDelete
's DSL API.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A parameter object that is passed toDiagnosticsListener
methods.A diagnostics listener.A provider forTransactionListener
instances.An intermediate type for the construction of a relational division.An intermediate type for the construction of a relational divisionAn intermediate type for the construction of a relational divisionDomain<T>The meta model of a SQLDOMAIN
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AQuery
that can drop types.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A contextual DSL providing "attached" implementations to theorg.jooq
interfaces.EmbeddableRecord<R extends EmbeddableRecord<R>>A record originating from a single tableA SQL enum type.A context object forQuery
execution passed to registeredExecuteListener
's.An event handler implementingExecuteListener
events.A provider forExecuteListener
instances.TheExecutorProvider
SPI can be used to provide jOOQ with custom asynchronous execution behaviour.A step in the construction of anEXIT
statement where aWHEN
clause can be added.Results of anDSLContext.explain(Query)
call.ACondition
that always yieldsfalse
.Field<T>A column expression.An object that can behave like a field (a field-like object).A common base type forField
andConstraint
where DSL API accepts both types alike.A source of migration content.A set of files that are in a specific order.ForByStep<T>The step in the creation of aFOR LOOP
statement where theBY
clause can be supplied.AForeignKey
is an object referencing aUniqueKey
.ForInStep<T>The step in the creation of aFOR LOOP
statement where theIN
clause can be supplied.A type that can format its contents.Function1<T1,R>A function of degree 1.Function10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,R>A function of degree 10.Function11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,R>A function of degree 11.Function12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,R>A function of degree 12.Function13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,R>A function of degree 13.Function14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,R>A function of degree 14.Function15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,R>A function of degree 15.Function16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,R>A function of degree 16.Function17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,R>A function of degree 17.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.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.Function2<T1,T2,R>A function of degree 2.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.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.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.Function3<T1,T2,T3,R>A function of degree 3.Function4<T1,T2,T3,T4,R>A function of degree 4.Function5<T1,T2,T3,T4,T5,R>A function of degree 5.Function6<T1,T2,T3,T4,T5,T6,R>A function of degree 6.Function7<T1,T2,T3,T4,T5,T6,T7,R>A function of degree 7.Function8<T1,T2,T3,T4,T5,T6,T7,T8,R>A function of degree 8.Function9<T1,T2,T3,T4,T5,T6,T7,T8,T9,R>A function of degree 9.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theGRANT
statement.A step in the construction of theGRANT
statement.A step in the construction of theGRANT
statement.MySQL'sGROUP_CONCAT
function.MySQL'sGROUP_CONCAT
function.An expression to be used exclusively inGROUP BY
clauses.AnIdentity
is an object representing anIDENTITY
column as understood by the SQL:2003 standard.An intermediate step in building a proceduralIF
statement.An intermediate step in building a proceduralIF
statement.A DDL index definition.AnINSERT
statement.InsertFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.InsertOnConflictConditionStep<R extends Record>This type is used for theInsert
's DSL API.InsertOnConflictDoUpdateStep<R extends Record>This type is used for theInsert
's DSL API.InsertOnConflictWhereIndexPredicateStep<R extends Record>This type is used for theInsert
's DSL API.InsertOnConflictWhereStep<R extends Record>This type is used for theInsert
's DSL API.InsertOnDuplicateSetMoreStep<R extends Record>This type is used for theInsert
's DSL API.InsertOnDuplicateSetStep<R extends Record>This type is used for theInsert
's DSL API.InsertOnDuplicateStep<R extends Record>This type is used for theInsert
's DSL API.InsertQuery<R extends Record>AnINSERT
statement (model API).InsertResultStep<R extends Record>This type is used for theInsert
's DSL API.InsertReturningStep<R extends Record>This type is used for theInsert
's DSL API.InsertSetMoreStep<R extends Record>This type is used for theInsert
's alternative DSL API.InsertSetStep<R extends Record>This type is used for theInsert
's alternative DSL API.InsertValuesStep1<R extends Record,T1>This type is used for theInsert
's DSL API.InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>This type is used for theInsert
's DSL API.InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>This type is used for theInsert
's DSL API.InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>This type is used for theInsert
's DSL API.InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>This type is used for theInsert
's DSL API.InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>This type is used for theInsert
's DSL API.InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>This type is used for theInsert
's DSL API.InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>This type is used for theInsert
's DSL API.InsertValuesStep17<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 theInsert
's DSL API.InsertValuesStep18<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 theInsert
's DSL API.InsertValuesStep19<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 theInsert
's DSL API.InsertValuesStep2<R extends Record,T1,T2>This type is used for theInsert
's DSL API.InsertValuesStep20<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 theInsert
's DSL API.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>This type is used for theInsert
's DSL API.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>This type is used for theInsert
's DSL API.InsertValuesStep3<R extends Record,T1,T2,T3>This type is used for theInsert
's DSL API.InsertValuesStep4<R extends Record,T1,T2,T3,T4>This type is used for theInsert
's DSL API.InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>This type is used for theInsert
's DSL API.InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>This type is used for theInsert
's DSL API.InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>This type is used for theInsert
's DSL API.InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>This type is used for theInsert
's DSL API.InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>This type is used for theInsert
's DSL API.InsertValuesStepN<R extends Record>This type is used for theInsert
's DSL API.A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theNULL
clause can be defined.A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theORDER BY
clause can be defined.A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theRETURNING
clause can be defined.A step in the construction of theJSON ARRAY
function.A step in the construction of theJSON ARRAY
function.JSONEntry<T>A JSON entry for JSON objects.A step in the creation ofJSONEntry
values.A step in the construction ofDSL.jsonExists(Field, Field)
orDSL.jsonbExists(Field, Field)
functions where theON ERROR
clause can be defined.A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theNULL
clause can be defined.A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theRETURNING
clause can be defined.A step in the construction of theJSON OBJECT
function.A step in the construction of theJSON OBJECT
function.A step in the construction of anJSON_TABLE
expression.A step in the construction of anJSON_TABLE
expression.A step in the construction of anJSON_TABLE
expression.A step in the construction of anJSON_TABLE
expression.A step in the construction ofDSL.jsonValue(Field, Field)
orDSL.jsonbValue(Field, Field)
functions where theON EMPTY
andON ERROR
clauses can be defined for default values.A step in the construction ofDSL.jsonValue(Field, Field)
orDSL.jsonbValue(Field, Field)
functions where theON EMPTY
andON ERROR
clauses can be defined.A step in the construction of theJSON VALUE
function.AKey
is an object representing aUNIQUE KEY
, aPRIMARY KEY
, or aFOREIGN KEY
.A SQL keyword.A label for use in procedural code.A step in the creation of aLIKE
predicate to which anESCAPE
clause can be appended.A database link reference.TheLoader
API is used for configuring data loads.A context object that provides information about a loader's current state toLoaderRowListener
.LoaderCSVOptionsStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderCSVStep<R extends Record>TheLoader
API is used for configuring data loads.An error that occurred during loading.The argument object forLoaderFieldMapper.map(LoaderFieldContext)
.LoaderJSONOptionsStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderJSONStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderListenerStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderLoadStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderOptionsStep<R extends Record>TheLoader
API is used for configuring data loads.A listener forLoader
progress.LoaderRowsStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderSourceStep<R extends Record>TheLoader
API is used for configuring data loads.LoaderXMLStep<R extends Record>TheLoader
API is used for configuring data loads.A common logger abstraction API for jOOQ's internal logging.An intermediate step in building a proceduralLOOP
statement.AMERGE
statement.MergeFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.MergeKeyStep1<R extends Record,T1>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep2<R extends Record,T1,T2>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep3<R extends Record,T1,T2,T3>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep4<R extends Record,T1,T2,T3,T4>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeKeyStepN<R extends Record>This type is used for the H2-specific variant of theMerge
's DSL API.MergeMatchedDeleteStep<R extends Record>This type is used for theMerge
's DSL API.MergeMatchedSetMoreStep<R extends Record>This type is used for theMerge
's DSL API.MergeMatchedSetStep<R extends Record>This type is used for theMerge
's DSL API.MergeMatchedStep<R extends Record>This type is used for theMerge
's DSL API.MergeMatchedThenStep<R extends Record>This type is used for theMerge
's DSL API.MergeMatchedWhereStep<R extends Record>This type is used for theMerge
's DSL API.MergeNotMatchedSetMoreStep<R extends Record>This type is used for theMerge
's DSL API.MergeNotMatchedSetStep<R extends Record>This type is used for theMerge
's DSL API.MergeNotMatchedStep<R extends Record>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep1<R extends Record,T1>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>This type is used for theMerge
's DSL API.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 theMerge
's DSL API.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 theMerge
's DSL API.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 theMerge
's DSL API.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 theMerge
's DSL API.MergeNotMatchedValuesStep2<R extends Record,T1,T2>This type is used for theMerge
's DSL API.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 theMerge
's DSL API.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 theMerge
's DSL API.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 theMerge
's DSL API.MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>This type is used for theMerge
's DSL API.MergeNotMatchedValuesStepN<R extends Record>This type is used for theMerge
's DSL API.MergeNotMatchedWhereStep<R extends Record>This type is used for theMerge
's DSL API.MergeOnConditionStep<R extends Record>This type is used for theMerge
's DSL API.MergeOnStep<R extends Record>This type is used for theMerge
's DSL API.MergeUsingStep<R extends Record>This type is used for theMerge
's DSL API.MergeValuesStep1<R extends Record,T1>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep2<R extends Record,T1,T2>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep3<R extends Record,T1,T2,T3>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep4<R extends Record,T1,T2,T3,T4>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStepN<R extends Record>This type is used for the H2-specific variant of theMerge
's DSL API.A wrapping object forDatabaseMetaData
or for other sources of database meta information (e.g.An SPI that can produce dynamic catalog, schema, table meta data information.An executable migration between twoCommit
instances.The context in which aMigration
is executed.A listener forMigration
lifecycles.A provider forMigrationListener
instances.An identifier.A common base type for all qualifiable, named objects.An abstraction over directed, acyclic graph models.An ordered-set aggregate function.An ordered-set aggregate function.OrderField<T>AQueryPart
to be used exclusively inORDER BY
clauses.A container for stored procedures and functionsParam<T>A named parameter and/or bind value.Parameter<T>A parameter to a stored procedure or function.A publicly available API for the internal parse context that allows for parsing SQL fragements.A listener that allows for parsing custom SQL.A provider forParseListener
instances.A SQL parser.Period<T>A period specification for usage in temporal tables.This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.PivotInStep<T>This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.A privilege for use inGRANT
andREVOKE
statements.Publisher<T>A bridge fromFlow.Publisher
toPublisher
for compatibility purposes.A qualified asterisk.QualifiedRecord<R extends QualifiedRecord<R>>QuantifiedSelect<R extends Record>A quantified select for use in quantified comparison predicates.A wrapper for a collection of queries.Any query.The common base type for all objects that can be used for query composition.Base functionality declaration for all query objectsA database result record.Record1<T1>A model type for a records with degree1
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>A model type for a records with degree10
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>A model type for a records with degree11
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>A model type for a records with degree12
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>A model type for a records with degree13
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>A model type for a records with degree14
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>A model type for a records with degree15
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>A model type for a records with degree16
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 degree17
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 degree18
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 degree19
Record2<T1,T2>A model type for a records with degree2
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 degree20
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 degree21
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 degree22
Record3<T1,T2,T3>A model type for a records with degree3
Record4<T1,T2,T3,T4>A model type for a records with degree4
Record5<T1,T2,T3,T4,T5>A model type for a records with degree5
Record6<T1,T2,T3,T4,T5,T6>A model type for a records with degree6
Record7<T1,T2,T3,T4,T5,T6,T7>A model type for a records with degree7
Record8<T1,T2,T3,T4,T5,T6,T7,T8>A model type for a records with degree8
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>A model type for a records with degree9
A context object forRecord
manipulation passed to registeredRecordListener
's.RecordHandler<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#11902] - UseIterable.forEach(Consumer)
based methods, instead.A listener for manipulation events onUpdatableRecord
s.A provider forRecordListener
instances.RecordMapper<R extends Record,E>ARecordMapper
is a mapper that can receiveRecord
objects, when fetching data from the database, transforming them into a custom type<E>
.A provider forRecordMapper
instances.RecordQualifier<R extends Record>RecordType<R extends Record>RecordUnmapper<E,R extends Record>ARecordUnmapper
is a mapper that can receive user objects and convert them back toRecord
.A provider forRecordUnmapper
instances.The render context is used for renderingQueryPart
's to SQL.An intermediate step in building a proceduralREPEAT
statement.A scope that can manage resources.A wrapper for database results returned by
.SelectQuery
A type that contains either aResult
, an update count, or an exception.ResultQuery<R extends Record>A query that can return results.A list ofResult
and update counts that can be returned byResultQuery.fetchMany()
calls and other calls that produce multiple cursors and update counts.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theREVOKE
statement.A step in the construction of theREVOKE
statement.A privilege for use inGRANT
andREVOKE
statements.Routine<T>A routine is a callable object in your RDBMS.A row value expression.Row1<T1>A row value expression.Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>A row value expression.Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>A row value expression.Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>A row value expression.Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>A row value expression.Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>A row value expression.Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>A row value expression.Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>A row value expression.Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>A row value expression.Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>A row value expression.Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>A row value expression.Row2<T1,T2>A row value expression.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.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.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.Row3<T1,T2,T3>A row value expression.Row4<T1,T2,T3,T4>A row value expression.Row5<T1,T2,T3,T4,T5>A row value expression.Row6<T1,T2,T3,T4,T5,T6>A row value expression.Row7<T1,T2,T3,T4,T5,T6,T7>A row value expression.Row8<T1,T2,T3,T4,T5,T6,T7,T8>A row value expression.Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>A row value expression.Any query that is not aResultQuery
, and thus possibly produces a row count as a result, instead of aResult
.A data type corresponding to JDBC'sTypes.ROWID
.A row value expression.A schema.Scope implementations provide access to a variety of objects that are available from a given scope.ASELECT
statement.SelectConditionStep<R extends Record>SelectConnectByAfterStartWithConditionStep<R extends Record>SelectConnectByAfterStartWithStep<R extends Record>SelectConnectByConditionStep<R extends Record>SelectConnectByStep<R extends Record>SelectCorrelatedSubqueryStep<R extends Record>SelectDistinctOnStep<R extends Record>SelectField<T>AQueryPart
to be used exclusively inSELECT
clauses.AQueryPart
to be used exclusively inSELECT
clauses.SelectFinalStep<R extends Record>SelectForJSONCommonDirectivesStep<R extends Record>SelectForJSONStep<R extends Record>SelectForStep<R extends Record>SelectForUpdateOfStep<R extends Record>SelectForUpdateStep<R extends Record>SelectForUpdateWaitStep<R extends Record>SelectForXMLCommonDirectivesStep<R extends Record>SelectForXMLPathDirectivesStep<R extends Record>SelectForXMLRawDirectivesStep<R extends Record>SelectForXMLStep<R extends Record>SelectFromStep<R extends Record>SelectGroupByStep<R extends Record>SelectHavingConditionStep<R extends Record>SelectHavingStep<R extends Record>SelectIntoStep<R extends Record>SelectJoinPartitionByStep<R extends Record>SelectJoinStep<R extends Record>SelectLimitAfterOffsetStep<R extends Record>SelectLimitPercentAfterOffsetStep<R extends Record>SelectLimitPercentStep<R extends Record>SelectLimitStep<R extends Record>SelectOffsetStep<R extends Record>SelectOnConditionStep<R extends Record>SelectOnStep<R extends Record>SelectOptionalOnStep<R extends Record>SelectOptionStep<R extends Record>SelectOrderByStep<R extends Record>SelectQualifyConditionStep<R extends Record>SelectQualifyStep<R extends Record>SelectQuery<R extends Record>ASELECT
statement (model API).SelectSeekLimitStep<R extends Record>SelectSeekStep1<R extends Record,T1>SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>SelectSeekStep2<R extends Record,T1,T2>SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>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>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>SelectSeekStep3<R extends Record,T1,T2,T3>SelectSeekStep4<R extends Record,T1,T2,T3,T4>SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>SelectSeekStepN<R extends Record>SelectSelectStep<R extends Record>SelectStartWithStep<R extends Record>SelectUnionStep<R extends Record>SelectWhereStep<R extends Record>SelectWindowStep<R extends Record>SelectWithTiesAfterOffsetStep<R extends Record>SelectWithTiesStep<R extends Record>A sequence.A step in the construction of theSIGNAL SQL STATE
function.SortField<T>A sort specification.A plain SQLQueryPart
.A statement that can be placed inside of aBlock
, but not executed on its own.StoreQuery<R extends Record>A query storing objects to the database.A table.TableField<R extends Record,T>A field contained in a table.An object that can behave like a table (a table-like object).TableOnConditionStep<R extends Record>An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.TableOnStep<R extends Record>TableOptionalOnStep<R extends Record>TableOuterJoinStep<R extends Record>An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.TablePartitionByStep<R extends Record>An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.TableRecord<R extends TableRecord<R>>A record originating from a single tableA custom transaction object.AnFunctionalInterface
that wraps transactional code.AnFunctionalInterface
that wraps transactional code.A context object that is used to pass arguments to the various methods ofTransactionProvider
.TheTransactionListener
SPI is used to intercept theTransactionProvider
's transaction events.A provider forTransactionListener
instances.TheTransactionProvider
SPI can be used to implement customtransaction
behaviour that is applied when callingDSLContext.transactionResult(TransactionalCallable)
orDSLContext.transaction(TransactionalRunnable)
.ACondition
that always yieldstrue
.A step in the construction of theTRUNCATE
statement.TruncateCascadeStep<R extends Record>A step in the construction of theTRUNCATE
statement.TruncateFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.TruncateIdentityStep<R extends Record>A step in the construction of theTRUNCATE
statement.Typed<T>A marker interface for all query parts that have aDataType
.UDT definition.A field contained in a UDT.An object holding data of a UDTAUniqueKey
is an object representing aUNIQUE KEY
or aPRIMARY KEY
.An unwrapper SPI that can be used to override the default unwrapping algorithm.A provider for theUnwrapper
SPI which is used to override the default behaviour when unwrapping JDBC types throughWrapper.unwrap(Class)
.UpdatableRecord<R extends UpdatableRecord<R>>A common interface for records that can be stored back to the database again.AnUPDATE
statement.UpdateConditionStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.UpdateFromStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateLimitStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateOrderByStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateQuery<R extends Record>AnUPDATE
statement (model API).UpdateResultStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateReturningStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateSetFirstStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateSetMoreStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateSetStep<R extends Record>This type is used for theUpdate
's DSL API.UpdateWhereStep<R extends Record>This type is used for theUpdate
's DSL API.A privilege for use inGRANT
andREVOKE
statements.Variable<T>A local variable reference.A version ID attached to aMeta
description of a database.A directed, acyclic graph ofVersion
objects.VersionsBetweenAndStep<R extends Record,T>This type is used for the OracleVERSIONS
clause DSL API, providing access to the flashback versions query clauses.A context object forQueryPart
traversal passed to registeredVisitListener
's.A listener forQueryPart
traversal events.A provider forVisitListener
instances.This type is used for the window function DSL API.A window definition.This type is used for the window function DSL API.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.A window specification.An intermediate step in the construction of aWindowSpecification
.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.An intermediate step in the construction of aWindowSpecification
.An intermediate step in the construction of aWindowSpecification
.An intermediate step in the construction of aWindowSpecification
.An intermediate step in the construction of aWindowSpecification
.The SQL standardARRAY_AGG()
function.A type modelling XML attributes for use inDSL.xmlelement(Name, XMLAttributes, Field...)
.A step in the construction of anXMLEXISTS
predicate.A step in the construction of anXMLQUERY
expression.A step in the construction of anXMLTABLE
expression.A step in the construction of anXMLTABLE
expression.A step in the construction of anXMLTABLE
expression.A step in the construction of anXMLTABLE
expression.A step in the construction of anXMLTABLE
expression. -
ClassDescriptionA CSV formatting type, which can be used to configure chart exports.Some publicly available constants used in jOOQConverters<T,U>A chain of converters.An unknown type that is used when users do not provide any explicit user type
Class
reference e.g.A CSV formatting type, which can be used to configure CSV imports / exports.A configuration type for use with the variousMeta.ddl()
methods.A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.A utility class that can traverse a directory structure given some ant-style file patterns, or classpath resources.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A JSON formatting type, which can be used to configure JSON imports / exports.A configuration type for use with the variousMeta.migrateTo(Meta)
methods.A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.Common utilities related toRecord
types and constructingRecordMapper
.An auxiliary class for constructingRow
collections.Deprecated, for removal: This API element is subject to removal in a future version.- 2.0.5 - Use runtime configurationSettings
insteadA source of text data.A container for annotations on stringly typed API.A description of various additionalTable
options to describe the table runtime meta model.A text formatting type, which can be used to configure text imports / exports.An XML wrapper type for XML data obtained from the database.An XML formatting type, which can be used to configure XML imports / exports. -
Enum ClassDescriptionThe chart output format.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11.0 - [#7258] - This part of the
VisitListener
SPI is deprecated.A comparator to be used in conditions to form comparison predicates.TheFile.type()
.When to apply the quoteA date part can be used with SQL functions such as extract().The type of database interaction that is being executed with this context.The sort algorithm to be applied to directory contents.The type of join.The format of individual JSON records.The current language context of someParseContext
orRenderContext
.The log level.A flag indicating whether the name is quoted or not.An enum that specifies the nullability of aDataType
.An operator used for combining conditionsThe mode of aParam
.The cast mode for bind values.The sorting order used inORDER BY
clauses.Dialects and dialect families as supported by jOOQ.TheON COMMIT
flag forTableOptions.TableType.TEMPORARY
tables.A description of the type of aTable
.The format of individual XML records. -
Annotation InterfaceDescriptionAllow a set of
SQLDialect
to be supported by any jOOQ statement in the scope of this annotation.This annotation allowsAllow.PlainSQL
API usage within the scope of where it is placed.Simple version of the JSR 305 annotation that allows for inspecting jOOQ code and detect accidentally omitted calls toQuery.execute()
and the likes in IntelliJ.Signifies that a API (public class, method or field) is internal and subject to incompatible changes, or even removal, in a future release.This annotation marks all methods and types that allow for producing aQueryPart
that generates "plain SQL" inside of an AST.An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.Require a set ofSQLDialect
to be supported by any jOOQ statement in the scope of this annotation.The annotated string type represents a keywordComment
, which will be wrapped byDSL.comment(String)
.The annotated string type represents a keywordKeyword
, which will be wrapped byDSL.keyword(String)
.The annotated string type represents an identifier, i.e.The annotated string type represents a bind variable, i.e.The annotated string type represents a plain SQL template, i.e.A formal declaration of whether any API element is supported by a givenSQLDialect