API diff between 3.3 and 3.7

See all diffs here

ObjectModification
org.jooq
AggregateFilterStepadded
AggregateFunction
over()pulled up
over(String)pulled up
over(Name)pulled up
over(WindowDefinition)pulled up
over(WindowSpecification)pulled up
AlterSequenceFinalStepadded
AlterSequenceRestartStepadded
AlterTableAlterStepadded
AlterTableDropStepadded
AlterTableFinalStepadded
AlterTableStepadded
ArrayAggOrderByStepadded
ArrayRecord
get()deprecated
getList()deprecated
getSchema()added
set(Object...)deprecated
set(Array)deprecated
set(Collection)added
setList(List)deprecated
size()removed
BatchBindStep
bind(Map)added
bind(Map...)added
Bindingadded
BindingGetResultSetContextadded
BindingGetSQLInputContextadded
BindingGetStatementContextadded
BindingRegisterContextadded
BindingSQLContextadded
BindingSetSQLOutputContextadded
BindingSetStatementContextadded
Case
when(Condition, Select)added
CaseConditionStep
otherwise(Select)added
when(Condition, Select)added
CaseValueStep
when(Object, Select)added
when(Field, Select)added
CommonTableExpressionadded
Condition
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
Configuration
converterProvider()added
derive(Connection)added
derive(DataSource)added
derive(ConverterProvider)added
derive(TransactionProvider)added
family()added
set(Connection)added
set(DataSource)added
set(ConverterProvider)added
set(TransactionProvider)added
transactionProvider()added
ConnectionCallableadded
ConnectionRunnableadded
Constraintadded
ConstraintFinalStepadded
ConstraintForeignKeyOnStepadded
ConstraintForeignKeyReferencesStep1 - 22added
ConstraintForeignKeyReferencesStepNadded
ConstraintTypeStepadded
Context
bindValue(Object, Field)added
cast()added
castMode()added
castMode(RenderContext.CastMode)added
castModeSome(SQLDialect...)added
configuration()pulled up
data()pulled up
data(Object)pulled up
data(Object, Object)pulled up
declareCTE()added
declareCTE(boolean)added
format()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
nextAlias()added
paramType()added
paramType(ParamType)added
peekAlias()added
qualify()added
qualify(boolean)added
render()added
render(QueryPart)added
sql(char)added
sql(int)added
sql(String)added
sql(String, boolean)added
statement()added
ConverterProvideradded
Convertersadded
CreateIndexFinalStepadded
CreateIndexStepadded
CreateSequenceFinalStepadded
CreateTableAsStepadded
CreateTableColumnStepadded
CreateTableFinalStepadded
CreateTableOnCommitStepadded
CreateViewAsStepadded
CreateViewFinalStepadded
Cursor
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
dialect()added
family()added
fetchOptional(Field, Object)added
settings()added
DDLQueryadded
DSLContext
alterSequence(String)added
alterSequence(Name)added
alterSequence(Sequence)added
alterTable(String)added
alterTable(Name)added
alterTable(Table)added
batchInsert(TableRecord...)contravariance
close()added
configuration()pulled up
connection(ConnectionRunnable)added
connectionResult(ConnectionCallable)added
createGlobalTemporaryTable(String)added
createGlobalTemporaryTable(Name)added
createGlobalTemporaryTable(Table)added
createIndex(String)added
createIndex(Name)added
createSequence(String)added
createSequence(Name)added
createSequence(Sequence)added
createTable(String)added
createTable(Name)added
createTable(Table)added
createTemporaryTable(String)added
createTemporaryTable(Name)added
createTemporaryTable(Table)added
createView(String, String...)added
createView(Name, Name...)added
createView(Table, Field...)added
currval(String)added
deleteFrom(Table)added
dropIndex(String)added
dropIndex(Name)added
dropIndexIfExists(String)added
dropIndexIfExists(Name)added
dropSequence(String)added
dropSequence(Name)added
dropSequence(Sequence)added
dropSequenceIfExists(String)added
dropSequenceIfExists(Name)added
dropSequenceIfExists(Sequence)added
dropTable(String)added
dropTable(Name)added
dropTable(Table)added
dropTableIfExists(String)added
dropTableIfExists(Name)added
dropTableIfExists(Table)added
dropView(String)added
dropView(Name)added
dropView(Table)added
dropViewIfExists(String)added
dropViewIfExists(Name)added
dropViewIfExists(Table)added
execute(SQL)added
fetch(SQL)added
fetchExists(Select)added
fetchExists(Table)added
fetchExists(Table, Condition)added
fetchFromCSV(String, boolean)added
fetchFromCSV(String, boolean, char)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
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(String)added
fetchValues(ResultSet)added
fetchValues(ResultQuery)added
fetchValues(SQL)added
fetchValues(TableField)added
fetchValues(String, Object...)added
fetchValues(String, QueryPart...)added
fetchValues(ResultSet, Class)added
fetchValues(ResultSet, DataType)added
fetchValues(ResultSet, Field)added
mock(MockDataProvider, MockRunnable)added
mockResult(MockDataProvider, MockCallable)added
newResult(Field)added
newResult(Field...)added
newResult(Field, Field)added
newResult(Field, Field, Field)added
newResult(Field, Field, Field, Field) ... and more overloadsadded
nextval(String)added
query(SQL)added
renderNamedOrInlinedParams(QueryPart)added
resultQuery(SQL)added
select(SelectField)contravariance
select(SelectField...)contravariance
select(SelectField, SelectField)contravariance
select(SelectField, SelectField, SelectField)contravariance
select(SelectField, SelectField, SelectField, SelectField) ... and more overloadscontravariance
selectDistinct(SelectField)contravariance
selectDistinct(SelectField...)contravariance
selectDistinct(SelectField, SelectField)contravariance
selectDistinct(SelectField, SelectField, SelectField)contravariance
selectDistinct(SelectField, SelectField, SelectField, SelectField) ... and more overloadscontravariance
transaction(TransactionalRunnable)added
transactionResult(TransactionalCallable)added
truncate(String)added
truncate(Name)added
with(String)added
with(CommonTableExpression...)added
with(String, String...)added
withRecursive(String)added
withRecursive(CommonTableExpression...)added
withRecursive(String, String...)added
DataType
asConvertedDataType(Binding)added
getBinding()added
getConverter()added
DeleteConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
DeleteQuery
getReturnedRecord()added
getReturnedRecords()added
setReturning()added
setReturning(Collection)added
setReturning(Field...)added
DeleteResultStepadded
DeleteReturningStepadded
DeleteWhereStep
where(Boolean)added
where(SQL)added
DerivedColumnListadded
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
DropIndexFinalStepadded
DropIndexOnStepadded
DropSequenceFinalStepadded
DropTableFinalStepadded
DropTableStepadded
DropViewFinalStepadded
ExecuteContext
configuration()pulled up
data()pulled up
data(Object)pulled up
data(Object, Object)pulled up
sqlWarning()added
sqlWarning(SQLWarning)added
ExecuteListener
outEnd(ExecuteContext)added
outStart(ExecuteContext)added
warning(ExecuteContext)added
Field
as(Field)added
getBinding()added
in(Result)added
notIn(Result)added
plus()added
shl(Number)added
shl(Object)removed
shr(Number)added
shr(Object)removed
FieldOrRowadded
InsertQuery
setSelect(Field[], Select)added
InsertResultStep
fetchOptional()added
InsertSetMoreStep
set(Map)added
set(Record)added
set(Field, Object)added
set(Field, Field)added
set(Field, Select)added
InsertSetStep
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
Linkadded
Loader
executed()added
result()added
LoaderContextadded
LoaderJSONOptionsStep
ignoreRows(int)deprecated
LoaderListenerStepadded
LoaderOptionsStep
batchAfter(int)added
batchAll()added
batchNone()added
bulkAfter(int)added
bulkAll()added
bulkNone()added
LoaderRowListeneradded
LoaderRowsStepadded
LoaderSourceStep
loadArrays(Iterable)added
loadArrays(Object[]...)added
loadArrays(Iterator)added
loadCSV(File, String)added
loadCSV(File, Charset)added
loadCSV(File, CharsetDecoder)added
loadCSV(InputStream, String)added
loadCSV(InputStream, Charset)added
loadCSV(InputStream, CharsetDecoder)added
loadJSON(File, String)added
loadJSON(File, Charset)added
loadJSON(File, CharsetDecoder)added
loadJSON(InputStream, String)added
loadJSON(InputStream, Charset)added
loadJSON(InputStream, CharsetDecoder)added
loadRecords(Iterable)added
loadRecords(Iterator)added
loadRecords(Record...)added
loadXML(File, String)added
loadXML(File, Charset)added
loadXML(File, CharsetDecoder)added
loadXML(InputStream, String)added
loadXML(InputStream, Charset)added
loadXML(InputStream, CharsetDecoder)added
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
Name
as(Select)added
fields(String...)added
Operator
toSQL()added
Parameter
getBinding()added
getConverter()added
PlainSQLadded
QueryPartInternal
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
Record
changed(Name)added
changed(Name, boolean)added
compareTo(Object)added
field(Name)added
fields(Name...)added
from(Object, Name...)added
fromArray(Object..., Name...)added
fromMap(Map, Name...)added
getValue(Name)added
getValue(Name, Class)added
getValue(Name, Converter)added
into(Field)added
into(Field...)added
into(Field, Field)added
into(Field, Field, Field)added
into(Field, Field, Field, Field) ... and more overloadsadded
intoList()added
original(Name)added
reset(Name)added
Record1 - 22
fieldsRow()added
valuesRow()added
RecordContext
configuration()pulled up
data()pulled up
data(Object)pulled up
data(Object, Object)pulled up
recordType()added
RecordType
dataType(Name)added
field(Name)added
field(int, Class)added
field(int, DataType)added
field(String, Class)added
field(String, DataType)added
field(Name, Class)added
field(Name, DataType)added
fields(Name...)added
indexOf(Name)added
type(Name)added
RenderContext
cast()deprecated
castMode(RenderContext.CastMode)added
castModeSome(SQLDialect...)deprecated
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
Result
fetchChildren(ForeignKey)added
fetchParents(ForeignKey)added
field(Name)added
field(int, Class)added
field(int, DataType)added
field(String, Class)added
field(String, DataType)added
field(Name, Class)added
field(Name, DataType)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
format(OutputStream)added
format(Writer)added
format(OutputStream, int)added
format(Writer, int)added
formatCSV(boolean)added
formatCSV(OutputStream)added
formatCSV(Writer)added
formatCSV(boolean, char)added
formatCSV(OutputStream, boolean)added
formatCSV(OutputStream, char)added
formatCSV(Writer, boolean)added
formatCSV(Writer, char)added
formatCSV(boolean, char, String)added
formatCSV(OutputStream, boolean, char)added
formatCSV(OutputStream, char, String)added
formatCSV(Writer, boolean, char)added
formatCSV(Writer, char, String)added
formatCSV(OutputStream, boolean, char, String)added
formatCSV(Writer, boolean, char, String)added
formatHTML(OutputStream)added
formatHTML(Writer)added
formatInsert()added
formatInsert(OutputStream)added
formatInsert(Writer)added
formatInsert(Table, Field...)added
formatInsert(OutputStream, Table, Field...)added
formatInsert(Writer, Table, Field...)added
formatJSON(OutputStream)added
formatJSON(Writer)added
formatXML(OutputStream)added
formatXML(Writer)added
getValues(Name)added
getValues(Name, Class)added
getValues(Name, Converter)added
intern(Name...)added
into(Field)added
into(Field...)added
into(Field, Field)added
into(Field, Field, Field)added
into(Field, Field, Field, Field) ... and more overloadsadded
intoArray()deprecated
intoArray(Name)added
intoArray(Name, Class)added
intoArray(Name, Converter)added
intoArrays()added
intoGroups(int)added
intoGroups(int[])added
intoGroups(Class)added
intoGroups(String)added
intoGroups(String[])added
intoGroups(Name)added
intoGroups(Name[])added
intoGroups(RecordMapper)added
intoGroups(Table)added
intoGroups(int, int)added
intoGroups(int, Class)added
intoGroups(int, RecordMapper)added
intoGroups(int[], Class)added
intoGroups(int[], RecordMapper)added
intoGroups(Class, Class)added
intoGroups(Class, RecordMapper)added
intoGroups(String, Class)added
intoGroups(String, String)added
intoGroups(String, RecordMapper)added
intoGroups(String[], Class)added
intoGroups(String[], RecordMapper)added
intoGroups(Name, Class)added
intoGroups(Name, Name)added
intoGroups(Name, RecordMapper)added
intoGroups(Name[], Class)added
intoGroups(Name[], RecordMapper)added
intoGroups(RecordMapper, Class)added
intoGroups(RecordMapper, RecordMapper)added
intoGroups(Table, Class)added
intoGroups(Table, RecordMapper)added
intoMap(int)added
intoMap(int[])added
intoMap(Class)added
intoMap(String)added
intoMap(String[])added
intoMap(Name)added
intoMap(Name[])added
intoMap(RecordMapper)added
intoMap(Table)added
intoMap(int, int)added
intoMap(int, Class)added
intoMap(int, RecordMapper)added
intoMap(int[], Class)added
intoMap(int[], RecordMapper)added
intoMap(Class, Class)added
intoMap(Class, RecordMapper)added
intoMap(String, Class)added
intoMap(String, String)added
intoMap(String, RecordMapper)added
intoMap(String[], Class)added
intoMap(String[], RecordMapper)added
intoMap(Name, Class)added
intoMap(Name, Name)added
intoMap(Name, RecordMapper)added
intoMap(Name[], Class)added
intoMap(Name[], RecordMapper)added
intoMap(RecordMapper, Class)added
intoMap(RecordMapper, RecordMapper)added
intoMap(Table, Class)added
intoMap(Table, RecordMapper)added
intoSet(int)added
intoSet(String)added
intoSet(Field)added
intoSet(Name)added
intoSet(int, Class)added
intoSet(int, Converter)added
intoSet(String, Class)added
intoSet(String, Converter)added
intoSet(Field, Class)added
intoSet(Field, Converter)added
intoSet(Name, Class)added
intoSet(Name, Converter)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(int)added
fetchAny(String)added
fetchAny(Field)added
fetchAny(Name)added
fetchAny(RecordMapper)added
fetchAny(int, Class)added
fetchAny(int, Converter)added
fetchAny(String, Class)added
fetchAny(String, Converter)added
fetchAny(Field, Class)added
fetchAny(Field, Converter)added
fetchAny(Name, Class)added
fetchAny(Name, Converter)added
fetchAnyArray()added
fetchAnyInto(Class)added
fetchAnyInto(Table)added
fetchAnyMap()added
fetchArray()added
fetchArray(Name)added
fetchArray(Name, Class)added
fetchArray(Name, Converter)added
fetchGroups(int)added
fetchGroups(int[])added
fetchGroups(Class)added
fetchGroups(String)added
fetchGroups(String[])added
fetchGroups(Name)added
fetchGroups(Name[])added
fetchGroups(RecordMapper)added
fetchGroups(Table)added
fetchGroups(int, int)added
fetchGroups(int, Class)added
fetchGroups(int, RecordMapper)added
fetchGroups(int[], Class)added
fetchGroups(int[], RecordMapper)added
fetchGroups(Class, Class)added
fetchGroups(Class, RecordMapper)added
fetchGroups(String, Class)added
fetchGroups(String, String)added
fetchGroups(String, RecordMapper)added
fetchGroups(String[], Class)added
fetchGroups(String[], RecordMapper)added
fetchGroups(Name, Class)added
fetchGroups(Name, Name)added
fetchGroups(Name, RecordMapper)added
fetchGroups(Name[], Class)added
fetchGroups(Name[], RecordMapper)added
fetchGroups(RecordMapper, Class)added
fetchGroups(RecordMapper, RecordMapper)added
fetchGroups(Table, Class)added
fetchGroups(Table, RecordMapper)added
fetchMap(int)added
fetchMap(int[])added
fetchMap(Class)added
fetchMap(String)added
fetchMap(String[])added
fetchMap(Name)added
fetchMap(Name[])added
fetchMap(RecordMapper)added
fetchMap(Table)added
fetchMap(int, int)added
fetchMap(int, Class)added
fetchMap(int, RecordMapper)added
fetchMap(int[], Class)added
fetchMap(int[], RecordMapper)added
fetchMap(Class, Class)added
fetchMap(Class, RecordMapper)added
fetchMap(String, Class)added
fetchMap(String, String)added
fetchMap(String, RecordMapper)added
fetchMap(String[], Class)added
fetchMap(String[], RecordMapper)added
fetchMap(Name, Class)added
fetchMap(Name, Name)added
fetchMap(Name, RecordMapper)added
fetchMap(Name[], Class)added
fetchMap(Name[], RecordMapper)added
fetchMap(RecordMapper, Class)added
fetchMap(RecordMapper, RecordMapper)added
fetchMap(Table, Class)added
fetchMap(Table, RecordMapper)added
fetchOne(Name)added
fetchOne(RecordMapper)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(int)added
fetchSet(String)added
fetchSet(Field)added
fetchSet(Name)added
fetchSet(int, Class)added
fetchSet(int, Converter)added
fetchSet(String, Class)added
fetchSet(String, Converter)added
fetchSet(Field, Class)added
fetchSet(Field, Converter)added
fetchSet(Name, Class)added
fetchSet(Name, Converter)added
intern(Name...)added
iterator()added
keepStatement(boolean)added
queryTimeout(int)added
stream()added
Resultsadded
Routine
getResults()added
getReturnParameter()added
getValue(Parameter)added
setValue(Parameter, Object)added
Row
dataType(Name)added
field(Name)added
field(int, Class)added
field(int, DataType)added
field(String, Class)added
field(String, DataType)added
field(Name, Class)added
field(Name, DataType)added
fields(Name...)added
indexOf(Name)added
type(Name)added
Row1 - 22
compare(Comparator, QuantifiedSelect)added
compare(Comparator, Select)added
eq(QuantifiedSelect)added
equal(QuantifiedSelect)added
ge(QuantifiedSelect)added
greaterOrEqual(QuantifiedSelect)added
greaterThan(QuantifiedSelect)added
gt(QuantifiedSelect)added
in(Result)added
le(QuantifiedSelect)added
lessOrEqual(QuantifiedSelect)added
lessThan(QuantifiedSelect)added
lt(QuantifiedSelect)added
ne(QuantifiedSelect)added
notEqual(QuantifiedSelect)added
notIn(Result)added
RowN
compare(Comparator, QuantifiedSelect)added
compare(Comparator, Select)added
eq(QuantifiedSelect)added
equal(QuantifiedSelect)added
ge(QuantifiedSelect)added
greaterOrEqual(QuantifiedSelect)added
greaterThan(QuantifiedSelect)added
gt(QuantifiedSelect)added
in(Result)added
le(QuantifiedSelect)added
lessOrEqual(QuantifiedSelect)added
lessThan(QuantifiedSelect)added
lt(QuantifiedSelect)added
ne(QuantifiedSelect)added
notEqual(QuantifiedSelect)added
notIn(Result)added
SQLadded
SQLDialect
families()added
precedes(SQLDialect)added
predecessor()added
thirdParty()added
SQLDialect.ThirdPartyadded
Scopeadded
Select
exceptAll(Select)added
fetchCount()deprecated
intersectAll(Select)added
SelectConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
SelectConnectByConditionStep
and(Boolean)added
and(SQL)added
SelectConnectByStep
connectBy(Boolean)added
connectBy(SQL)added
connectByNoCycle(Boolean)added
connectByNoCycle(SQL)added
SelectDistinctOnStepadded
SelectFieldadded
SelectForUpdateStep
withCheckOption()added
withReadOnly()added
SelectFromStep
from(SQL)added
from(TableLike)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
SelectIntoStepadded
SelectJoinStep
crossApply(SQL)added
crossJoin(SQL)added
fullOuterJoin(SQL)added
innerJoin(String)added
innerJoin(SQL)added
innerJoin(TableLike)added
innerJoin(String, Object...)added
innerJoin(String, QueryPart...)added
join(SQL)added
leftAntiJoin(TableLike)added
leftJoin(String)added
leftJoin(SQL)added
leftJoin(TableLike)added
leftJoin(String, Object...)added
leftJoin(String, QueryPart...)added
leftOuterJoin(SQL)added
leftSemiJoin(TableLike)added
naturalJoin(SQL)added
naturalLeftOuterJoin(SQL)added
naturalRightOuterJoin(SQL)added
outerApply(SQL)added
rightJoin(String)added
rightJoin(SQL)added
rightJoin(TableLike)added
rightJoin(String, Object...)added
rightJoin(String, QueryPart...)added
rightOuterJoin(SQL)added
straightJoin(TableLike)added
straightJoin(String, Object...)added
straightJoin(String, QueryPart...)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
SelectQuery
addDistinctOn(Collection)added
addDistinctOn(SelectField...)added
addFrom(TableLike)added
addSelect(SelectField...)contravariance
setInto(Table)added
setWithCheckOption()added
setWithReadOnly()added
SelectSelectStep
select(SelectField...)contravariance
SelectStartWithStep
startWith(Boolean)added
startWith(SQL)added
SelectUnionStepadded
SelectWhereStep
where(Boolean)added
where(SQL)added
Table
at(String)added
at(Link)added
at(Name)added
crossApply(SQL)added
crossJoin(SQL)added
forceIndex(String...)added
forceIndexForGroupBy(String...)added
forceIndexForJoin(String...)added
forceIndexForOrderBy(String...)added
fullOuterJoin(SQL)added
ignoreIndex(String...)added
ignoreIndexForGroupBy(String...)added
ignoreIndexForJoin(String...)added
ignoreIndexForOrderBy(String...)added
innerJoin(String)added
innerJoin(SQL)added
innerJoin(TableLike)added
innerJoin(String, Object...)added
innerJoin(String, QueryPart...)added
join(SQL)added
leftAntiJoin(TableLike)added
leftJoin(String)added
leftJoin(SQL)added
leftJoin(TableLike)added
leftJoin(String, Object...)added
leftJoin(String, QueryPart...)added
leftOuterJoin(SQL)added
leftSemiJoin(TableLike)added
naturalJoin(SQL)added
naturalLeftOuterJoin(SQL)added
naturalRightOuterJoin(SQL)added
newRecord()added
outerApply(SQL)added
rightJoin(String)added
rightJoin(SQL)added
rightJoin(TableLike)added
rightJoin(String, Object...)added
rightJoin(String, QueryPart...)added
rightOuterJoin(SQL)added
straightJoin(String)added
straightJoin(SQL)added
straightJoin(TableLike)added
straightJoin(String, Object...)added
straightJoin(String, QueryPart...)added
useIndex(String...)added
useIndexForGroupBy(String...)added
useIndexForJoin(String...)added
useIndexForOrderBy(String...)added
TableLike
field(Name)added
field(int, Class)added
field(int, DataType)added
field(String, Class)added
field(String, DataType)added
field(Name, Class)added
field(Name, DataType)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
TableRecord
insert()added
insert(Field...)added
original()added
Templateremoved
Transactionadded
TransactionContextadded
TransactionProvideradded
TransactionalCallableadded
TransactionalRunnableadded
UDT
field(Name)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
newRecord()added
UpdatableRecord
insert(Field...)added
store(Field...)added
update(Field...)added
UpdateConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
UpdateFromStep
from(SQL)added
from(TableLike)added
UpdateQuery
addFrom(TableLike)added
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
VisitContext
configuration()pulled up
data()pulled up
data(Object)pulled up
data(Object, Object)pulled up
WindowBeforeOverStep
over()pulled up
WithAsStepadded
WithStepadded
org.jooq.conf
BackslashEscapingadded
Settings
getBackslashEscaping()added
isFetchWarnings()added
isMapJPAAnnotations()added
isRenderScalarSubqueriesForStoredFunctions()added
setBackslashEscaping(BackslashEscaping)added
setFetchWarnings(Boolean)added
setMapJPAAnnotations(Boolean)added
setRenderScalarSubqueriesForStoredFunctions(Boolean)added
withBackslashEscaping(BackslashEscaping)added
withFetchWarnings(Boolean)added
withMapJPAAnnotations(Boolean)added
withRenderScalarSubqueriesForStoredFunctions(Boolean)added
SettingsTools
getBackslashEscaping(Settings)added
org.jooq.exception
IOExceptionadded
LoaderConfigurationExceptionadded
NoDataFoundExceptionadded
TooManyRowsExceptionadded
org.jooq.impl
AbstractConverteradded
AbstractRoutine
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
getResults()added
getReturnParameter()added
getValue(Parameter)added
setValue(Parameter, Object)added
toSQL(RenderContext)deprecated
AbstractXMLasObjectBindingadded
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
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(Array)deprecated
set(Collection)added
set(int, Object)added
setList(List)deprecated
subList(int, int)added
toArray()added
toArray(Object[])added
BlobBindingadded
CatalogImpl
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
ClobBindingadded
CustomCondition
accept(Context)added
and(Boolean)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
CustomField
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
CustomQueryPart
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
DAOImpl
dialect()added
family()added
fetchOptional(Field, Object)added
settings()added
DSL
alterSequence(String)added
alterSequence(Name)added
alterSequence(Sequence)added
alterTable(String)added
alterTable(Name)added
alterTable(Table)added
and(Collection)added
and(Condition...)added
array(Object...)added
array(Collection)added
array(Field...)added
arrayAgg(Field)added
boolAnd(Condition)added
boolAnd(Field)added
boolOr(Condition)added
boolOr(Field)added
choose()added
choose(Object)added
choose(Field)added
coalesce(Field, Object)added
coerce(Object, Class)added
coerce(Object, DataType)added
coerce(Object, Field)added
concat(String, Field)added
concat(Field, String)added
condition(Boolean)added
condition(Map)added
condition(SQL)added
condition(Operator, Collection)added
condition(Operator, Condition...)added
constraint(String)added
count(Table)added
countDistinct(Table)added
createGlobalTemporaryTable(String)added
createGlobalTemporaryTable(Name)added
createGlobalTemporaryTable(Table)added
createIndex(String)added
createIndex(Name)added
createSequence(String)added
createSequence(Name)added
createSequence(Sequence)added
createTable(String)added
createTable(Name)added
createTable(Table)added
createTemporaryTable(String)added
createTemporaryTable(Name)added
createTemporaryTable(Table)added
createView(String, String...)added
createView(Name, Name...)added
createView(Table, Field...)added
cube(FieldOrRow...)added
cumeDist(Field...)added
currentSchema()added
date(String)added
dateSub(Date, Number)added
dateSub(Field, Field)added
dateSub(Date, Number, DatePart)added
dateSub(Date, Field, DatePart)added
dateSub(Field, Number, DatePart)added
dateSub(Field, Field, DatePart)added
defaultValue()added
defaultValue(Class)added
defaultValue(DataType)added
defaultValue(Field)added
deleteFrom(Table)added
denseRank(Field...)added
dropIndex(String)added
dropIndex(Name)added
dropIndexIfExists(String)added
dropIndexIfExists(Name)added
dropSequence(String)added
dropSequence(Name)added
dropSequence(Sequence)added
dropSequenceIfExists(String)added
dropSequenceIfExists(Name)added
dropSequenceIfExists(Sequence)added
dropTable(String)added
dropTable(Name)added
dropTable(Table)added
dropTableIfExists(String)added
dropTableIfExists(Name)added
dropTableIfExists(Table)added
dropView(String)added
dropView(Name)added
dropView(Table)added
dropViewIfExists(String)added
dropViewIfExists(Name)added
dropViewIfExists(Table)added
every(Condition)added
every(Field)added
field(Name)added
field(SQL)added
field(Select)added
field(SelectField)added
field(Name, Class)added
field(Name, DataType)added
field(SQL, Class)added
field(SQL, DataType)added
fieldByName(String...)deprecated
fieldByName(Class, String...)deprecated
fieldByName(DataType, String...)deprecated
link(String)added
link(Name)added
link(String, Schema)added
list(Collection)added
list(QueryPart...)added
not(Boolean)added
not(Field)added
nthValue(Field, int)added
nthValue(Field, Field)added
or(Collection)added
or(Condition...)added
param()added
param(Class)added
param(DataType)added
param(Field)added
param(String, Field)added
percentRank(Field...)added
percentileCont(Number)added
percentileCont(Field)added
percentileDisc(Number)added
percentileDisc(Field)added
query(String)added
query(SQL)added
query(String, Object...)added
query(String, QueryPart...)added
queryPart(String)deprecated
queryPart(String, Object...)deprecated
queryPart(String, QueryPart...)deprecated
rank(Field...)added
resultQuery(String)added
resultQuery(SQL)added
resultQuery(String, Object...)added
resultQuery(String, QueryPart...)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
schema(Name)added
schemaByName(String)deprecated
select(SelectField)contravariance
select(SelectField...)contravariance
select(SelectField, SelectField)contravariance
select(SelectField, SelectField, SelectField)contravariance
select(SelectField, SelectField, SelectField, SelectField) ... and more overloadscontravariance
selectDistinct(SelectField)contravariance
selectDistinct(SelectField...)contravariance
selectDistinct(SelectField, SelectField)contravariance
selectDistinct(SelectField, SelectField, SelectField)contravariance
selectDistinct(SelectField, SelectField, SelectField, SelectField) ... and more overloadscontravariance
sequence(String)added
sequence(Name)added
sequence(String, Class)added
sequence(String, DataType)added
sequence(Name, Class)added
sequence(Name, DataType)added
sequenceByName(String...)added
sequenceByName(Class, String...)added
sequenceByName(DataType, String...)added
sql(String)added
sql(String, Object...)added
sql(String, QueryPart...)added
table(Name)added
table(Record)added
table(Record...)added
table(SQL)added
tableByName(String...)deprecated
time(String)added
timestamp(String)added
truncate(Name)added
using(String)added
using(String, Properties)added
using(String, String, String)added
when(Condition, Object)added
when(Condition, Field)added
when(Condition, Select)added
with(String)added
with(CommonTableExpression...)added
with(String, String...)added
withRecursive(String)added
withRecursive(CommonTableExpression...)added
withRecursive(String, String...)added
DateAsTimestampBindingadded
DefaultBindingadded
DefaultConfiguration
converterProvider()added
derive(ConverterProvider)added
derive(TransactionProvider)added
family()added
set(ConverterProvider)added
set(TransactionProvider)added
setConnection(Connection)added
setConnectionProvider(ConnectionProvider)added
setDataSource(DataSource)added
setExecuteListenerProvider(ExecuteListenerProvider...)added
setRecordListenerProvider(RecordListenerProvider...)added
setRecordMapperProvider(RecordMapperProvider)added
setSQLDialect(SQLDialect)added
setSettings(Settings)added
setTransactionProvider(TransactionProvider)added
setVisitListenerProvider(VisitListenerProvider...)added
transactionProvider()added
DefaultConverterProvideradded
DefaultDSLContext
alterSequence(String)added
alterSequence(Name)added
alterSequence(Sequence)added
alterTable(String)added
alterTable(Name)added
alterTable(Table)added
batchInsert(TableRecord...)contravariance
close()added
configuration()pulled up
connection(ConnectionRunnable)added
connectionResult(ConnectionCallable)added
createGlobalTemporaryTable(String)added
createGlobalTemporaryTable(Name)added
createGlobalTemporaryTable(Table)added
createIndex(String)added
createIndex(Name)added
createSequence(String)added
createSequence(Name)added
createSequence(Sequence)added
createTable(String)added
createTable(Name)added
createTable(Table)added
createTemporaryTable(String)added
createTemporaryTable(Name)added
createTemporaryTable(Table)added
createView(String, String...)added
createView(Name, Name...)added
createView(Table, Field...)added
currval(String)added
deleteFrom(Table)added
dropIndex(String)added
dropIndex(Name)added
dropIndexIfExists(String)added
dropIndexIfExists(Name)added
dropSequence(String)added
dropSequence(Name)added
dropSequence(Sequence)added
dropSequenceIfExists(String)added
dropSequenceIfExists(Name)added
dropSequenceIfExists(Sequence)added
dropTable(String)added
dropTable(Name)added
dropTable(Table)added
dropTableIfExists(String)added
dropTableIfExists(Name)added
dropTableIfExists(Table)added
dropView(String)added
dropView(Name)added
dropView(Table)added
dropViewIfExists(String)added
dropViewIfExists(Name)added
dropViewIfExists(Table)added
execute(SQL)added
fetch(SQL)added
fetchExists(Select)added
fetchExists(Table)added
fetchExists(Table, Condition)added
fetchFromCSV(String, boolean)added
fetchFromCSV(String, boolean, char)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
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(String)added
fetchValues(ResultSet)added
fetchValues(ResultQuery)added
fetchValues(SQL)added
fetchValues(TableField)added
fetchValues(String, Object...)added
fetchValues(String, QueryPart...)added
fetchValues(ResultSet, Class)added
fetchValues(ResultSet, DataType)added
fetchValues(ResultSet, Field)added
mock(MockDataProvider, MockRunnable)added
mockResult(MockDataProvider, MockCallable)added
newResult(Field)added
newResult(Field...)added
newResult(Field, Field)added
newResult(Field, Field, Field)added
newResult(Field, Field, Field, Field) ... and more overloadsadded
nextval(String)added
query(SQL)added
renderNamedOrInlinedParams(QueryPart)added
resultQuery(SQL)added
select(SelectField)contravariance
select(SelectField...)contravariance
select(SelectField, SelectField)contravariance
select(SelectField, SelectField, SelectField)contravariance
select(SelectField, SelectField, SelectField, SelectField) ... and more overloadscontravariance
selectDistinct(SelectField)contravariance
selectDistinct(SelectField...)contravariance
selectDistinct(SelectField, SelectField)contravariance
selectDistinct(SelectField, SelectField, SelectField)contravariance
selectDistinct(SelectField, SelectField, SelectField, SelectField) ... and more overloadscontravariance
transaction(TransactionalRunnable)added
transactionResult(TransactionalCallable)added
truncate(String)added
truncate(Name)added
with(String)added
with(CommonTableExpression...)added
with(String, String...)added
withRecursive(String)added
withRecursive(CommonTableExpression...)added
withRecursive(String, String...)added
DefaultDataType
asConvertedDataType(Binding)added
getBinding()added
getConverter()added
DefaultExecuteListener
outEnd(ExecuteContext)added
outStart(ExecuteContext)added
warning(ExecuteContext)added
DefaultTransactionProvideradded
EnumConverter
fromType()pulled up
toType()pulled up
KeywordImpl
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
NoTransactionProvideradded
NullIf
bind(BindContext)added
declaresCTE()added
generatesCast()added
toSQL(RenderContext)added
PackageImpl
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
SchemaImpl
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
SequenceImpl
accept(Context)added
bind(BindContext)added
clauses(Context)added
declaresCTE()added
declaresFields()added
declaresTables()added
declaresWindows()added
equals(Object)added
generatesCast()added
toSQL(RenderContext)added
toString()added
TableImpl
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
generatesCast()added
toSQL(RenderContext)deprecated
TableRecordImpl
insert()added
insert(Field...)added
UDTImpl
accept(Context)added
bind(BindContext)deprecated
declaresCTE()added
field(Name)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
generatesCast()added
newRecord()added
toSQL(RenderContext)deprecated
UpdatableRecordImpl
insert()pulled up
store(Field...)added
update(Field...)added
XMLasDOMBindingadded
org.jooq.tools
LoggerListener
outEnd(ExecuteContext)added
StopWatch
split()added
StopWatchListener
outEnd(ExecuteContext)added
outStart(ExecuteContext)added
warning(ExecuteContext)added
org.jooq.tools.jdbc
JDBCUtils
driver(String)added
safeFree(Array)added
safeFree(SQLXML)added
wasNull(CallableStatement, Boolean)added
wasNull(CallableStatement, Number)added
wasNull(ResultSet, Boolean)added
wasNull(ResultSet, Number)added
wasNull(SQLInput, Boolean)added
wasNull(SQLInput, Number)added
MockArrayadded
MockCallableadded
MockConfigurationadded
MockConnectionProvideradded
MockExecuteContext
outParameterTypes()added
MockResult
<init>(Record)added
MockRunnableadded
MockSavepointadded
org.jooq.tools.json
JSONArray
toString()added
JSONObject
toString()added
org.jooq.util.hana
HanaDSLadded
HanaDataTypeadded
org.jooq.util.informix
InformixDSLadded
InformixDataTypeadded
org.jooq.util.mysql
MySQLDSL
aesDecrypt(byte[], byte[])added
aesEncrypt(byte[], byte[])added
compress(byte[])added
decode(byte[], byte[])added
desDecrypt(byte[])added
desDecrypt(byte[], byte[])added
desEncrypt(byte[])added
desEncrypt(byte[], byte[])added
encode(byte[], byte[])added
password(byte[])added
sha1(byte[])added
sha2(byte[], int)added
uncompress(byte[])added
uncompressedLength(byte[])added
values(Field)added
org.jooq.util.oracle
OracleDSL
oraRowscn()added
rowscn()added
scnToTimestamp(Number)added
scnToTimestamp(Field)added
timestampToScn(Date)added
timestampToScn(Field)added
toChar(Object)added
toChar(String)removed
toChar(Object, String)added
toChar(Object, Field)added
toChar(String, String)removed
toChar(String, Field)removed
toNumber(String)added
toNumber(Field)added
toNumber(String, String)added
toNumber(String, Field)added
toNumber(Field, String)added
toNumber(Field, Field)added
OracleDSL.DBMS_AQadded
OracleDSL.DBMS_AQ.DELIVERY_MODEadded
OracleDSL.DBMS_AQ.DEQUEUE_MODEadded
OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_Tadded
OracleDSL.DBMS_AQ.ENQUEUE_OPTIONS_Tadded
OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_Tadded
OracleDSL.DBMS_AQ.NAVIGATIONadded
OracleDSL.DBMS_AQ.SEQUENCE_DEVIATIONadded
OracleDSL.DBMS_AQ.VISIBILITYadded
OracleDSL.DBMS_AQ.WAITadded
Queueadded
QueueImpladded
org.jooq.util.postgres
PostgresDSL
array(Select)added
arrayFill(Object, Integer[])added
arrayFill(Object, Field)added
arrayFill(Field, Integer[])added
arrayFill(Field, Field)added
arrayFill(Object, Integer[], Integer[])added
arrayFill(Object, Field, Field)added
arrayFill(Field, Integer[], Integer[])added
arrayFill(Field, Field, Field)added
arrayLength(Object...)added
arrayLength(Field)added
arrayRemove(Object[], Object)added
arrayRemove(Object[], Field)added
arrayRemove(Field, Object)added
arrayRemove(Field, Field)added
arrayReplace(Object[], Object, Object)added
arrayReplace(Object[], Field, Field)added
arrayReplace(Field, Object, Object)added
arrayReplace(Field, Field, Field)added
stringToArray(String, String, String)added
stringToArray(String, Field, Field)added
stringToArray(Field, String, String)added
stringToArray(Field, Field, Field)added
PostgresUtils
toPGString(byte[])added
toPGString(Object)added
toPGString(Record)added
org.jooq.util.redshift
RedshiftDSLadded
RedshiftDataTypeadded
org.jooq.util.vertica
VerticaDSLadded
VerticaDataTypeadded

Legend

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