| 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.auroramysql |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.AURORA_MYSQL dialect. |
| org.jooq.util.aurorapostgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.AURORA_POSTGRES 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.sqldatawarehouse |
The
org.jooq.util.sqldatawarehouse package contains classes
related to the SQLDialect.SQLDATAWAREHOUSE dialect family. |
| 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.sqlserver 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.teradata |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.TERADATA dialect family. |
| 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. |
| AlterIndexOnStep
The step in the
ALTER INDEX where the table can be specified for
the index. |
| 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. |
| Block
A query that models an anonymous procedural block
|
| 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
Deprecated.
- 3.11.0 - [#7258] - This part of the
VisitListener SPI
is deprecated. There are currently no plans of replacing it.
Please get in touch if you think this functionality needs to be
kept in one way or another: https://github.com/jOOQ/jOOQ/issues/7258 |
| Collation
A collation.
|
| Comment
A meta model for SQL comments on tables, fields, etc.
|
| CommentOnFinalStep
The final step for the creation of a
COMMENT ON [ object type ]
statement. |
| CommentOnIsStep
The step in the
COMMENT ON [ object type ] statement where the
comment can be specified. |
| 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. |
| CreateIndexIncludeStep
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. |
| CreateTableCommentStep
A
Query that can create tables. |
| CreateTableConstraintStep
A
Query that can create tables. |
| CreateTableFinalStep
A
Query that can create tables. |
| CreateTableIndexStep
A
Query that can create tables. |
| CreateTableOnCommitStep
A
Query that can create tables. |
| CreateTableStorageStep
A
Query that can create tables. |
| CreateTableWithDataStep
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. |
| DiagnosticsContext
A parameter object that is passed to
DiagnosticsListener methods. |
| DiagnosticsListener
A diagnostics listener.
|
| DiagnosticsListenerProvider
A provider for
TransactionListener instances. |
| DivideByOnConditionStep
An intermediate type for the construction of a relational division.
|
| DivideByOnStep
An intermediate type for the construction of a relational division
Referencing
XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
| DivideByReturningStep
An intermediate type for the construction of a relational division
Referencing
XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
| 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. |
| Explain
Results of an
DSLContext.explain(Query) call. |
| 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)
|
| FieldOrConstraint
A common base type for
Field and Constraint where DSL API accepts
both types alike. |
| FieldOrRow |
| ForeignKey
A
ForeignKey is an object referencing a UniqueKey. |
| Formattable
A type that can format its contents.
|
| FutureResult
Deprecated.
- 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0
|
| GrantFinalStep
The final step in the creation of a
REVOKE statement. |
| GrantOnStep
The step in the creation of a
GRANT statement where the
ON clause can be added. |
| GrantToStep
The step in the creation of a
GRANT statement where the
TO clause can be added. |
| GrantWithGrantOptionStep
The step of creation
GRANT statement that assign user
or role a grant option. |
| 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. |
| MetaProvider
An SPI that can produce dynamic catalog, schema, table meta data information.
|
| Name
A SQL identifier
QueryPart. |
| Named
A common base type for all qualifiable, named objects.
|
| 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. |
| Privilege |
| QualifiedAsterisk
A
QueryPart to be used exclusively in SELECT
clauses. |
| 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. |
| RevokeFinalStep
The final step in the creation of a
REVOKE statement. |
| RevokeFromStep
The step in the creation of a
REVOKE statement where the
FROM clause can be added. |
| RevokeOnStep
The step in the creation of a
REVOKE statement where the
ON clause can be added. |
| Role
The Role to be used by GRANT statement.
|
| 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. |
| SelectFieldOrAsterisk
A
QueryPart to be used exclusively in SELECT
clauses. |
| SelectFinalStep |
| SelectForUpdateOfStep |
| SelectForUpdateStep |
| SelectForUpdateWaitStep |
| SelectFromStep |
| SelectGroupByStep |
| SelectHavingConditionStep |
| SelectHavingStep |
| SelectIntoStep |
| SelectJoinPartitionByStep |
| SelectJoinStep |
| SelectLimitAfterOffsetStep |
| SelectLimitPercentAfterOffsetStep |
| SelectLimitPercentStep |
| 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. |
| Statement
A statement that can be placed inside of a
Block, but not executed on
its own. |
| 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
An intermediate type for the construction of a
JOIN clause,
where there may optionally be a join criteria added using an ON
clause (with a Condition), or using a USING clause (with
a list of Field)
Referencing XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
| 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. |
| TXTFormat
A CSV formatting type, which can be used to configure CSV imports / exports.
|
| 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. |
| User
The User to be used by GRANT statement.
|
| 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. |
| AlterIndexOnStep
The step in the
ALTER INDEX where the table can be specified for
the index. |
| 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
|
| Asterisk
A
QueryPart to be used exclusively in SELECT
clauses. |
| 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. |
| Block
A query that models an anonymous procedural block
|
| 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
Deprecated.
- 3.11.0 - [#7258] - This part of the
VisitListener SPI
is deprecated. There are currently no plans of replacing it.
Please get in touch if you think this functionality needs to be
kept in one way or another: https://github.com/jOOQ/jOOQ/issues/7258 |
| Collation
A collation.
|
| Comment
A meta model for SQL comments on tables, fields, etc.
|
| CommentOnIsStep
The step in the
COMMENT ON [ object type ] statement where the
comment can be specified. |
| 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. |
| DiagnosticsContext
A parameter object that is passed to
DiagnosticsListener methods. |
| DiagnosticsListener
A diagnostics listener.
|
| DiagnosticsListenerProvider
A provider for
TransactionListener instances. |
| 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. |
| Explain
Results of an
DSLContext.explain(Query) call. |
| 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 |
| FieldOrConstraint
A common base type for
Field and Constraint where DSL API accepts
both types alike. |
| FieldOrRow |
| ForeignKey
A
ForeignKey is an object referencing a UniqueKey. |
| GrantOnStep
The step in the creation of a
GRANT statement where the
ON clause can be added. |
| 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. |
| MetaProvider
An SPI that can produce dynamic catalog, schema, table meta data information.
|
| Name
A SQL identifier
QueryPart. |
| Named
A common base type for all qualifiable, named objects.
|
| 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. |
| Privilege |
| 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. |
| RevokeOnStep
The step in the creation of a
REVOKE statement where the
ON clause can be added. |
| Role
The Role to be used by GRANT statement.
|
| 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. |
| SelectFieldOrAsterisk
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.
|
| Statement
A statement that can be placed inside of a
Block, but not executed on
its own. |
| 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. |
| User
The User to be used by GRANT statement.
|
| 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. |
| WindowFromFirstLastStep
This type is used for the window function DSL API.
|
| 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
|
| DiagnosticsListener
A diagnostics listener.
|
| DiagnosticsListenerProvider
A provider for
TransactionListener instances. |
| 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. |
| MetaProvider
An SPI that can produce dynamic catalog, schema, table meta data information.
|
| 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.
|
| 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.
|
| 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.
|
| 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.
|
| 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 © 2019. All rights reserved.