Module org.jooq
Package org.jooq
This package contains jOOQ's public API.
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. These interfaces are constructed mostly
through the DSL and DSLContext
classes, which hide implementation facts from the public API.
-
Interface Summary Interface Description AggregateFilterStep<T> The step in the specification of aggregate functions where the SQL:2003 standardFILTER clausecan be added.AggregateFunction<T> An aggregate function.AlterDatabaseFinalStep A step in the construction of theALTER DATABASEstatement.AlterDatabaseStep A step in the construction of theALTER DATABASEstatement.AlterDomainDropConstraintCascadeStep A step in the construction of theALTER DOMAINstatement.AlterDomainFinalStep A step in the construction of theALTER DOMAINstatement.AlterDomainRenameConstraintStep A step in the construction of theALTER DOMAINstatement.AlterDomainStep<T> A step in the construction of theALTER DOMAINstatement.AlterIndexFinalStep The final step in theALTER INDEXDSL.AlterIndexOnStep The step in theALTER INDEXwhere the table can be specified for the index.AlterIndexStep The step in theALTER INDEXwhere the action can be decided.AlterSchemaFinalStep A step in the construction of theALTER SCHEMAstatement.AlterSchemaStep A step in the construction of theALTER SCHEMAstatement.AlterSequenceFinalStep AQuerythat can alter sequences.AlterSequenceFlagsStep The step in theALTER SEQUENCEstatement where the flags of the sequence are modified or cleared.AlterSequenceStep<T extends Number> AQuerythat can alter sequences.AlterTableAddStep The step in theALTER TABLEDSL used toADDcolumns.AlterTableAlterConstraintStep The step in theALTER TABLEDSL used toALTERconstraints.AlterTableAlterStep<T> The step in theALTER TABLEDSL used toALTERcolumns.AlterTableDropStep The step in theALTER TABLEDSL used toDROPcolumns or constraints.AlterTableFinalStep The final step in theALTER TABLEDSL.AlterTableRenameColumnToStep The step in theALTER TABLEDSL used toRENAMEcolumns.AlterTableRenameConstraintToStep The step in theALTER TABLEDSL used toRENAMEconstraints.AlterTableRenameIndexToStep The step in theALTER TABLEDSL used toRENAMEindexes.AlterTableStep The step in theALTER TABLEstatement where the action can be decided.AlterTableUsingIndexStep The step in theALTER TABLE ..AlterTypeFinalStep AQuerythat can alter types.AlterTypeRenameValueToStep AQuerythat can alter types.AlterTypeStep AQuerythat can alter types.AlterViewFinalStep The final step in theALTER VIEWDSL.AlterViewStep The step in theALTER VIEWwhere the action can be decided.ArrayAggOrderByStep<T> The SQL standardARRAY_AGG()function.ArrayRecord<E> A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.Asterisk An unqualified asterisk.Attachable An object in jOOQ that can have an underlyingConfigurationattached or detached.Batch A wrapper for a JDBC batch operation.BatchBindStep This type is used for theBatch's DSL API.BatchedCallable<T> An operation that can run code and statements, buffering all consecutive and identical SQL strings in aBatchedPreparedStatement, delaying their execution.BatchedRunnable An operation that can run code and statements, buffering all consecutive and identical SQL strings in aBatchedPreparedStatement, delaying their execution.BetweenAndStep<T> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep1<T1> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep2<T1,T2> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep3<T1,T2,T3> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep4<T1,T2,T3,T4> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep5<T1,T2,T3,T4,T5> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep6<T1,T2,T3,T4,T5,T6> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStepN An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStepR<R extends Record> An intermediate DSL type for the construction of aBETWEENpredicate.BindContext The bind context is used for bindingQueryPart's and their contained values to aPreparedStatement's bind variables.Binding<T,U> An SPI (Service Provider Interface) that exposes all low-level interactions with JDBC bind variables.BindingGetResultSetContext<U> A container type forBinding.get(BindingGetResultSetContext)arguments.BindingGetSQLInputContext<U> A container type forBinding.get(BindingGetSQLInputContext)arguments.BindingGetStatementContext<U> A container type forBinding.get(BindingGetStatementContext)arguments.BindingRegisterContext<U> A container type forBinding.register(BindingRegisterContext)arguments.BindingSetSQLOutputContext<U> A container type forBinding.set(BindingSetSQLOutputContext)arguments.BindingSetStatementContext<U> A container type forBinding.set(BindingSetStatementContext)arguments.BindingSQLContext<U> A container type forBinding.sql(BindingSQLContext)arguments.Block A procedural block.Case The SQL case statement.CaseConditionStep<T> The final step in creating a case statement of the typeCaseValueStep<V> An intermediary step in creating a case statement of the typeCaseWhenStep<V,T> The final step in creating a case statement of the typeCatalog A catalog.CharacterSet A character set.CharsetProvider Check<R extends Record> A check constraint.CloseableDSLContext A resourcefulDSLContextthat should be closed in a try-with-resources statement.Collation A collation.Comment A comment.CommentOnFinalStep The final step for the creation of aCOMMENT ON [ object type ]statement.CommentOnIsStep The step in theCOMMENT ON [ object type ]statement where the comment can be specified.CommonTableExpression<R extends Record> A common table expression.Condition A condition or predicate.ConditionProvider Deprecated. - 2.6.0 [#1881] - This type will be removed from the public API, soon.Configuration AConfigurationconfigures aDSLContext, providing it with information for query rendering and execution.ConnectionCallable<T> An operation that can run code and statements against a provided JDBCConnection.ConnectionProvider A connection lifecycle handler API.ConnectionRunnable An operation that can run code and statements against a provided JDBCConnection.Constraint A DDL constraint.ConstraintEnforcementStep The step in theConstraintconstruction DSL API that allows for addingENFORCEDandNOT ENFORCEDclauses.ConstraintFinalStep The final step in theConstraintconstruction DSL API.ConstraintForeignKeyOnStep The step in theConstraintconstruction DSL API that allows for addingON DELETEandON UPDATEclauses.ConstraintForeignKeyReferencesStep1<T1> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep2<T1,T2> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.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 theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.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 theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep3<T1,T2,T3> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep4<T1,T2,T3,T4> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep5<T1,T2,T3,T4,T5> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep6<T1,T2,T3,T4,T5,T6> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep7<T1,T2,T3,T4,T5,T6,T7> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep8<T1,T2,T3,T4,T5,T6,T7,T8> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStepN The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintTypeStep The step in theConstraintconstruction DSL API that allows for specifying the constraint type.Context<C extends Context<C>> A context type that is used for rendering SQL or for binding.ContextTransactionalCallable<T> AnFunctionalInterfacethat wraps transactional code.ContextTransactionalRunnable AnFunctionalInterfacethat wraps transactional code.ContinueWhenStep A step in the construction of anCONTINUEstatement where aWHENclause can be added.Converter<T,U> AConverterfor data types.ConverterProvider CreateDatabaseFinalStep A step in the construction of theCREATE DATABASEstatement.CreateDomainAsStep A step in the construction of theCREATE DOMAINstatement.CreateDomainConstraintStep A step in the construction of theCREATE DOMAINstatement.CreateDomainDefaultStep<T> A step in the construction of theCREATE DOMAINstatement.CreateDomainFinalStep A step in the construction of theCREATE DOMAINstatement.CreateIndexFinalStep AQuerythat can create indexes.CreateIndexIncludeStep AQuerythat can create indexes.CreateIndexStep AQuerythat can create indexes.CreateIndexWhereStep AQuerythat can create indexes.CreateSchemaFinalStep A step in the construction of theCREATE SCHEMAstatement.CreateSequenceFinalStep A step in the construction of theCREATE SEQUENCEstatement.CreateSequenceFlagsStep A step in the construction of theCREATE SEQUENCEstatement.CreateTableAsStep<R extends Record> AQuerythat can create tables.CreateTableColumnStep AQuerythat can create tables.CreateTableCommentStep AQuerythat can create tables.CreateTableConstraintStep AQuerythat can create tables.CreateTableFinalStep AQuerythat can create tables.CreateTableIndexStep AQuerythat can create tables.CreateTableOnCommitStep AQuerythat can create tables.CreateTableStorageStep AQuerythat can create tables.CreateTableWithDataStep AQuerythat can create tables.CreateTypeFinalStep AQuerythat can create types.CreateTypeStep AQuerythat can create types.CreateViewAsStep<R extends Record> AQuerythat can create views.CreateViewFinalStep AQuerythat can create views.Cursor<R extends Record> Cursors allow for lazy, sequential access to an underlying JDBCResultSet.DAO<R extends TableRecord<R>,P,T> A generic DAO interface for a pojo and a primary key type.DataType<T> A common interface to all dialect-specific data types.DDLQuery A marker interface for all DDL queries.Declaration<T> A local variable declaration.Delete<R extends Record> ADELETEstatement.DeleteConditionStep<R extends Record> This type is used for theDelete's DSL API.DeleteFinalStep<R extends Record> This type is used for theDelete's DSL API.DeleteLimitStep<R extends Record> This type is used for theDelete's DSL API.DeleteOrderByStep<R extends Record> This type is used for theDelete's DSL API.DeleteQuery<R extends Record> ADELETEstatement (model API).DeleteResultStep<R extends Record> This type is used for theDelete's DSL API.DeleteReturningStep<R extends Record> This type is used for theDelete's DSL API.DeleteUsingStep<R extends Record> This type is used for theDelete's DSL API.DeleteWhereStep<R extends Record> This type is used for theDelete's DSL API.DerivedColumnList A derived column list.DerivedColumnList1 A derived column list.DerivedColumnList10 A derived column list.DerivedColumnList11 A derived column list.DerivedColumnList12 A derived column list.DerivedColumnList13 A derived column list.DerivedColumnList14 A derived column list.DerivedColumnList15 A derived column list.DerivedColumnList16 A derived column list.DerivedColumnList17 A derived column list.DerivedColumnList18 A derived column list.DerivedColumnList19 A derived column list.DerivedColumnList2 A derived column list.DerivedColumnList20 A derived column list.DerivedColumnList21 A derived column list.DerivedColumnList22 A derived column list.DerivedColumnList3 A derived column list.DerivedColumnList4 A derived column list.DerivedColumnList5 A derived column list.DerivedColumnList6 A derived column list.DerivedColumnList7 A derived column list.DerivedColumnList8 A derived column list.DerivedColumnList9 A derived column list.DiagnosticsContext A parameter object that is passed toDiagnosticsListenermethods.DiagnosticsListener A diagnostics listener.DiagnosticsListenerProvider A provider forTransactionListenerinstances.DivideByOnConditionStep An intermediate type for the construction of a relational division.DivideByOnStep An intermediate type for the construction of a relational divisionDivideByReturningStep An intermediate type for the construction of a relational divisionDomain<T> The meta model of a SQLDOMAINDropDatabaseFinalStep A step in the construction of theDROP DATABASEstatement.DropDomainCascadeStep A step in the construction of theDROP DOMAINstatement.DropDomainFinalStep A step in the construction of theDROP DOMAINstatement.DropIndexCascadeStep AQuerythat can drop indexes.DropIndexFinalStep AQuerythat can drop indexes.DropIndexOnStep AQuerythat can drop indexes.DropSchemaFinalStep A step in the construction of theDROP SCHEMAstatement.DropSchemaStep A step in the construction of theDROP SCHEMAstatement.DropSequenceFinalStep A step in the construction of theDROP SEQUENCEstatement.DropTableFinalStep The final step in theDROP TABLEDSL.DropTableStep The step in theDROP TABLEDSL used to specifyDROPbehaviour.DropTypeFinalStep AQuerythat can drop types.DropTypeStep AQuerythat can drop types.DropViewFinalStep The final step in theDROP VIEWDSL.DSLContext A contextual DSL providing "attached" implementations to theorg.jooqinterfaces.EmbeddableRecord<R extends EmbeddableRecord<R>> A record originating from a single tableEnumType A SQL enum type.ExecuteContext A context object forQueryexecution passed to registeredExecuteListener's.ExecuteEventHandler An event handler implementingExecuteListenerevents.ExecuteListener ExecuteListenerProvider A provider forExecuteListenerinstances.ExecutorProvider TheExecutorProviderSPI can be used to provide jOOQ with custom asynchronous execution behaviour.ExitWhenStep A step in the construction of anEXITstatement where aWHENclause can be added.Explain Results of anDSLContext.explain(Query)call.False AConditionthat always yieldsfalse.Field<T> A column expression.FieldLike An object that can behave like a field (a field-like object).FieldOrConstraint A common base type forFieldandConstraintwhere DSL API accepts both types alike.FieldOrRow FilePattern.Loader A callback interface that allows for loading aSource.ForByStep<T> The step in the creation of aFOR LOOPstatement where theBYclause can be supplied.ForeignKey<R extends Record,O extends Record> AForeignKeyis an object referencing aUniqueKey.ForInStep<T> The step in the creation of aFOR LOOPstatement where theINclause can be supplied.Formattable A type that can format its contents.FutureResult<R extends Record> Deprecated. - 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0GrantFinalStep A step in the construction of theGRANTstatement.GrantOnStep A step in the construction of theGRANTstatement.GrantToStep A step in the construction of theGRANTstatement.GrantWithGrantOptionStep A step in the construction of theGRANTstatement.GroupConcatOrderByStep MySQL'sGROUP_CONCATfunction.GroupConcatSeparatorStep MySQL'sGROUP_CONCATfunction.GroupField An expression to be used exclusively inGROUP BYclauses.Identity<R extends Record,T> AnIdentityis an object representing anIDENTITYcolumn as understood by the SQL:2003 standard.IfElseStep An intermediate step in building a proceduralIFstatement.IfThenStep An intermediate step in building a proceduralIFstatement.Index A DDL index definition.Insert<R extends Record> AnINSERTstatement.InsertFinalStep<R extends Record> This type is used for theInsert's DSL API.InsertOnConflictConditionStep<R extends Record> This type is used for theInsert's DSL API.InsertOnConflictDoUpdateStep<R extends Record> This type is used for theInsert's DSL API.InsertOnConflictWhereIndexPredicateStep<R extends Record> This type is used for theInsert's DSL API.InsertOnConflictWhereStep<R extends Record> This type is used for theInsert's DSL API.InsertOnDuplicateSetMoreStep<R extends Record> This type is used for theInsert's DSL API.InsertOnDuplicateSetStep<R extends Record> This type is used for theInsert's DSL API.InsertOnDuplicateStep<R extends Record> This type is used for theInsert's DSL API.InsertQuery<R extends Record> AnINSERTstatement (model API).InsertResultStep<R extends Record> This type is used for theInsert's DSL API.InsertReturningStep<R extends Record> This type is used for theInsert's DSL API.InsertSetMoreStep<R extends Record> This type is used for theInsert's alternative DSL API.InsertSetStep<R extends Record> This type is used for theInsert's alternative DSL API.InsertValuesStep1<R extends Record,T1> This type is used for theInsert's DSL API.InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for theInsert's DSL API.InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for theInsert's DSL API.InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for theInsert's DSL API.InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for theInsert's DSL API.InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for theInsert's DSL API.InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for theInsert's DSL API.InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for theInsert's DSL API.InsertValuesStep17<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 theInsert's DSL API.InsertValuesStep18<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 theInsert'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 theInsert's DSL API.InsertValuesStep2<R extends Record,T1,T2> This type is used for theInsert'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 theInsert'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 theInsert'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 theInsert's DSL API.InsertValuesStep3<R extends Record,T1,T2,T3> This type is used for theInsert's DSL API.InsertValuesStep4<R extends Record,T1,T2,T3,T4> This type is used for theInsert's DSL API.InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for theInsert's DSL API.InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for theInsert's DSL API.InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for theInsert's DSL API.InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for theInsert's DSL API.InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for theInsert's DSL API.InsertValuesStepN<R extends Record> This type is used for theInsert's DSL API.JSONArrayAggNullStep<T> A step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theNULLclause can be defined.JSONArrayAggOrderByStep<J> A step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theORDER BYclause can be defined.JSONArrayNullStep<T> A step in the construction ofDSL.jsonArray(Field...)orDSL.jsonbArray(Field...)functions where theNULLclause can be defined.JSONEntry<T> A JSON entry for JSON objects.JSONEntryValueStep A step in the creation ofJSONEntryvalues.JSONExistsOnStep A step in the construction ofDSL.jsonExists(Field, Field)orDSL.jsonbExists(Field, Field)functions where theON ERRORclause can be defined.JSONObjectAggNullStep<T> A step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theNULLclause can be defined.JSONObjectNullStep<T> A step in the construction ofDSL.jsonObject(JSONEntry...)orDSL.jsonbObject(JSONEntry...)functions where theNULLclause can be defined.JSONTableColumnForOrdinalityStep A step in the construction of anJSON_TABLEexpression.JSONTableColumnPathStep A step in the construction of anJSON_TABLEexpression.JSONTableColumnsFirstStep A step in the construction of anJSON_TABLEexpression.JSONTableColumnsStep A step in the construction of anJSON_TABLEexpression.JSONValueDefaultStep<J> A step in the construction ofDSL.jsonValue(Field, Field)orDSL.jsonbValue(Field, Field)functions where theON EMPTYandON ERRORclauses can be defined for default values.JSONValueOnStep<J> A step in the construction ofDSL.jsonValue(Field, Field)orDSL.jsonbValue(Field, Field)functions where theON EMPTYandON ERRORclauses can be defined.Key<R extends Record> AKeyis an object representing aUNIQUE KEY, aPRIMARY KEY, or aFOREIGN KEY.Keyword A SQL keyword.Label A label for use in procedural code.LikeEscapeStep A step in the creation of aLIKEpredicate to which anESCAPEclause can be appended.Link A database link reference.Loader<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderContext A context object that provides information about a loader's current state toLoaderRowListener.LoaderCSVOptionsStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderCSVStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderError An error that occurred during loading.LoaderFieldMapper LoaderFieldMapper.LoaderFieldContext The argument object forLoaderFieldMapper.map(LoaderFieldContext).LoaderJSONOptionsStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderJSONStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderListenerStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderLoadStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderOptionsStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderRowListener A listener forLoaderprogress.LoaderRowsStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderSourceStep<R extends Record> TheLoaderAPI is used for configuring data loads.LoaderXMLStep<R extends Record> TheLoaderAPI is used for configuring data loads.Log A common logger abstraction API for jOOQ's internal logging.LoopStep An intermediate step in building a proceduralLOOPstatement.Merge<R extends Record> AMERGEstatement.MergeFinalStep<R extends Record> This type is used for theMerge's DSL API.MergeKeyStep1<R extends Record,T1> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep2<R extends Record,T1,T2> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep3<R extends Record,T1,T2,T3> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep4<R extends Record,T1,T2,T3,T4> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStepN<R extends Record> This type is used for the H2-specific variant of theMerge's DSL API.MergeMatchedDeleteStep<R extends Record> This type is used for theMerge's DSL API.MergeMatchedSetMoreStep<R extends Record> This type is used for theMerge's DSL API.MergeMatchedSetStep<R extends Record> This type is used for theMerge's DSL API.MergeMatchedStep<R extends Record> This type is used for theMerge's DSL API.MergeMatchedThenStep<R extends Record> This type is used for theMerge's DSL API.MergeMatchedWhereStep<R extends Record> This type is used for theMerge's DSL API.MergeNotMatchedSetMoreStep<R extends Record> This type is used for theMerge's DSL API.MergeNotMatchedSetStep<R extends Record> This type is used for theMerge's DSL API.MergeNotMatchedStep<R extends Record> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep1<R extends Record,T1> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for theMerge'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 theMerge'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 theMerge'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 theMerge'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 theMerge's DSL API.MergeNotMatchedValuesStep2<R extends Record,T1,T2> This type is used for theMerge'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 theMerge'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 theMerge'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 theMerge's DSL API.MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for theMerge's DSL API.MergeNotMatchedValuesStepN<R extends Record> This type is used for theMerge's DSL API.MergeNotMatchedWhereStep<R extends Record> This type is used for theMerge's DSL API.MergeOnConditionStep<R extends Record> This type is used for theMerge's DSL API.MergeOnStep<R extends Record> This type is used for theMerge's DSL API.MergeUsingStep<R extends Record> This type is used for theMerge's DSL API.MergeValuesStep1<R extends Record,T1> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep2<R extends Record,T1,T2> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep3<R extends Record,T1,T2,T3> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep4<R extends Record,T1,T2,T3,T4> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStepN<R extends Record> This type is used for the H2-specific variant of theMerge's DSL API.Meta A wrapping object forDatabaseMetaDataor for other sources of database meta information (e.g.Meta.Predicate<Q extends QueryPart> A predicate to filter out query parts of a given type from meta data.MetaProvider An SPI that can produce dynamic catalog, schema, table meta data information.Migration An executable migration between twoVersioninstances.MigrationContext The context in which aMigrationis executed.MigrationListener A listener forMigrationlifecycles.MigrationListenerProvider A provider forMigrationListenerinstances.Name An identifier.Named A common base type for all qualifiable, named objects.OrderedAggregateFunction<T> An ordered-set aggregate function.OrderedAggregateFunctionOfDeferredType An ordered-set aggregate function.OrderField<T> AQueryPartto be used exclusively inORDER BYclauses.Package A container for stored procedures and functionsParam<T> A named parameter and/or bind value.Parameter<T> A parameter to a stored procedure or function.Parser This is experimental functionality.Period<T> A period specification for usage in temporal tables.PeriodSpecification PeriodSpecificationBetweenAndStep<T> PeriodSpecificationFromToStep<T> PivotForStep This type is used for the OraclePIVOTclause DSL API, pivotingTableobjects to new tables.PivotInStep<T> This type is used for the OraclePIVOTclause DSL API, pivotingTableobjects to new tables.Privilege A privilege for use inGRANTandREVOKEstatements.Qualified QualifiedAsterisk A qualified asterisk.QuantifiedSelect<R extends Record> A quantified select for use in quantified comparison predicates.Queries A wrapper for a collection of queries.Query Any query.QueryPart The common base type for all objects that can be used for query composition.QueryPartInternal Base functionality declaration for all query objectsRecord A database result record.Record1<T1> A model type for a records with degree1Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> A model type for a records with degree10Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> A model type for a records with degree11Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> A model type for a records with degree12Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> A model type for a records with degree13Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> A model type for a records with degree14Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> A model type for a records with degree15Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> A model type for a records with degree16Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> A model type for a records with degree17Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> A model type for a records with degree18Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> A model type for a records with degree19Record2<T1,T2> A model type for a records with degree2Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> A model type for a records with degree20Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> A model type for a records with degree21Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> A model type for a records with degree22Record3<T1,T2,T3> A model type for a records with degree3Record4<T1,T2,T3,T4> A model type for a records with degree4Record5<T1,T2,T3,T4,T5> A model type for a records with degree5Record6<T1,T2,T3,T4,T5,T6> A model type for a records with degree6Record7<T1,T2,T3,T4,T5,T6,T7> A model type for a records with degree7Record8<T1,T2,T3,T4,T5,T6,T7,T8> A model type for a records with degree8Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> A model type for a records with degree9RecordContext A context object forRecordmanipulation passed to registeredRecordListener's.RecordHandler<R extends Record> ARecordHandleris a handler that can receiveRecordobjects, when fetching data from the database.RecordListener A listener for manipulation events onUpdatableRecords.RecordListenerProvider A provider forRecordListenerinstances.RecordMapper<R extends Record,E> ARecordMapperis a mapper that can receiveRecordobjects, when fetching data from the database, transforming them into a custom type<E>.RecordMapperProvider A provider forRecordMapperinstances.RecordType<R extends Record> RecordUnmapper<E,R extends Record> ARecordUnmapperis a mapper that can receive user objects and convert them back toRecord.RecordUnmapperProvider A provider forRecordUnmapperinstances.RenderContext The render context is used for renderingQueryPart's to SQL.RepeatUntilStep An intermediate step in building a proceduralREPEATstatement.ResourceManagingScope A scope that can manage resources.Result<R extends Record> A wrapper for database results returned by.SelectQueryResultOrRows A type that contains either aResult, an update count, or an exception.ResultQuery<R extends Record> A query that can return results.Results A list ofResultand update counts that can be returned byResultQuery.fetchMany()calls and other calls that produce multiple cursors and update counts.RevokeFinalStep A step in the construction of theREVOKEstatement.RevokeFromStep A step in the construction of theREVOKEstatement.RevokeOnStep A step in the construction of theREVOKEstatement.Role A privilege for use inGRANTandREVOKEstatements.Routine<T> A routine is a callable object in your RDBMS.Row A row value expression.Row1<T1> A row value expression.Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> A row value expression.Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> A row value expression.Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> A row value expression.Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> A row value expression.Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> A row value expression.Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> A row value expression.Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> A row value expression.Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> A row value expression.Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> A row value expression.Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> A row value expression.Row2<T1,T2> A row value expression.Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> A row value expression.Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> A row value expression.Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> A row value expression.Row3<T1,T2,T3> A row value expression.Row4<T1,T2,T3,T4> A row value expression.Row5<T1,T2,T3,T4,T5> A row value expression.Row6<T1,T2,T3,T4,T5,T6> A row value expression.Row7<T1,T2,T3,T4,T5,T6,T7> A row value expression.Row8<T1,T2,T3,T4,T5,T6,T7,T8> A row value expression.Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> A row value expression.RowCountQuery Any query that is not aResultQuery, and thus possibly produces a row count as a result, instead of aResult.RowId A data type corresponding to JDBC'sTypes.ROWID.RowN A row value expression.Schema A schema.Scope Scope implementations provide access to a variety of objects that are available from a given scope.Select<R extends Record> ASELECTstatement.SelectConditionStep<R extends Record> SelectConnectByAfterStartWithConditionStep<R extends Record> SelectConnectByAfterStartWithStep<R extends Record> SelectConnectByConditionStep<R extends Record> SelectConnectByStep<R extends Record> SelectCorrelatedSubqueryStep<R extends Record> SelectDistinctOnStep<R extends Record> SelectField<T> AQueryPartto be used exclusively inSELECTclauses.SelectFieldOrAsterisk AQueryPartto be used exclusively inSELECTclauses.SelectFinalStep<R extends Record> SelectForJSONCommonDirectivesStep<R extends Record> SelectForJSONStep<R extends Record> SelectForStep<R extends Record> SelectForUpdateOfStep<R extends Record> SelectForUpdateStep<R extends Record> SelectForUpdateWaitStep<R extends Record> SelectForXMLCommonDirectivesStep<R extends Record> SelectForXMLPathDirectivesStep<R extends Record> SelectForXMLRawDirectivesStep<R extends Record> SelectForXMLStep<R extends Record> SelectFromStep<R extends Record> SelectGroupByStep<R extends Record> SelectHavingConditionStep<R extends Record> SelectHavingStep<R extends Record> SelectIntoStep<R extends Record> SelectJoinPartitionByStep<R extends Record> SelectJoinStep<R extends Record> SelectLimitAfterOffsetStep<R extends Record> SelectLimitPercentAfterOffsetStep<R extends Record> SelectLimitPercentStep<R extends Record> SelectLimitStep<R extends Record> SelectOffsetStep<R extends Record> SelectOnConditionStep<R extends Record> SelectOnStep<R extends Record> SelectOptionalOnStep<R extends Record> SelectOptionStep<R extends Record> SelectOrderByStep<R extends Record> SelectQualifyConditionStep<R extends Record> SelectQualifyStep<R extends Record> SelectQuery<R extends Record> ASELECTstatement (model API).SelectSeekLimitStep<R extends Record> SelectSeekStep1<R extends Record,T1> SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSeekStep2<R extends Record,T1,T2> 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> SelectSeekStep3<R extends Record,T1,T2,T3> SelectSeekStep4<R extends Record,T1,T2,T3,T4> SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5> SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6> SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSeekStepN<R extends Record> SelectSelectStep<R extends Record> SelectStartWithStep<R extends Record> SelectUnionStep<R extends Record> SelectWhereStep<R extends Record> SelectWindowStep<R extends Record> SelectWithTiesAfterOffsetStep<R extends Record> SelectWithTiesStep<R extends Record> Sequence<T extends Number> A sequence.SortField<T> A sort specification.SQL A plain SQLQueryPart.Statement A statement that can be placed inside of aBlock, but not executed on its own.StoreQuery<R extends Record> A query storing objects to the database.Table<R extends Record> A table.TableField<R extends Record,T> A field contained in a table.TableLike<R extends Record> An object that can behave like a table (a table-like object).TableOnConditionStep<R extends Record> An intermediate (optional) type for the construction of aJOINclause, where the join criteria is added using anONclause (with aCondition.TableOnStep<R extends Record> TableOptionalOnStep<R extends Record> TableOuterJoinStep<R extends Record> An intermediate type for the construction of a partitionedSQLDialect.ORACLEOUTER JOINclause.TablePartitionByStep<R extends Record> An intermediate type for the construction of a partitionedSQLDialect.ORACLEOUTER JOINclause.TableRecord<R extends TableRecord<R>> A record originating from a single tableTransaction A custom transaction object.TransactionalCallable<T> AnFunctionalInterfacethat wraps transactional code.TransactionalRunnable AnFunctionalInterfacethat wraps transactional code.TransactionContext A context object that is used to pass arguments to the various methods ofTransactionProvider.TransactionListener TheTransactionListenerSPI is used to intercept theTransactionProvider's transaction events.TransactionListenerProvider A provider forTransactionListenerinstances.TransactionProvider TheTransactionProviderSPI can be used to implement customtransactionbehaviour that is applied when callingDSLContext.transactionResult(TransactionalCallable)orDSLContext.transaction(TransactionalRunnable).True AConditionthat always yieldstrue.Truncate<R extends Record> ATRUNCATEstatement.TruncateCascadeStep<R extends Record> AQuerythat can truncate a table in the database.TruncateFinalStep<R extends Record> AQuerythat can truncate a table in the database.TruncateIdentityStep<R extends Record> AQuerythat can truncate a table in the database.Typed<T> A marker interface for all query parts that have aDataType.UDT<R extends UDTRecord<R>> UDT definition.UDTField<R extends UDTRecord<R>,T> A field contained in a UDT.UDTRecord<R extends UDTRecord<R>> An object holding data of a UDTUniqueKey<R extends Record> AUniqueKeyis an object representing aUNIQUE KEYor aPRIMARY KEY.Unwrapper An unwrapper SPI that can be used to override the default unwrapping algorithm.UnwrapperProvider A provider for theUnwrapperSPI which is used to override the default behaviour when unwrapping JDBC types throughWrapper.unwrap(Class).UpdatableRecord<R extends UpdatableRecord<R>> A common interface for records that can be stored back to the database again.Update<R extends Record> AnUPDATEstatement.UpdateConditionStep<R extends Record> This type is used for theUpdate's DSL API.UpdateFinalStep<R extends Record> This type is used for theUpdate's DSL API.UpdateFromStep<R extends Record> This type is used for theUpdate's DSL API.UpdateLimitStep<R extends Record> This type is used for theUpdate's DSL API.UpdateOrderByStep<R extends Record> This type is used for theUpdate's DSL API.UpdateQuery<R extends Record> AnUPDATEstatement (model API).UpdateResultStep<R extends Record> This type is used for theUpdate's DSL API.UpdateReturningStep<R extends Record> This type is used for theUpdate's DSL API.UpdateSetFirstStep<R extends Record> This type is used for theUpdate's DSL API.UpdateSetMoreStep<R extends Record> This type is used for theUpdate's DSL API.UpdateSetStep<R extends Record> This type is used for theUpdate's DSL API.UpdateWhereStep<R extends Record> This type is used for theUpdate's DSL API.User A privilege for use inGRANTandREVOKEstatements.Variable<T> A local variable reference.Version A version ID attached to aMetadescription of a database.VersionProvider An SPI that allows for providing a graph of versions.Versions A directed, acyclic graph ofVersionobjects.VersionsBetweenAndStep<R extends Record,T> This type is used for the OracleVERSIONSclause DSL API, providing access to the flashback versions query clauses.VisitContext A context object forQueryParttraversal passed to registeredVisitListener's.VisitListener A listener forQueryParttraversal events.VisitListenerProvider A provider forVisitListenerinstances.WindowBeforeOverStep<T> This type is used for the window function DSL API.WindowDefinition A window definition.WindowExcludeStep<T> This type is used for the window function DSL API.WindowFinalStep<T> This type is used for the window function DSL API.WindowFromFirstLastStep<T> This type is used for the window function DSL API.WindowIgnoreNullsStep<T> This type is used for the window function DSL API.WindowOrderByStep<T> This type is used for the window function DSL API.WindowOverStep<T> This type is used for the window function DSL API.WindowPartitionByStep<T> This type is used for the window function DSL API.WindowRowsAndStep<T> This type is used for the window function DSL API.WindowRowsStep<T> This type is used for the window function DSL API.WindowSpecification A window specification.WindowSpecificationExcludeStep An intermediate step in the construction of aWindowSpecification.WindowSpecificationFinalStep An intermediate step in the construction of aWindowSpecification.WindowSpecificationOrderByStep An intermediate step in the construction of aWindowSpecification.WindowSpecificationPartitionByStep An intermediate step in the construction of aWindowSpecification.WindowSpecificationRowsAndStep An intermediate step in the construction of aWindowSpecification.WindowSpecificationRowsStep An intermediate step in the construction of aWindowSpecification.WithAsStep WithAsStep1 WithAsStep10 WithAsStep11 WithAsStep12 WithAsStep13 WithAsStep14 WithAsStep15 WithAsStep16 WithAsStep17 WithAsStep18 WithAsStep19 WithAsStep2 WithAsStep20 WithAsStep21 WithAsStep22 WithAsStep3 WithAsStep4 WithAsStep5 WithAsStep6 WithAsStep7 WithAsStep8 WithAsStep9 WithStep XMLAggOrderByStep<T> The SQL standardARRAY_AGG()function.XMLAttributes A type modelling XML attributes for use inDSL.xmlelement(Name, XMLAttributes, Field...).XMLExistsPassingStep A step in the construction of anXMLEXISTSpredicate.XMLQueryPassingStep A step in the construction of anXMLQUERYexpression.XMLTableColumnForOrdinalityStep A step in the construction of anXMLTABLEexpression.XMLTableColumnPathStep A step in the construction of anXMLTABLEexpression.XMLTableColumnsFirstStep A step in the construction of anXMLTABLEexpression.XMLTableColumnsStep A step in the construction of anXMLTABLEexpression.XMLTablePassingStep A step in the construction of anXMLTABLEexpression. -
Class Summary Class Description ChartFormat Constants Some publicly available constants used in jOOQConverters<T,U> A chain of converters.CSVFormat A CSV formatting type, which can be used to configure CSV imports / exports.DDLExportConfiguration A configuration type for use with the variousMeta.ddl()methods.DiffCLI A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.DiffCLI.Args FilePattern A utility class that can traverse a directory structure given some ant-style file patterns, or classpath resources.JSON A JSON wrapper type for JSON data obtained from the database.JSONB A JSON wrapper type for JSONB data obtained from the database.JSONFormat A JSON formatting type, which can be used to configure JSON imports / exports.MigrationConfiguration A configuration type for use with the variousMeta.migrateTo(Meta)methods.ParserCLI A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.ParserCLI.Args SchemaMapping Deprecated. - 2.0.5 - Use runtime configurationSettingsinsteadSource A source of text data.TableOptions A description of various additionalTableoptions to describe the table runtime meta model.TXTFormat A CSV formatting type, which can be used to configure CSV imports / exports.XML An XML wrapper type for XML data obtained from the database.XMLFormat An XML formatting type, which can be used to configure XML imports / exports. -
Enum Summary Enum Description ChartFormat.Display ChartFormat.Output The chart output format.ChartFormat.Type Clause Deprecated. - 3.11.0 - [#7258] - This part of theVisitListenerSPI is deprecated.Comparator A comparator to be used in conditions to form comparison predicates.CSVFormat.Quote When to apply the quoteDatePart A date part can be used with SQL functions such as extract().DDLFlag ExecuteType The type of database interaction that is being executed with this context.FilePattern.Sort The sort algorithm to be applied to directory contents.JoinType The type of join.JSONFormat.RecordFormat The format of individual JSON records.Log.Level The log level.Name.Quoted A flag indicating whether the name is quoted or not.Nullability An enum that specifies the nullability of aDataType.Operator An operator used for combining conditionsParamMode The mode of aParam.RenderContext.CastMode The cast mode for bind values.SortOrder The sorting order used inORDER BYclauses.SQLDialect Dialects and dialect families as supported by jOOQ.TableOptions.OnCommit TheON COMMITflag forTableOptions.TableType.TEMPORARYtables.TableOptions.TableType A description of the type of aTable.XMLFormat.RecordFormat The format of individual XML records. -
Annotation Types Summary Annotation Type Description Allow Allow a set ofSQLDialectto be supported by any jOOQ statement in the scope of this annotation.Allow.PlainSQL This annotation allowsAllow.PlainSQLAPI usage within the scope of where it is placed.Internal Signifies that a API (public class, method or field) is internal and subject to incompatible changes, or even removal, in a future release.PlainSQL This annotation marks all methods and types that allow for producing aQueryPartthat generates "plain SQL" inside of an AST.Pro 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.Require Require a set ofSQLDialectto be supported by any jOOQ statement in the scope of this annotation.Support A formal declaration of whether any API element is supported by a givenSQLDialect