| Package | Description |
|---|---|
| org.jooq |
The
org.jooq package contains jOOQ's public API. |
| org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
| org.jooq.tools |
The
org.jooq.tools package contains jOOQ's public utilities. |
| org.jooq.tools.jdbc |
The
org.jooq.tools.jdbc package contains compatibility classes
to bridge between JDBC 4.0 and JDBC 4.1. |
| org.jooq.util.access |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.ACCESS dialect family. |
| org.jooq.util.ase |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.ASE dialect. |
| org.jooq.util.cubrid |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.CUBRID dialect. |
| org.jooq.util.db2 |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.DB2 dialect. |
| org.jooq.util.derby |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.DERBY dialect. |
| org.jooq.util.firebird |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.FIREBIRD dialect. |
| org.jooq.util.h2 |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.H2 dialect. |
| org.jooq.util.hana |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.HANA dialect. |
| org.jooq.util.hsqldb |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.HSQLDB dialect. |
| org.jooq.util.informix |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.DB2 dialect. |
| org.jooq.util.ingres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.INGRES dialect. |
| org.jooq.util.mariadb |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.MARIADB dialect. |
| org.jooq.util.mysql |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.MYSQL dialect. |
| org.jooq.util.oracle |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.ORACLE dialect. |
| org.jooq.util.postgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.POSTGRES dialect. |
| org.jooq.util.redshift |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.REDSHIFT dialect. |
| org.jooq.util.sqlite |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.SQLITE dialect. |
| org.jooq.util.sqlserver |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.SQLSERVER dialect family. |
| org.jooq.util.sybase |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.SYBASE dialect. |
| org.jooq.util.vertica |
| Class and Description |
|---|
| AggregateFilterStep
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause can be added. |
| AggregateFunction
An aggregate function is a special field that is usually used in a
GROUP BY context. |
| AlterIndexFinalStep
The final step in the
ALTER INDEX DSL. |
| AlterIndexStep
The step in the
ALTER INDEX where the action can be decided. |
| AlterSchemaFinalStep
The final step in the
DROP SCHEMA DSL. |
| AlterSchemaStep
The step in the
ALTER SCHEMA DSL used to specify
ALTER behaviour. |
| AlterSequenceFinalStep
A
Query that can alter sequences. |
| AlterSequenceRestartStep
A
Query that can alter sequences. |
| AlterSequenceStep
A
Query that can alter sequences. |
| AlterTableAlterStep
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. |
| AlterTableRenameIndexToStep
The step in the
ALTER TABLE DSL used to RENAME
indexes. |
| AlterTableStep
The step in the
ALTER TABLE statement where the action can be
decided. |
| AlterTableUsingIndexStep
The step in the
ALTER TABLE .. |
| AlterViewFinalStep
The final step in the
ALTER VIEW DSL. |
| AlterViewStep
The step in the
ALTER VIEW where the action can be decided. |
| ArrayRecord
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. |
| Batch
A wrapper for a JDBC batch operation.
|
| BatchBindStep
This type is used for the
Batch's DSL API. |
| BetweenAndStep
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep1
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep10
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep11
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep12
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep13
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep14
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep15
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep16
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep17
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep18
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep19
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep2
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep20
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep21
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep22
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep3
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep4
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep5
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep6
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep7
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep8
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
| BetweenAndStep9
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
An SPI (Service Provider Interface) that exposes all low-level interactions
with JDBC bind variables.
|
| BindingGetResultSetContext
A container type for
Binding.get(BindingGetResultSetContext)
arguments. |
| BindingGetSQLInputContext
A container type for
Binding.get(BindingGetSQLInputContext)
arguments. |
| BindingGetStatementContext
A container type for
Binding.get(BindingGetStatementContext)
arguments. |
| BindingRegisterContext
A container type for
Binding.register(BindingRegisterContext)
arguments. |
| BindingSetSQLOutputContext
A container type for
Binding.set(BindingSetSQLOutputContext)
arguments. |
| BindingSetStatementContext
A container type for
Binding.set(BindingSetStatementContext)
arguments. |
| BindingSQLContext
A container type for
Binding.sql(BindingSQLContext) arguments. |
| CaseConditionStep
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
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
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.
|
| ChartFormat |
| ChartFormat.Display |
| ChartFormat.Output
The chart output format.
|
| ChartFormat.Type |
| Clause
A listing of clauses that emit events
VisitListener. |
| CommonTableExpression
A common table expression is a table that can be supplied to
WITH clauses. |
| Comparator
A comparator to be used in conditions to form comparison predicates.
|
| 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. Its methods will be pushed down into extending interfaces.
Do not reference this type directly.
|
| Configuration
A
Configuration configures a DSLContext, providing it
with information for query rendering and execution. |
| ConnectionCallable
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
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep10
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep11
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep12
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep13
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep14
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep15
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep16
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep17
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep18
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep19
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep2
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep20
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep21
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep22
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep3
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep4
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep5
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep6
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep7
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep8
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep9
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. |
| Context
A context type that is used for rendering SQL or for binding.
|
| ContextTransactionalCallable
An
FunctionalInterface that wraps transactional code. |
| ContextTransactionalRunnable
An
FunctionalInterface that wraps transactional code. |
| Converter
A
Converter for data types. |
| ConverterProvider
Deprecated.
- This API is still EXPERIMENTAL. Do not use yet
|
| CreateIndexFinalStep
A
Query that can create indexes. |
| CreateIndexStep
A
Query that can create indexes. |
| CreateIndexWhereStep
A
Query that can create indexes. |
| CreateSchemaFinalStep
A
Query that can create schemas. |
| CreateSequenceFinalStep
A
Query that can create sequences. |
| CreateTableAsStep
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
A
Query that can create views. |
| CreateViewFinalStep
A
Query that can create views. |
| CSVFormat
A CSV formatting type, which can be used to configure CSV imports / exports.
|
| CSVFormat.Quote
When to apply the quote
|
| Cursor
Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet. |
| DataType
A common interface to all dialect-specific data types.
|
| DatePart
A date part can be used with SQL functions such as extract().
|
| DDLFlag |
| DDLQuery
A marker interface for all DDL queries.
|
| Delete
A
Query that can delete data in the database. |
| DeleteConditionStep
This type is used for the
Delete's DSL API. |
| DeleteFinalStep
This type is used for the
Delete's DSL API. |
| DeleteQuery
A query used for deletion of data
|
| DeleteResultStep
This type is used for the
Delete's DSL API. |
| DeleteReturningStep
This type is used for the
Delete's DSL API. |
| DeleteWhereStep
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 drop indexes. |
| DropIndexOnStep
A
Query that can drop indexes. |
| DropSchemaFinalStep
The final step in the
DROP SCHEMA DSL. |
| DropSchemaStep
The step in the
DROP SCHEMA DSL used to specify
DROP behaviour. |
| 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. |
| ExecuteListener |
| ExecuteListenerProvider
A provider for
ExecuteListener instances. |
| ExecuteType
The type of database interaction that is being executed with this context.
|
| ExecutorProvider
The
ExecutorProvider SPI can be used to provide jOOQ with custom
asynchronous execution behaviour. |
| Field
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
A
ForeignKey is an object referencing a UniqueKey. |
| FutureResult
Deprecated.
- 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0
|
| GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
| GroupField
A
QueryPart to be used exclusively in GROUP BY
clauses |
| Identity
An
Identity is an object representing an IDENTITY
column as understood by the SQL:2003 standard. |
| Index
A DDL index definition.
|
| Insert
A
Query that can insert data in the database. |
| InsertFinalStep
This type is used for the
Insert's DSL API. |
| InsertOnConflictConditionStep
This type is used for the
Insert's DSL API. |
| InsertOnConflictDoUpdateStep
This type is used for the
Insert's DSL API. |
| InsertOnConflictWhereStep
This type is used for the
Insert's DSL API. |
| InsertOnDuplicateSetMoreStep
This type is used for the
Insert's DSL API. |
| InsertOnDuplicateSetStep
This type is used for the
Insert's DSL API. |
| InsertOnDuplicateStep
This type is used for the
Insert's DSL API. |
| InsertQuery
A query for data insertion
|
| InsertResultStep
This type is used for the
Insert's DSL API. |
| InsertReturningStep
This type is used for the
Insert's DSL API. |
| InsertSetMoreStep
This type is used for the
Insert's alternative DSL API. |
| InsertSetStep
This type is used for the
Insert's alternative DSL API. |
| InsertValuesStep1
This type is used for the
Insert's DSL API. |
| InsertValuesStep10
This type is used for the
Insert's DSL API. |
| InsertValuesStep11
This type is used for the
Insert's DSL API. |
| InsertValuesStep12
This type is used for the
Insert's DSL API. |
| InsertValuesStep13
This type is used for the
Insert's DSL API. |
| InsertValuesStep14
This type is used for the
Insert's DSL API. |
| InsertValuesStep15
This type is used for the
Insert's DSL API. |
| InsertValuesStep16
This type is used for the
Insert's DSL API. |
| InsertValuesStep17
This type is used for the
Insert's DSL API. |
| InsertValuesStep18
This type is used for the
Insert's DSL API. |
| InsertValuesStep19
This type is used for the
Insert's DSL API. |
| InsertValuesStep2
This type is used for the
Insert's DSL API. |
| InsertValuesStep20
This type is used for the
Insert's DSL API. |
| InsertValuesStep21
This type is used for the
Insert's DSL API. |
| InsertValuesStep22
This type is used for the
Insert's DSL API. |
| InsertValuesStep3
This type is used for the
Insert's DSL API. |
| InsertValuesStep4
This type is used for the
Insert's DSL API. |
| InsertValuesStep5
This type is used for the
Insert's DSL API. |
| InsertValuesStep6
This type is used for the
Insert's DSL API. |
| InsertValuesStep7
This type is used for the
Insert's DSL API. |
| InsertValuesStep8
This type is used for the
Insert's DSL API. |
| InsertValuesStep9
This type is used for the
Insert's DSL API. |
| InsertValuesStepN
This type is used for the
Insert's DSL API. |
| JoinType
The type of join
|
| JSONFormat
A JSON formatting type, which can be used to configure JSON imports /
exports.
|
| JSONFormat.RecordFormat
The format of individual JSON records.
|
| Key
A
Key is an object representing a UNIQUE KEY, a
PRIMARY KEY, or a FOREIGN KEY. |
| Keyword
A SQL keyword
QueryPart. |
| LikeEscapeStep
A step in the creation of a
LIKE predicate to which an
ESCAPE clause can be appended. |
| Link
A database link reference.
|
| Loader
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
The
Loader API is used for configuring data loads. |
| LoaderCSVStep
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
The
Loader API is used for configuring data loads. |
| LoaderJSONStep
The
Loader API is used for configuring data loads. |
| LoaderListenerStep
The
Loader API is used for configuring data loads. |
| LoaderLoadStep
The
Loader API is used for configuring data loads. |
| LoaderOptionsStep
The
Loader API is used for configuring data loads. |
| LoaderRowListener
A listener for
Loader progress. |
| LoaderRowsStep
The
Loader API is used for configuring data loads. |
| LoaderSourceStep
The
Loader API is used for configuring data loads. |
| LoaderXMLStep
The
Loader API is used for configuring data loads. |
| Log.Level
The log level.
|
| Merge
A
Query that can merge data in the database. |
| MergeFinalStep
This type is used for the
Merge's DSL API. |
| MergeKeyStep1
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep10
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep11
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep12
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep13
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep14
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep15
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep16
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep17
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep18
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep19
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep2
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep20
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep21
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep22
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep3
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep4
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep5
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep6
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep7
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep8
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep9
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStepN
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeMatchedDeleteStep
This type is used for the
Merge's DSL API. |
| MergeMatchedSetMoreStep
This type is used for the
Merge's DSL API. |
| MergeMatchedSetStep
This type is used for the
Merge's DSL API. |
| MergeMatchedStep
This type is used for the
Merge's DSL API. |
| MergeMatchedWhereStep
This type is used for the
Merge's DSL API. |
| MergeNotMatchedSetMoreStep
This type is used for the
Merge's DSL API. |
| MergeNotMatchedSetStep
This type is used for the
Merge's DSL API. |
| MergeNotMatchedStep
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep1
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep10
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep11
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep12
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep13
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep14
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep15
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep16
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep17
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep18
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep19
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep2
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep20
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep21
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep22
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep3
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep4
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep5
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep6
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep7
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep8
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStep9
This type is used for the
Merge's DSL API. |
| MergeNotMatchedValuesStepN
This type is used for the
Merge's DSL API. |
| MergeNotMatchedWhereStep
This type is used for the
Merge's DSL API. |
| MergeOnConditionStep
This type is used for the
Merge's DSL API. |
| MergeOnStep
This type is used for the
Merge's DSL API. |
| MergeUsingStep
This type is used for the
Merge's DSL API. |
| MergeValuesStep1
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep10
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep11
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep12
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep13
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep14
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep15
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep16
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep17
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep18
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep19
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep2
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep20
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep21
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep22
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep3
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep4
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep5
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep6
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep7
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep8
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStep9
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeValuesStepN
This type is used for the H2-specific variant of the
Merge's DSL API. |
| Meta
A wrapping object for
DatabaseMetaData or for other sources of
database meta information (e.g. |
| Name
A SQL identifier
QueryPart. |
| Nullability
An enum that specifies the nullability of a
DataType. |
| Operator
An operator used for combining conditions
|
| OrderField
A
QueryPart to be used exclusively in ORDER BY
clauses. |
| Package
A container for stored procedures and functions
This is only supported in the
SQLDialect.ORACLE dialect |
| Param
A named parameter and/or bind value.
|
| Parameter
A parameter to a stored procedure or function.
|
| ParamMode
The mode of a
Param. |
| Parser
This is experimental functionality.
|
| PivotForStep
This type is used for the Oracle
PIVOT clause DSL API, pivoting
Table objects to new tables. |
| PivotInStep
This type is used for the Oracle
PIVOT clause DSL API, pivoting
Table objects to new tables. |
| PlainSQL
This annotation marks all methods and types that allow for producing a
QueryPart that generates "plain SQL" inside of an AST. |
| QuantifiedSelect
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.
|
| Record
A database result record.
|
| Record1
A model type for a records with degree
1 |
| Record10
A model type for a records with degree
10 |
| Record11
A model type for a records with degree
11 |
| Record12
A model type for a records with degree
12 |
| Record13
A model type for a records with degree
13 |
| Record14
A model type for a records with degree
14 |
| Record15
A model type for a records with degree
15 |
| Record16
A model type for a records with degree
16 |
| Record17
A model type for a records with degree
17 |
| Record18
A model type for a records with degree
18 |
| Record19
A model type for a records with degree
19 |
| Record2
A model type for a records with degree
2 |
| Record20
A model type for a records with degree
20 |
| Record21
A model type for a records with degree
21 |
| Record22
A model type for a records with degree
22 |
| Record3
A model type for a records with degree
3 |
| Record4
A model type for a records with degree
4 |
| Record5
A model type for a records with degree
5 |
| Record6
A model type for a records with degree
6 |
| Record7
A model type for a records with degree
7 |
| Record8
A model type for a records with degree
8 |
| Record9
A model type for a records with degree
9 |
| RecordContext
A context object for
Record manipulation passed to registered
RecordListener's. |
| RecordHandler
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
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 |
| RecordUnmapper
A
RecordUnmapper is a mapper that can receive user objects and
convert them back to Record. |
| RecordUnmapperProvider
A provider for
RecordUnmapper instances. |
| RenderContext
The render context is used for rendering
QueryPart's to SQL. |
| RenderContext.CastMode
The cast mode for bind values.
|
| Result
A wrapper for database results returned by
|
| ResultOrRows
A type that contains either a
Result, an update count, or an
exception. |
| ResultQuery
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
A routine is a callable object in your RDBMS.
|
| Row
A model type for a row value expression.
|
| Row1
A model type for a row value expression with degree
1. |
| Row10
A model type for a row value expression with degree
10. |
| Row11
A model type for a row value expression with degree
11. |
| Row12
A model type for a row value expression with degree
12. |
| Row13
A model type for a row value expression with degree
13. |
| Row14
A model type for a row value expression with degree
14. |
| Row15
A model type for a row value expression with degree
15. |
| Row16
A model type for a row value expression with degree
16. |
| Row17
A model type for a row value expression with degree
17. |
| Row18
A model type for a row value expression with degree
18. |
| Row19
A model type for a row value expression with degree
19. |
| Row2
A model type for a row value expression with degree
2. |
| Row20
A model type for a row value expression with degree
20. |
| Row21
A model type for a row value expression with degree
21. |
| Row22
A model type for a row value expression with degree
22. |
| Row3
A model type for a row value expression with degree
3. |
| Row4
A model type for a row value expression with degree
4. |
| Row5
A model type for a row value expression with degree
5. |
| Row6
A model type for a row value expression with degree
6. |
| Row7
A model type for a row value expression with degree
7. |
| Row8
A model type for a row value expression with degree
8. |
| Row9
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.
|
| SchemaMapping
Deprecated.
- 2.0.5 - Use runtime configuration
Settings instead |
| Scope
Scope implementations provide access to a variety of objects that are
available from a given scope.
|
| Select |
| SelectConditionStep |
| SelectConnectByAfterStartWithConditionStep |
| SelectConnectByAfterStartWithStep |
| SelectConnectByConditionStep |
| SelectConnectByStep |
| SelectDistinctOnStep |
| SelectField
A
QueryPart to be used exclusively in SELECT
clauses |
| SelectFinalStep |
| SelectForUpdateOfStep |
| SelectForUpdateStep |
| SelectForUpdateWaitStep |
| SelectFromStep |
| SelectGroupByStep |
| SelectHavingConditionStep |
| SelectHavingStep |
| SelectIntoStep |
| SelectJoinPartitionByStep |
| SelectJoinStep |
| SelectLimitAfterOffsetStep |
| SelectLimitStep |
| SelectOffsetStep |
| SelectOnConditionStep |
| SelectOnStep |
| SelectOptionalOnStep |
| SelectOptionStep |
| SelectOrderByStep |
| SelectQuery
A query for data selection
|
| SelectSeekLimitStep |
| SelectSeekStep1 |
| SelectSeekStep10 |
| SelectSeekStep11 |
| SelectSeekStep12 |
| SelectSeekStep13 |
| SelectSeekStep14 |
| SelectSeekStep15 |
| SelectSeekStep16 |
| SelectSeekStep17 |
| SelectSeekStep18 |
| SelectSeekStep19 |
| SelectSeekStep2 |
| SelectSeekStep20 |
| SelectSeekStep21 |
| SelectSeekStep22 |
| SelectSeekStep3 |
| SelectSeekStep4 |
| SelectSeekStep5 |
| SelectSeekStep6 |
| SelectSeekStep7 |
| SelectSeekStep8 |
| SelectSeekStep9 |
| SelectSeekStepN |
| SelectSelectStep |
| SelectStartWithStep |
| SelectUnionStep |
| SelectWhereStep |
| SelectWindowStep |
| SelectWithTiesAfterOffsetStep |
| SelectWithTiesStep |
| Sequence
A type representing sequences in databases that support this.
|
| SortField |
| SortOrder
The sorting order used in
ORDER BY clauses. |
| SQL
A plain SQL
QueryPart. |
| SQLDialect
Dialects and dialect families as supported by jOOQ.
|
| SQLDialect.ThirdParty
Third party representations of the enclosing
SQLDialect. |
| StoreQuery
A query storing objects to the database.
|
| 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. |
| Table
A table to be used in queries
|
| TableField
A field contained in a table
|
| TableLike
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 |
| TableOptionalOnStep |
| TableOuterJoinStep
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
| TablePartitionByStep
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
| TableRecord
A record originating from a single table
|
| Transaction
A custom transaction object.
|
| TransactionalCallable
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. |
| TransactionListener
The
TransactionListener SPI is used to intercept the
TransactionProvider's transaction events. |
| TransactionListenerProvider
A provider for
TransactionListener instances. |
| 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
A
Query that can truncate a table in the database. |
| TruncateCascadeStep
A
Query that can truncate a table in the database. |
| TruncateFinalStep
A
Query that can truncate a table in the database. |
| TruncateIdentityStep
A
Query that can truncate a table in the database. |
| UDT
UDT definition
|
| UDTRecord
An object holding data of a UDT
|
| UniqueKey
A
UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY. |
| UpdatableRecord
A common interface for records that can be stored back to the database again.
|
| Update
A
Query that can update data in the database. |
| UpdateConditionStep
This type is used for the
Update's DSL API. |
| UpdateFinalStep
This type is used for the
Update's DSL API. |
| UpdateFromStep
This type is used for the
Update's DSL API. |
| UpdateQuery
A query for data updating
|
| UpdateResultStep
This type is used for the
Update's DSL API. |
| UpdateReturningStep
This type is used for the
Update's DSL API. |
| UpdateSetFirstStep
This type is used for the
Update's DSL API. |
| UpdateSetMoreStep
This type is used for the
Update's DSL API. |
| UpdateSetStep
This type is used for the
Update's DSL API. |
| UpdateWhereStep
This type is used for the
Update's DSL API. |
| VersionsBetweenAndStep
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
This type is used for the window function DSL API.
|
| WindowDefinition
A window definition.
|
| WindowFinalStep
This type is used for the window function DSL API.
|
| WindowIgnoreNullsStep
This type is used for the window function DSL API.
|
| WindowOrderByStep
This type is used for the window function DSL API.
|
| WindowOverStep
This type is used for the window function DSL API.
|
| WindowPartitionByStep
This type is used for the window function DSL API.
|
| WindowRowsAndStep
This type is used for the window function DSL API.
|
| WindowRowsStep
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. |
| 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 |
| XMLFormat
An XML formatting type, which can be used to configure XML imports / exports.
|
| XMLFormat.RecordFormat
The format of individual XML records.
|
| Class and Description |
|---|
| AggregateFunction
An aggregate function is a special field that is usually used in a
GROUP BY context. |
| AlterIndexStep
The step in the
ALTER INDEX where the action can be decided. |
| AlterSchemaStep
The step in the
ALTER SCHEMA DSL used to specify
ALTER behaviour. |
| AlterSequenceStep
A
Query that can alter sequences. |
| AlterTableStep
The step in the
ALTER TABLE statement where the action can be
decided. |
| AlterViewStep
The step in the
ALTER VIEW where the action can be decided. |
| ArrayAggOrderByStep
The SQL standard
ARRAY_AGG() function. |
| ArrayRecord
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. |
| Batch
A wrapper for a JDBC batch operation.
|
| BatchBindStep
This type is used for the
Batch's DSL API. |
| BindContext
The bind context is used for binding
QueryPart's and their contained
values to a PreparedStatement's bind variables. |
| Binding
An SPI (Service Provider Interface) that exposes all low-level interactions
with JDBC bind variables.
|
| BindingGetResultSetContext
A container type for
Binding.get(BindingGetResultSetContext)
arguments. |
| BindingGetSQLInputContext
A container type for
Binding.get(BindingGetSQLInputContext)
arguments. |
| BindingGetStatementContext
A container type for
Binding.get(BindingGetStatementContext)
arguments. |
| BindingRegisterContext
A container type for
Binding.register(BindingRegisterContext)
arguments. |
| BindingSetSQLOutputContext
A container type for
Binding.set(BindingSetSQLOutputContext)
arguments. |
| BindingSetStatementContext
A container type for
Binding.set(BindingSetStatementContext)
arguments. |
| BindingSQLContext
A container type for
Binding.sql(BindingSQLContext) arguments. |
| Case
The SQL case statement.
|
| CaseConditionStep
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
An intermediary 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.
|
| Clause
A listing of clauses that emit events
VisitListener. |
| CommonTableExpression
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
|
| Configuration
A
Configuration configures a DSLContext, providing it
with information for query rendering and execution. |
| ConnectionCallable
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. |
| ConstraintFinalStep
The final step in the
Constraint construction DSL API. |
| ConstraintForeignKeyReferencesStep1
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep10
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep11
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep12
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep13
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep14
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep15
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep16
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep17
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep18
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep19
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep2
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep20
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep21
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep22
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep3
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep4
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep5
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep6
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep7
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep8
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
| ConstraintForeignKeyReferencesStep9
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
A context type that is used for rendering SQL or for binding.
|
| ContextTransactionalCallable
An
FunctionalInterface that wraps transactional code. |
| ContextTransactionalRunnable
An
FunctionalInterface that wraps transactional code. |
| Converter
A
Converter for data types. |
| ConverterProvider
Deprecated.
- This API is still EXPERIMENTAL. Do not use yet
|
| CreateIndexStep
A
Query that can create indexes. |
| CreateSchemaFinalStep
A
Query that can create schemas. |
| CreateSequenceFinalStep
A
Query that can create sequences. |
| CreateTableAsStep
A
Query that can create tables. |
| CreateViewAsStep
A
Query that can create views. |
| Cursor
Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet. |
| DAO
A generic DAO interface for a pojo and a primary key type.
|
| DataType
A common interface to all dialect-specific data types.
|
| DatePart
A date part can be used with SQL functions such as extract().
|
| DDLFlag |
| DeleteQuery
A query used for deletion of data
|
| DeleteWhereStep
This type is used for the
Delete's DSL API. |
| DropIndexOnStep
A
Query that can drop indexes. |
| DropSchemaStep
The step in the
DROP SCHEMA DSL used to specify
DROP behaviour. |
| DropSequenceFinalStep
A
Query that can drop sequences. |
| 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. |
| False
A predicate that always yields
false. |
| Field
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 |
| FieldOrRow |
| ForeignKey
A
ForeignKey is an object referencing a UniqueKey. |
| GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
| GroupField
A
QueryPart to be used exclusively in GROUP BY
clauses |
| Identity
An
Identity is an object representing an IDENTITY
column as understood by the SQL:2003 standard. |
| Index
A DDL index definition.
|
| InsertQuery
A query for data insertion
|
| InsertSetStep
This type is used for the
Insert's alternative DSL API. |
| InsertValuesStep1
This type is used for the
Insert's DSL API. |
| InsertValuesStep10
This type is used for the
Insert's DSL API. |
| InsertValuesStep11
This type is used for the
Insert's DSL API. |
| InsertValuesStep12
This type is used for the
Insert's DSL API. |
| InsertValuesStep13
This type is used for the
Insert's DSL API. |
| InsertValuesStep14
This type is used for the
Insert's DSL API. |
| InsertValuesStep15
This type is used for the
Insert's DSL API. |
| InsertValuesStep16
This type is used for the
Insert's DSL API. |
| InsertValuesStep17
This type is used for the
Insert's DSL API. |
| InsertValuesStep18
This type is used for the
Insert's DSL API. |
| InsertValuesStep19
This type is used for the
Insert's DSL API. |
| InsertValuesStep2
This type is used for the
Insert's DSL API. |
| InsertValuesStep20
This type is used for the
Insert's DSL API. |
| InsertValuesStep21
This type is used for the
Insert's DSL API. |
| InsertValuesStep22
This type is used for the
Insert's DSL API. |
| InsertValuesStep3
This type is used for the
Insert's DSL API. |
| InsertValuesStep4
This type is used for the
Insert's DSL API. |
| InsertValuesStep5
This type is used for the
Insert's DSL API. |
| InsertValuesStep6
This type is used for the
Insert's DSL API. |
| InsertValuesStep7
This type is used for the
Insert's DSL API. |
| InsertValuesStep8
This type is used for the
Insert's DSL API. |
| InsertValuesStep9
This type is used for the
Insert's DSL API. |
| InsertValuesStepN
This type is used for the
Insert's DSL API. |
| Keyword
A SQL keyword
QueryPart. |
| Link
A database link reference.
|
| LoaderOptionsStep
The
Loader API is used for configuring data loads. |
| MergeKeyStep1
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep10
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep11
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep12
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep13
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep14
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep15
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep16
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep17
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep18
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep19
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep2
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep20
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep21
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep22
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep3
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep4
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep5
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep6
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep7
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep8
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStep9
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeKeyStepN
This type is used for the H2-specific variant of the
Merge's DSL API. |
| MergeUsingStep
This type is used for the
Merge's DSL API. |
| Meta
A wrapping object for
DatabaseMetaData or for other sources of
database meta information (e.g. |
| Name
A SQL identifier
QueryPart. |
| Nullability
An enum that specifies the nullability of a
DataType. |
| Operator
An operator used for combining conditions
|
| OrderedAggregateFunction
An ordered-set aggregate function.
|
| OrderedAggregateFunctionOfDeferredType
An ordered-set aggregate function.
|
| OrderField
A
QueryPart to be used exclusively in ORDER BY
clauses. |
| Package
A container for stored procedures and functions
This is only supported in the
SQLDialect.ORACLE dialect |
| Param
A named parameter and/or bind value.
|
| Parameter
A parameter to a stored procedure or function.
|
| Parser
This is experimental functionality.
|
| PlainSQL
This annotation marks all methods and types that allow for producing a
QueryPart that generates "plain SQL" inside of an AST. |
| QuantifiedSelect
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
A model type for a records with degree
1 |
| Record10
A model type for a records with degree
10 |
| Record11
A model type for a records with degree
11 |
| Record12
A model type for a records with degree
12 |
| Record13
A model type for a records with degree
13 |
| Record14
A model type for a records with degree
14 |
| Record15
A model type for a records with degree
15 |
| Record16
A model type for a records with degree
16 |
| Record17
A model type for a records with degree
17 |
| Record18
A model type for a records with degree
18 |
| Record19
A model type for a records with degree
19 |
| Record2
A model type for a records with degree
2 |
| Record20
A model type for a records with degree
20 |
| Record21
A model type for a records with degree
21 |
| Record22
A model type for a records with degree
22 |
| Record3
A model type for a records with degree
3 |
| Record4
A model type for a records with degree
4 |
| Record5
A model type for a records with degree
5 |
| Record6
A model type for a records with degree
6 |
| Record7
A model type for a records with degree
7 |
| Record8
A model type for a records with degree
8 |
| Record9
A model type for a records with degree
9 |
| RecordContext
A context object for
Record manipulation passed to registered
RecordListener's. |
| RecordListener
A listener for manipulation events on
UpdatableRecords. |
| RecordListenerProvider
A provider for
RecordListener instances. |
| RecordMapper
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 |
| RecordUnmapper
A
RecordUnmapper is a mapper that can receive user objects and
convert them back to Record. |
| RecordUnmapperProvider
A provider for
RecordUnmapper instances. |
| RenderContext
The render context is used for rendering
QueryPart's to SQL. |
| Result
A wrapper for database results returned by
|
| ResultQuery
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
A routine is a callable object in your RDBMS.
|
| Row
A model type for a row value expression.
|
| Row1
A model type for a row value expression with degree
1. |
| Row10
A model type for a row value expression with degree
10. |
| Row11
A model type for a row value expression with degree
11. |
| Row12
A model type for a row value expression with degree
12. |
| Row13
A model type for a row value expression with degree
13. |
| Row14
A model type for a row value expression with degree
14. |
| Row15
A model type for a row value expression with degree
15. |
| Row16
A model type for a row value expression with degree
16. |
| Row17
A model type for a row value expression with degree
17. |
| Row18
A model type for a row value expression with degree
18. |
| Row19
A model type for a row value expression with degree
19. |
| Row2
A model type for a row value expression with degree
2. |
| Row20
A model type for a row value expression with degree
20. |
| Row21
A model type for a row value expression with degree
21. |
| Row22
A model type for a row value expression with degree
22. |
| Row3
A model type for a row value expression with degree
3. |
| Row4
A model type for a row value expression with degree
4. |
| Row5
A model type for a row value expression with degree
5. |
| Row6
A model type for a row value expression with degree
6. |
| Row7
A model type for a row value expression with degree
7. |
| Row8
A model type for a row value expression with degree
8. |
| Row9
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.
|
| SchemaMapping
Deprecated.
- 2.0.5 - Use runtime configuration
Settings instead |
| Scope
Scope implementations provide access to a variety of objects that are
available from a given scope.
|
| Select |
| SelectField
A
QueryPart to be used exclusively in SELECT
clauses |
| SelectQuery
A query for data selection
|
| SelectSelectStep |
| SelectWhereStep |
| Sequence
A type representing sequences in databases that support this.
|
| SQL
A plain SQL
QueryPart. |
| SQLDialect
Dialects and dialect families as supported by jOOQ.
|
| 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. |
| Table
A table to be used in queries
|
| TableField
A field contained in a table
|
| TableLike
An object that can behave like a table (a table-like object)
|
| TableRecord
A record originating from a single table
|
| TransactionalCallable
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. |
| TransactionListener
The
TransactionListener SPI is used to intercept the
TransactionProvider's transaction events. |
| TransactionListenerProvider
A provider for
TransactionListener instances. |
| TransactionProvider
The
TransactionProvider SPI can be used to implement custom
transaction behaviour that is applied when calling
DSLContext.transactionResult(TransactionalCallable) or
DSLContext.transaction(TransactionalRunnable). |
| True
A predicate that always yields
true. |
| TruncateIdentityStep
A
Query that can truncate a table in the database. |
| UDT
UDT definition
|
| UDTField
A field contained in a UDT
|
| UDTRecord
An object holding data of a UDT
|
| UniqueKey
A
UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY. |
| UpdatableRecord
A common interface for records that can be stored back to the database again.
|
| UpdateQuery
A query for data updating
|
| UpdateSetFirstStep
This type is used for the
Update's DSL API. |
| 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. |
| WindowIgnoreNullsStep
This type is used for the window function DSL API.
|
| WindowOverStep
This type is used for the window function DSL API.
|
| WindowSpecificationFinalStep
An intermediate step in the construction of a
WindowSpecification. |
| WindowSpecificationOrderByStep
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 and Description |
|---|
| Converter
A
Converter for data types. |
| ExecuteContext
A context object for
Query execution passed to registered
ExecuteListener's. |
| ExecuteListener |
| Field
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 |
| Log
A common logger abstraction API for jOOQ's internal logging.
|
| Log.Level
The log level.
|
| Class and Description |
|---|
| Configuration
A
Configuration configures a DSLContext, providing it
with information for query rendering and execution. |
| ConnectionProvider
A connection lifecycle handler API.
|
| ConverterProvider
Deprecated.
- This API is still EXPERIMENTAL. Do not use yet
|
| DSLContext
A contextual DSL providing "attached" implementations to the
org.jooq interfaces. |
| ExecuteListener |
| ExecuteListenerProvider
A provider for
ExecuteListener instances. |
| ExecutorProvider
The
ExecutorProvider SPI can be used to provide jOOQ with custom
asynchronous execution behaviour. |
| Record
A database result record.
|
| RecordListener
A listener for manipulation events on
UpdatableRecords. |
| RecordListenerProvider
A provider for
RecordListener instances. |
| RecordMapper
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. |
| RecordUnmapper
A
RecordUnmapper is a mapper that can receive user objects and
convert them back to Record. |
| RecordUnmapperProvider
A provider for
RecordUnmapper instances. |
| Result
A wrapper for database results returned by
|
| SchemaMapping
Deprecated.
- 2.0.5 - Use runtime configuration
Settings instead |
| SQLDialect
Dialects and dialect families as supported by jOOQ.
|
| TransactionListener
The
TransactionListener SPI is used to intercept the
TransactionProvider's transaction events. |
| TransactionListenerProvider
A provider for
TransactionListener instances. |
| TransactionProvider
The
TransactionProvider SPI can be used to implement custom
transaction behaviour that is applied when calling
DSLContext.transactionResult(TransactionalCallable) or
DSLContext.transaction(TransactionalRunnable). |
| VisitListener
A listener for
QueryPart traversal events. |
| VisitListenerProvider
A provider for
VisitListener instances. |
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Field
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 |
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Record
A database result record.
|
| Result
A wrapper for database results returned by
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Record
A database result record.
|
| Result
A wrapper for database results returned by
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| EnumType
A SQL enum type.
|
| Field
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 |
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| EnumType
A SQL enum type.
|
| Field
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 |
| 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. |
| Class and Description |
|---|
| Configuration
A
Configuration configures a DSLContext, providing it
with information for query rendering and execution. |
| DataType
A common interface to all dialect-specific data types.
|
| Field
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 |
| Record
A database result record.
|
| Result
A wrapper for database results returned by
|
| Schema
An object representing a database schema.
|
| 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. |
| UDT
UDT definition
|
| UDTRecord
An object holding data of a UDT
|
| Class and Description |
|---|
| Condition
A condition to be used in a query's where part
|
| DataType
A common interface to all dialect-specific data types.
|
| Field
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 |
| Record
A database result record.
|
| Record1
A model type for a records with degree
1 |
| Result
A wrapper for database results returned by
|
| Select |
| 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. |
| Table
A table to be used in queries
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Record
A database result record.
|
| Result
A wrapper for database results returned by
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Field
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 |
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Field
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 |
| 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. |
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Class and Description |
|---|
| DataType
A common interface to all dialect-specific data types.
|
| Record
A database result record.
|
| Result
A wrapper for database results returned by
|
Copyright © 2018. All Rights Reserved.