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 change set describing the exact migration path between the
Node.parents() versions and the Commit.version() represented by this
change.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 step in the construction of the
CREATE TYPE statement.A step in the construction of the
CREATE VIEW 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 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.verify() or
Commits.load(java.io.File), etc.A default implementation for a pooled
DataSource-oriented
ConnectionProviderA 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 implementation of the
PolicyProvider SPI, offering a way to
construct a PolicyProvider.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
DOMAINJava 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.A step in the construction of the
DROP 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 step in the construction of the
DROP 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 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.
Java class for FetchTriggerValuesAfterReturning.
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.
An alternative annotation to replace
Generated from the JDK, in order to
elevate scope to RetentionPolicy.RUNTIME, keeping an identical
structure.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.
The History of
Version elements as installed by previous
Migrations.This class is generated by jOOQ.
This class is generated by jOOQ.
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.An
InverseForeignKey is an inverse ForeignKey.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
null values in JSON objects or arrays.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 JooqLoggerAn 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.
A udt 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 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 relationship path.
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.A policy that applies row level security to a table.
A policy provider to provide a
Policy for a table's row level
security.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
JoinHint type.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.The
TRY CAST function.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
1A model type for a records with degree
10A model type for a records with degree
11A model type for a records with degree
12A model type for a records with degree
13A model type for a records with degree
14A model type for a records with degree
15A model type for a records with degree
16A model type for a records with degree
17A model type for a records with degree
18A model type for a records with degree
19A model type for a records with degree
2A model type for a records with degree
20A model type for a records with degree
21A model type for a records with degree
22A model type for a records with degree
3A model type for a records with degree
4A model type for a records with degree
5A model type for a records with degree
6A model type for a records with degree
7A model type for a records with degree
8A model type for a records with degree
9A 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
UpdatableRecords.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
SelectQueryA 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
SQLDialectDeprecated, 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.
A tag that is associated with a
Commit.Java class for TagType complex type.
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.A meta model of SQL
TRIGGER objects.Java class for Trigger complex type.
Java class for TriggerActionOrientation.
Java class for TriggerActionTiming.
The event type on which a trigger fires.
Java class for TriggerEventManipulation.
The execution scope of a trigger.
The time when which a trigger fires.
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.
An object representing a user defined type.
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
A field dereferenced from a UDT path.
A common base type for UDT path fields.
A field dereferenced from a UDT path.
A common base type for table fields that are also
UDTPathField.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.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.Java class for Warning.
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.A combined
YearToMonth / DayToSecond interval.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.