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.
-
ClassDescriptionThe step in the specification of aggregate functions where the SQL:2003 standard
FILTER clause
can be added.An aggregate function.Allow a set ofSQLDialect
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.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 … ADD CONSTRAINT
statement where an optional index can be specified to enforce the constraint.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of 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.A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), or an associative array, additionally providing some convenience methods.ArrayRecord<E>A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.A "record" that encapsulates an Oracle-style associative array, 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
.An SPI to provide audit fields.The type of the audit info produced by anAuditGenerator
.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 CSV formatting type, which can be used to configure chart exports.The chart output format.A check constraint.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.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11.0 - [#7258] - This part of theVisitListener
SPI is deprecated.A resourcefulDSLContext
that should be closed in a try-with-resources statement.AQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.CloseableResultQuery<R extends Record>AResultQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.A collation.A common base type forComment
and other, potential future types where DSL API accepts all types alike.A comment.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of 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 comparator to be used in conditions to form comparison predicates.A condition or predicate.Deprecated, for removal: This API element is subject to removal in a future version.- 2.6.0 [#1881] - This type will be removed from the public API, soon.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
.Some publicly available constants used in jOOQA 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.TheFile.type()
.A context type that is used for rendering SQL or for binding.ContextConverter<T,U> A special type ofConverter
with alternativeContextConverter.from(Object, ConverterContext)
andContextConverter.to(Object, ConverterContext)
methods.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.AScope
that models the life cycle of a data type conversion call toConverter.from(Object)
orConverter.to(Object)
.Converters<T,U> A chain of converters.An unknown type that is used when users do not provide any explicit user typeClass
reference e.g.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of 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.A step in the construction of theCREATE TABLE
statement.A step in the construction of theCREATE TABLE
statement.A step in the construction of theCREATE TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE TABLE
statement.A step in the construction of theCREATE TABLE
statement.A step in the construction of theCREATE TABLE
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.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.A CSV formatting type, which can be used to configure CSV imports / exports.When to apply the quoteCursors allow for lazy, sequential access to an underlying JDBCResultSet
.A generic DAO interface for a pojo and a primary key type.DataType<T>A common interface to all dialect-specific data types.A date part can be used with SQL functions such as extract().A configuration type for use with the variousMeta.ddl()
methods.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.A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.An intermediate type for the construction of a relational division.An intermediate type for the construction of a relational 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.The batch mode, which helps interpret the contents ofExecuteContext.batchQueries()
.An event handler implementingExecuteListener
events.A provider forExecuteListener
instances.AScope
that knows itsExecuteContext
.The type of database interaction that is being executed with this context.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).Deprecated.- 3.17.0 - [#13005] - UseTableElement
instead.A source of migration content.A utility class that can traverse a directory structure given some ant-style file patterns, or classpath resources.The sort algorithm to be applied to directory contents.A set of files that are in a specific order.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.An SPI that allows for overriding certain formatting defaults.Function0<R>A function of degree 0.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.Utilities related to the construction of functions.A generator can be used withDataType.generatedAlwaysAs(Generator)
to implement dynamic, client side computed columns, i.e.AGeneratorContext
is an argument object that is passed to aGenerator
when generating client side computed columns.The statement type of aGeneratorContext
.A wrapper type for spatial data obtained from the database.A wrapper type for spatial data obtained from the database.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of 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.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.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.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.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.This type is used for theInsert
's DSL API.InsertValuesStepN<R extends Record>This type is used for theInsert
's DSL API.Deprecated.- 3.17.0 - [#13071] - UseApiStatus.Internal
instead.The type of join.A JSON wrapper type for JSON data obtained from the database.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.A JSON wrapper type for JSONB data obtained from the database.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 JSON formatting type, which can be used to configure JSON imports / exports.The format of individual JSON records.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.The current language context of someParseContext
orRenderContext
.A step in the construction of theLIKE
function.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.The log level.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.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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.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.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.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.This type is used for theMerge
's DSL API.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.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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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.A configuration type for use with the variousMeta.migrateTo(Meta)
methods.The context in which aMigration
is executed.A listener forMigration
lifecycles.A provider forMigrationListener
instances.The experimental migrations API.An identifier.A flag indicating whether the name is quoted or not.A common base type for all qualifiable, named objects.An abstraction over directed, acyclic graph models.ACondition
that always yieldsnull
.An enum that specifies the nullability of aDataType
.An operator used for combining conditions.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.The mode of aParam
.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.A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.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.This annotation marks all methods and types that allow for producing aQueryPart
that generates "plain SQL" inside of an AST.A privilege for use inGRANT
andREVOKE
statements.An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.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.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>Common utilities related toRecord
types and constructingRecordMapper
.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.The cast mode for bind values.An intermediate step in building a proceduralREPEAT
statement.An API forQueryPart.$replace(Replacer)
query part transformations.A set ofReplacer
constructor methods.Require a set ofSQLDialect
to be supported by any jOOQ statement in the scope of this annotation.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.A step in the construction of theROLLBACK
statement.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.An auxiliary class for constructingRow
collections.A schema.Deprecated, for removal: This API element is subject to removal in a future version.- 2.0.5 - Use runtime configurationSettings
insteadScope 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>SelectSeekStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> 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> 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.The sorting order used inORDER BY
clauses.A source of text data.A wrapper type for spatial data obtained from the database.A plain SQLQueryPart
.Dialects and dialect families as supported by jOOQ.A category forSQLDialect
.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 container for annotations on stringly typed API.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
A table.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>A description of various additionalTable
options to describe the table runtime meta model.TheON COMMIT
flag forTableOptions.TableType.TEMPORARY
tables.A description of the type of aTable
.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 for reactive usage.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)
.An SPI to provide SQL transformation configuration and behaviour.Traverser<A,R> An API forQueryPart.$traverse(Traverser)
query part traversals.A set ofTraverser
constructor methods.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.A text formatting type, which can be used to configure text imports / exports.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.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
.An XML wrapper type for XML data obtained from the database.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.An XML formatting type, which can be used to configure XML imports / exports.The format of individual XML records.A step in the construction of 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.