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.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.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. |
Class and Description |
---|
AggregateFunction
An aggregate function is a special field that is usually used in a
GROUP BY context. |
AlterSequenceFinalStep
A
Query that can alter sequences. |
AlterSequenceRestartStep
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. |
AlterTableStep
The step in the
ALTER TABLE 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.
|
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. |
ConnectionProvider
A connection lifecycle handler API.
|
Context
A context type that is used for rendering SQL or for binding.
|
Converter
A
Converter for data types. |
CreateIndexFinalStep
A
Query that can create indexes. |
CreateIndexStep
A
Query that can create indexes. |
CreateSequenceFinalStep
A
Query that can create sequences. |
CreateTableAsStep
A
Query that can create tables. |
CreateTableColumnStep
A
Query that can create tables. |
CreateTableFinalStep
A
Query that can create tables. |
CreateViewAsStep
A
Query that can create views. |
CreateViewFinalStep
A
Query that can create views. |
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().
|
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
|
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. |
DivideByOnConditionStep
An intermediate type for the construction of a relational division.
|
DivideByOnStep
An intermediate type for the construction of a relational division
|
DivideByReturningStep
An intermediate type for the construction of a relational division
|
DropIndexFinalStep
A
Query that can create indexes. |
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. |
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.
|
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)
|
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. |
Insert
A
Query that can insert data in the database. |
InsertFinalStep
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
|
Key
A
Key is an object representing a UNIQUE KEY , a
PRIMARY KEY , or a FOREIGN KEY . |
Loader
The
Loader API is used for configuring data loads. |
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.
|
LoaderJSONOptionsStep
The
Loader API is used for configuring data loads. |
LoaderJSONStep
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. |
LoaderSourceStep
The
Loader API is used for configuring data loads. |
LoaderXMLStep
The
Loader API is used for configuring data loads. |
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
This object can be obtained through DSLContext.meta() in order to
provide convenient access to your database meta data. |
Name
A SQL identifier
QueryPart . |
Operator
An operator used for combining conditions
|
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.
|
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. |
QuantifiedSelect
A participant of a quantified comparison predicate
A
QuantifiedSelect models the right hand side of a quantified
comparison predicate. |
Query
Any query
|
QueryPart
The common base type for all objects that can be used for query composition.
|
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
UpdatableRecord s. |
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 |
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
|
ResultQuery
A query that can return results.
|
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 |
SelectConnectByConditionStep |
SelectConnectByStep |
SelectDistinctOnStep |
SelectFinalStep |
SelectForUpdateOfStep |
SelectForUpdateStep |
SelectForUpdateWaitStep |
SelectFromStep |
SelectGroupByStep |
SelectHavingConditionStep |
SelectHavingStep |
SelectIntoStep |
SelectJoinPartitionByStep |
SelectJoinStep |
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 |
Sequence
A type representing sequences in databases that support this.
|
SortField |
SortOrder
The sorting order used in OrderByFieldLists
|
SQLDialect
Dialects and dialect families as supported by jOOQ.
|
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 |
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 . |
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 |
WithStep |
Class and Description |
---|
AggregateFunction
An aggregate function is a special field that is usually used in a
GROUP BY context. |
AlterSequenceRestartStep
A
Query that can alter sequences. |
AlterTableStep
The step in the
ALTER TABLE 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. |
AttachableInternal
Base functionality declaration for all
Attachable s
This interface is for JOOQ INTERNAL USE only. |
Batch
A wrapper for a JDBC batch operation.
|
BatchBindStep
This type is used for the
Batch 's DSL API. |
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.
|
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. |
ConnectionProvider
A connection lifecycle handler API.
|
Context
A context type that is used for rendering SQL or for binding.
|
Converter
A
Converter for data types. |
CreateIndexStep
A
Query that can create indexes. |
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().
|
DeleteQuery
A query used for deletion of data
|
DeleteWhereStep
This type is used for the
Delete 's DSL API. |
DropIndexFinalStep
A
Query that can create indexes. |
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. |
ExecuteListener |
ExecuteListenerProvider
A provider for
ExecuteListener instances. |
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 |
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. |
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 . |
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
This object can be obtained through DSLContext.meta() in order to
provide convenient access to your database meta data. |
Name
A SQL identifier
QueryPart . |
OrderedAggregateFunction
An ordered aggregate function.
|
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.
|
QuantifiedSelect
A participant of a quantified comparison predicate
A
QuantifiedSelect models the right hand side of a quantified
comparison predicate. |
Query
Any query
|
QueryPart
The common base type for all objects that can be used for query composition.
|
QueryPartInternal
Base functionality declaration for all query objects
This interface is for JOOQ INTERNAL USE only.
|
Record
A database result record.
|
Record1
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
UpdatableRecord s. |
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 |
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.
|
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 |
SelectQuery
A query for data selection
|
SelectSelectStep |
SelectWhereStep |
Sequence
A type representing sequences in databases that support this.
|
SortField |
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 . |
TransactionProvider
The
TransactionProvider SPI can be used to implement custom
transaction behaviour that is applied when calling
DSLContext.transactionResult(TransactionalCallable) or
DSLContext.transaction(TransactionalRunnable) . |
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 |
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 |
Class and Description |
---|
Record
A database result record.
|
Result
A wrapper for database results returned by
|
SQLDialect
Dialects and dialect families as supported by jOOQ.
|
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.
|
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 |
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 |
---|
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
|
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.
|
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.
|
Copyright © 2014. All Rights Reserved.