Package org.jooq

The org.jooq package contains jOOQ's public API.

See: Description

Interface Summary

Interface	Description
AggregateFunction<T>	An aggregate function is a special field that is usually used in a GROUP BY context.
ArrayRecord<E>	A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods
Attachable	An object in jOOQ that can have an underlying Configuration attached or detached.
AttachableInternal	Base functionality declaration for all Attachables This interface is for JOOQ INTERNAL USE only.
Batch	A wrapper for a JDBC batch operation.
BatchBindStep	This type is used for the Batch's DSL API.
BetweenAndStep<T>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep1<T1>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep2<T1,T2>	An intermediate DSL type for the construction of a BETWEEN 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 a BETWEEN 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 a BETWEEN 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 a BETWEEN predicate.
BetweenAndStep3<T1,T2,T3>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep4<T1,T2,T3,T4>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep5<T1,T2,T3,T4,T5>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep6<T1,T2,T3,T4,T5,T6>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>	An intermediate DSL type for the construction of a BETWEEN predicate.
BetweenAndStepN	An intermediate DSL type for the construction of a BETWEEN predicate.
BindContext	The bind context is used for binding QueryPart's and their contained values to a PreparedStatement's bind variables.
Case	The SQL case statement.
CaseConditionStep<T>	The final step in creating a case statement of the type CASE WHEN x < 1 THEN 'one' WHEN x >= 2 THEN 'two' ELSE 'three' END
CaseValueStep<V>	An intermediary step in creating a case statement of the type CASE x WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'three' END
CaseWhenStep<V,T>	The final step in creating a case statement of the type CASE x WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'three' END
Catalog	An object representing a database catalog.
Condition	A condition to be used in a query's where part
ConditionProvider	Deprecated - 2.6.0 [#1881] - This type will be removed from the public API, soon.
Configuration	A Configuration configures a DSLContext, providing it with information for query construction, rendering and execution.
ConnectionProvider	A connection lifecycle handler API.
Context<C extends Context<C>>	A context type that is used for rendering SQL or for binding.
Converter<T,U>	A Converter for data types.
Cursor<R extends Record>	Cursors allow for lazy, sequential access to an underlying JDBC ResultSet.
DAO<R extends TableRecord<R>,P,T>	A generic DAO interface for a pojo and a primary key type.
DataType<T>	A common interface to all dialect-specific data types.
Delete<R extends Record>	A Query that can delete data in the database.
DeleteConditionStep<R extends Record>	This type is used for the Delete's DSL API.
DeleteFinalStep<R extends Record>	This type is used for the Delete's DSL API.
DeleteQuery<R extends Record>	A query used for deletion of data
DeleteWhereStep<R extends Record>	This type is used for the Delete's DSL API.
DivideByOnConditionStep	An intermediate type for the construction of a relational division.
DivideByOnStep	An intermediate type for the construction of a relational division
DivideByReturningStep	An intermediate type for the construction of a relational division
DSLContext	A contextual DSL providing "attached" implementations to the org.jooq interfaces.
EnumType	A SQL enum type.
ExecuteContext	A context object for Query execution passed to registered ExecuteListener's.
ExecuteListener	An event listener for Query, Routine, or ResultSet render, prepare, bind, execute, fetch steps.
ExecuteListenerProvider	A provider for ExecuteListener instances.
Field<T>	A field used in tables and conditions Note that all fields qualify as GroupField, i.e. they can always be used in GROUP BY clauses
FieldLike	An object that can behave like a field (a field-like object)
ForeignKey<R extends Record,O extends Record>	A ForeignKey is an object referencing a UniqueKey.
FutureResult<R extends Record>	Deprecated - 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0
GroupConcatOrderByStep	MySQL's GROUP_CONCAT function.
GroupConcatSeparatorStep	MySQL's GROUP_CONCAT function.
GroupField	A QueryPart to be used exclusively in GROUP BY clauses
Identity<R extends Record,T>	An Identity is an object representing an IDENTITY column as understood by the SQL:2003 standard.
Insert<R extends Record>	A Query that can insert data in the database.
InsertFinalStep<R extends Record>	This type is used for the Insert's DSL API.
InsertOnDuplicateSetMoreStep<R extends Record>	This type is used for the Insert's DSL API.
InsertOnDuplicateSetStep<R extends Record>	This type is used for the Insert's DSL API.
InsertOnDuplicateStep<R extends Record>	This type is used for the Insert's DSL API.
InsertQuery<R extends Record>	A query for data insertion
InsertResultStep<R extends Record>	This type is used for the Insert's DSL API.
InsertReturningStep<R extends Record>	This type is used for the Insert's DSL API.
InsertSetMoreStep<R extends Record>	This type is used for the Insert's alternative DSL API.
InsertSetStep<R extends Record>	This type is used for the Insert's alternative DSL API.
InsertValuesStep1<R extends Record,T1>	This type is used for the Insert's DSL API.
InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Insert's DSL API.
InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Insert's DSL API.
InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Insert's DSL API.
InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Insert's DSL API.
InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Insert's DSL API.
InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Insert's DSL API.
InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Insert's DSL API.
InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Insert's DSL API.
InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Insert'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 the Insert's DSL API.
InsertValuesStep2<R extends Record,T1,T2>	This type is used for the Insert'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 the Insert'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 the Insert'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 the Insert's DSL API.
InsertValuesStep3<R extends Record,T1,T2,T3>	This type is used for the Insert's DSL API.
InsertValuesStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Insert's DSL API.
InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Insert's DSL API.
InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Insert's DSL API.
InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Insert's DSL API.
InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Insert's DSL API.
InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Insert's DSL API.
InsertValuesStepN<R extends Record>	This type is used for the Insert's DSL API.
Key<R extends Record>	A Key is an object representing a UNIQUE KEY, a PRIMARY KEY, or a FOREIGN KEY.
Keyword	A SQL keyword QueryPart.
Loader<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderCSVOptionsStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderCSVStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderError	An error that occurred during loading.
LoaderJSONOptionsStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderJSONStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderLoadStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderOptionsStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderSourceStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
LoaderXMLStep<R extends TableRecord<R>>	The Loader API is used for configuring data loads.
Merge<R extends Record>	A Query that can merge data in the database.
MergeFinalStep<R extends Record>	This type is used for the Merge's DSL API.
MergeKeyStep1<R extends Record,T1>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep2<R extends Record,T1,T2>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the H2-specific variant of the Merge's DSL API.
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>	This type is used for the H2-specific variant of the Merge's DSL API.
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>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep3<R extends Record,T1,T2,T3>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep4<R extends Record,T1,T2,T3,T4>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeKeyStepN<R extends Record>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeMatchedDeleteStep<R extends Record>	This type is used for the Merge's DSL API.
MergeMatchedSetMoreStep<R extends Record>	This type is used for the Merge's DSL API.
MergeMatchedSetStep<R extends Record>	This type is used for the Merge's DSL API.
MergeMatchedStep<R extends Record>	This type is used for the Merge's DSL API.
MergeMatchedWhereStep<R extends Record>	This type is used for the Merge's DSL API.
MergeNotMatchedSetMoreStep<R extends Record>	This type is used for the Merge's DSL API.
MergeNotMatchedSetStep<R extends Record>	This type is used for the Merge's DSL API.
MergeNotMatchedStep<R extends Record>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep1<R extends Record,T1>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep2<R extends Record,T1,T2>	This type is used for the Merge'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 the Merge'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 the Merge'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 the Merge's DSL API.
MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Merge's DSL API.
MergeNotMatchedValuesStepN<R extends Record>	This type is used for the Merge's DSL API.
MergeNotMatchedWhereStep<R extends Record>	This type is used for the Merge's DSL API.
MergeOnConditionStep<R extends Record>	This type is used for the Merge's DSL API.
MergeOnStep<R extends Record>	This type is used for the Merge's DSL API.
MergeUsingStep<R extends Record>	This type is used for the Merge's DSL API.
MergeValuesStep1<R extends Record,T1>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep2<R extends Record,T1,T2>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the H2-specific variant of the Merge's DSL API.
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>	This type is used for the H2-specific variant of the Merge's DSL API.
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>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep3<R extends Record,T1,T2,T3>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep4<R extends Record,T1,T2,T3,T4>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the H2-specific variant of the Merge's DSL API.
MergeValuesStepN<R extends Record>	This type is used for the H2-specific variant of the Merge's DSL API.
Meta	A wrapping object for DatabaseMetaData This object can be obtained through DSLContext.meta() in order to provide convenient access to your database meta data.
Name	A SQL identifier QueryPart.
OrderedAggregateFunction<T>	An ordered aggregate function.
Package	A container for stored procedures and functions This is only supported in the SQLDialect.ORACLE dialect
Param<T>	A named parameter and/or bind value.
Parameter<T>	A parameter to a stored procedure or function.
PivotForStep	This type is used for the Oracle PIVOT clause DSL API, pivoting Table objects to new tables.
PivotInStep<T>	This type is used for the Oracle PIVOT clause DSL API, pivoting Table objects to new tables.
QuantifiedSelect<R extends Record>	A participant of a quantified comparison predicate A QuantifiedSelect models the right hand side of a quantified comparison predicate.
Query	Any query
QueryPart	The common base type for all objects that can be used for query composition.
QueryPartInternal	Base functionality declaration for all query objects This interface is for JOOQ INTERNAL USE only.
Record	A database result record.
Record1<T1>	A model type for a records with degree 1
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	A model type for a records with degree 10
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	A model type for a records with degree 11
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	A model type for a records with degree 12
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	A model type for a records with degree 13
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	A model type for a records with degree 14
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	A model type for a records with degree 15
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	A model type for a records with degree 16
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	A model type for a records with degree 17
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	A model type for a records with degree 18
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	A model type for a records with degree 19
Record2<T1,T2>	A model type for a records with degree 2
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	A model type for a records with degree 20
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	A model type for a records with degree 21
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	A model type for a records with degree 22
Record3<T1,T2,T3>	A model type for a records with degree 3
Record4<T1,T2,T3,T4>	A model type for a records with degree 4
Record5<T1,T2,T3,T4,T5>	A model type for a records with degree 5
Record6<T1,T2,T3,T4,T5,T6>	A model type for a records with degree 6
Record7<T1,T2,T3,T4,T5,T6,T7>	A model type for a records with degree 7
Record8<T1,T2,T3,T4,T5,T6,T7,T8>	A model type for a records with degree 8
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>	A model type for a records with degree 9
RecordContext	A context object for Record manipulation passed to registered RecordListener's.
RecordHandler<R extends Record>	A RecordHandler is a handler that can receive Record objects, when fetching data from the database.
RecordListener	A listener for manipulation events on UpdatableRecords.
RecordListenerProvider	A provider for RecordListener instances.
RecordMapper<R extends Record,E>	A RecordMapper is a mapper that can receive Record objects, when fetching data from the database, transforming them into a custom type <E>
RecordMapperProvider	A provider for RecordMapper instances.
RecordType<R extends Record>	A record type for Table, Cursor, Result and other objects.
RenderContext	The render context is used for rendering QueryPart's to SQL.
Result<R extends Record>	A wrapper for database results returned by SelectQuery
ResultQuery<R extends Record>	A query that can return results.
Routine<T>	A routine is a callable object in your RDBMS.
Row	A model type for a row value expression.
Row1<T1>	A model type for a row value expression with degree 1.
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	A model type for a row value expression with degree 10.
Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	A model type for a row value expression with degree 11.
Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	A model type for a row value expression with degree 12.
Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	A model type for a row value expression with degree 13.
Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	A model type for a row value expression with degree 14.
Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	A model type for a row value expression with degree 15.
Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	A model type for a row value expression with degree 16.
Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	A model type for a row value expression with degree 17.
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	A model type for a row value expression with degree 18.
Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	A model type for a row value expression with degree 19.
Row2<T1,T2>	A model type for a row value expression with degree 2.
Row20<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 row value expression with degree 20.
Row21<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 row value expression with degree 21.
Row22<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 row value expression with degree 22.
Row3<T1,T2,T3>	A model type for a row value expression with degree 3.
Row4<T1,T2,T3,T4>	A model type for a row value expression with degree 4.
Row5<T1,T2,T3,T4,T5>	A model type for a row value expression with degree 5.
Row6<T1,T2,T3,T4,T5,T6>	A model type for a row value expression with degree 6.
Row7<T1,T2,T3,T4,T5,T6,T7>	A model type for a row value expression with degree 7.
Row8<T1,T2,T3,T4,T5,T6,T7,T8>	A model type for a row value expression with degree 8.
Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>	A model type for a row value expression with degree 9.
RowN	A model type for a row value expression with degree N > 22.
Schema	An object representing a database schema
Select<R extends Record>	A Query that can provide a Result after execution
SelectConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectConnectByConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectConnectByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectFinalStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectForUpdateOfStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectForUpdateStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectForUpdateWaitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectFromStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectGroupByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectHavingConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectHavingStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectJoinPartitionByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectJoinStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectLimitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectOnConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectOnStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectOptionalOnStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectOptionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectOrderByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectQuery<R extends Record>	A query for data selection
SelectSeekLimitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep1<R extends Record,T1>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep2<R extends Record,T1,T2>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep3<R extends Record,T1,T2,T3>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSeekStepN<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectSelectStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectStartWithStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectWhereStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
SelectWindowStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
Sequence<T extends Number>	A type representing sequences in databases that support this.
SortField<T>	A wrapper for a Field and a SortField
StoreQuery<R extends Record>	A query storing objects to the database.
Table<R extends Record>	A table to be used in queries
TableField<R extends Record,T>	A field contained in a table
TableLike<R extends Record>	An object that can behave like a table (a table-like object)
TableOnConditionStep	An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
TableOnStep	An intermediate type for the construction of a JOIN clause, where there must be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field).
TableOptionalOnStep	An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)
TablePartitionByStep	An intermediate type for the construction of a partitioned SQLDialect.ORACLE OUTER JOIN clause.
TableRecord<R extends TableRecord<R>>	A record originating from a single table
Template	Deprecated - This type is still very experimental and not yet released to a broad public.
Truncate<R extends Record>	A Query that can truncate a table in the database.
TruncateCascadeStep<R extends Record>	A Query that can truncate a table in the database.
TruncateFinalStep<R extends Record>	A Query that can truncate a table in the database.
TruncateIdentityStep<R extends Record>	A Query that can truncate a table in the database.
UDT<R extends UDTRecord<R>>	UDT definition
UDTField<R extends UDTRecord<R>,T>	A field contained in a UDT
UDTRecord<R extends UDTRecord<R>>	An object holding data of a UDT
UniqueKey<R extends Record>	A UniqueKey is an object representing a UNIQUE KEY or a PRIMARY KEY.
UpdatableRecord<R extends UpdatableRecord<R>>	A common interface for records that can be stored back to the database again.
Update<R extends Record>	A Query that can update data in the database.
UpdateConditionStep<R extends Record>	This type is used for the Update's DSL API.
UpdateFinalStep<R extends Record>	This type is used for the Update's DSL API.
UpdateFromStep<R extends Record>	This type is used for the Update's DSL API.
UpdateQuery<R extends Record>	A query for data updating
UpdateResultStep<R extends Record>	This type is used for the Update's DSL API.
UpdateReturningStep<R extends Record>	This type is used for the Update's DSL API.
UpdateSetFirstStep<R extends Record>	This type is used for the Update's DSL API.
UpdateSetMoreStep<R extends Record>	This type is used for the Update's DSL API.
UpdateSetStep<R extends Record>	This type is used for the Update's DSL API.
UpdateWhereStep<R extends Record>	This type is used for the Update's DSL API.
VersionsBetweenAndStep<R extends Record,T>	This type is used for the Oracle VERSIONS clause DSL API, providing access to the flashback versions query clauses.
VisitContext	A context object for QueryPart traversal passed to registered VisitListener's.
VisitListener	A listener for QueryPart traversal events.
VisitListenerProvider	A provider for VisitListener instances.
WindowBeforeOverStep<T>	This type is used for the window function DSL API.
WindowDefinition	A window definition.
WindowFinalStep<T>	This type is used for the window function DSL API.
WindowIgnoreNullsStep<T>	This type is used for the window function DSL API.
WindowOrderByStep<T>	This type is used for the window function DSL API.
WindowOverStep<T>	This type is used for the window function DSL API.
WindowPartitionByStep<T>	This type is used for the window function DSL API.
WindowRowsAndStep<T>	This type is used for the window function DSL API.
WindowRowsStep<T>	This type is used for the window function DSL API.
WindowSpecification	A window specification.
WindowSpecificationFinalStep	An intermediate step in the construction of a WindowSpecification.
WindowSpecificationOrderByStep	An intermediate step in the construction of a WindowSpecification.
WindowSpecificationPartitionByStep	An intermediate step in the construction of a WindowSpecification.
WindowSpecificationRowsAndStep	An intermediate step in the construction of a WindowSpecification.
WindowSpecificationRowsStep	An intermediate step in the construction of a WindowSpecification.

Class Summary

Class	Description
Constants	Some publicly available constants used in jOOQ
SchemaMapping	Deprecated - 2.0.5 - Use runtime configuration Settings instead

Enum Summary

Enum	Description
Clause	A listing of clauses that emit events VisitListener.
Comparator	A comparator to be used in conditions to form comparison predicates.
DatePart	A date part can be used with SQL functions such as extract().
ExecuteType	The type of database interaction that is being executed with this context.
JoinType	The type of join
Operator	An operator used for combining conditions
RenderContext.CastMode	The cast mode for bind values.
SortOrder	The sorting order used in OrderByFieldLists
SQLDialect	Dialects and dialect families as supported by jOOQ.

Annotation Types Summary

Annotation Type	Description
Support	A formal declaration of whether any API element is supported by a given SQLDialect The annotation is mainly used in three modes: The annotation is absent on a method.

Package org.jooq Description

The org.jooq 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.