API diff between 3.9 and 3.11

See all diffs here

ObjectModification
org.jooq
AggregateFilterStep
filterWhere(Condition)added
AggregateFunction
keepDenseRankFirstOrderBy(OrderField...)contravariance
keepDenseRankFirstOrderBy(SortField...)removed
keepDenseRankLastOrderBy(OrderField...)contravariance
keepDenseRankLastOrderBy(SortField...)removed
AlterIndexOnStepadded
AlterIndexStep
renameTo(Index)added
AlterTableAlterStep
dropNotNull()added
setNotNull()added
AlterTableRenameIndexToStepadded
AlterTableStep
add(Collection)added
add(Field)added
add(FieldOrConstraint...)added
addColumn(Field)added
addColumnIfNotExists(Field)added
addColumnIfNotExists(String, DataType)added
addColumnIfNotExists(Field, DataType)added
addColumnIfNotExists(Name, DataType)added
addIfNotExists(Field)added
addIfNotExists(String, DataType)added
addIfNotExists(Field, DataType)added
addIfNotExists(Name, DataType)added
comment(String)added
comment(Comment)added
drop(String...)added
drop(Collection)added
drop(Field...)added
drop(Name...)added
dropColumnIfExists(String)added
dropColumnIfExists(Field)added
dropColumnIfExists(Name)added
dropColumns(String...)added
dropColumns(Collection)added
dropColumns(Field...)added
dropColumns(Name...)added
dropIfExists(String)added
dropIfExists(Field)added
dropIfExists(Name)added
renameIndex(String)added
renameIndex(Index)added
renameIndex(Name)added
AlterTableUsingIndexStep
usingIndex(Index)added
AlterViewStep
comment(String)added
comment(Comment)added
ArrayAggOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
ArrayRecord
getPackage()added
isSQLUsable()added
Asteriskadded
Attachable
configuration()added
AttachableInternalremoved
Binding
of(Converter, Consumer, Consumer, Consumer)added
Blockadded
Catalog
getName()pulled up
ChartFormatadded
ChartFormat.Displayadded
ChartFormat.Outputadded
ChartFormat.Typeadded
Clausedeprecated
ALTER_TABLE_ALTER_NULLadded
ALTER_TABLE_RENAME_INDEXadded
GRANTadded
GRANT_ONadded
GRANT_PRIVILEGEadded
GRANT_TOadded
PRIVILEGEadded
REVOKEadded
REVOKE_FROMadded
REVOKE_ONadded
REVOKE_PRIVILEGEadded
ROLEadded
USERadded
Collationadded
Commentadded
CommentOnFinalStepadded
CommentOnIsStepadded
Comparator
toKeyword()added
ConditionProvider
addConditions(Condition)added
addConditions(Operator, Condition)added
Configuration
clock()added
derive(Clock)added
derive(DiagnosticsListener...)added
derive(DiagnosticsListenerProvider...)added
derive(MetaProvider)added
derive(RecordUnmapper)added
derive(RecordUnmapperProvider)added
diagnosticsListenerProviders()added
dsl()added
metaProvider()added
recordUnmapperProvider()added
set(Clock)added
set(DiagnosticsListener...)added
set(DiagnosticsListenerProvider...)added
set(MetaProvider)added
set(RecordUnmapper)added
set(RecordUnmapperProvider)added
ConstraintForeignKeyReferencesStep1 - 22
references(String)added
references(Name)added
references(Table)added
references(Name, Name)added
ConstraintForeignKeyReferencesStepN
references(String)added
references(Name)added
references(Table)added
references(Name, Name...)added
ConstraintTypeStep
foreignKey(Name)added
foreignKey(Name...)added
foreignKey(Name, Name)added
foreignKey(Name, Name, Name)added
foreignKey(Name, Name, Name, Name) ... and more overloadsadded
primaryKey(Name...)added
unique(Name...)added
Context
keyword(String)deprecated
literal(String)deprecated
quote()added
quote(boolean)added
scopeEnd()added
scopeMarkEnd(QueryPart)added
scopeMarkStart(QueryPart)added
scopeRegister(QueryPart)added
scopeStart()added
CreateIndexIncludeStepadded
CreateIndexStep
on(String, Collection)added
on(Name, Collection)added
on(Name, Name...)added
on(Table, Collection)added
on(Table, OrderField...)contravariance
on(Table, SortField...)removed
CreateIndexWhereStep
where(Condition)added
CreateTableCommentStepadded
CreateTableIndexStepadded
CreateTableStorageStepadded
CreateTableWithDataStepadded
Cursor
collect(Collector)added
fetch(int)deprecated
fetchNext()added
fetchNext(int)added
fetchNext(RecordMapper)added
fetchNextInto(Class)added
fetchNextInto(RecordHandler)added
fetchNextInto(Table)added
fetchNextOptional()added
fetchNextOptional(RecordMapper)added
fetchNextOptionalInto(Class)added
fetchNextOptionalInto(Table)added
fetchOne()deprecated
fetchOne(RecordMapper)deprecated
fetchOneInto(Class)deprecated
fetchOneInto(RecordHandler)deprecated
fetchOneInto(Table)deprecated
fetchOptional()deprecated
fetchOptional(RecordMapper)deprecated
fetchOptionalInto(Class)deprecated
fetchOptionalInto(Table)deprecated
DDLFlag
COMMENTadded
DSLContext
alterIndex(Index)added
alterIndexIfExists(Index)added
begin(Collection)added
begin(Statement...)added
bindContext(PreparedStatement)deprecated
commentOnColumn(Field)added
commentOnColumn(Name)added
commentOnTable(String)added
commentOnTable(Name)added
commentOnTable(Table)added
commentOnView(String)added
commentOnView(Name)added
commentOnView(Table)added
createIndex()added
createIndex(Index)added
createIndexIfNotExists(Index)added
createOrReplaceView(String, String...)added
createOrReplaceView(String, BiFunction)added
createOrReplaceView(String, Function)added
createOrReplaceView(Name, BiFunction)added
createOrReplaceView(Name, Function)added
createOrReplaceView(Name, Name...)added
createOrReplaceView(Table, BiFunction)added
createOrReplaceView(Table, Function)added
createOrReplaceView(Table, Field...)added
createUniqueIndex()added
createUniqueIndex(Index)added
createUniqueIndexIfNotExists(Index)added
currval(Name)added
ddl(Collection)added
ddl(Table...)added
ddl(Collection, DDLFlag...)added
ddl(Table..., DDLFlag...)added
diagnosticsConnection()added
diagnosticsDataSource()added
dropIndex(Index)added
dropIndexIfExists(Index)added
dropTemporaryTable(String)added
dropTemporaryTable(Name)added
dropTemporaryTable(Table)added
explain(Query)added
fetchByExample(TableRecord)added
fetchSingle(String)added
fetchSingle(ResultSet)added
fetchSingle(ResultQuery)added
fetchSingle(SQL)added
fetchSingle(Table)added
fetchSingle(String, Object...)added
fetchSingle(String, QueryPart...)added
fetchSingle(ResultSet, Class...)added
fetchSingle(ResultSet, DataType...)added
fetchSingle(ResultSet, Field...)added
fetchSingle(Table, Condition)added
fetchValue(Field)added
fetchValue(Table)added
fetchValues(Table)added
grant(Collection)added
grant(Privilege)added
grant(Privilege...)added
meta(DatabaseMetaData)added
meta(Catalog...)added
meta(Schema...)added
meta(Table...)added
newRecord(Collection)added
newResult(Collection)added
nextval(Name)added
parsingConnection()added
parsingDataSource()added
queries(Collection)added
queries(Query...)added
renderContext()deprecated
revoke(Collection)added
revoke(Privilege)added
revoke(Privilege...)added
revokeGrantOptionFor(Collection)added
revokeGrantOptionFor(Privilege)added
revokeGrantOptionFor(Privilege...)added
select(SelectFieldOrAsterisk...)contravariance
selectDistinct(SelectFieldOrAsterisk...)contravariance
selectFrom(String)added
selectFrom(Name)added
selectFrom(SQL)added
selectFrom(String, Object...)added
selectFrom(String, QueryPart...)added
setCatalog(String)added
setCatalog(Catalog)added
setCatalog(Name)added
setSchema(String)added
setSchema(Name)added
setSchema(Schema)added
with(Name)added
with(Name, Name)added
with(Name, Name...)added
with(Name, Name, Name)added
with(Name, Name, Name, Name) ... and more overloadsadded
withRecursive(Name)added
withRecursive(Name, Name)added
withRecursive(Name, Name...)added
withRecursive(Name, Name, Name)added
withRecursive(Name, Name, Name, Name) ... and more overloadsadded
DataType
collation()added
collation(Collation)added
isEnum()added
nullability()added
nullability(Nullability)added
DatePart
CENTURYadded
DAY_OF_WEEKadded
DAY_OF_YEARadded
DECADEadded
EPOCHadded
MICROSECONDadded
MILLENNIUMadded
MILLISECONDadded
NANOSECONDadded
QUARTERadded
TIMEZONEadded
TIMEZONE_HOURadded
TIMEZONE_MINUTEadded
WEEKadded
toKeyword()added
DeleteQuery
addConditions(Condition)added
addConditions(Operator, Condition)added
setReturning(SelectFieldOrAsterisk...)contravariance
DeleteReturningStep
returning(SelectFieldOrAsterisk...)contravariance
returningResult(Collection)added
returningResult(SelectField)added
returningResult(SelectFieldOrAsterisk...)added
returningResult(SelectField, SelectField)added
returningResult(SelectField, SelectField, SelectField)added
returningResult(SelectField, SelectField, SelectField, SelectField) ... and more overloadsadded
DeleteWhereStep
where(Condition)added
DiagnosticsContextadded
DiagnosticsListeneradded
DiagnosticsListenerProvideradded
DivideByOnStep
on(Condition)added
ExecuteContext
serverOutput()added
serverOutput(String[])added
statementExecutionCount()added
Explainadded
Falseadded
Field
abs()deprecated
acos()deprecated
as(Name)added
asin()deprecated
atan()deprecated
atan2(Number)deprecated
atan2(Field)deprecated
avg()deprecated
avgOver()deprecated
ceil()deprecated
collate(String)added
collate(Collation)added
collate(Name)added
concat(char...)added
containsIgnoreCase(Object)added
containsIgnoreCase(Field)added
cos()deprecated
cosh()deprecated
cot()deprecated
coth()deprecated
count()deprecated
countDistinct()deprecated
countOver()deprecated
deg()deprecated
exp()deprecated
extract(DatePart)deprecated
firstValue()deprecated
floor()deprecated
greatest(Object...)deprecated
greatest(Field...)deprecated
lag()deprecated
lag(int)deprecated
lag(int, Object)deprecated
lag(int, Field)deprecated
lastValue()deprecated
lead()deprecated
lead(int)deprecated
lead(int, Object)deprecated
lead(int, Field)deprecated
least(Object...)deprecated
least(Field...)deprecated
ln()deprecated
log(int)deprecated
max()deprecated
maxOver()deprecated
median()deprecated
min()deprecated
minOver()deprecated
notContains(Object)added
notContains(Field)added
notContainsIgnoreCase(Object)added
notContainsIgnoreCase(Field)added
pow(Field)added
power(Field)added
rad()deprecated
rem(Number)added
rem(Field)added
round()deprecated
round(int)deprecated
sign()deprecated
sin()deprecated
sinh()deprecated
sortDefault()added
sqrt()deprecated
stddevPop()deprecated
stddevPopOver()deprecated
stddevSamp()deprecated
stddevSampOver()deprecated
sum()deprecated
sumOver()deprecated
tan()deprecated
tanh()deprecated
times(Number)added
times(Field)added
unaryMinus()added
unaryPlus()added
varPop()deprecated
varPopOver()deprecated
varSamp()deprecated
varSampOver()deprecated
FieldOrConstraintadded
Formattableadded
GrantFinalStepadded
GrantOnStepadded
GrantToStepadded
GrantWithGrantOptionStepadded
GroupConcatOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
Indexadded
InsertOnConflictConditionStepadded
InsertOnConflictWhereStepadded
InsertOnDuplicateStep
onConflictOnConstraint(Constraint)added
onConflictOnConstraint(Name)added
onConflictOnConstraint(UniqueKey)added
InsertQuery
addConditions(Collection)added
addConditions(Condition)added
addConditions(Condition...)added
addConditions(Operator, Collection)added
addConditions(Operator, Condition)added
addConditions(Operator, Condition...)added
onConflictOnConstraint(Constraint)added
onConflictOnConstraint(Name)added
onConflictOnConstraint(UniqueKey)added
setReturning(Field...)removed
setReturning(SelectFieldOrAsterisk...)added
InsertReturningStep
returning(SelectFieldOrAsterisk...)contravariance
returningResult(Collection)added
returningResult(SelectField)added
returningResult(SelectFieldOrAsterisk...)added
returningResult(SelectField, SelectField)added
returningResult(SelectField, SelectField, SelectField)added
returningResult(SelectField, SelectField, SelectField, SelectField) ... and more overloadsadded
JSONFormat
DEFAULT_FOR_RECORDSadded
DEFAULT_FOR_RESULTSadded
format()added
format(boolean)added
indent()added
indent(int)added
indentString(int)added
newline()added
newline(String)added
JoinType
qualified()added
toKeyword()added
MergeOnStep
on(Condition)added
Meta
getCatalog(String)added
getCatalog(Name)added
getSchemas(String)added
getSchemas(Name)added
getSequences(String)added
getSequences(Name)added
getTables(String)added
getTables(Name)added
MetaProvideradded
Name
append(String)added
append(Name)added
as()added
fields(Name)added
fields(Name...)added
fields(Name, Name)added
fields(Name, Name, Name)added
fields(Name, Name, Name, Name) ... and more overloadsadded
parts()added
qualifier()added
quotedName()added
unqualifiedName()added
unquotedName()added
Namedadded
Nullabilityadded
OrderFieldadded
OrderedAggregateFunction
withinGroupOrderBy(OrderField...)contravariance
withinGroupOrderBy(SortField...)removed
OrderedAggregateFunctionOfDeferredType
withinGroupOrderBy(OrderField)contravariance
withinGroupOrderBy(SortField)removed
Package
getName()pulled up
Parameter
getName()pulled up
Parser
parse(String, Object...)added
parseCondition(String, Object...)added
parseField(String, Object...)added
parseName(String, Object...)added
parseQuery(String, Object...)added
parseResultQuery(String)added
parseResultQuery(String, Object...)added
parseRow(String)added
parseRow(String, Object...)added
parseSelect(String)added
parseSelect(String, Object...)added
parseTable(String, Object...)added
ParserCLIadded
ParserCLI.Argsadded
Privilegeadded
QualifiedAsteriskadded
Queries
block()added
executeBatch()added
fetchMany()added
queryStream()added
stream()deprecated
Record
format()added
format(OutputStream)added
format(Writer)added
format(TXTFormat)added
format(OutputStream, TXTFormat)added
format(Writer, TXTFormat)added
formatJSON()added
formatJSON(OutputStream)added
formatJSON(Writer)added
formatJSON(JSONFormat)added
formatJSON(OutputStream, JSONFormat)added
formatJSON(Writer, JSONFormat)added
formatXML()added
formatXML(OutputStream)added
formatXML(Writer)added
formatXML(XMLFormat)added
formatXML(OutputStream, XMLFormat)added
formatXML(Writer, XMLFormat)added
Record1 - 22
component1()added
RecordUnmapperadded
RecordUnmapperProvideradded
Result
format()pulled up
format(int)pulled up
format(OutputStream)pulled up
format(Writer)pulled up
format(OutputStream, int)pulled up
format(Writer, int)pulled up
formatCSV()pulled up
formatCSV(boolean)pulled up
formatCSV(char)pulled up
formatCSV(OutputStream)pulled up
formatCSV(Writer)pulled up
formatCSV(CSVFormat)pulled up
formatCSV(boolean, char)pulled up
formatCSV(char, String)pulled up
formatCSV(OutputStream, boolean)pulled up
formatCSV(OutputStream, char)pulled up
formatCSV(OutputStream, CSVFormat)pulled up
formatCSV(Writer, boolean)pulled up
formatCSV(Writer, char)pulled up
formatCSV(Writer, CSVFormat)pulled up
formatCSV(boolean, char, String)pulled up
formatCSV(OutputStream, boolean, char)pulled up
formatCSV(OutputStream, char, String)pulled up
formatCSV(Writer, boolean, char)pulled up
formatCSV(Writer, char, String)pulled up
formatCSV(OutputStream, boolean, char, String)pulled up
formatCSV(Writer, boolean, char, String)pulled up
formatHTML()pulled up
formatHTML(OutputStream)pulled up
formatHTML(Writer)pulled up
formatInsert()pulled up
formatInsert(OutputStream)pulled up
formatInsert(Writer)pulled up
formatInsert(Table, Field...)pulled up
formatInsert(OutputStream, Table, Field...)pulled up
formatInsert(Writer, Table, Field...)pulled up
formatJSON()pulled up
formatJSON(OutputStream)pulled up
formatJSON(Writer)pulled up
formatJSON(JSONFormat)pulled up
formatJSON(OutputStream, JSONFormat)pulled up
formatJSON(Writer, JSONFormat)pulled up
formatXML()pulled up
formatXML(OutputStream)pulled up
formatXML(Writer)pulled up
intern(int...)deprecated
intern(String...)deprecated
intern(Field...)deprecated
intern(Name...)deprecated
intoGroups(int[], int[])added
intoGroups(String[], String[])added
intoGroups(Field[], Field[])added
intoGroups(Name[], Name[])added
intoGroups(Table, Table)added
intoMap(int[], int[])added
intoMap(String[], String[])added
intoMap(Field[], Field[])added
intoMap(Name[], Name[])added
intoMap(Table, Table)added
intoSet(RecordMapper)added
intoXML()pulled up
intoXML(ContentHandler)pulled up
ResultOrRows
exception()added
ResultQuery
collect(Collector)added
fetchGroups(int[], int[])added
fetchGroups(String[], String[])added
fetchGroups(Field[], Field[])added
fetchGroups(Name[], Name[])added
fetchGroups(Table, Table)added
fetchMap(int[], int[])added
fetchMap(String[], String[])added
fetchMap(Field[], Field[])added
fetchMap(Name[], Name[])added
fetchMap(Table, Table)added
fetchSet(RecordMapper)added
fetchSingle()added
fetchSingle(int)added
fetchSingle(String)added
fetchSingle(Field)added
fetchSingle(Name)added
fetchSingle(RecordMapper)added
fetchSingle(int, Class)added
fetchSingle(int, Converter)added
fetchSingle(String, Class)added
fetchSingle(String, Converter)added
fetchSingle(Field, Class)added
fetchSingle(Field, Converter)added
fetchSingle(Name, Class)added
fetchSingle(Name, Converter)added
fetchSingleArray()added
fetchSingleInto(Class)added
fetchSingleInto(Table)added
fetchSingleMap()added
fetchStreamInto(Class)added
fetchStreamInto(Table)added
forEach(Consumer)added
intern(int...)deprecated
intern(String...)deprecated
intern(Field...)deprecated
intern(Name...)deprecated
spliterator()added
RevokeFinalStepadded
RevokeFromStepadded
RevokeOnStepadded
Roleadded
Routine
getName()pulled up
Row1 - 22
isDistinctFrom(Object)added
isDistinctFrom(Field)added
isDistinctFrom(Record1)added
isDistinctFrom(Row1)added
isNotDistinctFrom(Object)added
isNotDistinctFrom(Field)added
isNotDistinctFrom(Record1)added
isNotDistinctFrom(Row1)added
RowN
isDistinctFrom(Object...)added
isDistinctFrom(Field...)added
isDistinctFrom(Record)added
isDistinctFrom(RowN)added
isNotDistinctFrom(Object...)added
isNotDistinctFrom(Field...)added
isNotDistinctFrom(Record)added
isNotDistinctFrom(RowN)added
SQLDialect
AURORA_MYSQLadded
AURORA_POSTGRESadded
DB2_11added
MYSQL_5_7added
MYSQL_8_0added
POSTGRES_10added
SQLDATAWAREHOUSEadded
SQLSERVER2016added
SQLSERVER2017added
TERADATAadded
Schema
getComment()added
getName()pulled up
Scope
dsl()added
SelectConnectByAfterStartWithConditionStepadded
SelectConnectByAfterStartWithStepadded
SelectConnectByStep
startWith(Boolean)added
startWith(String)added
startWith(Condition)added
startWith(Field)added
startWith(SQL)added
startWith(String, Object...)added
startWith(String, QueryPart...)added
SelectDistinctOnStep
distinctOn(SelectFieldOrAsterisk...)contravariance
on(SelectFieldOrAsterisk...)contravariance
SelectField
getName()pulled up
SelectFieldOrAsteriskadded
SelectHavingStep
having(Condition)added
SelectJoinStep
fullJoin(String)added
fullJoin(Name)added
fullJoin(SQL)added
fullJoin(TableLike)added
fullJoin(String, Object...)added
fullJoin(String, QueryPart...)added
SelectLimitPercentAfterOffsetStepadded
SelectLimitPercentStepadded
SelectOnStep
on(Condition)added
SelectOrderByStep
orderBy(OrderField)contravariance
orderBy(OrderField...)contravariance
orderBy(SortField)removed
orderBy(SortField...)removed
orderBy(OrderField, OrderField)contravariance
orderBy(SortField, SortField)removed
orderBy(OrderField, OrderField, OrderField)contravariance
orderBy(SortField, SortField, SortField)removed
orderBy(OrderField, OrderField, OrderField, OrderField) ... and more overloadscontravariance
orderBy(SortField, SortField, SortField, SortField) ... and more overloadsremoved
orderSiblingsBy(OrderField...)contravariance
orderSiblingsBy(SortField...)removed
SelectQuery
addConditions(Condition)added
addConditions(Operator, Condition)added
addDistinctOn(SelectFieldOrAsterisk...)contravariance
addHaving(Condition)added
addHaving(Operator, Condition)added
addJoin(TableLike, Condition)added
addJoin(TableLike, JoinType, Condition)added
addJoin(TableLike, JoinType, Condition, Field[])added
addOrderBy(OrderField...)contravariance
addOrderBy(SortField...)removed
addSeekBefore(Collection)deprecated
addSeekBefore(Field...)deprecated
addSelect(SelectFieldOrAsterisk...)contravariance
setLimitPercent(boolean)added
setWithTies(boolean)added
SelectSeekStep1 - 22
seekBefore(Object)deprecated
seekBefore(Field)deprecated
SelectSeekStepN
seekBefore(Object...)deprecated
seekBefore(Field...)deprecated
SelectSelectStep
select(SelectFieldOrAsterisk...)contravariance
SelectWhereStep
where(Condition)added
SelectWithTiesAfterOffsetStepadded
SelectWithTiesStepadded
Sequence
getName()pulled up
SortOrder
DEFAULTadded
toKeyword()added
Statementadded
StoreQuery
getResult()added
setReturning(Field...)removed
setReturning(SelectFieldOrAsterisk...)added
TXTFormatadded
Table
as(Name)added
as(Name, BiFunction)added
as(Name, Function)added
as(Name, Name...)added
asterisk()added
fullJoin(String)added
fullJoin(Name)added
fullJoin(SQL)added
fullJoin(TableLike)added
fullJoin(String, Object...)added
fullJoin(String, QueryPart...)added
getIndexes()added
getName()pulled up
partitionBy(Collection)added
partitionBy(Field...)added
TableOnStep
on(Condition)added
TableOuterJoinStepadded
TransactionContext
causeThrowable()added
causeThrowable(Throwable)added
Trueadded
UDT
getName()pulled up
isSynthetic()added
UpdateQuery
addConditions(Condition)added
addConditions(Operator, Condition)added
setReturning(Field...)removed
setReturning(SelectFieldOrAsterisk...)added
UpdateReturningStep
returning(SelectFieldOrAsterisk...)contravariance
returningResult(Collection)added
returningResult(SelectField)added
returningResult(SelectFieldOrAsterisk...)added
returningResult(SelectField, SelectField)added
returningResult(SelectField, SelectField, SelectField)added
returningResult(SelectField, SelectField, SelectField, SelectField) ... and more overloadsadded
UpdateWhereStep
where(Condition)added
Useradded
WindowFromFirstLastStepadded
WindowOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
WindowPartitionByStep
partitionBy(Collection)added
partitionByOne()deprecated
WindowSpecificationOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
WindowSpecificationPartitionByStep
partitionByOne()deprecated
WithStep
select(SelectFieldOrAsterisk...)contravariance
selectDistinct(SelectFieldOrAsterisk...)contravariance
selectFrom(String)added
selectFrom(Name)added
selectFrom(SQL)added
selectFrom(String, Object...)added
selectFrom(String, QueryPart...)added
with(Name)added
with(Name, Name)added
with(Name, Name...)added
with(Name, Name, Name)added
with(Name, Name, Name, Name) ... and more overloadsadded
XMLFormatadded
XMLFormat.RecordFormatadded
org.jooq.conf
ExecuteWithoutWhereadded
MappedSchema
equals(Object)added
hashCode()added
toString()added
MappedTable
equals(Object)added
hashCode()added
toString()added
MiniJAXBadded
ObjectFactory
createRenderFormatting()added
ParamCastModeadded
ParamType
FORCE_INDEXEDadded
ParseUnknownFunctionsadded
ParseUnsupportedSyntaxadded
ParseWithMetaLookupsadded
RenderFormattingadded
RenderKeywordStyle
PASCALadded
RenderMapping
equals(Object)added
hashCode()added
toString()added
Settings
equals(Object)added
getDelimiter()added
getExecuteDeleteWithoutWhere()added
getExecuteUpdateWithoutWhere()added
getFetchServerOutputSize()added
getInListPadBase()added
getParamCastMode()added
getParseUnknownFunctions()added
getParseUnsupportedSyntax()added
getParseWithMetaLookups()added
getRenderFormatting()added
getThrowExceptions()added
hashCode()added
isCacheRecordMappers()added
isEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly()added
isMapConstructorParameterNames()added
isRenderOrderByRownumberForEmulatedPagination()added
isReturnRecordToPojo()added
setCacheRecordMappers(Boolean)added
setDelimiter(String)added
setEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean)added
setExecuteDeleteWithoutWhere(ExecuteWithoutWhere)added
setExecuteUpdateWithoutWhere(ExecuteWithoutWhere)added
setFetchServerOutputSize(Integer)added
setInListPadBase(Integer)added
setMapConstructorParameterNames(Boolean)added
setParamCastMode(ParamCastMode)added
setParseUnknownFunctions(ParseUnknownFunctions)added
setParseUnsupportedSyntax(ParseUnsupportedSyntax)added
setParseWithMetaLookups(ParseWithMetaLookups)added
setRenderFormatting(RenderFormatting)added
setRenderOrderByRownumberForEmulatedPagination(Boolean)added
setReturnRecordToPojo(Boolean)added
setThrowExceptions(ThrowExceptions)added
toString()added
withCacheRecordMappers(Boolean)added
withDelimiter(String)added
withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean)added
withExecuteDeleteWithoutWhere(ExecuteWithoutWhere)added
withExecuteUpdateWithoutWhere(ExecuteWithoutWhere)added
withFetchServerOutputSize(Integer)added
withInListPadBase(Integer)added
withMapConstructorParameterNames(Boolean)added
withParamCastMode(ParamCastMode)added
withParseUnknownFunctions(ParseUnknownFunctions)added
withParseUnsupportedSyntax(ParseUnsupportedSyntax)added
withParseWithMetaLookups(ParseWithMetaLookups)added
withRenderFormatting(RenderFormatting)added
withRenderOrderByRownumberForEmulatedPagination(Boolean)added
withReturnRecordToPojo(Boolean)added
withThrowExceptions(ThrowExceptions)added
SettingsTools
getExecuteDeleteWithoutWhere(Settings)added
getExecuteUpdateWithoutWhere(Settings)added
getFetchServerOutputSize(int, Settings)added
ThrowExceptionsadded
org.jooq.exception
DataAccessException
getCause(Class)added
ExceptionToolsadded
NoDataFoundException
<init>()added
TooManyRowsException
<init>()added
org.jooq.impl
AbstractKeysdeprecated
createForeignKey(UniqueKey, Table, TableField...)added
createForeignKey(UniqueKey, Table, String, TableField...)added
createIdentity(Table, TableField)added
createIndex(String, Table, OrderField[], boolean)added
createUniqueKey(Table, TableField...)added
createUniqueKey(Table, String, TableField...)added
AbstractRoutine
getName()pulled up
ArrayRecordImpl
getPackage()added
isSQLUsable()added
CatalogImpl
<init>(Name)added
<init>(String, String)added
<init>(Name, Comment)added
getName()pulled up
CatalogMetaProvideradded
CustomField
as(String)removed
as(Name)added
DSL
alterIndex(Index)added
alterIndexIfExists(Index)added
and(Condition, Condition)added
arrayAggDistinct(Field)added
asterisk()added
begin(Collection)added
begin(Statement...)added
choose(int, Object...)added
choose(int, Field...)added
choose(Field, Object...)added
choose(Field, Field...)added
collation(String)added
collation(Name)added
comment(String)added
commentOnColumn(Field)added
commentOnColumn(Name)added
commentOnTable(String)added
commentOnTable(Name)added
commentOnTable(Table)added
commentOnView(String)added
commentOnView(Name)added
commentOnView(Table)added
condition(Operator, Condition, Condition)added
count(SelectFieldOrAsterisk)added
countDistinct(SelectFieldOrAsterisk)added
createIndex()added
createIndex(Index)added
createIndexIfNotExists(Index)added
createOrReplaceView(String, String...)added
createOrReplaceView(String, Function)added
createOrReplaceView(Name, Function)added
createOrReplaceView(Name, Name...)added
createOrReplaceView(Table, Function)added
createOrReplaceView(Table, Field...)added
createUniqueIndex()added
createUniqueIndex(Index)added
createUniqueIndexIfNotExists(Index)added
cumeDist(Collection)added
denseRank(Collection)added
dropIndex(Index)added
dropIndexIfExists(Index)added
dropTemporaryTable(String)added
dropTemporaryTable(Name)added
dropTemporaryTable(Table)added
field(Name, DataType, Comment)added
foreignKey(Name)added
foreignKey(Name...)added
foreignKey(Name, Name)added
foreignKey(Name, Name, Name)added
foreignKey(Name, Name, Name, Name) ... and more overloadsadded
generateSeries(int, int, int)added
generateSeries(int, int, Field)added
generateSeries(int, Field, int)added
generateSeries(int, Field, Field)added
generateSeries(Field, int, int)added
generateSeries(Field, int, Field)added
generateSeries(Field, Field, int)added
generateSeries(Field, Field, Field)added
getDataType(Class)deprecated
grant(Collection)added
grant(Privilege)added
grant(Privilege...)added
groupId()added
iif(Condition, Object, Object)added
iif(Condition, Object, Field)added
iif(Condition, Field, Object)added
iif(Condition, Field, Field)added
index(Name)added
localDateAdd(LocalDate, Number)added
localDateAdd(Field, Field)added
localDateAdd(LocalDate, Number, DatePart)added
localDateAdd(LocalDate, Field, DatePart)added
localDateAdd(Field, Number, DatePart)added
localDateAdd(Field, Field, DatePart)added
localDateDiff(LocalDate, LocalDate)added
localDateDiff(LocalDate, Field)added
localDateDiff(Field, LocalDate)added
localDateDiff(Field, Field)added
localDateSub(LocalDate, Number)added
localDateSub(Field, Field)added
localDateSub(LocalDate, Number, DatePart)added
localDateSub(LocalDate, Field, DatePart)added
localDateSub(Field, Number, DatePart)added
localDateSub(Field, Field, DatePart)added
localDateTimeAdd(LocalDateTime, Number)added
localDateTimeAdd(Field, Field)added
localDateTimeAdd(LocalDateTime, Number, DatePart)added
localDateTimeAdd(LocalDateTime, Field, DatePart)added
localDateTimeAdd(Field, Number, DatePart)added
localDateTimeAdd(Field, Field, DatePart)added
localDateTimeDiff(LocalDateTime, LocalDateTime)added
localDateTimeDiff(LocalDateTime, Field)added
localDateTimeDiff(Field, LocalDateTime)added
localDateTimeDiff(Field, Field)added
localDateTimeSub(LocalDateTime, Number)added
localDateTimeSub(Field, Field)added
localDateTimeSub(LocalDateTime, Number, DatePart)added
localDateTimeSub(LocalDateTime, Field, DatePart)added
localDateTimeSub(Field, Number, DatePart)added
localDateTimeSub(Field, Field, DatePart)added
name(String)added
name(Name...)added
noCondition()added
now()added
or(Condition, Condition)added
orderBy(OrderField...)contravariance
percentRank(Collection)added
primaryKey(Name...)added
privilege(String)added
quotedName(String)added
quotedName(String...)added
quotedName(Collection)added
rank(Collection)added
revoke(Collection)added
revoke(Privilege)added
revoke(Privilege...)added
revokeGrantOptionFor(Collection)added
revokeGrantOptionFor(Privilege)added
revokeGrantOptionFor(Privilege...)added
role(String)added
role(Name)added
select(SelectFieldOrAsterisk...)contravariance
selectDistinct(SelectFieldOrAsterisk...)contravariance
selectFrom(String)added
selectFrom(Name)added
selectFrom(SQL)added
selectFrom(String, Object...)added
selectFrom(String, QueryPart...)added
sequence(String)deprecated
sequence(String, Class)deprecated
sequence(String, DataType)deprecated
setCatalog(String)added
setCatalog(Catalog)added
setCatalog(Name)added
setSchema(String)added
setSchema(Name)added
setSchema(Schema)added
table(Collection)added
table(List)removed
table(Name, Comment)added
timestampSub(Timestamp, Number)added
timestampSub(Field, Field)added
timestampSub(Timestamp, Number, DatePart)added
timestampSub(Timestamp, Field, DatePart)added
timestampSub(Field, Number, DatePart)added
timestampSub(Field, Field, DatePart)added
translate(Field, String, String)added
translate(Field, Field, Field)added
unique(Name...)added
unnest(Collection)added
unnest(List)removed
unquotedName(String)added
unquotedName(String...)added
unquotedName(Collection)added
user(String)added
user(Name)added
widthBucket(Field, Number, Number, int)added
widthBucket(Field, Field, Field, Field) ... and more overloadsadded
with(Name)added
with(Name, Name)added
with(Name, Name...)added
with(Name, Name, Name)added
with(Name, Name, Name, Name) ... and more overloadsadded
withRecursive(Name)added
withRecursive(Name, Name)added
withRecursive(Name, Name...)added
withRecursive(Name, Name, Name)added
withRecursive(Name, Name, Name, Name) ... and more overloadsadded
DateToLocalDateConverteradded
DefaultBinding
<init>(Converter)deprecated
binding(Converter)added
DefaultConfiguration
clock()added
derive(Clock)added
derive(DiagnosticsListener...)added
derive(DiagnosticsListenerProvider...)added
derive(MetaProvider)added
derive(RecordUnmapper)added
derive(RecordUnmapperProvider)added
diagnosticsListenerProviders()added
dsl()added
metaProvider()added
recordUnmapperProvider()added
set(Clock)added
set(DiagnosticsListener...)added
set(DiagnosticsListenerProvider...)added
set(MetaProvider)added
set(RecordUnmapper)added
set(RecordUnmapperProvider)added
setClock(Clock)added
setDiagnosticsListener(DiagnosticsListener...)added
setDiagnosticsListenerProvider(DiagnosticsListenerProvider...)added
setExecuteListener(ExecuteListener...)added
setExecutor(Executor)added
setMetaProvider(MetaProvider)added
setRecordListener(RecordListener...)added
setRecordMapper(RecordMapper)added
setRecordUnmapper(RecordUnmapper)added
setRecordUnmapperProvider(RecordUnmapperProvider)added
setTransactionListener(TransactionListener...)added
setVisitListener(VisitListener...)added
DefaultDSLContext
alterIndex(Index)added
alterIndexIfExists(Index)added
begin(Collection)added
begin(Statement...)added
commentOnColumn(Field)added
commentOnColumn(Name)added
commentOnTable(String)added
commentOnTable(Name)added
commentOnTable(Table)added
commentOnView(String)added
commentOnView(Name)added
commentOnView(Table)added
createIndex()added
createIndex(Index)added
createIndexIfNotExists(Index)added
createOrReplaceView(String, String...)added
createOrReplaceView(String, BiFunction)added
createOrReplaceView(String, Function)added
createOrReplaceView(Name, BiFunction)added
createOrReplaceView(Name, Function)added
createOrReplaceView(Name, Name...)added
createOrReplaceView(Table, BiFunction)added
createOrReplaceView(Table, Function)added
createOrReplaceView(Table, Field...)added
createUniqueIndex()added
createUniqueIndex(Index)added
createUniqueIndexIfNotExists(Index)added
currval(Name)added
ddl(Collection)added
ddl(Table...)added
ddl(Collection, DDLFlag...)added
ddl(Table..., DDLFlag...)added
diagnosticsConnection()added
diagnosticsDataSource()added
dropIndex(Index)added
dropIndexIfExists(Index)added
dropTemporaryTable(String)added
dropTemporaryTable(Name)added
dropTemporaryTable(Table)added
explain(Query)added
fetchByExample(TableRecord)added
fetchSingle(String)added
fetchSingle(ResultSet)added
fetchSingle(ResultQuery)added
fetchSingle(SQL)added
fetchSingle(Table)added
fetchSingle(String, Object...)added
fetchSingle(String, QueryPart...)added
fetchSingle(ResultSet, Class...)added
fetchSingle(ResultSet, DataType...)added
fetchSingle(ResultSet, Field...)added
fetchSingle(Table, Condition)added
fetchValue(Field)added
fetchValue(Table)added
fetchValues(Table)added
grant(Collection)added
grant(Privilege)added
grant(Privilege...)added
meta(DatabaseMetaData)added
meta(Catalog...)added
meta(Schema...)added
meta(Table...)added
newRecord(Collection)added
newResult(Collection)added
nextval(Name)added
parsingConnection()added
parsingDataSource()added
queries(Collection)added
queries(Query...)added
revoke(Collection)added
revoke(Privilege)added
revoke(Privilege...)added
revokeGrantOptionFor(Collection)added
revokeGrantOptionFor(Privilege)added
revokeGrantOptionFor(Privilege...)added
select(SelectFieldOrAsterisk...)contravariance
selectDistinct(SelectFieldOrAsterisk...)contravariance
selectFrom(String)added
selectFrom(Name)added
selectFrom(SQL)added
selectFrom(String, Object...)added
selectFrom(String, QueryPart...)added
setCatalog(String)added
setCatalog(Catalog)added
setCatalog(Name)added
setSchema(String)added
setSchema(Name)added
setSchema(Schema)added
with(Name)added
with(Name, Name)added
with(Name, Name...)added
with(Name, Name, Name)added
with(Name, Name, Name, Name) ... and more overloadsadded
withRecursive(Name)added
withRecursive(Name, Name)added
withRecursive(Name, Name...)added
withRecursive(Name, Name, Name)added
withRecursive(Name, Name, Name, Name) ... and more overloadsadded
DefaultDataType
collation()added
collation(Collation)added
isEnum()added
nullability()added
nullability(Nullability)added
DefaultDiagnosticsListeneradded
DefaultDiagnosticsListenerProvideradded
DefaultMetaProvideradded
DefaultRecordMapper
<init>(RecordType, Class, Configuration)added
DefaultRecordUnmapperadded
DefaultRecordUnmapperProvideradded
DelegatingConverteradded
Iifadded
InformationSchemaMetaProvideradded
Internaladded
JPAConverteradded
NullIf
as(String)removed
as(Name)added
PackageImpl
getName()pulled up
ParserExceptionadded
SQLDataType
OFFSETDATETIME(int)added
OFFSETTIME(int)added
TIME(int)added
TIMESTAMP(int)added
TIMESTAMPWITHTIMEZONE(int)added
TIMEWITHTIMEZONE(int)added
SchemaImpl
<init>(Name)added
<init>(Name, Catalog)added
<init>(String, Catalog, String)added
<init>(Name, Catalog, Comment)added
getName()pulled up
SchemaMetaProvideradded
SequenceImpl
getName()pulled up
TableImpl
<init>(String)deprecated
<init>(Name)added
<init>(String, Schema)deprecated
<init>(Name, Schema)added
<init>(String, Schema, Table)deprecated
<init>(Name, Schema, Table)added
<init>(Table, ForeignKey, Table)added
<init>(String, Schema, Table, Field[])deprecated
<init>(Name, Schema, Table, Field[])added
<init>(String, Schema, Table, Field[], String)deprecated
<init>(Name, Schema, Table, Field[], String)added
<init>(Name, Schema, Table, Field[], Comment)added
<init>(Name, Schema, Table, ForeignKey, Table, Field[], Comment)added
as(Name)added
as(Name, Name...)added
getIndexes()added
partitionBy(Collection)added
partitionBy(Field...)added
rename(Name)added
TableMetaProvideradded
TimeToLocalTimeConverteradded
TimestampToLocalDateTimeConverteradded
UDTImpl
<init>(String, Schema, Package, boolean)added
getName()pulled up
isSynthetic()added
org.jooq.tools
Convert
convertCollection(Collection, Class)added
StringUtils
equals(String, String)added
org.jooq.tools.jdbc
DefaultCallableStatement
getDelegateCallableStatement()added
DefaultPreparedStatement
getDelegatePreparedStatement()added
DefaultResultSet
<init>(ResultSet, Statement)added
DefaultStatement
<init>(Statement, Connection)added
getDelegateStatement()added
MockConfiguration
clock()added
derive(Clock)added
derive(DiagnosticsListener...)added
derive(DiagnosticsListenerProvider...)added
derive(MetaProvider)added
derive(RecordUnmapper)added
derive(RecordUnmapperProvider)added
diagnosticsListenerProviders()added
dsl()added
metaProvider()added
recordUnmapperProvider()added
set(Clock)added
set(DiagnosticsListener...)added
set(DiagnosticsListenerProvider...)added
set(MetaProvider)added
set(RecordUnmapper)added
set(RecordUnmapperProvider)added
MockFileDatabase
queries()added
MockResult
<init>()added
<init>(int)added
MockResultSet
getObject(int, Class)added
getObject(String, Class)added
org.jooq.tools.reflect
Reflect
compile(String, String)added
initValue(Class)added
on(String, ClassLoader)added
org.jooq.types
DayToSecond
valueOf(Duration)added
UByte
MAXadded
MINadded
add(int)added
add(UByte)added
subtract(int)added
subtract(UByte)added
UInteger
MAXadded
MINadded
add(int)added
add(UInteger)added
subtract(int)added
subtract(UInteger)added
toBigInteger()added
ULong
MAXadded
MINadded
add(int)added
add(long)added
add(ULong)added
compare(long, long)added
subtract(int)added
subtract(long)added
subtract(ULong)added
UShort
MAXadded
MINadded
add(int)added
add(UShort)added
subtract(int)added
subtract(UShort)added
toBigInteger()added
org.jooq.util.auroramysql
AuroraMySQLDataTypeadded
org.jooq.util.aurorapostgres
AuroraPostgresDataTypeadded
org.jooq.util.h2
H2DataTypedeprecated
TIMESTAMPWITHTIMEZONEadded
org.jooq.util.hsqldb
HSQLDBDataTypedeprecated
UUIDadded
org.jooq.util.postgres
PostgresDSL
arrayOverlap(Object[], Object[])added
arrayOverlap(Object[], Field)added
arrayOverlap(Field, Object[])added
arrayOverlap(Field, Field)added
PostgresDataTypedeprecated
MONEYremoved
org.jooq.util.sqldatawarehouse
SQLDataWarehouseDataTypeadded
org.jooq.util.teradata
TeradataDataTypeadded
org.jooq.util.xml.jaxb
Catalogadded
Column
equals(Object)added
getComment()added
hashCode()added
setComment(String)added
toString()added
withComment(String)added
Indexadded
IndexColumnUsageadded
InformationSchema
equals(Object)added
getCatalogs()added
getIndexColumnUsages()added
getIndexes()added
getParameters()added
getRoutines()added
hashCode()added
setCatalogs(List)added
setIndexColumnUsages(List)added
setIndexes(List)added
setParameters(List)added
setRoutines(List)added
toString()added
withCatalogs(Collection)added
withCatalogs(List)added
withCatalogs(Catalog...)added
withIndexColumnUsages(Collection)added
withIndexColumnUsages(List)added
withIndexColumnUsages(IndexColumnUsage...)added
withIndexes(Collection)added
withIndexes(List)added
withIndexes(Index...)added
withParameters(Collection)added
withParameters(List)added
withParameters(Parameter...)added
withRoutines(Collection)added
withRoutines(List)added
withRoutines(Routine...)added
KeyColumnUsage
equals(Object)added
hashCode()added
toString()added
ObjectFactory
createCatalog()added
createIndex()added
createIndexColumnUsage()added
createParameter()added
createRoutine()added
Parameteradded
ParameterModeadded
ReferentialConstraint
equals(Object)added
hashCode()added
toString()added
Routineadded
RoutineTypeadded
Schema
equals(Object)added
getComment()added
hashCode()added
setComment(String)added
toString()added
withComment(String)added
Sequence
equals(Object)added
getComment()added
hashCode()added
setComment(String)added
toString()added
withComment(String)added
Table
equals(Object)added
getComment()added
hashCode()added
setComment(String)added
toString()added
withComment(String)added
TableConstraint
equals(Object)added
getComment()added
hashCode()added
setComment(String)added
toString()added
withComment(String)added

Legend

Eclipse icons copyright by Eclipse licensed under EPL. Inspiration taken from https://javaalmanac.io/
The jOOQ Logo