API diff between 3.6 and 3.10

See all diffs here

ObjectModification
org.jooq
AggregateFilterStep
filterWhere(Boolean)added
filterWhere(SQL)added
AggregateFunction
keepDenseRankFirstOrderBy(OrderField...)contravariance
keepDenseRankFirstOrderBy(SortField...)removed
keepDenseRankLastOrderBy(OrderField...)contravariance
keepDenseRankLastOrderBy(SortField...)removed
Allowadded
Allow.PlainSQLadded
AlterIndexFinalStepadded
AlterIndexStepadded
AlterSchemaFinalStepadded
AlterSchemaStepadded
AlterSequenceStepadded
AlterTableAlterStep
dropNotNull()added
setNotNull()added
AlterTableRenameColumnToStepadded
AlterTableRenameConstraintToStepadded
AlterTableRenameIndexToStepadded
AlterTableStep
add(Name, DataType)added
addColumn(Name, DataType)added
alter(Name)added
alterColumn(Name)added
drop(Name)added
dropColumn(Name)added
dropConstraint(Name)added
renameColumn(String)added
renameColumn(Field)added
renameColumn(Name)added
renameConstraint(String)added
renameConstraint(Constraint)added
renameConstraint(Name)added
renameIndex(String)added
renameIndex(Index)added
renameIndex(Name)added
renameTo(String)added
renameTo(Name)added
renameTo(Table)added
AlterTableUsingIndexStepadded
AlterViewFinalStepadded
AlterViewStepadded
ArrayAggOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
ArrayRecord
get()deprecated
getCatalog()added
getList()deprecated
getSchema()added
set(Object...)deprecated
set(Collection)deprecated
size()removed
Attachable
configuration()added
AttachableInternalremoved
Binding
of(Converter, Consumer, Consumer, Consumer)added
CSVFormatadded
CSVFormat.Quoteadded
CaseValueStep
mapFields(Map)added
mapValues(Map)added
CaseWhenStep
mapFields(Map)added
mapValues(Map)added
Catalog
getQualifiedName()added
getUnqualifiedName()added
schemaStream()added
ChartFormatadded
ChartFormat.Displayadded
ChartFormat.Outputadded
ChartFormat.Typeadded
Comparator
toKeyword()added
Condition
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
Configuration
clock()added
derive(Clock)added
derive(Executor)added
derive(ExecuteListener...)added
derive(ExecutorProvider)added
derive(RecordListener...)added
derive(RecordMapper)added
derive(RecordUnmapper)added
derive(RecordUnmapperProvider)added
derive(TransactionListener...)added
derive(TransactionListenerProvider...)added
derive(VisitListener...)added
dsl()added
executorProvider()added
recordUnmapperProvider()added
set(Clock)added
set(Executor)added
set(ExecuteListener...)added
set(ExecutorProvider)added
set(RecordListener...)added
set(RecordMapper)added
set(RecordUnmapper)added
set(RecordUnmapperProvider)added
set(TransactionListener...)added
set(TransactionListenerProvider...)added
set(VisitListener...)added
transactionListenerProviders()added
ConnectionCallableadded
ConnectionRunnableadded
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
declareAliases()added
declareAliases(boolean)added
keyword(String)deprecated
literal(String)deprecated
qualifyCatalog()added
qualifyCatalog(boolean)added
qualifySchema()added
qualifySchema(boolean)added
quote()added
quote(boolean)added
stringLiteral()added
stringLiteral(boolean)added
ContextTransactionalCallableadded
ContextTransactionalRunnableadded
Converter
andThen(Converter)added
inverse()added
of(Class, Class, Function, Function)added
ofNullable(Class, Class, Function, Function)added
CreateIndexStep
on(Name, Name...)added
on(Table, OrderField...)contravariance
CreateIndexWhereStepadded
CreateSchemaFinalStepadded
CreateTableAsStep
column(Field)added
column(Name, DataType)added
columns(Collection)added
columns(Field...)added
CreateTableColumnStep
column(Field)added
column(Name, DataType)added
columns(Collection)added
columns(Field...)added
CreateTableConstraintStepadded
Cursor
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()added
fetchOptional(RecordMapper)added
fetchOptionalInto(Class)added
fetchOptionalInto(Table)added
field(Name)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
stream()added
DAO
delete(Object)added
fetchOptional(Field, Object)added
DDLFlagadded
DSLContext
alterIndex(String)added
alterIndex(Index)added
alterIndex(Name)added
alterIndexIfExists(String)added
alterIndexIfExists(Index)added
alterIndexIfExists(Name)added
alterSchema(String)added
alterSchema(Name)added
alterSchema(Schema)added
alterSchemaIfExists(String)added
alterSchemaIfExists(Name)added
alterSchemaIfExists(Schema)added
alterSequenceIfExists(String)added
alterSequenceIfExists(Name)added
alterSequenceIfExists(Sequence)added
alterTableIfExists(String)added
alterTableIfExists(Name)added
alterTableIfExists(Table)added
alterView(String)added
alterView(Name)added
alterView(Table)added
alterViewIfExists(String)added
alterViewIfExists(Name)added
alterViewIfExists(Table)added
batch(Queries)added
bindContext(PreparedStatement)deprecated
close()added
connection(ConnectionRunnable)added
connectionResult(ConnectionCallable)added
createIndex(Index)added
createIndexIfNotExists(String)added
createIndexIfNotExists(Index)added
createIndexIfNotExists(Name)added
createSchema(String)added
createSchema(Name)added
createSchema(Schema)added
createSchemaIfNotExists(String)added
createSchemaIfNotExists(Name)added
createSchemaIfNotExists(Schema)added
createSequenceIfNotExists(String)added
createSequenceIfNotExists(Name)added
createSequenceIfNotExists(Sequence)added
createTableIfNotExists(String)added
createTableIfNotExists(Name)added
createTableIfNotExists(Table)added
createUniqueIndex(String)added
createUniqueIndex(Index)added
createUniqueIndex(Name)added
createUniqueIndexIfNotExists(String)added
createUniqueIndexIfNotExists(Index)added
createUniqueIndexIfNotExists(Name)added
createView(String, BiFunction)added
createView(String, Function)added
createView(Name, BiFunction)added
createView(Name, Function)added
createView(Table, BiFunction)added
createView(Table, Function)added
createViewIfNotExists(String, String...)added
createViewIfNotExists(String, BiFunction)added
createViewIfNotExists(String, Function)added
createViewIfNotExists(Name, BiFunction)added
createViewIfNotExists(Name, Function)added
createViewIfNotExists(Name, Name...)added
createViewIfNotExists(Table, BiFunction)added
createViewIfNotExists(Table, Function)added
createViewIfNotExists(Table, Field...)added
currval(Name)added
ddl(Catalog)added
ddl(Schema)added
ddl(Table)added
ddl(Catalog, DDLFlag...)added
ddl(Schema, DDLFlag...)added
ddl(Table, DDLFlag...)added
dropIndex(Index)added
dropIndexIfExists(Index)added
dropSchema(String)added
dropSchema(Name)added
dropSchema(Schema)added
dropSchemaIfExists(String)added
dropSchemaIfExists(Name)added
dropSchemaIfExists(Schema)added
execute(SQL)added
fetch(SQL)added
fetchAsync(String)added
fetchAsync(ResultSet)added
fetchAsync(ResultQuery)added
fetchAsync(SQL)added
fetchAsync(Table)added
fetchAsync(String, Object...)added
fetchAsync(String, QueryPart...)added
fetchAsync(ResultSet, Class...)added
fetchAsync(ResultSet, DataType...)added
fetchAsync(ResultSet, Field...)added
fetchAsync(Executor, String)added
fetchAsync(Executor, ResultSet)added
fetchAsync(Executor, ResultQuery)added
fetchAsync(Executor, SQL)added
fetchAsync(Executor, Table)added
fetchAsync(Table, Condition)added
fetchAsync(Executor, String, Object...)added
fetchAsync(Executor, String, QueryPart...)added
fetchAsync(Executor, ResultSet, Class...)added
fetchAsync(Executor, ResultSet, DataType...)added
fetchAsync(Executor, ResultSet, Field...)added
fetchAsync(Executor, Table, Condition)added
fetchByExample(TableRecord)added
fetchFromCSV(String, boolean)added
fetchFromCSV(String, boolean, char)added
fetchFromHTML(String)added
fetchFromStringData(List, boolean)added
fetchLazy(SQL)added
fetchMany(SQL)added
fetchOne(SQL)added
fetchOptional(String)added
fetchOptional(ResultSet)added
fetchOptional(ResultQuery)added
fetchOptional(SQL)added
fetchOptional(Table)added
fetchOptional(String, Object...)added
fetchOptional(String, QueryPart...)added
fetchOptional(ResultSet, Class...)added
fetchOptional(ResultSet, DataType...)added
fetchOptional(ResultSet, Field...)added
fetchOptional(Table, Condition)added
fetchOptionalValue(String)added
fetchOptionalValue(ResultSet)added
fetchOptionalValue(ResultQuery)added
fetchOptionalValue(SQL)added
fetchOptionalValue(TableField)added
fetchOptionalValue(String, Object...)added
fetchOptionalValue(String, QueryPart...)added
fetchOptionalValue(ResultSet, Class)added
fetchOptionalValue(ResultSet, DataType)added
fetchOptionalValue(ResultSet, Field)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
fetchStream(String)added
fetchStream(ResultSet)added
fetchStream(ResultQuery)added
fetchStream(SQL)added
fetchStream(Table)added
fetchStream(String, Object...)added
fetchStream(String, QueryPart...)added
fetchStream(ResultSet, Class...)added
fetchStream(ResultSet, DataType...)added
fetchStream(ResultSet, Field...)added
fetchStream(Table, Condition)added
fetchValue(SQL)added
fetchValue(TableField)added
fetchValues(SQL)added
informationSchema(Catalog)added
informationSchema(Catalog...)added
informationSchema(Schema)added
informationSchema(Schema...)added
informationSchema(Table)added
informationSchema(Table...)added
meta(InformationSchema)added
nextval(Name)added
parser()added
parsingConnection()added
queries(Collection)added
queries(Query...)added
query(SQL)added
renderContext()deprecated
resultQuery(SQL)added
setCatalog(String)added
setCatalog(Catalog)added
setCatalog(Name)added
setSchema(String)added
setSchema(Name)added
setSchema(Schema)added
transaction(ContextTransactionalRunnable)added
transactionAsync(TransactionalRunnable)added
transactionAsync(Executor, TransactionalRunnable)added
transactionResult(ContextTransactionalCallable)added
transactionResultAsync(TransactionalCallable)added
transactionResultAsync(Executor, TransactionalCallable)added
with(Name)added
with(String, String)added
with(String, BiFunction)added
with(String, Function)added
with(Name, Name)added
with(Name, Name...)added
with(String, String, String)added
with(Name, Name, Name)added
with(String, String, String, String) ... and more overloadsadded
with(Name, Name, Name, Name) ... and more overloadsadded
withRecursive(Name)added
withRecursive(String, String)added
withRecursive(String, BiFunction)added
withRecursive(String, Function)added
withRecursive(Name, Name)added
withRecursive(Name, Name...)added
withRecursive(String, String, String)added
withRecursive(Name, Name, Name)added
withRecursive(String, String, String, String) ... and more overloadsadded
withRecursive(Name, Name, Name, Name) ... and more overloadsadded
DataType
defaultValue()added
defaultValue(Object)added
defaultValue(Field)added
defaulted(boolean)deprecated
getSQLType(Configuration)added
identity()added
identity(boolean)added
isUDT()added
nullability()added
nullability(Nullability)added
DeleteConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
DeleteResultStep
fetchOptional()added
DeleteWhereStep
where(Boolean)added
where(SQL)added
DerivedColumnList1 - 22added
DivideByOnConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
DivideByOnStep
on(Boolean)added
on(SQL)added
DropSchemaFinalStepadded
DropSchemaStepadded
EnumType
getCatalog()added
ExecuteEventHandleradded
ExecutorProvideradded
Falseadded
Field
as(Function)added
as(Name)added
changed(Record)added
containsIgnoreCase(Object)added
containsIgnoreCase(Field)added
field(Record)added
from(Record)added
get(Record)added
getQualifiedName()added
getUnqualifiedName()added
getValue(Record)added
notContains(Object)added
notContains(Field)added
notContainsIgnoreCase(Object)added
notContainsIgnoreCase(Field)added
original(Record)added
pow(Field)added
power(Field)added
rem(Number)added
rem(Field)added
reset(Record)added
shl(Number)added
shl(Object)removed
shr(Number)added
shr(Object)removed
sortDefault()added
times(Number)added
times(Field)added
unaryMinus()added
unaryPlus()added
FieldLike
asField(Function)added
FieldOrRowadded
GroupConcatOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
Indexadded
InsertOnConflictConditionStepadded
InsertOnConflictDoUpdateStepadded
InsertOnConflictWhereStepadded
InsertOnDuplicateStep
onConflict(Collection)added
onConflict(Field...)added
onConflictDoNothing()added
InsertQuery
addConditions(Collection)added
addConditions(Condition...)added
addConditions(Operator, Collection)added
addConditions(Operator, Condition...)added
onConflict(Collection)added
onConflict(Field...)added
setSelect(Field[], Select)added
InsertResultStep
fetchOptional()added
JSONFormatadded
JSONFormat.RecordFormatadded
JoinType
qualified()added
toKeyword()added
Key
constraint()added
getName()added
LikeEscapeStepadded
Linkadded
LoaderCSVStep
fields(LoaderFieldMapper)added
LoaderFieldMapperadded
LoaderFieldMapper.LoaderFieldContextadded
LoaderJSONOptionsStep
ignoreRows(int)deprecated
LoaderJSONStep
fields(LoaderFieldMapper)added
LoaderRowsStepadded
LoaderSourceStep
loadArrays(Iterable)added
loadArrays(Object[]...)added
loadArrays(Iterator)added
loadArrays(Stream)added
loadRecords(Iterable)added
loadRecords(Iterator)added
loadRecords(Stream)added
loadRecords(Record...)added
Logadded
Log.Leveladded
MergeMatchedDeleteStep
deleteWhere(Boolean)added
MergeMatchedWhereStep
where(Boolean)added
MergeNotMatchedWhereStep
where(Boolean)added
MergeOnConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
MergeOnStep
on(Boolean)added
on(SQL)added
MergeUsingStep
columns(Collection)added
columns(Field)added
columns(Field...)added
columns(Field, Field)added
columns(Field, Field, Field)added
columns(Field, Field, Field, Field) ... and more overloadsadded
Meta
getSequences()added
Name
append(String)added
append(Name)added
equals(Object)added
equalsIgnoreCase(Name)added
fields(String)added
fields(BiFunction)added
fields(Function)added
fields(Name)added
fields(Name...)added
fields(String, String)added
fields(Name, Name)added
fields(String, String, String)added
fields(Name, Name, Name)added
fields(String, String, String, String) ... and more overloadsadded
fields(Name, Name, Name, Name) ... and more overloadsadded
first()added
last()added
parts()added
qualified()added
qualifier()added
quotedName()added
unqualifiedName()added
unquotedName()added
Nullabilityadded
Operator
toSQL()added
OrderFieldadded
OrderedAggregateFunction
withinGroupOrderBy(OrderField...)contravariance
withinGroupOrderBy(SortField...)removed
OrderedAggregateFunctionOfDeferredTypeadded
Package
getCatalog()added
Param
getParamMode()added
getParamType()added
setConverted(Object)deprecated
setInline(boolean)deprecated
setValue(Object)deprecated
ParamModeadded
Parameter
isUnnamed()added
Parseradded
Queriesadded
Query
executeAsync()added
executeAsync(Executor)added
QueryPartInternal
accept(Context)deprecated
generatesCast()added
Record
changed(Name)added
changed(Name, boolean)added
compareTo(Object)added
field(Name)added
fields(Name...)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
from(Object, Name...)added
fromArray(Object..., Name...)added
fromMap(Map, Name...)added
get(int)added
get(String)added
get(Field)added
get(Name)added
get(int, Class)added
get(int, Converter)added
get(String, Class)added
get(String, Converter)added
get(Field, Class)added
get(Field, Converter)added
get(Name, Class)added
get(Name, Converter)added
getValue(Name)added
getValue(Name, Class)added
getValue(Name, Converter)added
intoStream()added
original(Name)added
reset(Name)added
set(Field, Object)added
set(Field, Object, Converter)added
with(Field, Object)added
with(Field, Object, Converter)added
Record1 - 22
component1()added
fieldsRow()added
valuesRow()added
RecordType
dataType(Name)added
field(Name)added
field(Name, Class)added
field(Name, DataType)added
fields(Name...)added
indexOf(Name)added
type(Name)added
RecordUnmapperadded
RecordUnmapperProvideradded
RenderContext
castMode(RenderContext.CastMode)added
castModeSome(SQLDialect[])added
format(boolean)added
formatIndentEnd()added
formatIndentEnd(int)added
formatIndentLockEnd()added
formatIndentLockStart()added
formatIndentStart()added
formatIndentStart(int)added
formatNewLine()added
formatNewLineAfterPrintMargin()added
formatPrintMargin(int)added
formatSeparator()added
keyword(String)added
literal(String)added
paramType(ParamType)added
qualify(boolean)added
sql(char)added
sql(int)added
sql(String)added
sql(String, boolean)added
Requireadded
Result
field(Name)added
field(Name, Class)added
field(Name, DataType)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
formatCSV(boolean)added
formatCSV(CSVFormat)added
formatCSV(boolean, char)added
formatCSV(OutputStream, boolean)added
formatCSV(OutputStream, CSVFormat)added
formatCSV(Writer, boolean)added
formatCSV(Writer, CSVFormat)added
formatCSV(boolean, char, String)added
formatCSV(OutputStream, boolean, char)added
formatCSV(Writer, boolean, char)added
formatCSV(OutputStream, boolean, char, String)added
formatCSV(Writer, boolean, char, String)added
formatChart()added
formatChart(OutputStream)added
formatChart(Writer)added
formatChart(ChartFormat)added
formatChart(OutputStream, ChartFormat)added
formatChart(Writer, ChartFormat)added
formatJSON(JSONFormat)added
formatJSON(OutputStream, JSONFormat)added
formatJSON(Writer, JSONFormat)added
formatXML(XMLFormat)added
formatXML(OutputStream, XMLFormat)added
formatXML(Writer, XMLFormat)added
getValues(Name)added
getValues(Name, Class)added
getValues(Name, Converter)added
intern(int...)deprecated
intern(String...)deprecated
intern(Field...)deprecated
intern(Name...)added
intoArray(Name)added
intoArray(Name, Class)added
intoArray(Name, Converter)added
intoGroups(Class)added
intoGroups(Name)added
intoGroups(Name[])added
intoGroups(RecordMapper)added
intoGroups(int[], int[])added
intoGroups(Class, Class)added
intoGroups(Class, RecordMapper)added
intoGroups(String[], String[])added
intoGroups(Field[], Field[])added
intoGroups(Name, Class)added
intoGroups(Name, Name)added
intoGroups(Name, RecordMapper)added
intoGroups(Name[], Class)added
intoGroups(Name[], Name[])added
intoGroups(Name[], RecordMapper)added
intoGroups(RecordMapper, Class)added
intoGroups(RecordMapper, RecordMapper)added
intoGroups(Table, Table)added
intoMap(Class)added
intoMap(Name)added
intoMap(Name[])added
intoMap(RecordMapper)added
intoMap(int[], int[])added
intoMap(Class, Class)added
intoMap(Class, RecordMapper)added
intoMap(String[], String[])added
intoMap(Field[], Field[])added
intoMap(Name, Class)added
intoMap(Name, Name)added
intoMap(Name, RecordMapper)added
intoMap(Name[], Class)added
intoMap(Name[], Name[])added
intoMap(Name[], RecordMapper)added
intoMap(RecordMapper, Class)added
intoMap(RecordMapper, RecordMapper)added
intoMap(Table, Table)added
intoSet(Name)added
intoSet(Name, Class)added
intoSet(Name, Converter)added
intoXML(XMLFormat)added
intoXML(ContentHandler, XMLFormat)added
sortAsc(Name)added
sortAsc(Name, Comparator)added
sortDesc(Name)added
sortDesc(Name, Comparator)added
ResultOrRowsadded
ResultQuery
bind(int, Object)added
bind(String, Object)added
fetch(Name)added
fetch(Name, Class)added
fetch(Name, Converter)added
fetchAny(Name)added
fetchAny(RecordMapper)added
fetchAny(Name, Class)added
fetchAny(Name, Converter)added
fetchArray(Name)added
fetchArray(Name, Class)added
fetchArray(Name, Converter)added
fetchAsync()added
fetchAsync(Executor)added
fetchGroups(Class)added
fetchGroups(Name)added
fetchGroups(Name[])added
fetchGroups(RecordMapper)added
fetchGroups(int[], int[])added
fetchGroups(Class, Class)added
fetchGroups(Class, RecordMapper)added
fetchGroups(String[], String[])added
fetchGroups(Field[], Field[])added
fetchGroups(Name, Class)added
fetchGroups(Name, Name)added
fetchGroups(Name, RecordMapper)added
fetchGroups(Name[], Class)added
fetchGroups(Name[], Name[])added
fetchGroups(Name[], RecordMapper)added
fetchGroups(RecordMapper, Class)added
fetchGroups(RecordMapper, RecordMapper)added
fetchGroups(Table, Table)added
fetchMap(Class)added
fetchMap(Name)added
fetchMap(Name[])added
fetchMap(RecordMapper)added
fetchMap(int[], int[])added
fetchMap(Class, Class)added
fetchMap(Class, RecordMapper)added
fetchMap(String[], String[])added
fetchMap(Field[], Field[])added
fetchMap(Name, Class)added
fetchMap(Name, Name)added
fetchMap(Name, RecordMapper)added
fetchMap(Name[], Class)added
fetchMap(Name[], Name[])added
fetchMap(Name[], RecordMapper)added
fetchMap(RecordMapper, Class)added
fetchMap(RecordMapper, RecordMapper)added
fetchMap(Table, Table)added
fetchOne(Name)added
fetchOne(Name, Class)added
fetchOne(Name, Converter)added
fetchOptional()added
fetchOptional(int)added
fetchOptional(String)added
fetchOptional(Field)added
fetchOptional(Name)added
fetchOptional(RecordMapper)added
fetchOptional(int, Class)added
fetchOptional(int, Converter)added
fetchOptional(String, Class)added
fetchOptional(String, Converter)added
fetchOptional(Field, Class)added
fetchOptional(Field, Converter)added
fetchOptional(Name, Class)added
fetchOptional(Name, Converter)added
fetchOptionalArray()added
fetchOptionalInto(Class)added
fetchOptionalInto(Table)added
fetchOptionalMap()added
fetchSet(Name)added
fetchSet(Name, Class)added
fetchSet(Name, Converter)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
fetchStream()added
fetchStreamInto(Class)added
fetchStreamInto(Table)added
forEach(Consumer)added
intern(int...)deprecated
intern(String...)deprecated
intern(Field...)deprecated
intern(Name...)added
keepStatement(boolean)added
queryTimeout(int)added
spliterator()added
stream()added
Resultsadded
Routine
get(Parameter)added
getCatalog()added
set(Parameter, Object)added
Row
dataType(Name)added
field(Name)added
field(Name, Class)added
field(Name, DataType)added
fieldStream()added
fields(Name...)added
indexOf(Name)added
type(Name)added
SQLDialect
isFamily()added
supports(SQLDialect)added
thirdParty()added
SQLDialect.ThirdPartyadded
Schema
getCatalog()added
getQualifiedName()added
getUnqualifiedName()added
sequenceStream()added
tableStream()added
udtStream()added
SchemaMapping
map(Catalog)added
Scope
dsl()added
Select
exceptAll(Select)added
intersectAll(Select)added
SelectConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
SelectConnectByAfterStartWithConditionStepadded
SelectConnectByAfterStartWithStepadded
SelectConnectByConditionStep
and(Boolean)added
and(SQL)added
SelectConnectByStep
connectBy(Boolean)added
connectBy(SQL)added
connectByNoCycle(Boolean)added
connectByNoCycle(SQL)added
startWith(Boolean)added
startWith(String)added
startWith(Condition)added
startWith(Field)added
startWith(SQL)added
startWith(String, Object...)added
startWith(String, QueryPart...)added
SelectFromStep
from(Name)added
from(SQL)added
SelectHavingConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
SelectHavingStep
having(Boolean)added
having(SQL)added
SelectJoinStep
crossApply(Name)added
crossApply(SQL)added
crossJoin(Name)added
crossJoin(SQL)added
fullJoin(String)added
fullJoin(Name)added
fullJoin(SQL)added
fullJoin(TableLike)added
fullJoin(String, Object...)added
fullJoin(String, QueryPart...)added
fullOuterJoin(Name)added
fullOuterJoin(SQL)added
innerJoin(String)added
innerJoin(Name)added
innerJoin(SQL)added
innerJoin(TableLike)added
innerJoin(String, Object...)added
innerJoin(String, QueryPart...)added
join(Name)added
join(SQL)added
leftAntiJoin(TableLike)added
leftJoin(String)added
leftJoin(Name)added
leftJoin(SQL)added
leftJoin(TableLike)added
leftJoin(String, Object...)added
leftJoin(String, QueryPart...)added
leftOuterJoin(Name)added
leftOuterJoin(SQL)added
leftSemiJoin(TableLike)added
naturalJoin(Name)added
naturalJoin(SQL)added
naturalLeftOuterJoin(Name)added
naturalLeftOuterJoin(SQL)added
naturalRightOuterJoin(Name)added
naturalRightOuterJoin(SQL)added
outerApply(Name)added
outerApply(SQL)added
rightJoin(String)added
rightJoin(Name)added
rightJoin(SQL)added
rightJoin(TableLike)added
rightJoin(String, Object...)added
rightJoin(String, QueryPart...)added
rightOuterJoin(Name)added
rightOuterJoin(SQL)added
straightJoin(String)added
straightJoin(Name)added
straightJoin(SQL)added
straightJoin(TableLike)added
straightJoin(String, Object...)added
straightJoin(String, QueryPart...)added
SelectLimitAfterOffsetStepadded
SelectLimitStep
offset(int)added
offset(Param)added
SelectOnConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
SelectOnStep
on(Boolean)added
on(SQL)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
addOffset(int)added
addOffset(Param)added
addOrderBy(OrderField...)contravariance
addOrderBy(SortField...)removed
setWithTies(boolean)added
SelectStartWithStep
startWith(Boolean)added
startWith(SQL)added
SelectUnionStep
except(Select)added
exceptAll(Select)added
exceptAll(Select)added
intersect(Select)added
intersectAll(Select)added
intersectAll(Select)added
union(Select)added
unionAll(Select)added
SelectWhereStep
where(Boolean)added
where(SQL)added
SelectWithTiesAfterOffsetStepadded
SelectWithTiesStepadded
Sequence
getCatalog()added
SortOrder
toKeyword()added
Table
as(Name)added
as(Table)added
as(String, BiFunction)added
as(String, Function)added
as(Name, BiFunction)added
as(Name, Function)added
as(Name, Name...)added
as(Table, BiFunction)added
as(Table, Function)added
as(Table, Field...)added
at(String)added
at(Link)added
at(Name)added
crossApply(Name)added
crossApply(SQL)added
crossJoin(Name)added
crossJoin(SQL)added
eq(Table)added
equal(Table)added
equals(Object)added
from(Record)added
fullJoin(String)added
fullJoin(Name)added
fullJoin(SQL)added
fullJoin(TableLike)added
fullJoin(String, Object...)added
fullJoin(String, QueryPart...)added
fullOuterJoin(Name)added
fullOuterJoin(SQL)added
getCatalog()added
getDataType()added
getIndexes()added
getQualifiedName()added
getUnqualifiedName()added
innerJoin(String)added
innerJoin(Name)added
innerJoin(SQL)added
innerJoin(TableLike)added
innerJoin(String, Object...)added
innerJoin(String, QueryPart...)added
join(Name)added
join(SQL)added
leftAntiJoin(TableLike)added
leftJoin(String)added
leftJoin(Name)added
leftJoin(SQL)added
leftJoin(TableLike)added
leftJoin(String, Object...)added
leftJoin(String, QueryPart...)added
leftOuterJoin(Name)added
leftOuterJoin(SQL)added
leftSemiJoin(TableLike)added
naturalJoin(Name)added
naturalJoin(SQL)added
naturalLeftOuterJoin(Name)added
naturalLeftOuterJoin(SQL)added
naturalRightOuterJoin(Name)added
naturalRightOuterJoin(SQL)added
ne(Table)added
notEqual(Table)added
outerApply(Name)added
outerApply(SQL)added
partitionBy(Collection)added
partitionBy(Field...)added
rightJoin(String)added
rightJoin(Name)added
rightJoin(SQL)added
rightJoin(TableLike)added
rightJoin(String, Object...)added
rightJoin(String, QueryPart...)added
rightOuterJoin(Name)added
rightOuterJoin(SQL)added
straightJoin(String)added
straightJoin(Name)added
straightJoin(SQL)added
straightJoin(TableLike)added
straightJoin(String, Object...)added
straightJoin(String, QueryPart...)added
TableLike
asTable(String, BiFunction)added
asTable(String, Function)added
field(Name)added
field(Name, Class)added
field(Name, DataType)added
fieldStream()added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
TableOnConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
TableOnStep
on(Boolean)added
on(SQL)added
TableOuterJoinStepadded
TableRecord
insert(Collection)added
original()added
with(Field, Object)added
with(Field, Object)added
with(Field, Object, Converter)added
with(Field, Object, Converter)added
Templateremoved
TransactionContext
causeThrowable()added
causeThrowable(Throwable)added
TransactionListeneradded
TransactionListenerProvideradded
Trueadded
UDT
field(Name)added
fieldStream()added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
getCatalog()added
getPackage()added
isSQLUsable()added
isSynthetic()added
UDTRecord
with(Field, Object)added
with(Field, Object)added
with(Field, Object, Converter)added
with(Field, Object, Converter)added
UniqueKey
isPrimary()added
UpdatableRecord
insert(Collection)added
refresh(Collection)added
store(Collection)added
update(Collection)added
UpdateConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
UpdateFromStep
from(Name)added
from(SQL)added
UpdateQuery
addValues(RowN, RowN)added
addValues(RowN, Select)added
UpdateResultStep
fetchOptional()added
UpdateSetFirstStep
set(RowN, RowN)added
set(RowN, Select)added
UpdateWhereStep
where(Boolean)added
where(SQL)added
WindowOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
WindowPartitionByStep
partitionBy(Collection)added
partitionByOne()deprecated
WindowRowsStep
rangeBetweenCurrentRow()added
rangeBetweenFollowing(int)added
rangeBetweenPreceding(int)added
rangeBetweenUnboundedFollowing()added
rangeBetweenUnboundedPreceding()added
rangeCurrentRow()added
rangeFollowing(int)added
rangePreceding(int)added
rangeUnboundedFollowing()added
rangeUnboundedPreceding()added
WindowSpecificationOrderByStep
orderBy(OrderField...)contravariance
orderBy(SortField...)removed
WindowSpecificationPartitionByStep
partitionByOne()deprecated
WindowSpecificationRowsStep
rangeBetweenCurrentRow()added
rangeBetweenFollowing(int)added
rangeBetweenPreceding(int)added
rangeBetweenUnboundedFollowing()added
rangeBetweenUnboundedPreceding()added
rangeCurrentRow()added
rangeFollowing(int)added
rangePreceding(int)added
rangeUnboundedFollowing()added
rangeUnboundedPreceding()added
WithAsStep1 - 22added
WithStep
with(Name)added
with(String, String)added
with(String, BiFunction)added
with(String, Function)added
with(Name, Name)added
with(Name, Name...)added
with(String, String, String)added
with(Name, Name, Name)added
with(String, String, String, String) ... and more overloadsadded
with(Name, Name, Name, Name) ... and more overloadsadded
XMLFormatadded
XMLFormat.RecordFormatadded
org.jooq.conf
MappedSchema
getInputExpression()added
setInputExpression(Pattern)added
withInputExpression(Pattern)added
MappedTable
getInputExpression()added
setInputExpression(Pattern)added
withInputExpression(Pattern)added
ObjectFactory
createRenderFormatting()added
ParamCastModeadded
RegexAdapteradded
RenderFormattingadded
Settings
getDelimiter()added
getFetchSize()added
getMaxRows()added
getParamCastMode()added
getQueryTimeout()added
getRenderFormatting()added
getThrowExceptions()added
isDebugInfoOnStackTrace()added
isExecuteWithOptimisticLockingExcludeUnversioned()added
isInListPadding()added
isMapJPAAnnotations()added
isRenderCatalog()added
isRenderOrderByRownumberForEmulatedPagination()added
isReturnAllOnUpdatableRecord()added
isReturnRecordToPojo()added
setDebugInfoOnStackTrace(Boolean)added
setDelimiter(String)added
setExecuteWithOptimisticLockingExcludeUnversioned(Boolean)added
setFetchSize(Integer)added
setInListPadding(Boolean)added
setMapJPAAnnotations(Boolean)added
setMaxRows(Integer)added
setParamCastMode(ParamCastMode)added
setQueryTimeout(Integer)added
setRenderCatalog(Boolean)added
setRenderFormatting(RenderFormatting)added
setRenderOrderByRownumberForEmulatedPagination(Boolean)added
setReturnAllOnUpdatableRecord(Boolean)added
setReturnRecordToPojo(Boolean)added
setThrowExceptions(ThrowExceptions)added
withDebugInfoOnStackTrace(Boolean)added
withDelimiter(String)added
withExecuteWithOptimisticLockingExcludeUnversioned(Boolean)added
withFetchSize(Integer)added
withInListPadding(Boolean)added
withMapJPAAnnotations(Boolean)added
withMaxRows(Integer)added
withParamCastMode(ParamCastMode)added
withQueryTimeout(Integer)added
withRenderCatalog(Boolean)added
withRenderFormatting(RenderFormatting)added
withRenderOrderByRownumberForEmulatedPagination(Boolean)added
withReturnAllOnUpdatableRecord(Boolean)added
withReturnRecordToPojo(Boolean)added
withThrowExceptions(ThrowExceptions)added
SettingsTools
getFetchSize(int, Settings)added
getMaxRows(int, Settings)added
getQueryTimeout(int, Settings)added
ThrowExceptionsadded
org.jooq.exception
ConfigurationExceptionadded
DataAccessException
getCause(Class)added
getStackTrace()added
sqlState()added
sqlStateClass()added
sqlStateSubclass()added
MockFileDatabaseExceptionadded
NoDataFoundException
<init>()added
SQLStateClassadded
SQLStateSubclassadded
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
bind(BindContext)removed
generatesCast()added
get(Parameter)added
getCatalog()added
set(Parameter, Object)added
toSQL(RenderContext)removed
ArrayRecordImpl
add(Object)added
add(int, Object)added
addAll(Collection)added
addAll(int, Collection)added
clear()added
contains(Object)added
containsAll(Collection)added
get()deprecated
get(int)added
getCatalog()added
getList()deprecated
getSchema()added
indexOf(Object)added
isEmpty()added
lastIndexOf(Object)added
listIterator()added
listIterator(int)added
remove(int)added
remove(Object)added
removeAll(Collection)added
retainAll(Collection)added
set(Object...)deprecated
set(Collection)deprecated
set(int, Object)added
subList(int, int)added
toArray()added
toArray(Object[])added
CallbackExecuteListeneradded
CatalogImpl
<init>(Name)added
bind(BindContext)removed
generatesCast()added
getQualifiedName()added
getUnqualifiedName()added
schemaStream()added
toSQL(RenderContext)removed
CustomCondition
and(Boolean)added
bind(BindContext)removed
generatesCast()added
toSQL(RenderContext)removed
CustomField
as(String)removed
as(Name)added
bind(BindContext)removed
generatesCast()added
toSQL(RenderContext)removed
CustomQueryPart
bind(BindContext)removed
generatesCast()added
toSQL(RenderContext)removed
DAOImpl
delete(Object)added
fetchOptional(Field, Object)added
DSL
alterIndex(String)added
alterIndex(Index)added
alterIndex(Name)added
alterIndexIfExists(String)added
alterIndexIfExists(Index)added
alterIndexIfExists(Name)added
alterSchema(String)added
alterSchema(Name)added
alterSchema(Schema)added
alterSchemaIfExists(String)added
alterSchemaIfExists(Name)added
alterSchemaIfExists(Schema)added
alterSequenceIfExists(String)added
alterSequenceIfExists(Name)added
alterSequenceIfExists(Sequence)added
alterTableIfExists(String)added
alterTableIfExists(Name)added
alterTableIfExists(Table)added
alterView(String)added
alterView(Name)added
alterView(Table)added
alterViewIfExists(String)added
alterViewIfExists(Name)added
alterViewIfExists(Table)added
and(Condition, Condition)added
array(Object...)added
array(Collection)added
array(Field...)added
arrayAggDistinct(Field)added
boolAnd(Condition)added
boolAnd(Field)added
boolOr(Condition)added
boolOr(Field)added
catalog(Name)added
check(Condition)added
collect(Field, Class)added
collect(Field, DataType)added
collectDistinct(Field, Class)added
collectDistinct(Field, DataType)added
condition(Map)added
condition(Record)added
condition(SQL)added
condition(Operator, Condition, Condition)added
constraint()added
constraint(Name)added
createIndex(Index)added
createIndexIfNotExists(String)added
createIndexIfNotExists(Index)added
createIndexIfNotExists(Name)added
createSchema(String)added
createSchema(Name)added
createSchema(Schema)added
createSchemaIfNotExists(String)added
createSchemaIfNotExists(Name)added
createSchemaIfNotExists(Schema)added
createSequenceIfNotExists(String)added
createSequenceIfNotExists(Name)added
createSequenceIfNotExists(Sequence)added
createTableIfNotExists(String)added
createTableIfNotExists(Name)added
createTableIfNotExists(Table)added
createUniqueIndex(String)added
createUniqueIndex(Index)added
createUniqueIndex(Name)added
createUniqueIndexIfNotExists(String)added
createUniqueIndexIfNotExists(Index)added
createUniqueIndexIfNotExists(Name)added
createView(String, Function)added
createView(Name, Function)added
createView(Table, Function)added
createViewIfNotExists(String, String...)added
createViewIfNotExists(String, Function)added
createViewIfNotExists(Name, Function)added
createViewIfNotExists(Name, Name...)added
createViewIfNotExists(Table, Function)added
createViewIfNotExists(Table, Field...)added
cube(FieldOrRow...)added
cumeDist(Collection)added
currentLocalDate()added
currentLocalDateTime()added
currentLocalTime()added
currentOffsetDateTime()added
currentOffsetTime()added
currentSchema()added
day(Temporal)added
denseRank(Collection)added
dropIndex(Index)added
dropIndexIfExists(Index)added
dropSchema(String)added
dropSchema(Name)added
dropSchema(Schema)added
dropSchemaIfExists(String)added
dropSchemaIfExists(Name)added
dropSchemaIfExists(Schema)added
extract(Temporal, DatePart)added
field(Row1)pulled up
field(Row10)pulled up
field(Row11)pulled up
field(Row12)pulled up
field(Row13)pulled up
field(Row14)pulled up
field(Row15)pulled up
field(Row16)pulled up
field(Row17)pulled up
field(Row18)pulled up
field(Row19)pulled up
field(Row2)pulled up
field(Row20)pulled up
field(Row21)pulled up
field(Row22)pulled up
field(Row3)pulled up
field(Row4)pulled up
field(Row5)pulled up
field(Row6)pulled up
field(Row7)pulled up
field(Row8)pulled up
field(Row9)pulled up
field(SQL)added
field(SQL, Class)added
field(SQL, DataType)added
field(String, DataType, QueryPart...)added
foreignKey(String)added
foreignKey(String...)added
foreignKey(Field)added
foreignKey(Field...)added
foreignKey(Name)added
foreignKey(Name...)added
foreignKey(String, String)added
foreignKey(Field, Field)added
foreignKey(Name, Name)added
foreignKey(String, String, String)added
foreignKey(Field, Field, Field)added
foreignKey(Name, Name, Name)added
foreignKey(String, String, String, String) ... and more overloadsadded
foreignKey(Field, Field, Field, Field) ... and more overloadsadded
foreignKey(Name, Name, Name, Name) ... and more overloadsadded
groupId()added
hour(Temporal)added
ifnull(Object, Object)added
ifnull(Object, Field)added
ifnull(Field, Object)added
ifnull(Field, Field)added
index(Name)added
inline(boolean)added
inline(byte)added
inline(byte[])added
inline(double)added
inline(float)added
inline(int)added
inline(Boolean)added
inline(Byte)added
inline(Double)added
inline(Float)added
inline(Integer)added
inline(Long)added
inline(Short)added
inline(String)added
inline(BigDecimal)added
inline(BigInteger)added
inline(Date)added
inline(Time)added
inline(Timestamp)added
inline(LocalDate)added
inline(LocalDateTime)added
inline(LocalTime)added
inline(OffsetDateTime)added
inline(OffsetTime)added
inline(UUID)added
inline(long)added
inline(UByte)added
inline(UInteger)added
inline(ULong)added
inline(UShort)added
inline(short)added
link(String)added
link(Name)added
link(String, Schema)added
localDate(String)added
localDate(LocalDate)added
localDate(Field)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
localDateTime(String)added
localDateTime(LocalDateTime)added
localDateTime(Field)added
localTime(String)added
localTime(LocalTime)added
localTime(Field)added
minute(Temporal)added
mode()added
month(Temporal)added
name(String)added
name(Collection)added
name(Name...)added
not(Boolean)deprecated
now()added
nthValue(Field, int)added
nthValue(Field, Field)added
offsetDateTime(String)added
offsetDateTime(OffsetDateTime)added
offsetDateTime(Field)added
offsetTime(String)added
offsetTime(OffsetTime)added
offsetTime(Field)added
or(Condition, Condition)added
orderBy(OrderField...)contravariance
percentRank(Collection)added
position(String, String, int)added
position(String, String, Field)added
position(String, Field, int)added
position(String, Field, Field)added
position(Field, String, int)added
position(Field, String, Field)added
position(Field, Field, int)added
position(Field, Field, Field)added
primaryKey(String...)added
primaryKey(Field...)added
primaryKey(Name...)added
queries(Collection)added
queries(Query...)added
query(SQL)added
quotedName(String)added
quotedName(String...)added
quotedName(Collection)added
rangeBetweenCurrentRow()added
rangeBetweenFollowing(int)added
rangeBetweenPreceding(int)added
rangeBetweenUnboundedFollowing()added
rangeBetweenUnboundedPreceding()added
rangeCurrentRow()added
rangeFollowing(int)added
rangePreceding(int)added
rangeUnboundedFollowing()added
rangeUnboundedPreceding()added
rank(Collection)added
ratioToReport(Number)added
ratioToReport(Field)added
recordType(Collection)added
recordType(Field)added
recordType(Field[])added
recordType(Field, Field)added
recordType(Field, Field, Field)added
recordType(Field, Field, Field, Field) ... and more overloadsadded
resultQuery(SQL)added
rollup(FieldOrRow...)added
rowField(Row1)added
rowField(Row10)added
rowField(Row11)added
rowField(Row12)added
rowField(Row13)added
rowField(Row14)added
rowField(Row15)added
rowField(Row16)added
rowField(Row17)added
rowField(Row18)added
rowField(Row19)added
rowField(Row2)added
rowField(Row20)added
rowField(Row21)added
rowField(Row22)added
rowField(Row3)added
rowField(Row4)added
rowField(Row5)added
rowField(Row6)added
rowField(Row7)added
rowField(Row8)added
rowField(Row9)added
rowsFrom(Table...)added
second(Temporal)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(SQL)added
toDate(String, String)added
toDate(String, Field)added
toDate(Field, String)added
toDate(Field, Field)added
toLocalDate(String, String)added
toLocalDate(String, Field)added
toLocalDate(Field, String)added
toLocalDate(Field, Field)added
toLocalDateTime(String, String)added
toLocalDateTime(String, Field)added
toLocalDateTime(Field, String)added
toLocalDateTime(Field, Field)added
toTimestamp(String, String)added
toTimestamp(String, Field)added
toTimestamp(Field, String)added
toTimestamp(Field, Field)added
trunc(LocalDate)added
trunc(LocalDateTime)added
trunc(LocalDate, DatePart)added
trunc(LocalDateTime, DatePart)added
unique(String...)added
unique(Field...)added
unique(Name...)added
unquotedName(String)added
unquotedName(String...)added
unquotedName(Collection)added
val(boolean)added
val(byte)added
val(byte[])added
val(double)added
val(float)added
val(int)added
val(Boolean)added
val(Byte)added
val(Double)added
val(Float)added
val(Integer)added
val(Long)added
val(Short)added
val(String)added
val(BigDecimal)added
val(BigInteger)added
val(Date)added
val(Time)added
val(Timestamp)added
val(LocalDate)added
val(LocalDateTime)added
val(LocalTime)added
val(OffsetDateTime)added
val(OffsetTime)added
val(UUID)added
val(long)added
val(UByte)added
val(UInteger)added
val(ULong)added
val(UShort)added
val(short)added
value(boolean)added
value(byte)added
value(byte[])added
value(double)added
value(float)added
value(int)added
value(Boolean)added
value(Byte)added
value(Double)added
value(Float)added
value(Integer)added
value(Long)added
value(Short)added
value(String)added
value(BigDecimal)added
value(BigInteger)added
value(Date)added
value(Time)added
value(Timestamp)added
value(LocalDate)added
value(LocalDateTime)added
value(LocalTime)added
value(OffsetDateTime)added
value(OffsetTime)added
value(UUID)added
value(long)added
value(UByte)added
value(UInteger)added
value(ULong)added
value(UShort)added
value(short)added
widthBucket(Field, Number, Number, int)added
widthBucket(Field, Field, Field, Field) ... and more overloadsadded
with(Name)added
with(String, String)added
with(String, Function)added
with(Name, Name)added
with(Name, Name...)added
with(String, String, String)added
with(Name, Name, Name)added
with(String, String, String, String) ... and more overloadsadded
with(Name, Name, Name, Name) ... and more overloadsadded
withRecursive(Name)added
withRecursive(String, String)added
withRecursive(String, Function)added
withRecursive(Name, Name)added
withRecursive(Name, Name...)added
withRecursive(String, String, String)added
withRecursive(Name, Name, Name)added
withRecursive(String, String, String, String) ... and more overloadsadded
withRecursive(Name, Name, Name, Name) ... and more overloadsadded
year(Temporal)added
DefaultBinding
toString()added
DefaultConfiguration
clock()added
derive(Clock)added
derive(Executor)added
derive(ExecuteListener...)added
derive(ExecutorProvider)added
derive(RecordListener...)added
derive(RecordMapper)added
derive(RecordUnmapper)added
derive(RecordUnmapperProvider)added
derive(TransactionListener...)added
derive(TransactionListenerProvider...)added
derive(VisitListener...)added
dsl()added
executorProvider()added
recordUnmapperProvider()added
set(Clock)added
set(Executor)added
set(ExecuteListener...)added
set(ExecutorProvider)added
set(RecordListener...)added
set(RecordMapper)added
set(RecordUnmapper)added
set(RecordUnmapperProvider)added
set(TransactionListener...)added
set(TransactionListenerProvider...)added
set(VisitListener...)added
setExecutorProvider(ExecutorProvider)added
setRecordUnmapperProvider(RecordUnmapperProvider)added
setTransactionListenerProvider(TransactionListenerProvider...)added
transactionListenerProviders()added
DefaultConnectionProvider
isReadOnly()added
setReadOnly(boolean)added
DefaultConverterProvider
add(Converter)removed
toString()removed
DefaultDSLContext
alterIndex(String)added
alterIndex(Index)added
alterIndex(Name)added
alterIndexIfExists(String)added
alterIndexIfExists(Index)added
alterIndexIfExists(Name)added
alterSchema(String)added
alterSchema(Name)added
alterSchema(Schema)added
alterSchemaIfExists(String)added
alterSchemaIfExists(Name)added
alterSchemaIfExists(Schema)added
alterSequenceIfExists(String)added
alterSequenceIfExists(Name)added
alterSequenceIfExists(Sequence)added
alterTableIfExists(String)added
alterTableIfExists(Name)added
alterTableIfExists(Table)added
alterView(String)added
alterView(Name)added
alterView(Table)added
alterViewIfExists(String)added
alterViewIfExists(Name)added
alterViewIfExists(Table)added
batch(Queries)added
close()added
connection(ConnectionRunnable)added
connectionResult(ConnectionCallable)added
createIndex(Index)added
createIndexIfNotExists(String)added
createIndexIfNotExists(Index)added
createIndexIfNotExists(Name)added
createSchema(String)added
createSchema(Name)added
createSchema(Schema)added
createSchemaIfNotExists(String)added
createSchemaIfNotExists(Name)added
createSchemaIfNotExists(Schema)added
createSequenceIfNotExists(String)added
createSequenceIfNotExists(Name)added
createSequenceIfNotExists(Sequence)added
createTableIfNotExists(String)added
createTableIfNotExists(Name)added
createTableIfNotExists(Table)added
createUniqueIndex(String)added
createUniqueIndex(Index)added
createUniqueIndex(Name)added
createUniqueIndexIfNotExists(String)added
createUniqueIndexIfNotExists(Index)added
createUniqueIndexIfNotExists(Name)added
createView(String, BiFunction)added
createView(String, Function)added
createView(Name, BiFunction)added
createView(Name, Function)added
createView(Table, BiFunction)added
createView(Table, Function)added
createViewIfNotExists(String, String...)added
createViewIfNotExists(String, BiFunction)added
createViewIfNotExists(String, Function)added
createViewIfNotExists(Name, BiFunction)added
createViewIfNotExists(Name, Function)added
createViewIfNotExists(Name, Name...)added
createViewIfNotExists(Table, BiFunction)added
createViewIfNotExists(Table, Function)added
createViewIfNotExists(Table, Field...)added
currval(Name)added
ddl(Catalog)added
ddl(Schema)added
ddl(Table)added
ddl(Catalog, DDLFlag...)added
ddl(Schema, DDLFlag...)added
ddl(Table, DDLFlag...)added
dropIndex(Index)added
dropIndexIfExists(Index)added
dropSchema(String)added
dropSchema(Name)added
dropSchema(Schema)added
dropSchemaIfExists(String)added
dropSchemaIfExists(Name)added
dropSchemaIfExists(Schema)added
execute(SQL)added
fetch(SQL)added
fetchAsync(String)added
fetchAsync(ResultSet)added
fetchAsync(ResultQuery)added
fetchAsync(SQL)added
fetchAsync(Table)added
fetchAsync(String, Object...)added
fetchAsync(String, QueryPart...)added
fetchAsync(ResultSet, Class...)added
fetchAsync(ResultSet, DataType...)added
fetchAsync(ResultSet, Field...)added
fetchAsync(Executor, String)added
fetchAsync(Executor, ResultSet)added
fetchAsync(Executor, ResultQuery)added
fetchAsync(Executor, SQL)added
fetchAsync(Executor, Table)added
fetchAsync(Table, Condition)added
fetchAsync(Executor, String, Object...)added
fetchAsync(Executor, String, QueryPart...)added
fetchAsync(Executor, ResultSet, Class...)added
fetchAsync(Executor, ResultSet, DataType...)added
fetchAsync(Executor, ResultSet, Field...)added
fetchAsync(Executor, Table, Condition)added
fetchByExample(TableRecord)added
fetchFromCSV(String, boolean)added
fetchFromCSV(String, boolean, char)added
fetchFromHTML(String)added
fetchFromStringData(List, boolean)added
fetchLazy(SQL)added
fetchMany(SQL)added
fetchOne(SQL)added
fetchOptional(String)added
fetchOptional(ResultSet)added
fetchOptional(ResultQuery)added
fetchOptional(SQL)added
fetchOptional(Table)added
fetchOptional(String, Object...)added
fetchOptional(String, QueryPart...)added
fetchOptional(ResultSet, Class...)added
fetchOptional(ResultSet, DataType...)added
fetchOptional(ResultSet, Field...)added
fetchOptional(Table, Condition)added
fetchOptionalValue(String)added
fetchOptionalValue(ResultSet)added
fetchOptionalValue(ResultQuery)added
fetchOptionalValue(SQL)added
fetchOptionalValue(TableField)added
fetchOptionalValue(String, Object...)added
fetchOptionalValue(String, QueryPart...)added
fetchOptionalValue(ResultSet, Class)added
fetchOptionalValue(ResultSet, DataType)added
fetchOptionalValue(ResultSet, Field)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
fetchStream(String)added
fetchStream(ResultSet)added
fetchStream(ResultQuery)added
fetchStream(SQL)added
fetchStream(Table)added
fetchStream(String, Object...)added
fetchStream(String, QueryPart...)added
fetchStream(ResultSet, Class...)added
fetchStream(ResultSet, DataType...)added
fetchStream(ResultSet, Field...)added
fetchStream(Table, Condition)added
fetchValue(SQL)added
fetchValue(TableField)added
fetchValues(SQL)added
informationSchema(Catalog)added
informationSchema(Catalog...)added
informationSchema(Schema)added
informationSchema(Schema...)added
informationSchema(Table)added
informationSchema(Table...)added
meta(InformationSchema)added
nextval(Name)added
parser()added
parsingConnection()added
queries(Collection)added
queries(Query...)added
query(SQL)added
resultQuery(SQL)added
setCatalog(String)added
setCatalog(Catalog)added
setCatalog(Name)added
setSchema(String)added
setSchema(Name)added
setSchema(Schema)added
transaction(ContextTransactionalRunnable)added
transactionAsync(TransactionalRunnable)added
transactionAsync(Executor, TransactionalRunnable)added
transactionResult(ContextTransactionalCallable)added
transactionResultAsync(TransactionalCallable)added
transactionResultAsync(Executor, TransactionalCallable)added
with(Name)added
with(String, String)added
with(String, BiFunction)added
with(String, Function)added
with(Name, Name)added
with(Name, Name...)added
with(String, String, String)added
with(Name, Name, Name)added
with(String, String, String, String) ... and more overloadsadded
with(Name, Name, Name, Name) ... and more overloadsadded
withRecursive(Name)added
withRecursive(String, String)added
withRecursive(String, BiFunction)added
withRecursive(String, Function)added
withRecursive(Name, Name)added
withRecursive(Name, Name...)added
withRecursive(String, String, String)added
withRecursive(Name, Name, Name)added
withRecursive(String, String, String, String) ... and more overloadsadded
withRecursive(Name, Name, Name, Name) ... and more overloadsadded
DefaultDataType
defaultValue()added
defaultValue(Object)added
defaultValue(Field)added
defaulted(boolean)deprecated
getSQLType(Configuration)added
identity()added
identity(boolean)added
isUDT()added
nullability()added
nullability(Nullability)added
DefaultExecutoradded
DefaultExecutorProvideradded
DefaultRecordUnmapperadded
DefaultRecordUnmapperProvideradded
DefaultTransactionListeneradded
DefaultTransactionListenerProvideradded
DefaultTransactionProvider
<init>(ConnectionProvider, boolean)added
nested()added
DelegatingConverteradded
Internaladded
JPAConverteradded
KeywordImpl
bind(BindContext)removed
generatesCast()added
toSQL(RenderContext)removed
NullIf
as(String)removed
as(Name)added
bind(BindContext)removed
generatesCast()added
toSQL(RenderContext)removed
PackageImpl
bind(BindContext)removed
generatesCast()added
getCatalog()added
toSQL(RenderContext)removed
ParserExceptionadded
SQLDataType
BINARY(int)added
BLOB(int)added
CHAR(int)added
CLOB(int)added
DECIMAL(int)added
DECIMAL(int, int)added
LONGNVARCHAR(int)added
LONGVARBINARY(int)added
LONGVARCHAR(int)added
NCHAR(int)added
NCLOB(int)added
NUMERIC(int)added
NUMERIC(int, int)added
NVARCHAR(int)added
VARBINARY(int)added
VARCHAR(int)added
SchemaImpl
<init>(Name)added
<init>(String, Catalog)added
<init>(Name, Catalog)added
bind(BindContext)removed
generatesCast()added
getCatalog()added
getQualifiedName()added
getUnqualifiedName()added
sequenceStream()added
tableStream()added
toSQL(RenderContext)removed
udtStream()added
SequenceImpl
bind(BindContext)removed
generatesCast()added
getCatalog()added
toSQL(RenderContext)removed
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>(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
as(Name)added
as(Name, Name...)added
bind(BindContext)removed
generatesCast()added
getIndexes()added
getSchema()added
partitionBy(Collection)added
partitionBy(Field...)added
rename(String)added
rename(Name)added
toSQL(RenderContext)removed
TableRecordImpl
insert(Collection)added
with(Field, Object)added
with(Field, Object)added
with(Field, Object, Converter)added
with(Field, Object, Converter)added
ThreadLocalTransactionProvideradded
UDTImpl
<init>(String, Schema, Package)added
<init>(String, Schema, Package, boolean)added
bind(BindContext)removed
field(Name)added
fieldStream()added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
generatesCast()added
getCatalog()added
getPackage()added
isSQLUsable()added
isSynthetic()added
toSQL(RenderContext)removed
UDTRecordImpl
with(Field, Object)added
with(Field, Object)added
with(Field, Object, Converter)added
with(Field, Object, Converter)added
UpdatableRecordImpl
refresh(Collection)added
store(Collection)added
update(Collection)added
org.jooq.tools
Convert
convertCollection(Collection, Class)added
JooqLogger
globalThreshold(Log.Level)added
globalThreshold(JooqLogger.Level)added
JooqLogger.Leveladded
LoggerListener
exception(ExecuteContext)added
StopWatch
splitDebug(String, long)added
splitInfo(String, long)added
splitTrace(String, long)added
splitWarn(String)added
splitWarn(String, long)added
StringUtils
equals(String, String)added
org.jooq.tools.jdbc
DefaultCallableStatement
getDelegateCallableStatement()added
getObject(int, Class)added
getObject(String, Class)added
registerOutParameter(int, SQLType)added
registerOutParameter(String, SQLType)added
registerOutParameter(int, SQLType, int)added
registerOutParameter(int, SQLType, String)added
registerOutParameter(String, SQLType, int)added
registerOutParameter(String, SQLType, String)added
setObject(String, Object, SQLType)added
setObject(String, Object, SQLType, int)added
DefaultConnection
abort(Executor)added
getNetworkTimeout()added
getSchema()added
setNetworkTimeout(Executor, int)added
setSchema(String)added
DefaultPreparedStatement
executeLargeUpdate()added
getDelegatePreparedStatement()added
setObject(int, Object, SQLType)added
setObject(int, Object, SQLType, int)added
DefaultResultSet
<init>(ResultSet, Statement)added
getObject(int, Class)added
getObject(String, Class)added
updateObject(int, Object, SQLType)added
updateObject(String, Object, SQLType)added
updateObject(int, Object, SQLType, int)added
updateObject(String, Object, SQLType, int)added
DefaultStatement
<init>(Statement, Connection)added
closeOnCompletion()added
executeLargeBatch()added
executeLargeUpdate(String)added
executeLargeUpdate(String, int)added
executeLargeUpdate(String, int[])added
executeLargeUpdate(String, String[])added
getDelegateStatement()added
getLargeMaxRows()added
getLargeUpdateCount()added
isCloseOnCompletion()added
setLargeMaxRows(long)added
Mockadded
MockConfiguration
clock()added
derive(Clock)added
derive(Executor)added
derive(ExecuteListener...)added
derive(ExecutorProvider)added
derive(RecordListener...)added
derive(RecordMapper)added
derive(RecordUnmapper)added
derive(RecordUnmapperProvider)added
derive(TransactionListener...)added
derive(TransactionListenerProvider...)added
derive(VisitListener...)added
dsl()added
executorProvider()added
recordUnmapperProvider()added
set(Clock)added
set(Executor)added
set(ExecuteListener...)added
set(ExecutorProvider)added
set(RecordListener...)added
set(RecordMapper)added
set(RecordUnmapper)added
set(RecordUnmapperProvider)added
set(TransactionListener...)added
set(TransactionListenerProvider...)added
set(VisitListener...)added
transactionListenerProviders()added
MockFileDatabase
nullLiteral(String)added
queries()added
MockSavepointadded
org.jooq.util.jaxb.tools
StringAdapteradded
TrimAdapteradded
org.jooq.util.mysql
MySQLDSL
values(Field)added
org.jooq.util.oracle
OracleDSL.DBMS_AQ
dequeue(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T)added
dequeueAsync(Configuration, Queue)added
dequeueAsync(Executor, Configuration, Queue)added
dequeueAsync(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T)added
dequeueAsync(Executor, Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T)added
dequeueAsync(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T, OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T)added
dequeueAsync(Executor, Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T, OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T)added
dequeueIterable(Configuration, Queue)added
dequeueIterable(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T)added
dequeueIterable(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T, OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T)added
dequeueStream(Configuration, Queue)added
dequeueStream(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T)added
dequeueStream(Configuration, Queue, OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T, OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T)added
OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T
wait(int)added
OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T
expiration(BigDecimal)added
expires(BigDecimal)deprecated
org.jooq.util.postgres
PostgresDSL
arrayOverlap(Object[], Object[])added
arrayOverlap(Object[], Field)added
arrayOverlap(Field, Object[])added
arrayOverlap(Field, Field)added
PostgresUtils
toPGArray(String)added
org.jooq.util.redshift
RedshiftDSLadded
RedshiftDataTypeadded
org.jooq.util.vertica
VerticaDSLadded
VerticaDataTypeadded
org.jooq.util.xml.jaxb
Columnadded
Indexadded
IndexColumnUsageadded
InformationSchemaadded
KeyColumnUsageadded
ObjectFactoryadded
Parameteradded
ParameterModeadded
ReferentialConstraintadded
Routineadded
RoutineTypeadded
Schemaadded
Sequenceadded
Tableadded
TableConstraintadded
TableConstraintTypeadded

Legend

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