Interface | Description |
---|---|
AggregateFilterStep<T> |
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause can be added. |
AggregateFunction<T> |
An aggregate function is a special field that is usually used in a
GROUP BY context. |
AlterSequenceFinalStep |
A
Query that can alter sequences. |
AlterSequenceRestartStep<T extends Number> |
A
Query that can alter sequences. |
AlterTableAlterStep<T> |
The step in the
ALTER TABLE DSL used to ALTER
columns. |
AlterTableDropStep |
The step in the
ALTER TABLE DSL used to DROP
columns. |
AlterTableFinalStep |
The final step in the
ALTER TABLE DSL. |
AlterTableRenameColumnToStep |
The step in the
ALTER TABLE DSL used to RENAME
columns. |
AlterTableRenameConstraintToStep |
The step in the
ALTER TABLE DSL used to RENAME
constraints. |
AlterTableStep |
The step in the
ALTER TABLE where the action can be decided. |
ArrayAggOrderByStep<T> |
The SQL standard
ARRAY_AGG() function. |
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
Attachable s
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. |
Binding<T,U> |
An SPI (Service Provider Interface) that exposes all low-level interactions
with JDBC bind variables.
|
BindingGetResultSetContext<U> |
A container type for
Binding.get(BindingGetResultSetContext)
arguments. |
BindingGetSQLInputContext<U> |
A container type for
Binding.get(BindingGetSQLInputContext)
arguments. |
BindingGetStatementContext<U> |
A container type for
Binding.get(BindingGetStatementContext)
arguments. |
BindingRegisterContext<U> |
A container type for
Binding.register(BindingRegisterContext)
arguments. |
BindingSetSQLOutputContext<U> |
A container type for
Binding.set(BindingSetSQLOutputContext)
arguments. |
BindingSetStatementContext<U> |
A container type for
Binding.set(BindingSetStatementContext)
arguments. |
BindingSQLContext<U> |
A container type for
Binding.sql(BindingSQLContext) arguments. |
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.
|
CommonTableExpression<R extends Record> |
A common table expression is a table that can be supplied to
WITH clauses. |
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 rendering and execution. |
ConnectionCallable<T> |
An operation that can run code and statements against a provided JDBC
Connection . |
ConnectionProvider |
A connection lifecycle handler API.
|
ConnectionRunnable |
An operation that can run code and statements against a provided JDBC
Connection . |
Constraint |
A DDL constraint.
|
ConstraintFinalStep |
The final step in the
Constraint construction DSL API. |
ConstraintForeignKeyOnStep |
The step in the
Constraint construction DSL API that allows for
adding ON DELETE and ON UPDATE clauses. |
ConstraintForeignKeyReferencesStep1<T1> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep2<T1,T2> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep3<T1,T2,T3> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep4<T1,T2,T3,T4> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep5<T1,T2,T3,T4,T5> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep6<T1,T2,T3,T4,T5,T6> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep7<T1,T2,T3,T4,T5,T6,T7> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep8<T1,T2,T3,T4,T5,T6,T7,T8> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStepN |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintTypeStep |
The step in the
Constraint construction DSL API that allows for
specifying the constraint type. |
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. |
ConverterProvider | Deprecated
- This API is still EXPERIMENTAL.
|
CreateIndexFinalStep |
A
Query that can create indexes. |
CreateIndexStep |
A
Query that can create indexes. |
CreateSequenceFinalStep |
A
Query that can create sequences. |
CreateTableAsStep<R extends Record> |
A
Query that can create tables. |
CreateTableColumnStep |
A
Query that can create tables. |
CreateTableConstraintStep |
A
Query that can create tables. |
CreateTableFinalStep |
A
Query that can create tables. |
CreateTableOnCommitStep |
A
Query that can create tables. |
CreateViewAsStep<R extends Record> |
A
Query that can create views. |
CreateViewFinalStep |
A
Query that can create views. |
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.
|
DDLQuery |
A marker interface for all DDL queries.
|
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
|
DeleteResultStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DeleteReturningStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DeleteWhereStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DerivedColumnList |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList1 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList10 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList11 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList12 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList13 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList14 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList15 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList16 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList17 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList18 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList19 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList2 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList20 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList21 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList22 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList3 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList4 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList5 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList6 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList7 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList8 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList9 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
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
|
DropIndexFinalStep |
A
Query that can create indexes. |
DropIndexOnStep |
A
Query that can create indexes. |
DropSequenceFinalStep |
A
Query that can drop sequences. |
DropTableFinalStep |
The final step in the
DROP TABLE DSL. |
DropTableStep |
The step in the
DROP TABLE DSL used to specify DROP
behaviour. |
DropViewFinalStep |
The final step in the
DROP VIEW DSL. |
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. |
ExecuteEventHandler |
An event handler implementing
ExecuteListener events. |
ExecuteListener | |
ExecuteListenerProvider |
A provider for
ExecuteListener instances. |
ExecutorProvider |
The
ExecutorProvider SPI can be used to provide jOOQ with custom
asynchronous execution behaviour. |
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)
|
FieldOrRow | |
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 . |
Link |
A database link reference.
|
Loader<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderContext |
A context object that provides information about a loader's current state to
LoaderRowListener . |
LoaderCSVOptionsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderCSVStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderError |
An error that occurred during loading.
|
LoaderFieldMapper | |
LoaderFieldMapper.LoaderFieldContext |
The argument object for
LoaderFieldMapper.map(LoaderFieldContext)
. |
LoaderJSONOptionsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderJSONStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderListenerStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderLoadStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderOptionsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderRowListener |
A listener for
Loader progress. |
LoaderRowsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderSourceStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderXMLStep<R extends Record> |
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-set aggregate function.
|
OrderedAggregateFunctionOfDeferredType |
An ordered-set 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. |
Queries |
A wrapper for a collection of queries.
|
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
UpdatableRecord s. |
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> | |
RenderContext |
The render context is used for rendering
QueryPart 's to SQL. |
Result<R extends Record> |
A wrapper for database results returned by
|
ResultOrRows |
A type that contains either a
Result or an update count. |
ResultQuery<R extends Record> |
A query that can return results.
|
Results |
A list of
Result and update counts that can be returned by
ResultQuery.fetchMany() calls and other calls that produce multiple
cursors and update counts. |
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.
|
Scope |
Scope implementations provide access to a variety of objects that are
available from a given scope.
|
Select<R extends Record> | |
SelectConditionStep<R extends Record> | |
SelectConnectByConditionStep<R extends Record> | |
SelectConnectByStep<R extends Record> | |
SelectDistinctOnStep<R extends Record> | |
SelectField<T> |
A
QueryPart to be used exclusively in SELECT
clauses |
SelectFinalStep<R extends Record> | |
SelectForUpdateOfStep<R extends Record> | |
SelectForUpdateStep<R extends Record> | |
SelectForUpdateWaitStep<R extends Record> | |
SelectFromStep<R extends Record> | |
SelectGroupByStep<R extends Record> | |
SelectHavingConditionStep<R extends Record> | |
SelectHavingStep<R extends Record> | |
SelectIntoStep<R extends Record> | |
SelectJoinPartitionByStep<R extends Record> | |
SelectJoinStep<R extends Record> | |
SelectLimitAfterOffsetStep<R extends Record> | |
SelectLimitStep<R extends Record> | |
SelectOffsetStep<R extends Record> | |
SelectOnConditionStep<R extends Record> | |
SelectOnStep<R extends Record> | |
SelectOptionalOnStep<R extends Record> | |
SelectOptionStep<R extends Record> | |
SelectOrderByStep<R extends Record> | |
SelectQuery<R extends Record> |
A query for data selection
|
SelectSeekLimitStep<R extends Record> | |
SelectSeekStep1<R extends Record,T1> | |
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> | |
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> | |
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | |
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> | |
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> | |
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> | |
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> | |
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> | |
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> | |
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> | |
SelectSeekStep2<R extends Record,T1,T2> | |
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> | |
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> | |
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> | |
SelectSeekStep3<R extends Record,T1,T2,T3> | |
SelectSeekStep4<R extends Record,T1,T2,T3,T4> | |
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5> | |
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6> | |
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> | |
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> | |
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> | |
SelectSeekStepN<R extends Record> | |
SelectSelectStep<R extends Record> | |
SelectStartWithStep<R extends Record> | |
SelectUnionStep<R extends Record> | |
SelectWhereStep<R extends Record> | |
SelectWindowStep<R extends Record> | |
Sequence<T extends Number> |
A type representing sequences in databases that support this.
|
SortField<T> | |
SQL |
A plain SQL
QueryPart . |
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<R extends Record> |
An intermediate (optional) type for the construction of a
JOIN
clause, where the join criteria is added using an ON clause
(with a Condition . |
TableOnStep<R extends Record> | |
TableOptionalOnStep<R extends Record> | |
TablePartitionByStep<R extends Record> |
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
|
Transaction |
A custom transaction object.
|
TransactionalCallable<T> |
An
FunctionalInterface that wraps transactional code. |
TransactionalRunnable |
An
FunctionalInterface that wraps transactional code. |
TransactionContext |
A context object that is used to pass arguments to the various methods of
TransactionProvider . |
TransactionProvider |
The
TransactionProvider SPI can be used to implement custom
transaction behaviour that is applied when calling
DSLContext.transactionResult(TransactionalCallable) or
DSLContext.transaction(TransactionalRunnable) . |
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 . |
WithAsStep | |
WithAsStep1 | |
WithAsStep10 | |
WithAsStep11 | |
WithAsStep12 | |
WithAsStep13 | |
WithAsStep14 | |
WithAsStep15 | |
WithAsStep16 | |
WithAsStep17 | |
WithAsStep18 | |
WithAsStep19 | |
WithAsStep2 | |
WithAsStep20 | |
WithAsStep21 | |
WithAsStep22 | |
WithAsStep3 | |
WithAsStep4 | |
WithAsStep5 | |
WithAsStep6 | |
WithAsStep7 | |
WithAsStep8 | |
WithAsStep9 | |
WithStep |
Class | Description |
---|---|
Constants |
Some publicly available constants used in jOOQ
|
Converters<T,U> |
A chain of converters.
|
CSVFormat |
A CSV formatting type, which can be used to configure CSV imports / exports.
|
SchemaMapping | Deprecated
- 2.0.5 - Use runtime configuration
Settings instead |
Enum | Description |
---|---|
Clause |
A listing of clauses that emit events
VisitListener . |
Comparator |
A comparator to be used in conditions to form comparison predicates.
|
CSVFormat.Quote |
When to apply the quote
|
DatePart |
A date part can be used with SQL functions such as extract().
|
DDLFlag | |
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 Type | Description |
---|---|
PlainSQL |
This annotation marks all methods and types that allow for producing a
QueryPart that generates "plain SQL" inside of an AST. |
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. |
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.
Copyright © 2017. All Rights Reserved.