Uses of Package
org.jooq
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
This package contains jOOQ's public utilities.
JDBC tooling.
This package contains classes related to the
SQLDialect.ACCESS
dialect family.This package contains classes related to the
SQLDialect.ASE
dialect family.This package contains classes related to the
SQLDialect.AURORA_MYSQL
dialect family.This package contains classes related to the
SQLDialect.AURORA_POSTGRES
dialect family.This package contains classes related to the
SQLDialect.BIGQUERY
dialect family.This package contains classes related to the
SQLDialect.COCKROACHDB
dialect family.This package contains classes related to the
SQLDialect.CUBRID
dialect family.This package contains classes related to the
SQLDialect.DB2
dialect family.This package contains classes related to the
SQLDialect.DERBY
dialect family.This package contains classes related to the
SQLDialect.EXASOL
dialect family.This package contains classes related to the
SQLDialect.FIREBIRD
dialect family.This package contains classes related to the
SQLDialect.H2
dialect family.This package contains classes related to the
SQLDialect.HANA
dialect family.This package contains classes related to the
SQLDialect.HSQLDB
dialect family.This package contains classes related to the
SQLDialect.IGNITE
dialect family.This package contains classes related to the
SQLDialect.INFORMIX
dialect family.This package contains classes related to the
SQLDialect.INGRES
dialect family.This package contains classes related to the
SQLDialect.MARIADB
dialect family.This package contains classes related to the
SQLDialect.MEMSQL
dialect family.This package contains classes related to the
SQLDialect.MYSQL
dialect family.This package contains classes related to the
SQLDialect.ORACLE
dialect family.This package contains classes related to the
SQLDialect.POSTGRES
dialect family.This package contains classes related to the
SQLDialect.REDSHIFT
dialect family.This package contains classes related to the
SQLDialect.SNOWFLAKE
dialect family.This package contains classes related to the
SQLDialect.SQLDATAWAREHOUSE
dialect family.This package contains classes related to the
SQLDialect.SQLITE
dialect family.This package contains classes related to the
SQLDialect.SQLSERVER
dialect family.This package contains classes related to the
SQLDialect.SYBASE
dialect family.This package contains classes related to the
SQLDialect.TERADATA
dialect family.This package contains classes related to the
SQLDialect.VERTICA
dialect family.This package contains classes related to the
SQLDialect.YUGABYTEDB
dialect family.-
ClassDescriptionThe 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.A step in the construction of theALTER SEQUENCE
statement.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.A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), or an associative array, additionally providing some convenience methods.A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.A "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.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.An intermediate DSL type for the construction of aBETWEEN
predicate.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.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 final step in creating a case statement of the typeAn intermediary step in creating a case statement of the typeThe 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.AQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.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.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
.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.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 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 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 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 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 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 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 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 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 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 matching aFOREIGN KEY
clause with aREFERENCES
clause.The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.TheFile.type()
.A context type that is used for rendering SQL or for binding.A special type ofConverter
with alternativeContextConverter.from(Object, ConverterContext)
andContextConverter.to(Object, ConverterContext)
methods.AnFunctionalInterface
that wraps transactional code.AnFunctionalInterface
that wraps transactional code.AConverter
for data types.AScope
that models the life cycle of a data type conversion call toConverter.from(Object)
orConverter.to(Object)
.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.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 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.Whether to inline foreign key constraint definitions with the table definition.A marker interface for all DDL queries.ADELETE
statement.This type is used for theDelete
's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.This type is used for theDelete
's DSL API.This type is used for theDelete
's DSL API.ADELETE
statement (model API).This type is used for theDelete
's DSL API.This type is used for theDelete
's DSL API.This type is used for theDelete
's DSL API.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 divisionThe 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.An embeddable record.A 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.Results of anDSLContext.explain(Query)
call.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.The step in the creation of aFOR LOOP
statement where theBY
clause can be supplied.AForeignKey
is an object referencing aUniqueKey
.A type that can format its contents.An SPI that allows for overriding certain formatting defaults.A function of degree 1.A function of degree 10.A function of degree 11.A function of degree 12.A function of degree 13.A function of degree 14.A function of degree 15.A function of degree 16.A function of degree 17.A function of degree 18.A function of degree 19.A function of degree 2.A function of degree 20.A function of degree 21.A function of degree 22.A function of degree 3.A function of degree 4.A function of degree 5.A function of degree 6.A function of degree 7.A function of degree 8.A function of degree 9.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.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.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 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.AnINSERT
statement (model 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 alternative DSL API.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.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.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.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 theRETURNING
clause can be defined.A step in the construction of theJSON ARRAY
function.A JSON wrapper type for JSONB data obtained from the database.A JSON entry for JSON objects.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 theRETURNING
clause can be defined.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.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
.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.An error that occurred during loading.The argument object forLoaderFieldMapper.map(LoaderFieldContext)
.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.A listener forLoader
progress.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.TheLoader
API is used for configuring data loads.The log level.An intermediate step in building a proceduralLOOP
statement.AMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, 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)
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)
This type is used for the H2-specific variant of 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.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.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.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.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.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)
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)
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.An enum that specifies the nullability of aDataType
.An operator used for combining conditions.AQueryPart
to be used exclusively inORDER BY
clauses.A container for stored procedures and functionsA named parameter and/or bind value.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.This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.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.A bridge fromFlow.Publisher
toPublisher
for compatibility purposes.A qualified asterisk.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.A database result record.A model type for a records with degree1
A model type for a records with degree10
A model type for a records with degree11
A model type for a records with degree12
A model type for a records with degree13
A model type for a records with degree14
A model type for a records with degree15
A model type for a records with degree16
A model type for a records with degree17
A model type for a records with degree18
A model type for a records with degree19
A model type for a records with degree2
A model type for a records with degree20
A model type for a records with degree21
A model type for a records with degree22
A model type for a records with degree3
A model type for a records with degree4
A model type for a records with degree5
A model type for a records with degree6
A model type for a records with degree7
A model type for a records with degree8
A model type for a records with degree9
A context object forRecord
manipulation passed to registeredRecordListener
's.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.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 API forQueryPart.$replace(Replacer)
query part transformations.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.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.A routine is a callable object in your RDBMS.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.Any query that is not 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.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.AQueryPart
to be used exclusively inSELECT
clauses.AQueryPart
to be used exclusively inSELECT
clauses.ASELECT
statement (model API).A sequence.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.Third party representations of the enclosingSQLDialect
.A category forSQLDialect
.A statement that can be placed inside of aBlock
, but not executed on its own.A query storing objects to the database.The annotated string type represents a keywordComment
, which will be wrapped byDSL.comment(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).An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.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
.An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.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.An API forQueryPart.$traverse(Traverser)
query part traversals.A step in the construction of theTRUNCATE
statement.A step in the construction of theTRUNCATE
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 theTRUNCATE
statement.A text formatting type, which can be used to configure text imports / exports.A marker interface for all query parts that have aDataType
.UDT definition.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)
.A common interface for records that can be stored back to the database again.AnUPDATE
statement.This type is used for theUpdate
's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.AnUPDATE
statement (model API).This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.This type is used for theUpdate
's DSL API.A privilege for use inGRANT
andREVOKE
statements.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.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 XML wrapper type for XML data obtained from the database.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 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
Configuration
configures aDSLContext
, providing it with information for query rendering and execution.Dialects and dialect families as supported by jOOQ. -
ClassDescriptionThe step in the specification of aggregate functions where the SQL:2003 standard
FILTER clause
can be added.An aggregate function.A step in the construction of theALTER DATABASE
statement.A step in the construction of theALTER DOMAIN
statement.A step in the construction of theALTER INDEX
statement.A step in the construction of theALTER SCHEMA
statement.A step in the construction of theALTER SEQUENCE
statement.The step in theALTER TABLE
statement where the action can be decided.A step in the construction of theALTER TYPE
statement.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.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.The bind context is used for bindingQueryPart
's and their contained values to aPreparedStatement
's bind variables.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.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 typeA catalog.A character set.A CSV formatting type, which can be used to configure chart exports.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.A collation.A comment.A step in the construction of theCOMMENT ON TABLE
statement.An SPI that allows for providing a graph of versions.A (sub) set of commits.A common table expression.A condition or predicate.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.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 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 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 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 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 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 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 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 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 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 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 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.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.AConverter
for data types.AScope
that models the life cycle of a data type conversion call toConverter.from(Object)
orConverter.to(Object)
.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 FUNCTION
statement.A step in the construction of theCREATE INDEX
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.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 TRIGGER
statement.AQuery
that can create types.AQuery
that can create views.A CSV formatting type, which can be used to configure CSV imports / exports.Cursors allow for lazy, sequential access to an underlying JDBCResultSet
.A generic DAO interface for a pojo and a primary key type.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.A local variable declaration.ADELETE
statement.ADELETE
statement (model API).This type is used for theDelete
's DSL API.A parameter object that is passed toDiagnosticsListener
methods.A diagnostics listener.A provider forTransactionListener
instances.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.A step in the construction of theDROP INDEX
statement.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.A step in the construction of theDROP TABLE
statement.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.An embeddable record.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
.A column expression.Deprecated.- 3.17.0 - [#13005] - UseTableElement
instead.A source of migration content.AForeignKey
is an object referencing aUniqueKey
.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.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.A step in the construction of theGRANT
statement.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.A DDL index definition.AnINSERT
statement.AnINSERT
statement (model API).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.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.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.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 theORDER BY
clause can be defined.A step in the construction of theJSON ARRAY
function.A JSON wrapper type for JSONB data obtained from the database.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.A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theNULL
clause can be defined.A step in the construction of theJSON OBJECT
function.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.A SQL keyword.A label for use in procedural code.A database link reference.TheLoader
API is used for configuring data loads.An intermediate step in building a proceduralLOOP
statement.AMERGE
statement.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)
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)
This type is used for the H2-specific variant of theMerge
's DSL API.This type is used for 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.A listener forMigration
lifecycles.A provider forMigrationListener
instances.The experimental migrations API.An identifier.A common base type for all qualifiable, named objects.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.AQueryPart
to be used exclusively inORDER BY
clauses.A container for stored procedures and functionsA named parameter and/or bind value.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.A period specification for usage in temporal 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.A bridge fromFlow.Publisher
toPublisher
for compatibility purposes.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.A model type for a records with degree1
A model type for a records with degree10
A model type for a records with degree11
A model type for a records with degree12
A model type for a records with degree13
A model type for a records with degree14
A model type for a records with degree15
A model type for a records with degree16
A model type for a records with degree17
A model type for a records with degree18
A model type for a records with degree19
A model type for a records with degree2
A model type for a records with degree20
A model type for a records with degree21
A model type for a records with degree22
A model type for a records with degree3
A model type for a records with degree4
A model type for a records with degree5
A model type for a records with degree6
A model type for a records with degree7
A model type for a records with degree8
A model type for a records with degree9
A context object forRecord
manipulation passed to registeredRecordListener
's.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.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.An API forQueryPart.$replace(Replacer)
query part transformations.A wrapper for database results returned by
.SelectQuery
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.A step in the construction of theREVOKE
statement.A privilege for use inGRANT
andREVOKE
statements.A step in the construction of theROLLBACK
statement.A routine is a callable object in your RDBMS.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.A row value expression.Any query that is not 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.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.AQueryPart
to be used exclusively inSELECT
clauses.AQueryPart
to be used exclusively inSELECT
clauses.ASELECT
statement (model API).A sequence.A step in the construction of theSIGNAL SQL STATE
function.A sort specification.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 statement that can be placed inside of aBlock
, but not executed on its own.The annotated string type represents an identifier, i.e.The annotated string type represents a bind variable, 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).A description of various additionalTable
options to describe the table runtime meta model.A record originating from a single tableAnFunctionalInterface
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.An API forQueryPart.$traverse(Traverser)
query part traversals.ACondition
that always yieldstrue
.A step in the construction of theTRUNCATE
statement.A text formatting type, which can be used to configure text imports / exports.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)
.A common interface for records that can be stored back to the database again.AnUPDATE
statement.AnUPDATE
statement (model API).This type is used for theUpdate
's DSL API.A privilege for use inGRANT
andREVOKE
statements.A local variable reference.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.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
.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.A step in the construction of anXMLQUERY
expression.A step in the construction of anXMLTABLE
expression. -
-
ClassDescriptionA
Converter
for data types.A context object forQuery
execution passed to registeredExecuteListener
's.A column expression.A common logger abstraction API for jOOQ's internal logging.The log level. -
ClassDescriptionAn SPI to provide audit fields.A provider for cache implementations to replace the default.An SPI that allows for providing a graph of versions.A
Configuration
configures aDSLContext
, providing it with information for query rendering and execution.A connection lifecycle handler API.A provider forTransactionListener
instances.A contextual DSL providing "attached" implementations to theorg.jooq
interfaces.A provider forExecuteListener
instances.TheExecutorProvider
SPI can be used to provide jOOQ with custom asynchronous execution behaviour.An SPI that allows for overriding certain formatting defaults.An SPI that can produce dynamic catalog, schema, table meta data information.A provider forMigrationListener
instances.A provider forParseListener
instances.An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.A database result record.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.ARecordUnmapper
is a mapper that can receive user objects and convert them back toRecord
.A provider forRecordUnmapper
instances.A wrapper for database results returned by
.SelectQuery
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.Dialects and dialect families as supported by jOOQ.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.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)
.A provider forVisitListener
instances. -
-
-
-
ClassDescriptionA common interface to all dialect-specific data types.A database result record.A wrapper for database results returned by
.SelectQuery
-
-
-
-
-
-
ClassDescriptionA common interface to all dialect-specific data types.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A database result record.A wrapper for database results returned by
.SelectQuery
-
-
ClassDescriptionA common interface to all dialect-specific data types.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A database result record.A wrapper for database results returned by
.SelectQuery
-
-
ClassDescriptionA common interface to all dialect-specific data types.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A database result record.A wrapper for database results returned by
.SelectQuery
-
-
-
-
-
-
ClassDescriptionA common interface to all dialect-specific data types.A SQL enum type.A column expression.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A formal declaration of whether any API element is supported by a given
SQLDialect
-
ClassDescriptionA
Configuration
configures aDSLContext
, providing it with information for query rendering and execution.A common interface to all dialect-specific data types.A column expression.A wrapper type for spatial data obtained from the database.Deprecated.- 3.17.0 - [#13071] - UseApiStatus.Internal
instead.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.A database result record.A wrapper for database results returned by
.SelectQuery
A schema.A formal declaration of whether any API element is supported by a givenSQLDialect
UDT definition.An object holding data of a UDTAn XML wrapper type for XML data obtained from the database. -
ClassDescriptionA condition or predicate.A common interface to all dialect-specific data types.A column expression.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A database result record.A wrapper for database results returned by
.SelectQuery
A formal declaration of whether any API element is supported by a givenSQLDialect
A table. -
ClassDescriptionA common interface to all dialect-specific data types.A database result record.A wrapper for database results returned by
.SelectQuery
-
ClassDescriptionA common interface to all dialect-specific data types.A wrapper type for spatial data obtained from the database.A wrapper type for spatial data obtained from the database.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.
-
-
-
ClassDescriptionA common interface to all dialect-specific data types.A column expression.A formal declaration of whether any API element is supported by a given
SQLDialect
-
-
-
ClassDescriptionA common interface to all dialect-specific data types.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A database result record.A wrapper for database results returned by
.SelectQuery
-
ClassDescriptionA common interface to all dialect-specific data types.A JSON wrapper type for JSON data obtained from the database.A JSON wrapper type for JSONB data obtained from the database.A database result record.A wrapper for database results returned by
.SelectQuery