All Classes and Interfaces
Class
Description
A convenient base implementation for custom bindings, simplifies the
implementation.
A base implementation for
Configuration
classes, implementing the
usual convenience API.Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
A common base class for stored procedures
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause
can be added.An aggregate function.
Allow a set of
SQLDialect
to be supported by any jOOQ statement in
the scope of this annotation.This annotation allows
Allow.PlainSQL
API usage within the scope of
where it is placed.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER DATABASE
statement.A step in the construction of the
ALTER DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER DOMAIN
statement.A step in the construction of the
ALTER DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER INDEX
statement.A step in the construction of the
ALTER INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER SEQUENCE
statement.A step in the construction of the
ALTER SEQUENCE
statement.The step in the
ALTER TABLE
DSL used to ADD
columns.The step in the
ALTER TABLE
DSL used to ALTER
constraints.The step in the
ALTER TABLE
DSL used to ALTER
columns.The step in the
ALTER TABLE
DSL used to DROP
columns or constraints.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
The step in the
ALTER TABLE
DSL used to RENAME
columns.The step in the
ALTER TABLE
DSL used to RENAME
constraints.The step in the
ALTER TABLE
DSL used to RENAME
indexes.The step in the
ALTER TABLE
statement where the action can be
decided.The step in the
ALTER TABLE … ADD CONSTRAINT
statement where an
optional index can be specified to enforce the constraint.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER TYPE
statement.A step in the construction of the
ALTER TYPE
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
ALTER VIEW
statement.The SQL standard
ARRAY_AGG()
function.A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), or an
associative array, additionally providing some convenience methods.
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally
providing some convenience methods.
A common base class for Oracle ARRAY types
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
A "record" that encapsulates an Oracle-style associative array, additionally
providing some convenience methods.
A common base class for Oracle associative array types
An unqualified asterisk.
An object in jOOQ that can have an underlying
Configuration
attached
or detached.A type that is both
Attachable
and a QueryPart
.A
Generator
that can be used for audit columns, whose values are
defined by Configuration.auditProvider()
.An SPI to provide audit fields.
The type of the audit info produced by an
AuditGenerator
.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A base class for automatic conversion using
Configuration.converterProvider()
.Java class for BackslashEscaping.
A wrapper for a JDBC batch operation.
This type is used for the
Batch
's DSL API.An operation that can run code and statements, buffering all consecutive and
identical SQL strings in a
BatchedPreparedStatement
, delaying their
execution.A batching connection.
A batched statement.
An operation that can run code and statements, buffering all consecutive and
identical SQL strings in a
BatchedPreparedStatement
, delaying their
execution.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.An intermediate DSL type for the construction of a
BETWEEN
predicate.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The bind context is used for binding
QueryPart
's and their contained
values to a PreparedStatement
's bind variables.An SPI (Service Provider Interface) that exposes all low-level interactions
with JDBC bind variables.
A container type for
Binding.get(BindingGetResultSetContext)
arguments.A container type for
Binding.get(BindingGetSQLInputContext)
arguments.A container type for
Binding.get(BindingGetStatementContext)
arguments.A container type for
Binding.register(BindingRegisterContext)
arguments.A container type for
Binding.set(BindingSetSQLOutputContext)
arguments.A container type for
Binding.set(BindingSetStatementContext)
arguments.A container type for
Binding.sql(BindingSQLContext)
arguments.A binding that takes binary values but binds them as
Blob
to at the
JDBC level.A procedural block.
An internal marker subtype of
DefaultDataType
, to be used only by
built-in data types in SQLDataType
and dialect specific data type
classes, such as e.g.The parameter object passed to the
CacheProvider.provide(CacheContext)
method.A provider for cache implementations to replace the default.
The set of internal cache types.
A step in the construction of the
CALL
statement.An
ExecuteListener
that allows for functional composition.A
FormattingProvider
that allows for functional composition.A
ParseListener
that allows for functional composition.A
RecordListener
that allows for functional composition.A
TransactionListener
that allows for functional composition.A
VisitListener
that allows for functional composition.The SQL case statement.
The final step in creating a case statement of the type
An intermediary step in creating a case statement of the type
The final step in creating a case statement of the type
A catalog.
Java class for Catalog complex type.
A common base class for database catalogs
A
MetaProvider
that provides its meta data based on (possibly
generated) catalogs.Java class for ChangeType.
A character set.
A CSV formatting type, which can be used to configure chart exports.
The chart output format.
A check constraint.
Java class for CheckConstraint complex type.
Simple version of the JSR 305 annotation that allows for inspecting jOOQ code
and detect accidentally omitted calls to
Query.execute()
and the
likes in IntelliJ.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7258] - This part of the
VisitListener
SPI
is deprecated.A binding that takes binary values but binds them as
Clob
to at the
JDBC level.A resourceful
DSLContext
that should be closed in a
try-with-resources statement.A
Query
that holds a reference to the underlying
PreparedStatement
without closing it, for reuse.A
ResultQuery
that holds a reference to the underlying
PreparedStatement
without closing it, for reuse.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A collation.
Java class for Column complex type.
A common base type for
Comment
and other, potential future types
where DSL API accepts all types alike.A comment.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
COMMENT ON TABLE
statement.A commit in a version control system.
An SPI that allows for providing a graph of versions.
A (sub) set of commits.
Java class for CommitType complex type.
A common table expression.
A comparator to be used in conditions to form comparison predicates.
A condition or predicate.
Deprecated, for removal: This API element is subject to removal in a future version.
- 2.6.0 [#1881] - This type will be removed from the public API,
soon.
A
Configuration
configures a DSLContext
, providing it
with information for query rendering and execution.The
Configuration
was set up in a way that does not allow for a
particular operation.An operation that can run code and statements against a provided JDBC
Connection
.A connection lifecycle handler API.
An operation that can run code and statements against a provided JDBC
Connection
.Some publicly available constants used in jOOQ
A DDL constraint.
The step in the
Constraint
construction DSL API that allows for
adding ENFORCED
and NOT ENFORCED
clauses.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
The step in the
Constraint
construction DSL API that allows for
adding ON DELETE
and ON UPDATE
clauses.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.ConstraintForeignKeyReferencesStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.ConstraintForeignKeyReferencesStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.ConstraintForeignKeyReferencesStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
matching a FOREIGN KEY
clause with a REFERENCES
clause.The step in the
Constraint
construction DSL API that allows for
specifying the constraint type.Container factory for creating containers for JSON object and JSON array.
A simplified and stoppable SAX-like content handler for stream processing of JSON text.
The
File.type()
.A context type that is used for rendering SQL or for binding.
A special type of
Converter
with alternative
ContextConverter.from(Object, ConverterContext)
and
ContextConverter.to(Object, ConverterContext)
methods.An
FunctionalInterface
that wraps transactional code.An
FunctionalInterface
that wraps transactional code.A step in the construction of an
CONTINUE
statement where a
WHEN
clause can be added.An exception that is used to influence control flows.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#11898] This class will be removed in the future.
A
Converter
for data types.A
Scope
that models the life cycle of a data type conversion call to
Converter.from(Object)
or Converter.to(Object)
.A chain of converters.
An unknown type that is used when users do not provide any explicit user
type
Class
reference e.g.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
CREATE DOMAIN
statement.A step in the construction of the
CREATE DOMAIN
statement.A step in the construction of the
CREATE DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
CREATE FUNCTION
statement.A step in the construction of the
CREATE FUNCTION
statement.A step in the construction of the
CREATE FUNCTION
statement.A step in the construction of the
CREATE FUNCTION
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
CREATE INDEX
statement.A step in the construction of the
CREATE INDEX
statement.A step in the construction of the
CREATE INDEX
statement.A step in the construction of the
CREATE PROCEDURE
statement.A step in the construction of the
CREATE PROCEDURE
statement.A step in the construction of the
CREATE PROCEDURE
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
CREATE SEQUENCE
statement.A step in the construction of the
CREATE TABLE
statement.A step in the construction of the
CREATE TABLE
statement.A step in the construction of the
CREATE TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
CREATE TABLE
statement.A step in the construction of the
CREATE TABLE
statement.A step in the construction of the
CREATE TABLE
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.A step in the construction of the
CREATE TRIGGER
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A
Query
that can create types.A
Query
that can create views.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A CSV formatting type, which can be used to configure CSV imports / exports.
When to apply the quote
A very simple CSV parser released under a commercial-friendly license.
A very simple CSV reader released under a commercial-friendly license.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13.0 - [#9403] - This dialect is hardly used by anyone with
jOOQ or without jOOQ and will be removed in the near future.
Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet
.A base class for custom
Condition
implementations in client code.A base class for custom
Field
implementations in client code.A base class for custom
QueryPart
implementations in client code.A base class for custom
TableRecord
implementations in client code.A base class for custom
Statement
implementations in client code.A base class for custom
Table
implementations in client code.A generic DAO interface for a pojo and a primary key type.
A common base implementation for generated
DAO
.The
DataAccessException
is a generic RuntimeException
indicating that something went wrong while executing a SQL statement from
jOOQ.An error occurred while storing a record with optimistic locking active,
whose underlying data had already been changed.
An error occurred while running DDL statements in
DSLContext.meta(org.jooq.Source...)
and related API.The
DataException
is jOOQ's equivalent of JDBC's
SQLDataException
.An error occurred while running a
Migration
.An error occurred while running
Migration.validate()
.A default implementation for a pooled
DataSource
-oriented
ConnectionProvider
A common interface to all dialect-specific data types.
An error occurred while handling data types.
A binding that implements the date-as-timestamp semantics of the jOOQ code
generator.
A date part can be used with SQL functions such as extract().
Deprecated.
- 3.15.0 - [#11505] - Use
Converter.ofNullable(Class, Class, Function, Function)
instead, e.g.An implementation for the SQL standard
INTERVAL DAY TO SECOND
data type.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
A configuration type for use with the various
Meta.ddl()
methods.Whether to inline foreign key constraint definitions with the table
definition.
A marker interface for all DDL queries.
A local variable declaration.
A default JDBC CallableStatement implementation delegating all JDBC 4.0 calls
to an internal delegate.
An extension of
DefaultDSLContext
that implements also the
CloseableDSLContext
contract.A default implementation of the
CommitProvider
SPI, which provides
a materialisation of the currently available database version graph.A default implementation for configurations within a
DSLContext
, if no
custom configuration was supplied to DSL.using(Configuration)
.A default JDBC Connection implementation delegating all JDBC 4.0 calls to an
internal delegate.
A default R2DBC
Connection
implementation delegating all R2DBC
calls to an internal getDelegate().A default implementation for
ConnectionProvider
.A default converter provider offering the functionality of
Convert
.A common base class for data types.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
DiagnosticsListenerProvider
.A default implementation for
DSLContext
.Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
ExecuteListenerProvider
.A default
Executor
implementation.A default
ExecutorProvider
implementation, providing a
DefaultExecutor
instance.A default implementation for the
FormattingProvider
.A default implementation of the
MetaProvider
SPI, which provides meta
data information based on the JDBC DatabaseMetaData
API.Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
MigrationListenerProvider
.Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
ParseListenerProvider
.A default JDBC PreparedStatement implementation delegating all JDBC 4.0 calls
to an internal delegate.
Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
RecordListenerProvider
.This is the default implementation for
RecordMapper
types, which
applies to Record.into(Class)
, Result.into(Class)
, and
similar calls.A default
RecordMapperProvider
implementation, providing a
DefaultRecordMapper
instance.A default implementation for unmapping a custom type to a
Record
.A default
RecordUnmapperProvider
implementation, providing a
DefaultRecordUnmapper
instance.A default JDBC ResultSet implementation delegating all JDBC 4.0 calls to an
internal delegate.
A default JDBC Statement implementation delegating all JDBC 4.0 calls to an
internal delegate.
A default R2DBC
Statement
implementation delegating all R2DBC calls
to an internal getDelegate().Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
TransactionListenerProvider
.A default implementation for the
TransactionProvider
SPI.Deprecated.
- 3.17.0 - [#13542] - This class is no longer needed.
A default implementation for
VisitListenerProvider
.A
DELETE
statement.This type is used for the
Delete
's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the
Delete
's DSL API.This type is used for the
Delete
's DSL API.A
DELETE
statement (model API).This type is used for the
Delete
's DSL API.This type is used for the
Delete
's DSL API.This type is used for the
Delete
's DSL API.This type is used for the
Delete
's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
A derived column list.
Java class for DiagnosticsConnection.
A parameter object that is passed to
DiagnosticsListener
methods.A diagnostics listener.
A provider for
TransactionListener
instances.A command line interface to the Parser API, which works in a similar way as
https://www.jooq.org/translate.
An intermediate type for the construction of a relational division.
An intermediate type for the construction of a relational division
An intermediate type for the construction of a relational division
The meta model of a SQL
DOMAIN
Java class for Domain complex type.
Java class for DomainConstraint complex type.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
DROP DOMAIN
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
DROP INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
DROP INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
DROP SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
DROP TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A
Query
that can drop types.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A DSL "entry point" providing implementations to the
org.jooq
interfaces.A contextual DSL providing "attached" implementations to the
org.jooq
interfaces.Java class for ElementType complex type.
An embeddable record.
A record implementation for a record originating from a single table
A base class for enum conversion.
A SQL enum type.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A context object for
Query
execution passed to registered
ExecuteListener
's.The batch mode, which helps interpret the contents of
ExecuteContext.batchQueries()
.An event handler implementing
ExecuteListener
events.A provider for
ExecuteListener
instances.A
Scope
that knows its ExecuteContext
.The type of database interaction that is being executed with this context.
Java class for ExecuteWithoutWhere.
The
ExecutorProvider
SPI can be used to provide jOOQ with custom
asynchronous execution behaviour.A step in the construction of an
EXIT
statement where a
WHEN
clause can be added.Results of an
DSLContext.explain(Query)
call.A
Condition
that always yields false
.Java class for FetchIntermediateResult.
A column expression.
An object that can behave like a field (a field-like object).
Deprecated.
- 3.17.0 - [#13005] - Use
TableElement
instead.A source of migration content.
A utility class that can traverse a directory structure given some ant-style
file patterns, or classpath resources.
The sort algorithm to be applied to directory contents.
A set of files that are in a specific order.
Java class for FileType complex type.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
The step in the creation of a
FOR LOOP
statement where the
BY
clause can be supplied.A
ForeignKey
is an object referencing a UniqueKey
.The step in the creation of a
FOR LOOP
statement where the
IN
clause can be supplied.A type that can format its contents.
An SPI that allows for overriding certain formatting defaults.
A function of degree 0.
A function of degree 1.
A function of degree 10.
A function of degree 11.
A function of degree 12.
A function of degree 13.
A function of degree 14.
A function of degree 15.
A function of degree 16.
A function of degree 17.
A function of degree 18.
A function of degree 19.
A function of degree 2.
A function of degree 20.
A function of degree 21.
A function of degree 22.
A function of degree 3.
A function of degree 4.
A function of degree 5.
A function of degree 6.
A function of degree 7.
A function of degree 8.
A function of degree 9.
Utilities related to the construction of functions.
A generator can be used with
DataType.generatedAlwaysAs(Generator)
to
implement dynamic, client side computed columns, i.e.A
GeneratorContext
is an argument object that is passed to a
Generator
when generating client side computed columns.The statement type of a
GeneratorContext
.A wrapper type for spatial data obtained from the database.
A wrapper type for spatial data obtained from the database.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
GRANT
statement.A step in the construction of the
GRANT
statement.A step in the construction of the
GRANT
statement.MySQL's
GROUP_CONCAT
function.MySQL's
GROUP_CONCAT
function.An expression to be used exclusively in
GROUP BY
clauses.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
An
Identity
is an object representing an IDENTITY
column as understood by the SQL:2003 standard.A converter that doesn't convert anything.
An intermediate step in building a procedural
IF
statement.An intermediate step in building a procedural
IF
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A DDL index definition.
Java class for Index complex type.
Java class for IndexColumnUsage complex type.
Java class for anonymous complex type.
A
MetaProvider
that provides its meta data based on JAXB-annotated
InformationSchema
meta information.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
An
INSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.An
INSERT
statement (model API).This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's alternative DSL API.This type is used for the
Insert
's alternative DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the
Insert
's DSL API.InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the
Insert
's DSL API.InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.This type is used for the
Insert
's DSL API.The
IntegrityConstraintViolationException
is jOOQ's equivalent
of JDBC's SQLIntegrityConstraintViolationException
.A utility class that grants access to internal API, to be used only by
generated code.
Deprecated.
- 3.17.0 - [#13071] - Use
ApiStatus.Internal
instead.Java class for InterpreterNameLookupCaseSensitivity.
A schema that is on the search path.
A substitute for JDBC's missing
java.sql.Interval
data type.An unexpected result was encountered after executing a
Query
.Java class for InvocationOrder.
The jOOQ
IOException
is a wrapper for a
IOException
.Deprecated.
- 3.15.0 - [#11618] - This type is no longer used by jOOQ and
will be removed in the future.
Deprecated.
- 3.15.0 - [#11618] - This type is no longer used by jOOQ and
will be removed in the future.
Deprecated.
- 3.15.0 - [#11618] - This type is no longer used by jOOQ and
will be removed in the future.
JDBC-related utility methods.
The type of join.
The jOOQ logger abstraction.
Deprecated.
- Use
Log.Level
insteadA converter that delegates data type conversions to a JPA
AttributeConverter
.A JSON wrapper type for JSON data obtained from the database.
A JSON array.
A step in the construction of
DSL.jsonArrayAgg(Field)
or
DSL.jsonbArrayAgg(Field)
functions where the NULL
clause
can be defined.A step in the construction of
DSL.jsonArrayAgg(Field)
or
DSL.jsonbArrayAgg(Field)
functions where the ORDER BY
clause can be defined.A step in the construction of
DSL.jsonArrayAgg(Field)
or
DSL.jsonbArrayAgg(Field)
functions where the RETURNING
clause can be defined.A step in the construction of the
JSON ARRAY
function.A step in the construction of the
JSON ARRAY
function.A JSON wrapper type for JSONB data obtained from the database.
A JSON entry for JSON objects.
A step in the creation of
JSONEntry
values.A step in the construction of
DSL.jsonExists(Field, Field)
or
DSL.jsonbExists(Field, Field)
functions where the
ON ERROR
clause can be defined.A JSON formatting type, which can be used to configure JSON imports /
exports.
The format of individual JSON records.
A JSON object.
A step in the construction of
DSL.jsonObjectAgg(JSONEntry)
or
DSL.jsonbObjectAgg(JSONEntry)
functions where the NULL
clause can be defined.A step in the construction of
DSL.jsonObjectAgg(JSONEntry)
or
DSL.jsonbObjectAgg(JSONEntry)
functions where the
RETURNING
clause can be defined.A step in the construction of the
JSON OBJECT
function.A step in the construction of the
JSON OBJECT
function.Parser for JSON text.
A step in the construction of an
JSON_TABLE
expression.A step in the construction of an
JSON_TABLE
expression.A step in the construction of an
JSON_TABLE
expression.A step in the construction of an
JSON_TABLE
expression.A step in the construction of
DSL.jsonValue(Field, Field)
or
DSL.jsonbValue(Field, Field)
functions where the
ON EMPTY
and ON ERROR
clauses can be defined for
default values.A step in the construction of
DSL.jsonValue(Field, Field)
or
DSL.jsonbValue(Field, Field)
functions where the
ON EMPTY
and ON ERROR
clauses can be defined.A step in the construction of the
JSON VALUE
function.A
Key
is an object representing a UNIQUE KEY
, a
PRIMARY KEY
, or a FOREIGN KEY
.Java class for KeyColumnUsage complex type.
A SQL keyword.
A label for use in procedural code.
The current language context of some
ParseContext
or
RenderContext
.A schema that references a lazy initialisable
Catalog
singleton, for
use in generated code.A schema that references a lazy initialisable
Schema
singleton, for
use in generated code.A lazy supplier
A step in the construction of the
LIKE
function.A database link reference.
The
Loader
API is used for configuring data loads.The
LoaderConfigurationException
indicates that a Loader
was executed with an illegal execution configuration.A context object that provides information about a loader's current state to
LoaderRowListener
.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.An error that occurred during loading.
The argument object for
LoaderFieldMapper.map(LoaderFieldContext)
.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.A listener for
Loader
progress.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.The
Loader
API is used for configuring data loads.A binding that implements the date-as-timestamp semantics of the jOOQ code
generator.
A common logger abstraction API for jOOQ's internal logging.
The log level.
A default
ExecuteListener
that just logs events to java.util.logging,
log4j, or slf4j using the JooqLogger
An R2DBC
Batch
proxy that logs all statements that are prepared
or executed using it.A JDBC
Connection
proxy that logs all statements that are prepared or
executed using it.An R2DBC
Connection
proxy that logs all statements that are prepared
or executed using it.A default implementation of a
DiagnosticsListener
that logs
diagnostics.An R2DBC
Statement
proxy that logs all statements that are prepared
or executed using it.An intermediate step in building a procedural
LOOP
statement.A catalog mapping configuration.
A schema mapping configuration.
A table mapping configuration.
An error occurred while fetching data into a user defined Java object with
any of these methods:
ResultQuery.fetchInto(Class)
Cursor.fetchInto(Class)
Result.into(Class)
Record.into(Class)
...Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The
SQLDialect.MARIADB
specific DSL.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A
MERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeKeyStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeKeyStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeKeyStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
This type is used for the H2-specific variant of the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the
Merge
's DSL API.MergeNotMatchedValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.This type is used for the
Merge
's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
MergeValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via
DSLContext.mergeInto(Table)
This type is used for the H2-specific variant of the
Merge
's DSL API.A wrapping object for
DatabaseMetaData
or for other sources of
database meta information (e.g.An SPI that can produce dynamic catalog, schema, table meta data information.
An executable migration between two
Commit
instances.A configuration type for use with the various
Meta.migrateTo(Meta)
methods.The context in which a
Migration
is executed.A listener for
Migration
lifecycles.A provider for
MigrationListener
instances.The public API entry point for jOOQ migrations.
The experimental migrations API.
A migration schema configuration.
Java class for MigrationsType complex type.
The migration schema and table configuration.
This class allows for mashalling / unmarshalling XML content to jOOQ
configuration objects.
Various utilities related to
MockDataProvider
.A mock
Array
.An
FunctionalInterface
that wraps mockable code.A mock configuration.
A mock connection.
A mock connection provider.
A data provider for mock query executions.
A mock execution context.
A file-based
MockDataProvider
.A configuration object for the
MockFileDatabase
.An unexpected result can be encountered while loading a file-based
MockDataProvider
.A mock result.
A mock result set.
A mock result set meta data object.
An
FunctionalInterface
that wraps mockable code.A mock statement.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The
SQLDialect.MYSQL
specific DSL.An identifier.
A flag indicating whether the name is quoted or not.
A common base type for all qualifiable, named objects.
A binding that takes binary values but binds them as
NClob
to at the
JDBC level.Java class for NestedCollectionEmulation.
An "empty" implementation that is never connected.
No rows were returned from a
ResultQuery
, when exactly one row was
expected.An abstraction over directed, acyclic graph models.
An "empty" implementation that is never transactional.
A
Condition
that always yields null
.An enum that specifies the nullability of a
DataType
.This object contains factory methods for each
Java content interface and Java element interface
generated in the org.jooq.conf package.
This object contains factory methods for each
Java content interface and Java element interface
generated in the org.jooq.migrations.xml.jaxb package.
This object contains factory methods for each
Java content interface and Java element interface
generated in the org.jooq.util.xml.jaxb package.
Java class for ObjectType.
An operator used for combining conditions.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The
SQLDialect.ORACLE
specific DSL.Oracle AQ related features are located here.
A flag corresponding to
DBMS_AQ.DEQUEUE_OPTIONS_T.DELIVERY_MODE
and to
DBMS_AQ.ENQUEUE_OPTIONS_T.DELIVERY_MODE
.A flag corresponding to
DBMS_AQ.DEQUEUE_OPTIONS_T.DEQUEUE_MODE
.A
RECORD
corresponding to
DBMS_AQ.DEQUEUE_OPTIONS_T
.A
RECORD
corresponding to
DBMS_AQ.ENQUEUE_OPTIONS_T
.A
RECORD
corresponding to
DBMS_AQ.MESSAGE_PROPERTIES_T
.A flag corresponding to
DBMS_AQ.DEQUEUE_OPTIONS_T.NAVIGATION
.A flag corresponding to
DBMS_AQ.ENQUEUE_OPTIONS_T.SEQUENCE_DEVIATION
.A flag corresponding to
DBMS_AQ.DEQUEUE_OPTIONS_T.VISIBILITY
and to
DBMS_AQ.ENQUEUE_OPTIONS_T.VISIBILITY
.A flag corresponding to
DBMS_AQ.DEQUEUE_OPTIONS_T.WAIT
.An ordered-set aggregate function.
An ordered-set aggregate function.
A
QueryPart
to be used exclusively in ORDER BY
clauses.A container for stored procedures and functions
A default implementation for packages (containers of stored procedures and
functions)
A named parameter and/or bind value.
Java class for ParamCastMode.
A parameter to a stored procedure or function.
Java class for Parameter complex type.
Java class for ParameterMode.
The mode of a
Param
.Java class for ParamType.
Java class for ParentType complex type.
A publicly available API for the internal parse context that allows for
parsing SQL fragements.
ParseException explains why and where the error occurs in source JSON text.
A listener that allows for parsing custom SQL.
A provider for
ParseListener
instances.Java class for ParseNameCase.
A SQL parser.
A command line interface to the Parser API, which works in a similar way as
https://www.jooq.org/translate.
An exception that arises while parsing SQL through
DSLContext.parser()
.A schema that is on the search path.
Java class for ParseUnknownFunctions.
Java class for ParseUnsupportedSyntax.
Java class for ParseWithMetaLookups.
A period specification for usage in temporal tables.
This implements a class that handles the PostgreSQL interval type.
PGobject is a class used to describe unknown types An unknown type is any type that is unknown by
JDBC Standards.
This type is used for the Oracle
PIVOT
clause DSL API, pivoting
Table
objects to new tables.This type is used for the Oracle
PIVOT
clause DSL API, pivoting
Table
objects to new tables.This annotation marks all methods and types that allow for producing a
QueryPart
that generates "plain SQL" inside of an AST.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The
SQLDialect.POSTGRES
specific DSL.A collection of utilities to cover the Postgres JDBC driver's missing
implementations.
A privilege for use in
GRANT
and REVOKE
statements.An annotation that indicates that any given API is available to the
commercial jOOQ distributions only, including the jOOQ Express Edition, the
jOOQ Professional Edition, and the jOOQ Enterprise Edition.
A bridge from
Flow.Publisher
to
Publisher
for compatibility purposes.A draft of the new query object model API.
The
ABS
function.The
ACOS
function.The
ACOSH
function.The
ACOTH
function.The
ADD
operator.The
ALTER DATABASE
statement.The
ALTER DOMAIN
statement.The
ALTER INDEX
statement.The
ALTER SCHEMA
statement.The
ALTER SEQUENCE
statement.The
ALTER TYPE
statement.The
ALTER VIEW
statement.The
AND
operator.The
ANY VALUE
function.The
ARRAY APPEND
function.The
ARRAY CONCAT
function.The
ARRAY GET
function.The
ARRAY OVERLAP
function.The
ARRAY PREPEND
function.The
ARRAY REMOVE
function.The
ARRAY REPLACE
function.The
ASCII
function.The
ASIN
function.The
ASINH
function.The
ATAN
function.The
ATAN2
function.The
ATANH
function.The
AVG
function.The
BETWEEN
predicate.The
BIT AND
operator.The
BIT AND AGG
function.The
BIT COUNT
function.The
BIT GET
function.The
BIT LENGTH
function.The
BIT NAND
operator.The
BIT NAND AGG
function.The
BIT NOR
operator.The
BIT NOR AGG
function.The
BIT NOT
operator.The
BIT OR
operator.The
BIT OR AGG
function.The
BIT SET
function.The
BIT X NOR
operator.The
BIT X NOR AGG
function.The
BIT XOR
operator.The
BIT XOR AGG
function.The
BOOL AND
function.The
BOOL OR
function.The
CALL
statement.The
CARDINALITY
function.The
Cascade
type.The
CEIL
function.The
CHAR LENGTH
function.The
CHR
function.The
COMMENT ON TABLE
statement.The
COMMIT
statement.The
FIELD
function.The
CONNECT BY ISCYCLE
function.The
CONNECT BY ISLEAF
function.The
CONNECT BY ROOT
function.The
CONTAINS
operator.The
CONTAINS IGNORE CASE
operator.The
CORR
function.The
COS
function.The
COSH
function.The
COT
function.The
COTH
function.The
COUNT
function.The
COVAR POP
function.The
COVAR SAMP
function.The
CREATE DATABASE
statement.The
CREATE DOMAIN
statement.The
CREATE FUNCTION
statement.The
CREATE INDEX
statement.The
CREATE PROCEDURE
statement.The
CREATE SCHEMA
statement.The
CREATE SEQUENCE
statement.The
CREATE TABLE
statement.The
CREATE TRIGGER
statement.The
CREATE TYPE
statement.The
CREATE VIEW
statement.The
CURRENT CATALOG
function.The
CURRENT SCHEMA
function.The
CURRENT USER
function.The
CycleOption
type.The
DATE ADD
function.The
DEGREES
function.The
DELETE
statement.An
DELETE
statement with a RETURNING
clause.The
DELETING
function.The
Deterministic
type.The
DIGITS
function.The
DIV
operator.The
DocumentOrContent
type.The
DROP DATABASE
statement.The
DROP DOMAIN
statement.The
DROP FUNCTION
statement.The
DROP INDEX
statement.The
DROP PROCEDURE
statement.The
DROP SCHEMA
statement.The
DROP SEQUENCE
statement.The
DROP TABLE
statement.The
DROP TRIGGER
statement.The
DROP TYPE
statement.The
DROP VIEW
statement.The
ENDS WITH
operator.The
ENDS WITH IGNORE CASE
operator.The
EQ
operator.The
EQ
operator.The
E
function.The
EXCLUDED
function.The
EXECUTE
function.The
EXISTS
function.The
EXP
function.A
Condition
that is always FALSE
.The
CONDITION
function.The
FLOOR
function.The
FrameExclude
type.The
FrameUnits
type.The
FromFirstOrLast
type.The
GE
operator.The
GenerationLocation
type.The
GenerationOption
type.The
GE
operator.The
GOTO
function.The
GRANT
statement.The
GT
operator.The
GT
operator.A table with a MySQL style index access hint.
The
IdentityRestartOption
type.The
IN
operator.The
IN
predicate accepting a list of values.The
INSERT
statement.The
INSERTING
function.An
INSERT
statement with a RETURNING
clause.The
IS DISTINCT FROM
operator.The
IS DOCUMENT
operator.The
IS JSON
operator.The
IS NOT DISTINCT FROM
operator.The
IS NOT DOCUMENT
operator.The
IS NOT JSON
operator.The
IS NOT NULL
operator.The
IS NULL
operator.The
JSON ARRAY
function.The
JSONB GET ATTRIBUTE
function.The
JSONB GET ATTRIBUTE AS TEXT
function.The
JSONB GET ELEMENT
function.The
JSONB GET ELEMENT AS TEXT
function.The
JSONB INSERT
function.The
JSONB KEYS
function.The
JSONB REMOVE
function.The
JSONB REPLACE
function.The
JSONB SET
function.The
JSON GET ATTRIBUTE
function.The
JSON GET ATTRIBUTE AS TEXT
function.The
JSON GET ELEMENT
function.The
JSON GET ELEMENT AS TEXT
function.The
JSON INSERT
function.The
JSON KEYS
function.The
JSON OBJECT
function.The
JSONOnNull
type.The
JSON REMOVE
function.The
JSON REPLACE
function.The
JSON SET
function.The
LE
operator.The
LEFT
function.The
LE
operator.The
LEVEL
function.The
LIKE
operator.The
LIKE IGNORE CASE
operator.The
LIKE
operator.A table with a database link.
The
LN
function.The
LOG
function.The
LOG10
function.The
LOWER
function.The
LPAD
function.The
LT
operator.The
LT
operator.The
LTRIM
function.The
Materialized
type.The
MAX
function.The
MD5
function.The
MEDIAN
function.The
MIN
function.The
MOD
operator.The
MUL
operator.The
NE
operator.The
NE
operator.The
NOT
operator.The
NOT
operator.The
NOT IN
operator.The
NOT IN
predicate accepting a list of values.The
NOT LIKE
operator.The
NOT LIKE IGNORE CASE
operator.The
NOT LIKE
operator.The
NOT SIMILAR TO
operator.The
NOT SIMILAR TO
operator.Deprecated, for removal: This API element is subject to removal in a future version.
- [#12425] - 3.16.0 - Missing implementations should be added
as soon as possible!
A
Condition
that is always NULL
.The
NullCallClause
type.The
NULLIF
function.The
NullOrdering
type.The
NullTreatment
type.The
NVL
function.The
OCTET LENGTH
function.The
OR
operator.The
OVERLAY
function.The
PI
function.The
PLUS
operator.The
POSITION
function.The
POWER
operator.The
PRIOR
function.The
PRODUCT
function.The
ROWID
operator.The
Quantifier
type.The
RADIANS
function.The
RAND
function.The
REGR AVGX
function.The
REGR AVGY
function.The
REGR COUNT
function.The
REGR INTERCEPT
function.The
REGR R2
function.The
REGR SLOPE
function.The
REGR SXX
function.The
REGR SXY
function.The
REGR SYY
function.The
RELEASE SAVEPOINT
statement.The
REPEAT
function.The
REPLACE
function.The
ResultOption
type.The
RETURN_
function.The
REVERSE
function.The
REVOKE
statement.The
RIGHT
function.The
ROLLBACK
statement.The
ROUND
function.The
ROW EQ
operator.The
ROW GE
operator.The
ROW GT
operator.The
ROW LE
operator.The
ROW LT
operator.The
ROW NE
operator.The
ROWNUM
function.The
RPAD
function.The
RTRIM
function.The
SAVEPOINT
statement.The
SET CATALOG
statement.The
SET
statement.The
SET SCHEMA
statement.The
SHL
operator.The
SHR
operator.The
SIGN
function.The
SIGNAL SQL STATE
function.The
SIMILAR TO
operator.The
SIMILAR TO
operator.The
SIN
function.The
SINH
function.The
SPACE
function.The
SPLIT PART
function.The
SQLDataAccess
type.The
SQRT
function.The
SQUARE
function.The
ST AREA
function.The
STARTS WITH
operator.The
STARTS WITH IGNORE CASE
operator.The
START TRANSACTION
statement.The
ST ASBINARY
function.The
ST ASTEXT
function.The
ST CENTROID
function.The
ST CONTAINS
function.The
ST CROSSES
function.The
STDDEV POP
function.The
STDDEV SAMP
function.The
ST DIFFERENCE
function.The
ST DISJOINT
function.The
ST DISTANCE
function.The
ST ENDPOINT
function.The
ST EQUALS
function.The
ST EXTERIORRING
function.The
ST GEOMETRYN
function.The
ST GEOMETRYTYPE
function.The
ST GEOMFROMTEXT
function.The
ST GEOMFROMWKB
function.The
ST INTERIORRINGN
function.The
ST INTERSECTION
function.The
ST INTERSECTS
function.The
ST ISCLOSED
function.The
ST ISEMPTY
function.The
ST LENGTH
function.The
ST NUMGEOMETRIES
function.The
ST NUMINTERIORRING
function.The
ST NUMPOINTS
function.The
ST OVERLAPS
function.The
ST POINTN
function.The
ST SRID
function.The
ST STARTPOINT
function.The
ST TOUCHES
function.The
ST UNION
function.The
ST WITHIN
function.The
ST X
function.The
ST Y
function.The
ST Z
function.The
SUB
operator.The
SUBSTRING
function.The
SUBSTRING INDEX
function.The
SUM
function.The
SYS CONNECT BY PATH
function.The
TableCommitAction
type.The
EQ
operator.The
NE
operator.The
TAN
function.The
TANH
function.The
TAU
function.The
TO CHAR
function.The
TO DATE
function.The
TO HEX
function.The
TO TIMESTAMP
function.The
TRANSLATE
function.The
TRIM
function.A
Condition
that is always TRUE
.The
TRUNC
function.The
TRUNCATE
statement.A generic tuple of degree 2 for use in
QOM
types.The
UNIQUE
function.An unmodifiable
Collection
of QueryPart
elements.The
UPDATE
statement.An
UPDATE
statement with a RETURNING
clause.The
UPDATING
function.The
UPPER
function.The
UUID
function.The
VAR POP
function.The
VAR SAMP
function.The
WIDTH BUCKET
function.A collection derived table or table valued function with a
WITH ORDINALITY
clause.The
WithOrWithoutData
type.A table with a T-SQL style
WITH
hint.The
XMLCOMMENT
function.The
XMLCONCAT
function.The
XMLDOCUMENT
function.The
XMLFOREST
function.The
XMLPassingMechanism
type.The
XMLPI
function.The
XMLSERIALIZE
function.The
XOR
operator.A qualified asterisk.
A quantified select for use in quantified comparison predicates.
A wrapper for a collection of queries.
Any query.
The common base type for all objects that can be used for query composition.
Base functionality declaration for all query objects
Java class for QueryPoolable.
An Oracle AQ specification.
A common base class for AQ.
A database result record.
A model type for a records with degree
1
A model type for a records with degree
10
A model type for a records with degree
11
A model type for a records with degree
12
A model type for a records with degree
13
A model type for a records with degree
14
A model type for a records with degree
15
A model type for a records with degree
16
A model type for a records with degree
17
A model type for a records with degree
18
A model type for a records with degree
19
A model type for a records with degree
2
A model type for a records with degree
20
A model type for a records with degree
21
A model type for a records with degree
22
A model type for a records with degree
3
A model type for a records with degree
4
A model type for a records with degree
5
A model type for a records with degree
6
A model type for a records with degree
7
A model type for a records with degree
8
A model type for a records with degree
9
A context object for
Record
manipulation passed to registered
RecordListener
's.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#11902] - Use
Iterable.forEach(Consumer)
based methods, instead.A listener for manipulation events on
UpdatableRecord
s.A provider for
RecordListener
instances.A
RecordMapper
is a mapper that can receive Record
objects, when fetching data from the database, transforming them into a
custom type <E>
.A provider for
RecordMapper
instances.Common utilities related to
Record
types and constructing
RecordMapper
.A
RecordUnmapper
is a mapper that can receive user objects and
convert them back to Record
.A provider for
RecordUnmapper
instances.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
Java class for ReferentialConstraint complex type.
A unchecked wrapper for any of Java's checked reflection exceptions:
The render context is used for rendering
QueryPart
's to SQL.The cast mode for bind values.
Java class for RenderDefaultNullability.
All sorts of formatting flags / settings.
Java class for RenderImplicitJoinType.
Java class for RenderImplicitWindowRange.
Java class for RenderKeywordCase.
Deprecated.
The runtime schema and table mapping.
Java class for RenderNameCase.
Deprecated.
Java class for RenderOptionalKeyword.
Java class for RenderQuotedNames.
Java class for RenderTable.
An intermediate step in building a procedural
REPEAT
statement.An API for
QueryPart.$replace(Replacer)
query part transformations.A set of
Replacer
constructor methods.Require a set of
SQLDialect
to be supported by any jOOQ statement in
the scope of this annotation.A scope that can manage resources.
A wrapper for database results returned by
SelectQuery
.A type that contains either a
Result
, an update count, or an
exception.A query that can return 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.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
REVOKE
statement.A step in the construction of the
REVOKE
statement.A privilege for use in
GRANT
and REVOKE
statements.A step in the construction of the
ROLLBACK
statement.A routine is a callable object in your RDBMS.
Java class for Routine complex type.
Java class for RoutineType.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
A row value expression.
Any query that is not a
ResultQuery
, and thus possibly produces a row
count as a result, instead of a Result
.A data type corresponding to JDBC's
Types.ROWID
.A row value expression.
An auxiliary class for constructing
Row
collections.A schema.
Java class for Schema complex type.
A common base class for database schemata
Deprecated, for removal: This API element is subject to removal in a future version.
- 2.0.5 - Use runtime configuration
Settings
insteadA
MetaProvider
that provides its meta data based on (possibly
generated) schemas.Scope implementations provide access to a variety of objects that are
available from a given scope.
A
SELECT
statement.A
QueryPart
to be used exclusively in SELECT
clauses.A
QueryPart
to be used exclusively in SELECT
clauses.A
SELECT
statement (model API).SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
A sequence.
Java class for Sequence complex type.
A common base class for sequences
Settings that influence the way jOOQ renders SQL code.
Convenience methods for jOOQ runtime settings.
A step in the construction of the
SIGNAL SQL STATE
function.A
DataSource
that wraps a single connection, preventing its closing
when it is obtained from this data source.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A sort specification.
The sorting order used in
ORDER BY
clauses.A source of text data.
A wrapper type for spatial data obtained from the database.
A plain SQL
QueryPart
.The SQL standard data types, as described in
Types
.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Dialects and dialect families as supported by jOOQ.
A category for
SQLDialect
.An exception thrown if an SQL construct is used, which is not supported by
the dialect set in
Configuration.dialect()
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
The
SQLDialect.SQLSERVER
specific DSL.The class of the SQL state as specified by the SQL:2011 standard, or by individual
vendors.
The subclass of the SQL state class as specified by the SQL standard, or by individual
vendors.
A statement that can be placed inside of a
Block
, but not executed on
its own.Java class for StatementType.
A time measuring device
A default
ExecuteListener
that just logs events to java.util.logging,
log4j, or slf4j using the JooqLogger
.A query storing objects to the database.
An
XmlAdapter
that implements useful features after parsing XML
strings with JAXB.A container for annotations on stringly typed API.
The annotated string type represents a keyword
Comment
,
which will be wrapped by DSL.comment(String)
.The annotated string type represents a keyword
Keyword
,
which will be wrapped by DSL.keyword(String)
.The annotated string type represents an identifier, i.e.
The annotated string type represents a bind variable, i.e.
The annotated string type represents a plain SQL template, i.e.
Operations on
String
that are null
safe.A formal declaration of whether any API element is supported by a given
SQLDialect
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
A table.
Java class for Table complex type.
Java class for TableConstraint complex type.
Java class for TableConstraintType.
A field contained in a table.
A common base type for tables
An object that can behave like a table (a table-like object).
A
MetaProvider
that provides its meta data based on (possibly
generated) schemas.An intermediate (optional) type for the construction of a
JOIN
clause, where the join criteria is added using an ON
clause
(with a Condition
.A description of various additional
Table
options to describe the
table runtime meta model.The
ON COMMIT
flag for TableOptions.TableType.TEMPORARY
tables.A description of the type of a
Table
.An intermediate type for the construction of a partitioned
SQLDialect.ORACLE
OUTER JOIN
clause.An intermediate type for the construction of a partitioned
SQLDialect.ORACLE
OUTER JOIN
clause.A record originating from a single table
A record implementation for a record originating from a single table
Java class for TableType.
An exception that occurs with plain
SQL
templating.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
A
TransactionProvider
that implements thread-bound transaction
semantics.Java class for ThrowExceptions.
Deprecated.
- 3.15.0 - [#11505] - Use
Converter.ofNullable(Class, Class, Function, Function)
instead, e.g.Deprecated.
- 3.15.0 - [#11505] - Use
Converter.ofNullable(Class, Class, Function, Function)
instead, e.g.Too many rows (more than 1) were returned from a
ResultQuery
.A custom transaction object.
An
FunctionalInterface
that wraps transactional code.An
FunctionalInterface
that wraps transactional code for
reactive usage.An
FunctionalInterface
that wraps transactional code.A context object that is used to pass arguments to the various methods of
TransactionProvider
.The
TransactionListener
SPI is used to intercept the
TransactionProvider
's transaction events.A provider for
TransactionListener
instances.The
TransactionProvider
SPI can be used to implement custom
transaction
behaviour that is applied when calling
DSLContext.transactionResult(TransactionalCallable)
or
DSLContext.transaction(TransactionalRunnable)
.Java class for Transformation.
An SPI to provide SQL transformation configuration and behaviour.
Java class for TransformUnneededArithmeticExpressions.
An API for
QueryPart.$traverse(Traverser)
query part traversals.A set of
Traverser
constructor methods.Deprecated.
- 3.8.0 - [#4550] Do not reference this type directly.
A
Condition
that always yields true
.A step in the construction of the
TRUNCATE
statement.A step in the construction of the
TRUNCATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
A step in the construction of the
TRUNCATE
statement.A text formatting type, which can be used to configure text imports /
exports.
A marker interface for all query parts that have a
DataType
.The
unsigned byte
typeUDT definition.
A field contained in a UDT.
A common base type for UDT's
An object holding data of a UDT
A record implementation for a record originating from a single UDT
The
unsigned int
typeThe
unsigned long
typeA
UniqueKey
is an object representing a UNIQUE KEY
or a PRIMARY KEY
.A utility class for static access to unsigned number functionality.
A base type for unsigned numbers.
An unwrapper SPI that can be used to override the default unwrapping
algorithm.
A provider for the
Unwrapper
SPI which is used to override the
default behaviour when unwrapping JDBC types through
Wrapper.unwrap(Class)
.A common interface for records that can be stored back to the database again.
A record implementation for a record holding a primary key
An
UPDATE
statement.This type is used for the
Update
's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the
Update
's DSL API.This type is used for the
Update
's DSL API.This type is used for the
Update
's DSL API.An
UPDATE
statement (model API).This type is used for the
Update
's DSL API.This type is used for the
Update
's DSL API.This type is used for the
Update
's DSL API.This type is used for the
Update
's DSL API.This type is used for the
Update
's DSL API.Java class for UpdateUnchangedRecords.
This type is used for the
Update
's DSL API.A privilege for use in
GRANT
and REVOKE
statements.The
unsigned short
typeA local variable reference.
A version ID attached to a
Meta
description of a database.A directed, acyclic graph of
Version
objects.This type is used for the Oracle
VERSIONS
clause DSL API,
providing access to the flashback versions query clauses.Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11.0 - [#7375] - This type is part of jOOQ's internal API.
Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#10796] - This class will be removed, soon, no more
vendor specific DSL API will be added.
Java class for View complex type.
A context object for
QueryPart
traversal passed to registered
VisitListener
's.A listener for
QueryPart
traversal events.A provider for
VisitListener
instances.This type is used for the window function DSL API.
A window definition.
This type is used for the window function DSL API.
Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
This type is used for the window function DSL API.
A window specification.
An intermediate step in the construction of a
WindowSpecification
.Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.
An intermediate step in the construction of a
WindowSpecification
.An intermediate step in the construction of a
WindowSpecification
.An intermediate step in the construction of a
WindowSpecification
.An intermediate step in the construction of a
WindowSpecification
.Java class for WriteIfReadonly.
An XML wrapper type for XML data obtained from the database.
The SQL standard
ARRAY_AGG()
function.Interface to be implemented by JAXB annotated Java classes which are
serialized to XML using
XMLBuilder
.A type modelling XML attributes for use in
DSL.xmlelement(Name, XMLAttributes, Field...)
.Wrapper around a
StringBuilder
which can be used to serialize
a JAXB-annotated Java object graph to XML.A step in the construction of an
XMLEXISTS
predicate.An XML formatting type, which can be used to configure XML imports / exports.
The format of individual XML records.
A step in the construction of an
XMLQUERY
expression.A step in the construction of an
XMLTABLE
expression.A step in the construction of an
XMLTABLE
expression.A step in the construction of an
XMLTABLE
expression.A step in the construction of an
XMLTABLE
expression.A step in the construction of an
XMLTABLE
expression.A base class for
XML
to JAXB POJO conversion.An implementation for the SQL standard
INTERVAL YEAR TO MONTH
data type.