API diff between 3.6 and 3.7

See all diffs here

ObjectModification
org.jooq
AggregateFilterStep
filterWhere(Boolean)added
filterWhere(SQL)added
ArrayRecord
get()deprecated
getList()deprecated
getSchema()added
set(Object...)deprecated
set(Collection)deprecated
size()removed
Clause
SELECT_EXCEPT_ALLadded
SELECT_INTERSECT_ALLadded
TABLE_JOIN_ANTI_LEFTadded
TABLE_JOIN_SEMI_LEFTadded
Condition
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
ConnectionCallableadded
ConnectionRunnableadded
Constants
NS_EXPORTadded
XSD_EXPORTadded
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
fetchOptional(Field, Object)added
DSLContext
close()added
connection(ConnectionRunnable)added
connectionResult(ConnectionCallable)added
execute(SQL)added
fetch(SQL)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(SQL)added
query(SQL)added
resultQuery(SQL)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
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
Field
shl(Number)added
shl(Object)removed
shr(Number)added
shr(Object)removed
FieldOrRowadded
InsertQuery
setSelect(Field[], Select)added
InsertResultStep
fetchOptional()added
JoinType
LEFT_ANTI_JOINadded
LEFT_SEMI_JOINadded
STRAIGHT_JOINadded
Linkadded
LoaderJSONOptionsStep
ignoreRows(int)deprecated
LoaderRowsStepadded
LoaderSourceStep
loadArrays(Iterable)added
loadArrays(Object[]...)added
loadArrays(Iterator)added
loadRecords(Iterable)added
loadRecords(Iterator)added
loadRecords(Record...)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
Operator
toSQL()added
QueryPartInternal
generatesCast()added
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
original(Name)added
reset(Name)added
Record1 - 22
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
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
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(boolean, char)added
formatCSV(OutputStream, boolean)added
formatCSV(Writer, boolean)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
getValues(Name)added
getValues(Name, Class)added
getValues(Name, Converter)added
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(Class, Class)added
intoGroups(Class, 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
intoMap(Class)added
intoMap(Name)added
intoMap(Name[])added
intoMap(RecordMapper)added
intoMap(Class, Class)added
intoMap(Class, 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
intoSet(Name)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(Name)added
fetchAny(RecordMapper)added
fetchAny(Name, Class)added
fetchAny(Name, Converter)added
fetchArray(Name)added
fetchArray(Name, Class)added
fetchArray(Name, Converter)added
fetchGroups(Class)added
fetchGroups(Name)added
fetchGroups(Name[])added
fetchGroups(RecordMapper)added
fetchGroups(Class, Class)added
fetchGroups(Class, 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
fetchMap(Class)added
fetchMap(Name)added
fetchMap(Name[])added
fetchMap(RecordMapper)added
fetchMap(Class, Class)added
fetchMap(Class, 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
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
intern(Name...)added
keepStatement(boolean)added
queryTimeout(int)added
stream()added
Resultsadded
Row
dataType(Name)added
field(Name)added
field(Name, Class)added
field(Name, DataType)added
fields(Name...)added
indexOf(Name)added
type(Name)added
SQLDialect
POSTGRES_9_5added
REDSHIFTadded
VERTICAadded
thirdParty()added
SQLDialect.ThirdPartyadded
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
SelectConnectByConditionStep
and(Boolean)added
and(SQL)added
SelectConnectByStep
connectBy(Boolean)added
connectBy(SQL)added
connectByNoCycle(Boolean)added
connectByNoCycle(SQL)added
SelectFromStep
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(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
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
Table
at(String)added
at(Link)added
at(Name)added
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(String)added
straightJoin(SQL)added
straightJoin(TableLike)added
straightJoin(String, Object...)added
straightJoin(String, QueryPart...)added
TableLike
field(Name)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
original()added
Templateremoved
UDT
field(Name)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
UpdateConditionStep
and(Boolean)added
and(SQL)added
andNot(Boolean)added
or(Boolean)added
or(SQL)added
orNot(Boolean)added
UpdateFromStep
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
org.jooq.conf
Settings
isMapJPAAnnotations()added
setMapJPAAnnotations(Boolean)added
withMapJPAAnnotations(Boolean)added
org.jooq.impl
AbstractRoutine
generatesCast()added
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(Collection)deprecated
set(int, Object)added
subList(int, int)added
toArray()added
toArray(Object[])added
CatalogImpl
generatesCast()added
CustomCondition
and(Boolean)added
generatesCast()added
CustomField
generatesCast()added
CustomQueryPart
generatesCast()added
DAOImpl
fetchOptional(Field, Object)added
DSL
array(Object...)added
array(Collection)added
array(Field...)added
boolAnd(Condition)added
boolAnd(Field)added
boolOr(Condition)added
boolOr(Field)added
condition(Map)added
condition(SQL)added
cube(FieldOrRow...)added
currentSchema()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
link(String)added
link(Name)added
link(String, Schema)added
not(Boolean)deprecated
nthValue(Field, int)added
nthValue(Field, Field)added
query(SQL)added
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
table(SQL)added
DefaultDSLContext
close()added
connection(ConnectionRunnable)added
connectionResult(ConnectionCallable)added
execute(SQL)added
fetch(SQL)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(SQL)added
query(SQL)added
resultQuery(SQL)added
DefaultTransactionProvider
<init>(ConnectionProvider, boolean)added
nested()added
KeywordImpl
generatesCast()added
NullIf
generatesCast()added
PackageImpl
generatesCast()added
SQLDataType
LOCALDATEadded
LOCALDATETIMEadded
LOCALTIMEadded
OFFSETDATETIMEadded
OFFSETTIMEadded
TIMESTAMPWITHTIMEZONEadded
TIMEWITHTIMEZONEadded
SchemaImpl
generatesCast()added
SequenceImpl
generatesCast()added
TableImpl
generatesCast()added
UDTImpl
field(Name)added
fields(int...)added
fields(String...)added
fields(Field...)added
fields(Name...)added
generatesCast()added
org.jooq.tools.jdbc
MockSavepointadded
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
OracleDSL.DBMS_AQ.DEQUEUE_OPTIONS_T
wait_secondsadded
wait(int)added
OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T
expirationadded
expiresdeprecated
expiration(BigDecimal)added
expires(BigDecimal)deprecated
org.jooq.util.postgres
PostgresDataType
VOIDadded
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