- name(String...) - Static method in class org.jooq.impl.Factory
-
Create a new SQL identifier using a qualified name.
- Name - Interface in org.jooq
-
- NAME - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- namedParams() - Method in interface org.jooq.RenderContext
-
Whether bind variables should be rendered as named parameters:
:1, :2, :custom_name
or as JDBC bind variables
?
- namedParams(boolean) - Method in interface org.jooq.RenderContext
-
- NamedQueryPart - Interface in org.jooq
-
Deprecated.
- 2.6.0 [#1869] - This marker interface does not have enough
momentum to be exposed in the public API. It will be removed in
the future.
- NamedTypeProviderQueryPart<T> - Interface in org.jooq
-
Deprecated.
- 2.6.0 [#1870] - This marker interface does not have enough
momentum to be exposed in the public API. It will be removed in
the future.
- NATIONALCHARACTERLARGEOBJECT - Static variable in class org.jooq.util.ingres.IngresDataType
-
- NATIONALCHARACTERVARYING - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- NATIONALCHARVARYING - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- NATIVECHARACTER - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NATURAL - Static variable in class org.jooq.util.oracle.OracleDataType
-
- naturalJoin(TableLike<?>) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
NATURAL JOIN a table to the last table
added to the
FROM clause using
Table.naturalJoin(TableLike)
Natural joins are supported by most RDBMS.
- naturalJoin(String) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
NATURAL JOIN a table to the last table
added to the
FROM clause using
Table.naturalJoin(String)
Natural joins are supported by most RDBMS.
- naturalJoin(String, Object...) - Method in interface org.jooq.SelectJoinStep
-
- naturalJoin(String, QueryPart...) - Method in interface org.jooq.SelectJoinStep
-
- naturalJoin(TableLike<?>) - Method in interface org.jooq.Table
-
NATURAL JOIN a table to this table.
- naturalJoin(String) - Method in interface org.jooq.Table
-
NATURAL JOIN a table to this table.
- naturalJoin(String, Object...) - Method in interface org.jooq.Table
-
NATURAL JOIN a table to this table.
- naturalJoin(String, QueryPart...) - Method in interface org.jooq.Table
-
NATURAL JOIN a table to this table.
- naturalLeftOuterJoin(TableLike<?>) - Method in interface org.jooq.SelectJoinStep
-
- naturalLeftOuterJoin(String) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the
FROM clause using
Table.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS.
- naturalLeftOuterJoin(String, Object...) - Method in interface org.jooq.SelectJoinStep
-
- naturalLeftOuterJoin(String, QueryPart...) - Method in interface org.jooq.SelectJoinStep
-
- naturalLeftOuterJoin(TableLike<?>) - Method in interface org.jooq.Table
-
NATURAL LEFT OUTER JOIN a table to this table.
- naturalLeftOuterJoin(String) - Method in interface org.jooq.Table
-
NATURAL LEFT OUTER JOIN a table to this table.
- naturalLeftOuterJoin(String, Object...) - Method in interface org.jooq.Table
-
NATURAL LEFT OUTER JOIN a table to this table.
- naturalLeftOuterJoin(String, QueryPart...) - Method in interface org.jooq.Table
-
NATURAL LEFT OUTER JOIN a table to this table.
- NATURALN - Static variable in class org.jooq.util.oracle.OracleDataType
-
- naturalRightOuterJoin(TableLike<?>) - Method in interface org.jooq.SelectJoinStep
-
- naturalRightOuterJoin(String) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the
FROM clause using
Table.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS.
- naturalRightOuterJoin(String, Object...) - Method in interface org.jooq.SelectJoinStep
-
- naturalRightOuterJoin(String, QueryPart...) - Method in interface org.jooq.SelectJoinStep
-
- naturalRightOuterJoin(TableLike<?>) - Method in interface org.jooq.Table
-
NATURAL RIGHT OUTER JOIN a table to this table.
- naturalRightOuterJoin(String) - Method in interface org.jooq.Table
-
NATURAL RIGHT OUTER JOIN a table to this table.
- naturalRightOuterJoin(String, Object...) - Method in interface org.jooq.Table
-
NATURAL RIGHT OUTER JOIN a table to this table.
- naturalRightOuterJoin(String, QueryPart...) - Method in interface org.jooq.Table
-
NATURAL RIGHT OUTER JOIN a table to this table.
- NCHAR - Static variable in class org.jooq.impl.SQLDataType
-
- NCHAR - Static variable in class org.jooq.util.ase.ASEDataType
-
- NCHAR - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- NCHAR - Static variable in class org.jooq.util.h2.H2DataType
-
- NCHAR - Static variable in class org.jooq.util.ingres.IngresDataType
-
- NCHAR - Static variable in class org.jooq.util.oracle.OracleDataType
-
- NCHAR - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NCHAR - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NCHAR - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- NCHARLARGEOBJECT - Static variable in class org.jooq.util.ingres.IngresDataType
-
- NCHARVARYING - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- NCLOB - Static variable in class org.jooq.impl.SQLDataType
-
- NCLOB - Static variable in class org.jooq.util.h2.H2DataType
-
- NCLOB - Static variable in class org.jooq.util.ingres.IngresDataType
-
- NCLOB - Static variable in class org.jooq.util.oracle.OracleDataType
-
- ne(T) - Method in interface org.jooq.Field
-
this !
- ne(Field<T>) - Method in interface org.jooq.Field
-
this !
- ne(Select<?>) - Method in interface org.jooq.Field
-
this !
- ne(Row1<T1>) - Method in interface org.jooq.Row1
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1) - Method in interface org.jooq.Row1
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>) - Method in interface org.jooq.Row1
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row2<T1, T2>) - Method in interface org.jooq.Row2
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2) - Method in interface org.jooq.Row2
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>) - Method in interface org.jooq.Row2
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row3<T1, T2, T3>) - Method in interface org.jooq.Row3
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2, T3) - Method in interface org.jooq.Row3
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>, Field<T3>) - Method in interface org.jooq.Row3
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row4<T1, T2, T3, T4>) - Method in interface org.jooq.Row4
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2, T3, T4) - Method in interface org.jooq.Row4
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>, Field<T3>, Field<T4>) - Method in interface org.jooq.Row4
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row5<T1, T2, T3, T4, T5>) - Method in interface org.jooq.Row5
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2, T3, T4, T5) - Method in interface org.jooq.Row5
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>) - Method in interface org.jooq.Row5
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row6<T1, T2, T3, T4, T5, T6>) - Method in interface org.jooq.Row6
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2, T3, T4, T5, T6) - Method in interface org.jooq.Row6
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>) - Method in interface org.jooq.Row6
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row7<T1, T2, T3, T4, T5, T6, T7>) - Method in interface org.jooq.Row7
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2, T3, T4, T5, T6, T7) - Method in interface org.jooq.Row7
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>, Field<T7>) - Method in interface org.jooq.Row7
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Row8<T1, T2, T3, T4, T5, T6, T7, T8>) - Method in interface org.jooq.Row8
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(T1, T2, T3, T4, T5, T6, T7, T8) - Method in interface org.jooq.Row8
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>, Field<T7>, Field<T8>) - Method in interface org.jooq.Row8
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(RowN) - Method in interface org.jooq.RowN
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Object...) - Method in interface org.jooq.RowN
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- ne(Field<?>...) - Method in interface org.jooq.RowN
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- neg() - Method in interface org.jooq.Field
-
Negate this field to get its negative value.
- neg() - Method in class org.jooq.types.DayToSecond
-
- neg() - Method in interface org.jooq.types.Interval
-
Negate the interval (change its sign)
- neg() - Method in class org.jooq.types.YearToMonth
-
- newRecord(UDT<R>) - Method in interface org.jooq.FactoryOperations
-
- newRecord(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Create a new
Record that can be inserted into the corresponding
table.
- newRecord(Table<R>, Object) - Method in interface org.jooq.FactoryOperations
-
Create a new pre-filled
Record that can be inserted into the
corresponding table.
- newRecord(UDT<R>) - Method in class org.jooq.impl.Factory
-
- newRecord(Table<R>) - Method in class org.jooq.impl.Factory
-
Create a new
Record that can be inserted into the corresponding
table.
- newRecord(Table<R>, Object) - Method in class org.jooq.impl.Factory
-
Create a new pre-filled
Record that can be inserted into the
corresponding table.
- newRecord(UDT<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- newRecord(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- newRecord(Table<R>, Object) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- newRecord() - Method in interface org.jooq.InsertQuery
-
Adds a new Record to the insert statement for multi-record inserts
Calling this method will cause subsequent calls to
StoreQuery.addValue(Field, Object) (and similar) to fill the next record.
- newRecord() - Method in interface org.jooq.InsertSetMoreStep
-
Add an additional record to the INSERT statement
- next(R) - Method in interface org.jooq.RecordHandler
-
A callback method indicating that the next record has been fetched.
- nextAlias() - Method in interface org.jooq.RenderContext
-
Return a new alias that is unique for the scope of one query.
- nextIndex() - Method in interface org.jooq.Context
-
Get the next bind index.
- nextval(Sequence<T>) - Method in interface org.jooq.FactoryOperations
-
Convenience method to fetch the NEXTVAL for a sequence directly from this
Factory's underlying JDBC
Connection
- nextval(Sequence<T>) - Method in class org.jooq.impl.Factory
-
Convenience method to fetch the NEXTVAL for a sequence directly from this
Factory's underlying JDBC
Connection
- nextval(Sequence<T>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- nextval() - Method in class org.jooq.impl.SequenceImpl
-
- nextval() - Method in interface org.jooq.Sequence
-
Increment the sequence and get the next value
- NO_MAPPING - Static variable in class org.jooq.SchemaMapping
-
Deprecated.
- 2.0.5 - Do not reuse this SchemaMapping!
- normalise(String) - Static method in class org.jooq.impl.FieldTypeHelper
-
- not() - Method in interface org.jooq.Condition
-
- not(Condition) - Static method in class org.jooq.impl.Factory
-
- notBetween(T, T) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
This is the same as calling
notBetween(minValue).and(maxValue)
SQL: this not between minValue and maxValue
- notBetween(Field<T>, Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
This is the same as calling
notBetween(minValue).and(maxValue)
SQL: this not between minValue and maxValue
- notBetween(T) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
SQL: this not between minValue and maxValue
- notBetween(Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
SQL: this not between minValue and maxValue
- notBetweenSymmetric(T, T) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)
SQL: this not between symmetric minValue and maxValue
- notBetweenSymmetric(Field<T>, Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)
SQL: this not between symmetric minValue and maxValue
- notBetweenSymmetric(T) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
SQL: this not between symmetric minValue and maxValue
- notBetweenSymmetric(Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against some bounds
SQL: this not between symmetric minValue and maxValue
- notEqual(T) - Method in interface org.jooq.Field
-
this !
- notEqual(Field<T>) - Method in interface org.jooq.Field
-
this !
- notEqual(Select<?>) - Method in interface org.jooq.Field
-
this !
- notEqual(Row1<T1>) - Method in interface org.jooq.Row1
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1) - Method in interface org.jooq.Row1
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>) - Method in interface org.jooq.Row1
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row2<T1, T2>) - Method in interface org.jooq.Row2
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2) - Method in interface org.jooq.Row2
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>) - Method in interface org.jooq.Row2
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row3<T1, T2, T3>) - Method in interface org.jooq.Row3
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2, T3) - Method in interface org.jooq.Row3
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>, Field<T3>) - Method in interface org.jooq.Row3
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row4<T1, T2, T3, T4>) - Method in interface org.jooq.Row4
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2, T3, T4) - Method in interface org.jooq.Row4
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>, Field<T3>, Field<T4>) - Method in interface org.jooq.Row4
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row5<T1, T2, T3, T4, T5>) - Method in interface org.jooq.Row5
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2, T3, T4, T5) - Method in interface org.jooq.Row5
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>) - Method in interface org.jooq.Row5
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row6<T1, T2, T3, T4, T5, T6>) - Method in interface org.jooq.Row6
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2, T3, T4, T5, T6) - Method in interface org.jooq.Row6
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>) - Method in interface org.jooq.Row6
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row7<T1, T2, T3, T4, T5, T6, T7>) - Method in interface org.jooq.Row7
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2, T3, T4, T5, T6, T7) - Method in interface org.jooq.Row7
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>, Field<T7>) - Method in interface org.jooq.Row7
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Row8<T1, T2, T3, T4, T5, T6, T7, T8>) - Method in interface org.jooq.Row8
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(T1, T2, T3, T4, T5, T6, T7, T8) - Method in interface org.jooq.Row8
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>, Field<T7>, Field<T8>) - Method in interface org.jooq.Row8
-
Compare this row value expression with another row value expression for non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(RowN) - Method in interface org.jooq.RowN
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Object...) - Method in interface org.jooq.RowN
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqual(Field<?>...) - Method in interface org.jooq.RowN
-
Compare this row value expression with another row value expression for
non-equality
Row non-equality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
- notEqualAll(Select<?>) - Method in interface org.jooq.Field
-
this !
- notEqualAll(T...) - Method in interface org.jooq.Field
-
this !
- notEqualAll(Field<T[]>) - Method in interface org.jooq.Field
-
this !
- notEqualAny(Select<?>) - Method in interface org.jooq.Field
-
this !
- notEqualAny(T...) - Method in interface org.jooq.Field
-
this !
- notEqualAny(Field<T[]>) - Method in interface org.jooq.Field
-
this !
- notEqualIgnoreCase(String) - Method in interface org.jooq.Field
-
lower(this) !
- notEqualIgnoreCase(Field<String>) - Method in interface org.jooq.Field
-
lower(this) !
- notEqualSome(Select<?>) - Method in interface org.jooq.Field
-
- notExists(Select<?>) - Static method in class org.jooq.impl.Factory
-
Create a not exists condition.
- notIn(Collection<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
Note that if any of the passed values is NULL, then the
condition will be NULL (or false, depending on
the dialect) as well.
- notIn(T...) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
Note that if any of the passed values is NULL, then the
condition will be NULL (or false, depending on
the dialect) as well.
- notIn(Field<?>...) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
Note that if any of the passed values is NULL, then the
condition will be NULL (or false, depending on
the dialect) as well.
- notIn(Select<?>) - Method in interface org.jooq.Field
-
Create a condition to check this field against a subquery
Note that the subquery must return exactly one field.
- notIn(Select<?>) - Method in interface org.jooq.Row
-
Compare this row value expression with a subselect for non-equality
Note that the subquery must return a table of the same degree as this row
value expression.
- notIn(Collection<? extends Row1<T1>>) - Method in interface org.jooq.Row1
-
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row1<T1>...) - Method in interface org.jooq.Row1
-
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row2<T1, T2>>) - Method in interface org.jooq.Row2
-
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row2<T1, T2>...) - Method in interface org.jooq.Row2
-
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row3<T1, T2, T3>>) - Method in interface org.jooq.Row3
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row3<T1, T2, T3>...) - Method in interface org.jooq.Row3
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row4<T1, T2, T3, T4>>) - Method in interface org.jooq.Row4
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row4<T1, T2, T3, T4>...) - Method in interface org.jooq.Row4
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row5<T1, T2, T3, T4, T5>>) - Method in interface org.jooq.Row5
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row5<T1, T2, T3, T4, T5>...) - Method in interface org.jooq.Row5
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row6<T1, T2, T3, T4, T5, T6>>) - Method in interface org.jooq.Row6
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row6<T1, T2, T3, T4, T5, T6>...) - Method in interface org.jooq.Row6
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row7<T1, T2, T3, T4, T5, T6, T7>>) - Method in interface org.jooq.Row7
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row7<T1, T2, T3, T4, T5, T6, T7>...) - Method in interface org.jooq.Row7
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends Row8<T1, T2, T3, T4, T5, T6, T7, T8>>) - Method in interface org.jooq.Row8
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Row8<T1, T2, T3, T4, T5, T6, T7, T8>...) - Method in interface org.jooq.Row8
-
Compare this row value expression with a set of row value expressions for equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(Collection<? extends RowN>) - Method in interface org.jooq.RowN
-
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notIn(RowN...) - Method in interface org.jooq.RowN
-
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
- notLike(Field<String>) - Method in interface org.jooq.Field
-
Create a condition to pattern-check this field against a field
SQL: this not like field
- notLike(Field<String>, char) - Method in interface org.jooq.Field
-
Create a condition to pattern-check this field against a field
SQL: this not like field escape 'e'
- notLike(String) - Method in interface org.jooq.Field
-
Create a condition to pattern-check this field against a value
SQL: this not like value
- notLike(String, char) - Method in interface org.jooq.Field
-
Create a condition to pattern-check this field against a value
SQL: this not like value escape 'e'
- notLikeIgnoreCase(Field<String>) - Method in interface org.jooq.Field
-
Create a condition to case-insensitively pattern-check this field against
a field
This translates to
this not ilike field in
SQLDialect.POSTGRES, or to
lower(this) not like lower(field) in all other dialects.
- notLikeIgnoreCase(Field<String>, char) - Method in interface org.jooq.Field
-
Create a condition to case-insensitively pattern-check this field against
a field
This translates to
this not ilike field in
SQLDialect.POSTGRES, or to
lower(this) not like lower(field) in all other dialects.
- notLikeIgnoreCase(String) - Method in interface org.jooq.Field
-
Create a condition to case-insensitively pattern-check this field against
a value
This translates to
this not ilike value in
SQLDialect.POSTGRES, or to
lower(this) not like lower(value) in all other dialects.
- notLikeIgnoreCase(String, char) - Method in interface org.jooq.Field
-
Create a condition to case-insensitively pattern-check this field against
a value
This translates to
this not ilike value in
SQLDialect.POSTGRES, or to
lower(this) not like lower(value) in all other dialects.
- notLikeRegex(String) - Method in interface org.jooq.Field
-
Create a condition to regex-pattern-check this field against a pattern
See
Field.likeRegex(String) for more details
- notLikeRegex(Field<String>) - Method in interface org.jooq.Field
-
Create a condition to regex-pattern-check this field against a pattern
See
Field.likeRegex(String) for more details
- noWait() - Method in interface org.jooq.SelectForUpdateWaitStep
-
Add a WAIT clause to the FOR UPDATE clause at
the end of the query.
- noWait() - Method in interface org.jooq.SimpleSelectForUpdateWaitStep
-
Add a WAIT clause to the FOR UPDATE clause at
the end of the query.
- NTEXT - Static variable in class org.jooq.util.h2.H2DataType
-
- NTEXT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NTEXT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- ntile(int) - Static method in class org.jooq.impl.Factory
-
The ntile([number]) over ([analytic clause]) function.
- NULL - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NULL_CHARACTER - Static variable in class org.jooq.tools.csv.CSVParser
-
This is the "null" character - if a value is set to this then it is
ignored.
- nullif(T) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- nullif(Field<T>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- nullif(T, T) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NULLIF(value, other) function
- nullif(T, Field<T>) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NULLIF(value, other) function
- nullif(Field<T>, T) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NULLIF(value, other) function
- nullif(Field<T>, Field<T>) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NULLIF(value, other) function
Returns the dialect's equivalent to NULLIF:
Oracle
NULLIF
- nullSafe(Field<T>) - Static method in class org.jooq.impl.Factory
-
Null-safety of a field
- nullSafe(Field<?>...) - Static method in class org.jooq.impl.Factory
-
Null-safety of a field
- nullSafeDataType(Field<T>) - Static method in class org.jooq.impl.Factory
-
Get a default data type if a field is null
- nullsFirst() - Method in interface org.jooq.SortField
-
Add a NULLS FIRST clause to this sort field
- nullsLast() - Method in interface org.jooq.SortField
-
Add a NULLS LAST clause to this sort field
- nullString(String) - Method in interface org.jooq.LoaderCSVOptionsStep
-
Specify the input string representation of NULL.
- NUMBER - Static variable in class org.jooq.util.h2.H2DataType
-
- NUMBER - Static variable in class org.jooq.util.oracle.OracleDataType
-
- NUMERIC - Static variable in class org.jooq.impl.SQLDataType
-
- NUMERIC - Static variable in class org.jooq.util.ase.ASEDataType
-
- NUMERIC - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- NUMERIC - Static variable in class org.jooq.util.derby.DerbyDataType
-
- NUMERIC - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- NUMERIC - Static variable in class org.jooq.util.h2.H2DataType
-
- NUMERIC - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- NUMERIC - Static variable in class org.jooq.util.ingres.IngresDataType
-
- NUMERIC - Static variable in class org.jooq.util.oracle.OracleDataType
-
- NUMERIC - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- NUMERIC - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NUMERIC - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NUMERIC - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- NVARCHAR - Static variable in class org.jooq.impl.SQLDataType
-
- NVARCHAR - Static variable in class org.jooq.util.ase.ASEDataType
-
- NVARCHAR - Static variable in class org.jooq.util.h2.H2DataType
-
- NVARCHAR - Static variable in class org.jooq.util.ingres.IngresDataType
-
- NVARCHAR - Static variable in class org.jooq.util.oracle.OracleDataType
-
- NVARCHAR - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NVARCHAR - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NVARCHAR - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- NVARCHAR2 - Static variable in class org.jooq.util.h2.H2DataType
-
- NVARCHAR2 - Static variable in class org.jooq.util.oracle.OracleDataType
-
- nvl(T) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- nvl(Field<T>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- nvl(T, T) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL(value, defaultValue) function
- nvl(T, Field<T>) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL(value, defaultValue) function
- nvl(Field<T>, T) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL(value, defaultValue) function
- nvl(Field<T>, Field<T>) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL(value, defaultValue) function
Returns the dialect's equivalent to NVL:
DB2
nvl2(Z, Z) - Method in interface org.jooq.
Field
-
This method is part of the pre-2.0 API.
- nvl2(Field<Z>, Field<Z>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- nvl2(Field<?>, Z, Z) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<?>, Z, Field<Z>) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<?>, Field<Z>, Z) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<?>, Field<Z>, Field<Z>) - Static method in class org.jooq.impl.Factory
-
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
Returns the dialect's equivalent to NVL2:
Oracle
NVL2
Other dialects:
CASE WHEN [value] IS NULL THEN [valueIfNull] ELSE [valueIfNotNull] END
O
- OBJECT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- OBJECT - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- ObjectFactory - Class in org.jooq.conf
-
This object contains factory methods for each
Java content interface and Java element interface
generated in the org.jooq.conf package.
- ObjectFactory() - Constructor for class org.jooq.conf.ObjectFactory
-
Create a new ObjectFactory that can be used to create new instances of schema derived classes for package: org.jooq.conf
- octetLength() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- octetLength(String) - Static method in class org.jooq.impl.Factory
-
Get the octet_length(field) function
This translates into any dialect
- octetLength(Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the octet_length(field) function
This translates into any dialect
- of(Field<?>...) - Method in interface org.jooq.SelectForUpdateOfStep
-
Add an OF clause to the FOR UPDATE clause at
the end of the query.
- of(Collection<Field<?>>) - Method in interface org.jooq.SelectForUpdateOfStep
-
Add an OF clause to the FOR UPDATE clause at
the end of the query.
- of(Table<?>...) - Method in interface org.jooq.SelectForUpdateOfStep
-
Add an OF clause to the FOR UPDATE clause at
the end of the query.
- of(Field<?>...) - Method in interface org.jooq.SimpleSelectForUpdateOfStep
-
Add an OF clause to the FOR UPDATE clause at
the end of the query.
- of(Collection<Field<?>>) - Method in interface org.jooq.SimpleSelectForUpdateOfStep
-
Add an OF clause to the FOR UPDATE clause at
the end of the query.
- of(Table<?>...) - Method in interface org.jooq.SimpleSelectForUpdateOfStep
-
Add an OF clause to the FOR UPDATE clause at
the end of the query.
- offset(int) - Method in interface org.jooq.SelectOffsetStep
-
Add an OFFSET clause to the query
If there is no LIMIT ..
- offset(Param<Integer>) - Method in interface org.jooq.SelectOffsetStep
-
Add an OFFSET clause to the query using a named parameter
If there is no LIMIT ..
- offset(int) - Method in interface org.jooq.SimpleSelectOffsetStep
-
Add an OFFSET clause to the query
If there is no LIMIT ..
- offset(Param<Integer>) - Method in interface org.jooq.SimpleSelectOffsetStep
-
Add an OFFSET clause to the query using a named parameter
If there is no LIMIT ..
- OID - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- OID - Static variable in class org.jooq.util.h2.H2DataType
-
- OID - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- OIDVECTOR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- on(Condition...) - Method in interface org.jooq.DivideByOnStep
-
Add a division condition to the DIVIDE BY clause
- on(String) - Method in interface org.jooq.DivideByOnStep
-
Add a division condition to the DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) - Method in interface org.jooq.DivideByOnStep
-
Add a division condition to the DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, QueryPart...) - Method in interface org.jooq.DivideByOnStep
-
Add a division condition to the DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(Condition...) - Method in interface org.jooq.MergeOnStep
-
Provide join conditions and proceed to the next step
- on(String) - Method in interface org.jooq.MergeOnStep
-
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) - Method in interface org.jooq.MergeOnStep
-
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, QueryPart...) - Method in interface org.jooq.MergeOnStep
-
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(Field<T>) - Method in interface org.jooq.PivotForStep
-
Add a list of fields to the PIVOT clause.
- on(Condition...) - Method in interface org.jooq.SelectOnStep
-
Add an ON clause to the previous JOIN
- on(String) - Method in interface org.jooq.SelectOnStep
-
Add an ON clause to the previous JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) - Method in interface org.jooq.SelectOnStep
-
Add an ON clause to the previous JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, QueryPart...) - Method in interface org.jooq.SelectOnStep
-
Add an ON clause to the previous JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(Condition...) - Method in interface org.jooq.TableOnStep
-
Add an ON clause to the JOIN
- on(String) - Method in interface org.jooq.TableOnStep
-
Add an ON clause to the JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) - Method in interface org.jooq.TableOnStep
-
Add an ON clause to the JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, QueryPart...) - Method in interface org.jooq.TableOnStep
-
Add an ON clause to the JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String) - Static method in class org.jooq.tools.reflect.Reflect
-
Wrap a class name.
- on(Class<?>) - Static method in class org.jooq.tools.reflect.Reflect
-
Wrap a class.
- on(Object) - Static method in class org.jooq.tools.reflect.Reflect
-
Wrap an object.
- onDuplicateKeyError() - Method in interface org.jooq.LoaderOptionsStep
-
Instruct the Loader to cause an error in loading if there
are any duplicate records.
- onDuplicateKeyIgnore() - Method in interface org.jooq.InsertOnDuplicateStep
-
Add an ON DUPLICATE KEY IGNORE clause to this insert query.
- onDuplicateKeyIgnore(boolean) - Method in interface org.jooq.InsertQuery
-
Whether an ON DUPLICATE KEY IGNORE clause should be added to
this INSERT statement.
- onDuplicateKeyIgnore() - Method in interface org.jooq.LoaderOptionsStep
-
Instruct the Loader to skip duplicate records if the main
unique key's value is already in the database.
- onDuplicateKeyUpdate() - Method in interface org.jooq.InsertOnDuplicateStep
-
Add an ON DUPLICATE KEY UPDATE clause to this insert query.
- onDuplicateKeyUpdate(boolean) - Method in interface org.jooq.InsertQuery
-
Whether a ON DUPLICATE KEY UPDATE clause should be added to
this INSERT statement.
- onDuplicateKeyUpdate() - Method in interface org.jooq.LoaderOptionsStep
-
Instruct the Loader to update duplicate records if the main
unique key's value is already in the database.
- one() - Static method in class org.jooq.impl.Factory
-
A 1 literal.
- onErrorAbort() - Method in interface org.jooq.LoaderOptionsStep
-
Instruct the Loader to abort loading after the first error
that might occur when inserting a record.
- onErrorIgnore() - Method in interface org.jooq.LoaderOptionsStep
-
Instruct the Loader to ignore any errors that might occur
when inserting a record.
- onKey() - Method in interface org.jooq.SelectOnStep
-
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
- onKey(TableField<?, ?>...) - Method in interface org.jooq.SelectOnStep
-
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
- onKey(ForeignKey<?, ?>) - Method in interface org.jooq.SelectOnStep
-
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- onKey() - Method in interface org.jooq.TableOnStep
-
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- onKey(TableField<?, ?>...) - Method in interface org.jooq.TableOnStep
-
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- onKey(ForeignKey<?, ?>) - Method in interface org.jooq.TableOnStep
-
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- Operator - Enum in org.jooq
-
An operator used for combining conditions
- or(Condition) - Method in interface org.jooq.Condition
-
Combine this condition with another one using the
Operator.OR
operator.
- or(String) - Method in interface org.jooq.Condition
-
Combine this condition with another one using the
Operator.OR
operator.
- or(String, Object...) - Method in interface org.jooq.Condition
-
Combine this condition with another one using the
Operator.OR
operator.
- or(String, QueryPart...) - Method in interface org.jooq.Condition
-
Combine this condition with another one using the
Operator.OR
operator.
- or(Condition) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
- or(String) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(String, Object...) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(String, QueryPart...) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(Condition) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String, Object...) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String, QueryPart...) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(Condition) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, QueryPart...) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, QueryPart...) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, QueryPart...) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, QueryPart...) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, QueryPart...) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String, Object...) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String, QueryPart...) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(Condition) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
- or(String) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(String, Object...) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(String, QueryPart...) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- OracleDataType<T> - Class in org.jooq.util.oracle
-
- OracleFactory - Class in org.jooq.util.oracle
-
- OracleFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.oracle.OracleFactory
-
- OracleFactory(Connection, Settings) - Constructor for class org.jooq.util.oracle.OracleFactory
-
Create a factory with connection and a settings configured
- OracleFactory(DataSource, Settings) - Constructor for class org.jooq.util.oracle.OracleFactory
-
Create a factory with a data source and a settings configured
- OracleFactory(Connection) - Constructor for class org.jooq.util.oracle.OracleFactory
-
Create a factory with connection
- OracleFactory(DataSource) - Constructor for class org.jooq.util.oracle.OracleFactory
-
Create a factory with a data source
- OracleFactory(Settings) - Constructor for class org.jooq.util.oracle.OracleFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- OracleFactory() - Constructor for class org.jooq.util.oracle.OracleFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- orderBy(Field<?>...) - Method in interface org.jooq.GroupConcatOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(SortField<?>...) - Method in interface org.jooq.GroupConcatOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(Collection<SortField<?>>) - Method in interface org.jooq.GroupConcatOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(Field<?>...) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(SortField<?>...) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(Collection<SortField<?>>) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(int...) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER BY clause to the query
Indexes start at 1 in SQL!
- orderBy(Field<?>...) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(SortField<?>...) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(Collection<SortField<?>>) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER BY clause to the query
- orderBy(int...) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER BY clause to the query
Indexes start at 1 in SQL!
- orderBy(Field<?>...) - Method in interface org.jooq.WindowOrderByStep
-
Add an ORDER BY clause to the window function.
- orderBy(SortField<?>...) - Method in interface org.jooq.WindowOrderByStep
-
Add an ORDER BY clause to the window function.
- orderBy(Collection<SortField<?>>) - Method in interface org.jooq.WindowOrderByStep
-
Add an ORDER BY clause to the window function.
- OrderedAggregateFunction<T> - Interface in org.jooq
-
An ordered aggregate function.
- OrderProvider - Interface in org.jooq
-
Deprecated.
- 2.6.0 [#1881] - This type will be removed from the public API,
soon. Its methods will be pushed down into extending interfaces.
Do not reference this type directly.
- orderSiblingsBy(Field<?>...) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(SortField<?>...) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(Collection<SortField<?>>) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(int...) - Method in interface org.jooq.SelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(Field<?>...) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(SortField<?>...) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(Collection<SortField<?>>) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orderSiblingsBy(int...) - Method in interface org.jooq.SimpleSelectOrderByStep
-
Add an ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves.
- orExists(Select<?>) - Method in interface org.jooq.Condition
-
Combine this condition with an EXISTS clause using the
Operator.OR operator.
- orExists(Select<?>) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator
- orExists(Select<?>) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with an
EXISTS
clause using the
Operator.OR operator.
- orExists(Select<?>) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with an
EXISTS
clause using the
Operator.OR operator.
- orExists(Select<?>) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator
- org.jooq - package org.jooq
-
The org.jooq package contains jOOQ's public API
This package mostly contains interfaces that are implemented by the
org.jooq.impl package.
- org.jooq.conf - package org.jooq.conf
-
- org.jooq.exception - package org.jooq.exception
-
The org.jooq.exception package contains jOOQ's exceptions
- org.jooq.impl - package org.jooq.impl
-
The
org.jooq.impl package contains jOOQ's implementation classes
This package provides implementations for the jOOQ API from
org.jooq, whose interfaces are constructed mostly through the
Factory class, which hides implementation facts from
the public API
- org.jooq.tools - package org.jooq.tools
-
The org.jooq.tools package contains jOOQ's public utilities
- org.jooq.tools.csv - package org.jooq.tools.csv
-
The org.jooq.tools.csv package contains parts of OpenCSV
jOOQ has no external dependencies.
- org.jooq.tools.jdbc - package org.jooq.tools.jdbc
-
The org.jooq.tools.jdbc package contains compatibility classes
to bridge between JDBC 4.0 and JDBC 4.1
- org.jooq.tools.json - package org.jooq.tools.json
-
The org.jooq.tools.json package contains parts of JSON Simple
jOOQ has no external dependencies.
- org.jooq.tools.reflect - package org.jooq.tools.reflect
-
The org.jooq.tools.reflect package contains parts of jOOR
jOOQ has no external dependencies.
- org.jooq.tools.unsigned - package org.jooq.tools.unsigned
-
The org.jooq.tools.unsigned package contains parts of jOOU
jOOQ has no external dependencies.
- org.jooq.types - package org.jooq.types
-
The org.jooq.tools.types package contains data types that are
missing in JDBC
JDBC is missing some important SQL data types, such as INTERVAL types, or
UNSIGNED NUMBER types.
- org.jooq.util.ase - package org.jooq.util.ase
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.CUBRID dialect
- org.jooq.util.cubrid - package org.jooq.util.cubrid
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.ASE dialect
- org.jooq.util.db2 - package org.jooq.util.db2
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.DB2 dialect
- org.jooq.util.derby - package org.jooq.util.derby
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.DERBY dialect
- org.jooq.util.firebird - package org.jooq.util.firebird
-
- org.jooq.util.h2 - package org.jooq.util.h2
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.H2 dialect
- org.jooq.util.hsqldb - package org.jooq.util.hsqldb
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.HSQLDB dialect
- org.jooq.util.ingres - package org.jooq.util.ingres
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.INGRES dialect
- org.jooq.util.mysql - package org.jooq.util.mysql
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.ORACLE dialect
- org.jooq.util.oracle - package org.jooq.util.oracle
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.MYSQL dialect
- org.jooq.util.postgres - package org.jooq.util.postgres
-
- org.jooq.util.sqlite - package org.jooq.util.sqlite
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.SQLITE dialect
- org.jooq.util.sqlserver - package org.jooq.util.sqlserver
-
- org.jooq.util.sybase - package org.jooq.util.sybase
-
The
org.jooq.util.ase package contains classes related to the
SQLDialect.SYBASE dialect
- ORGAPACHEDERBYCATALOGINDEXDESCRIPTOR - Static variable in class org.jooq.util.derby.DerbyDataType
-
- ORGAPACHEDERBYCATALOGTYPEDESCRIPTOR - Static variable in class org.jooq.util.derby.DerbyDataType
-
- original() - Method in class org.jooq.impl.TableRecordImpl
-
- original() - Method in interface org.jooq.Record
-
Get this record containing the original values as fetched from the
database.
- original() - Method in interface org.jooq.TableRecord
-
Get this record containing the original values as fetched from the
database.
- orNot(Condition) - Method in interface org.jooq.Condition
-
Combine this condition with a negated other one using the
Operator.OR operator.
- orNot(Condition) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator
- orNot(Condition) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator.
- orNot(Condition) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator.
- orNot(Condition) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator
- orNotExists(Select<?>) - Method in interface org.jooq.Condition
-
Combine this condition with a NOT EXIST clause using the
Operator.OR operator.
- orNotExists(Select<?>) - Method in interface org.jooq.DeleteConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator
- orNotExists(Select<?>) - Method in interface org.jooq.DivideByOnConditionStep
-
Combine the currently assembled conditions with a
NOT EXISTS
clause using the
Operator.OR operator.
- orNotExists(Select<?>) - Method in interface org.jooq.MergeOnConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) - Method in interface org.jooq.SelectConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) - Method in interface org.jooq.SelectHavingConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) - Method in interface org.jooq.SelectOnConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) - Method in interface org.jooq.SimpleSelectConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) - Method in interface org.jooq.TableOnConditionStep
-
Combine the currently assembled conditions with a
NOT EXISTS
clause using the
Operator.OR operator.
- orNotExists(Select<?>) - Method in interface org.jooq.UpdateConditionStep
-
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator
- OTHER - Static variable in class org.jooq.impl.SQLDataType
-
- OTHER - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- OTHER - Static variable in class org.jooq.util.h2.H2DataType
-
- OTHER - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- otherwise(T) - Method in interface org.jooq.CaseConditionStep
-
Add an else clause to the already constructed case statement
- otherwise(Field<T>) - Method in interface org.jooq.CaseConditionStep
-
Add an else clause to the already constructed case statement
- otherwise(T) - Method in interface org.jooq.CaseWhenStep
-
Add an else clause to the already constructed case statement
- otherwise(Field<T>) - Method in interface org.jooq.CaseWhenStep
-
Add an else clause to the already constructed case statement
- output - Variable in class org.jooq.conf.MappedSchema
-
- output - Variable in class org.jooq.conf.MappedTable
-
- over() - Method in interface org.jooq.AggregateFunction
-
Turn this aggregate function into a window function.
- over() - Method in interface org.jooq.WindowBeforeOverStep
-
Add an OVER clause
- over() - Method in interface org.jooq.WindowOverStep
-
Add an OVER clause
- overlaps(T1, T2) - Method in interface org.jooq.Row2
-
Check if this row value expression overlaps another row value expression
The SQL standard specifies a temporal OVERLAPS predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2-degree row value expression comparisons,
by simulating them as such
-- This predicate
(A, B) OVERLAPS (C, D)
-- can be simulated as such
(C <= B) AND (A <= D)
- overlaps(Field<T1>, Field<T2>) - Method in interface org.jooq.Row2
-
Check if this row value expression overlaps another row value expression
The SQL standard specifies a temporal OVERLAPS predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2-degree row value expression comparisons,
by simulating them as such
-- This predicate
(A, B) OVERLAPS (C, D)
-- can be simulated as such
(C <= B) AND (A <= D)
- overlaps(Row2<T1, T2>) - Method in interface org.jooq.Row2
-
Check if this row value expression overlaps another row value expression
The SQL standard specifies a temporal OVERLAPS predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2-degree row value expression comparisons,
by simulating them as such
-- This predicate
(A, B) OVERLAPS (C, D)
-- can be simulated as such
(C <= B) AND (A <= D)
P
- Package - Interface in org.jooq
-
A container for stored procedures and functions
This is only supported in the
SQLDialect.ORACLE dialect
- PackageImpl - Class in org.jooq.impl
-
A default implementation for packages (containers of stored procedures and
functions)
Currently, this is only supported for the
SQLDialect.ORACLE dialect.
- PackageImpl(String, Schema) - Constructor for class org.jooq.impl.PackageImpl
-
- param(String) - Static method in class org.jooq.impl.Factory
-
- param(String, Class<? extends T>) - Static method in class org.jooq.impl.Factory
-
Create a named parameter with a defined type and no initial value.
- param(String, DataType<T>) - Static method in class org.jooq.impl.Factory
-
Create a named parameter with a defined type and no initial value.
- param(String, T) - Static method in class org.jooq.impl.Factory
-
Create a named parameter with an initial value.
- Param<T> - Interface in org.jooq
-
A named parameter and/or bind value.
- Parameter<T> - Interface in org.jooq
-
A parameter to a stored procedure or function.
- parse(String) - Static method in class org.jooq.util.postgres.PGobjectParser
-
- parseLine(String) - Method in class org.jooq.tools.csv.CSVParser
-
- parseLineMulti(String) - Method in class org.jooq.tools.csv.CSVParser
-
- partitionBy(Field<?>...) - Method in interface org.jooq.SelectJoinPartitionByStep
-
Add a PARTITION BY clause to the right hand side of the
OUTER JOIN keywords
- partitionBy(Collection<? extends Field<?>>) - Method in interface org.jooq.SelectJoinPartitionByStep
-
Add a PARTITION BY clause to the right hand side of the
OUTER JOIN keywords
- partitionBy(Field<?>...) - Method in interface org.jooq.TablePartitionByStep
-
Add a PARTITION BY clause to the right hand side of the
OUTER JOIN keywords
- partitionBy(Collection<? extends Field<?>>) - Method in interface org.jooq.TablePartitionByStep
-
Add a PARTITION BY clause to the right hand side of the
OUTER JOIN keywords
- partitionBy(Field<?>...) - Method in interface org.jooq.WindowPartitionByStep
-
Add a PARTITION BY clause to the window functions.
- partitionByOne() - Method in interface org.jooq.WindowPartitionByStep
-
Add a PARTITION BY 1 clause to the window functions, where
such a clause is required by the syntax of an RDBMS.
- password(String) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific PASSWORD() function
- password(Field<String>) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific PASSWORD() function
- peekAlias() - Method in interface org.jooq.RenderContext
-
- peekIndex() - Method in interface org.jooq.Context
-
Peek the next bind index.
- percentRank() - Static method in class org.jooq.impl.Factory
-
The precent_rank() over ([analytic clause]) function.
- PGIntervalConverter - Class in org.jooq.util.postgres
-
- PGIntervalConverter() - Constructor for class org.jooq.util.postgres.PGIntervalConverter
-
Deprecated.
- PGobjectParser - Class in org.jooq.util.postgres
-
- PGobjectParser() - Constructor for class org.jooq.util.postgres.PGobjectParser
-
Deprecated.
- pi() - Static method in class org.jooq.impl.Factory
-
The PI literal.
- pivot(Field<?>...) - Method in interface org.jooq.Table
-
Create a new
TABLE reference from this table, pivoting it
into another form
This has been observed to work with
SQLDialect.ORACLE
SQLDialect.SQLSERVER (not yet officially supported)
Other dialects by using some means of simulation (not yet officially
supported)
- pivot(Collection<? extends Field<?>>) - Method in interface org.jooq.Table
-
Create a new
TABLE reference from this table, pivoting it
into another form
For more details, see
Table.pivot(Field...)
- PivotForStep - Interface in org.jooq
-
This type is used for the Oracle
PIVOT clause DSL API, pivoting
Table objects to new tables.
- PivotInStep<T> - Interface in org.jooq
-
This type is used for the Oracle
PIVOT clause DSL API, pivoting
Table objects to new tables.
- PLS_INTEGER - Static variable in class org.jooq.util.oracle.OracleDataType
-
- position(String) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- position(Field<String>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- position(String, String) - Static method in class org.jooq.impl.Factory
-
Get the position(in, search) function
- position(String, Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the position(in, search) function
- position(Field<String>, String) - Static method in class org.jooq.impl.Factory
-
Get the position(in, search) function
- position(Field<String>, Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the position(in, search) function
This renders the position or any equivalent function:
position([search] in [in]) or
locate([in], [search]) or
locate([search], [in]) or
instr([in], [search]) or
charindex([search], [in])
- POSITIVE - Static variable in class org.jooq.util.oracle.OracleDataType
-
- POSITIVEN - Static variable in class org.jooq.util.oracle.OracleDataType
-
- PostgresDataType<T> - Class in org.jooq.util.postgres
-
- PostgresFactory - Class in org.jooq.util.postgres
-
- PostgresFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.postgres.PostgresFactory
-
- PostgresFactory(Connection, Settings) - Constructor for class org.jooq.util.postgres.PostgresFactory
-
Create a factory with connection and a settings configured
- PostgresFactory(DataSource, Settings) - Constructor for class org.jooq.util.postgres.PostgresFactory
-
Create a factory with a data source and a settings configured
- PostgresFactory(Connection) - Constructor for class org.jooq.util.postgres.PostgresFactory
-
Create a factory with connection
- PostgresFactory(DataSource) - Constructor for class org.jooq.util.postgres.PostgresFactory
-
Create a factory with a data source
- PostgresFactory(Settings) - Constructor for class org.jooq.util.postgres.PostgresFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- PostgresFactory() - Constructor for class org.jooq.util.postgres.PostgresFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- PostgresUtils - Class in org.jooq.util.postgres
-
A collection of utilities to cover the Postgres JDBC driver's missing
implementations.
- PostgresUtils() - Constructor for class org.jooq.util.postgres.PostgresUtils
-
- power(Number) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- power(Number, Number) - Static method in class org.jooq.impl.Factory
-
Get the power(field, exponent) function
- power(Field<? extends Number>, Number) - Static method in class org.jooq.impl.Factory
-
Get the power(field, exponent) function
- power(Number, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the power(field, exponent) function
- power(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the power(field, exponent) function
This renders the power function where available:
power([field], [exponent]) ... or simulates it
elsewhere using ln and exp:
exp(ln([field]) * [exponent])
- prepareEnd(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- prepareEnd(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- prepareEnd(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- prepareStart(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- prepareStart(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- prepareStart(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- prior(Field<T>) - Static method in class org.jooq.impl.Factory
-
Add the Oracle-specific PRIOR unary operator before a field
(to be used along with CONNECT BY clauses)
- processed() - Method in interface org.jooq.Loader
-
The number of processed rows
- provideFor(Configuration) - Method in interface org.jooq.ConfigurationProvider
-
Deprecated.
Provide a
Configuration to jOOQ, given a deserialised
Configuration.
- provideFor(Configuration) - Static method in class org.jooq.ConfigurationRegistry
-
Deprecated.
Communicate to client-registered
ConfigurationProvider's
This method is used by jOOQ retrieve a client-provided
Configuration.
Q
- qualify() - Method in interface org.jooq.RenderContext
-
Whether query parts should render qualified names or not
- qualify(boolean) - Method in interface org.jooq.RenderContext
-
- query() - Method in interface org.jooq.ExecuteContext
-
The jOOQ
Query that is being executed or
null if the
query is unknown, if it is a batch query, or if there was no jOOQ
Query
- query(String) - Method in interface org.jooq.FactoryOperations
-
Create a new query holding plain SQL.
- query(String, Object...) - Method in interface org.jooq.FactoryOperations
-
Create a new query holding plain SQL.
- query(String, QueryPart...) - Method in interface org.jooq.FactoryOperations
-
Create a new query holding plain SQL.
- query(String) - Method in class org.jooq.impl.Factory
-
Create a new query holding plain SQL.
- query(String, Object...) - Method in class org.jooq.impl.Factory
-
Create a new query holding plain SQL.
- query(String, QueryPart...) - Method in class org.jooq.impl.Factory
-
Create a new query holding plain SQL.
- query(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- query(String, Object...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- query(String, QueryPart...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- query() - Method in interface org.jooq.LoaderError
-
The query whose execution failed
- Query - Interface in org.jooq
-
Any query
- QueryPart - Interface in org.jooq
-
The common base type for all objects that can be used for query composition.
- QueryPartInternal - Interface in org.jooq
-
Base functionality declaration for all query objects
This interface is for JOOQ INTERNAL USE only.
- queryTimeout(int) - Method in interface org.jooq.Query
-
Specify the query timeout for the underlying JDBC
Statement
- queryTimeout(int) - Method in interface org.jooq.ResultQuery
-
Specify the query timeout for the underlying JDBC
Statement
- quote(char) - Method in interface org.jooq.LoaderCSVOptionsStep
-
Specify the quote character.
R
- rad() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- rad(Number) - Static method in class org.jooq.impl.Factory
-
Calculate radians from degrees from this field
- rad(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Calculate radians from degrees from this field
This renders the degrees function where available:
degrees([field]) ... or simulates it elsewhere:
[field] * PI / 180
- rand() - Static method in class org.jooq.impl.Factory
-
Get the rand() function
- rank() - Static method in class org.jooq.impl.Factory
-
The rank_over() over ([analytic clause]) function.
- RAW - Static variable in class org.jooq.util.h2.H2DataType
-
- RAW - Static variable in class org.jooq.util.oracle.OracleDataType
-
- readAll() - Method in class org.jooq.tools.csv.CSVReader
-
Reads the entire file into a List with each element being a String[] of
tokens.
- readNext() - Method in class org.jooq.tools.csv.CSVReader
-
Reads the next line from the buffer and converts to a string array.
- readSQL(SQLInput, String) - Method in class org.jooq.impl.UDTRecordImpl
-
- REAL - Static variable in class org.jooq.impl.SQLDataType
-
- REAL - Static variable in class org.jooq.util.ase.ASEDataType
-
- REAL - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- REAL - Static variable in class org.jooq.util.db2.DB2DataType
-
- REAL - Static variable in class org.jooq.util.derby.DerbyDataType
-
- REAL - Static variable in class org.jooq.util.h2.H2DataType
-
- REAL - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- REAL - Static variable in class org.jooq.util.ingres.IngresDataType
-
- REAL - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- REAL - Static variable in class org.jooq.util.oracle.OracleDataType
-
- REAL - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- REAL - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- REAL - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- REAL - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- record() - Method in interface org.jooq.ExecuteContext
-
The last record that was fetched from the result set, or
null if no record has been fetched.
- record(Record) - Method in interface org.jooq.ExecuteContext
-
Calling this has no effect.
- Record - Interface in org.jooq
-
A wrapper for database result records returned by
SelectQuery
- recordEnd(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- recordEnd(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- recordEnd(ExecuteContext) - Method in class org.jooq.tools.LoggerListener
-
- recordEnd(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- RecordHandler<R extends Record> - Interface in org.jooq
-
A
RecordHandler is a handler that can receive
Record
objects, when fetching data from the database.
- RecordMapper<R extends Record,E> - Interface in org.jooq
-
A
RecordMapper is a mapper that can receive
Record
objects, when fetching data from the database, transforming them into a
custom type
<E>
- recordStart(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- recordStart(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- recordStart(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- REF_CURSOR - Static variable in class org.jooq.util.oracle.OracleDataType
-
- REFCURSOR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- Reflect - Class in org.jooq.tools.reflect
-
A wrapper for an
Object or
Class upon which reflective calls
can be made.
- ReflectException - Exception in org.jooq.tools.reflect
-
- ReflectException(String) - Constructor for exception org.jooq.tools.reflect.ReflectException
-
- ReflectException(String, Throwable) - Constructor for exception org.jooq.tools.reflect.ReflectException
-
- ReflectException() - Constructor for exception org.jooq.tools.reflect.ReflectException
-
- ReflectException(Throwable) - Constructor for exception org.jooq.tools.reflect.ReflectException
-
- refresh() - Method in class org.jooq.impl.UpdatableRecordImpl
-
- refresh() - Method in interface org.jooq.UpdatableRecord
-
Refresh this record from the database, based on the value of the primary
key or main unique key.
- refreshUsing(TableField<R, ?>...) - Method in class org.jooq.impl.TableRecordImpl
-
- refreshUsing(TableField<R, ?>...) - Method in interface org.jooq.TableRecord
-
Deprecated.
- 2.5.0 [#1736] - These methods will be made part of jOOQ's
internal API soon. Do not reuse these methods.
- REGPROC - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- regrAvgX(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_AVGX linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrAvgY(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_AVGY linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrCount(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_COUNT linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrIntercept(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_INTERCEPT linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrR2(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_R2 linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrSlope(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_SLOPE linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrSXX(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_SXX linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrSXY(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_SXY linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- regrSYY(Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the REGR_SYY linear regression function
The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs.
- releaseSavepoint(Savepoint) - Method in interface org.jooq.FactoryOperations
-
- releaseSavepoint(Savepoint) - Method in class org.jooq.impl.Factory
-
- releaseSavepoint(Savepoint) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- render(QueryPart) - Method in interface org.jooq.FactoryOperations
-
Render a QueryPart in the context of this factory
This is the same as calling renderContext().render(part)
- render(QueryPart) - Method in class org.jooq.impl.Factory
-
Render a QueryPart in the context of this factory
This is the same as calling renderContext().render(part)
- render(QueryPart) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- render() - Method in interface org.jooq.RenderContext
-
Render the context's underlying SQL statement
- render(QueryPart) - Method in interface org.jooq.RenderContext
-
Render a query part in a new context derived from this one.
- renderContext() - Method in class org.jooq.impl.Factory
-
- RenderContext - Interface in org.jooq
-
The render context is used for rendering
QueryPart's to SQL.
- RenderContext.CastMode - Enum in org.jooq
-
The cast mode for bind values.
- renderEnd(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- renderEnd(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- renderEnd(ExecuteContext) - Method in class org.jooq.tools.LoggerListener
-
- renderEnd(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- renderFormatted - Variable in class org.jooq.conf.Settings
-
- renderInlined(QueryPart) - Method in interface org.jooq.FactoryOperations
-
Render a QueryPart in the context of this factory, inlining all bind
variables.
- renderInlined(QueryPart) - Method in class org.jooq.impl.Factory
-
Render a QueryPart in the context of this factory, inlining all bind
variables.
- renderInlined(QueryPart) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- RenderKeywordStyle - Enum in org.jooq.conf
-
Java class for RenderKeywordStyle.
- renderKeywordStyle - Variable in class org.jooq.conf.Settings
-
- RenderMapping - Class in org.jooq.conf
-
Java class for RenderMapping complex type.
- RenderMapping() - Constructor for class org.jooq.conf.RenderMapping
-
- renderMapping - Variable in class org.jooq.conf.Settings
-
- renderNamedParams(QueryPart) - Method in interface org.jooq.FactoryOperations
-
Render a QueryPart in the context of this factory, rendering bind
variables as named parameters.
- renderNamedParams(QueryPart) - Method in class org.jooq.impl.Factory
-
Render a QueryPart in the context of this factory, rendering bind
variables as named parameters.
- renderNamedParams(QueryPart) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- RenderNameStyle - Enum in org.jooq.conf
-
Java class for RenderNameStyle.
- renderNameStyle - Variable in class org.jooq.conf.Settings
-
- renderSchema - Variable in class org.jooq.conf.Settings
-
- renderStart(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- renderStart(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- renderStart(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- repeat(Number) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- repeat(Field<? extends Number>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- repeat(String, int) - Static method in class org.jooq.impl.Factory
-
Get the repeat(field, count) function
- repeat(String, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the repeat(field, count) function
- repeat(Field<String>, int) - Static method in class org.jooq.impl.Factory
-
Get the repeat(count) function
- repeat(Field<String>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the repeat(field, count) function
This renders the repeat or replicate function where available:
repeat([field], [count]) or
replicate([field], [count]) ... or simulates it elsewhere
using rpad and length, which may be simulated as well, depending on the
RDBMS:
rpad([field], length([field]) * [count], [field])
In
SQLDialect.SQLITE, this is simulated as such:
replace(substr(quote(zeroblob(([count] + 1) / 2)), 3, [count]), '0', [field])
- replace(Field<String>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- replace(String) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- replace(Field<String>, Field<String>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- replace(String, String) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- replace(Field<String>, String) - Static method in class org.jooq.impl.Factory
-
Get the replace(field, search) function
- replace(Field<String>, Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the replace(field, search) function
This renders the replace or str_replace function where available:
replace([field], [search]) or
str_replace([field], [search]) ... or simulates it elsewhere
using the three-argument replace function:
replace([field], [search], '')
- replace(Field<String>, String, String) - Static method in class org.jooq.impl.Factory
-
Get the replace(field, search, replace) function
- replace(Field<String>, Field<String>, Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the replace(field, search, replace) function
This renders the replace or str_replace function:
replace([field], [search]) or
str_replace([field], [search])
- replace(String, String, String) - Static method in class org.jooq.tools.StringUtils
-
Replaces all occurrences of a String within another String.
- replace(String, String, String, int) - Static method in class org.jooq.tools.StringUtils
-
Replaces a String with another String inside a larger String,
for the first max values of the search String.
- replaceEach(String, String[], String[]) - Static method in class org.jooq.tools.StringUtils
-
Replaces all occurrences of Strings within another String.
- respectNulls() - Method in interface org.jooq.WindowIgnoreNullsStep
-
Add a RESPECT NULLS clause to the window function.
- result() - Method in interface org.jooq.ExecuteContext
-
The last result that was fetched from the result set, or
null if no result has been fetched.
- result(Result<?>) - Method in interface org.jooq.ExecuteContext
-
Calling this has no effect.
- RESULT - Static variable in class org.jooq.impl.SQLDataType
-
The
ResultSet type
This is not a SQL or JDBC standard.
- Result<R extends Record> - Interface in org.jooq
-
- resultEnd(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- resultEnd(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- resultEnd(ExecuteContext) - Method in class org.jooq.tools.LoggerListener
-
- resultEnd(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- resultQuery(String) - Method in interface org.jooq.FactoryOperations
-
Create a new query holding plain SQL.
- resultQuery(String, Object...) - Method in interface org.jooq.FactoryOperations
-
Create a new query holding plain SQL.
- resultQuery(String, QueryPart...) - Method in interface org.jooq.FactoryOperations
-
Create a new query holding plain SQL.
- resultQuery(String) - Method in class org.jooq.impl.Factory
-
Create a new query holding plain SQL.
- resultQuery(String, Object...) - Method in class org.jooq.impl.Factory
-
Create a new query holding plain SQL.
- resultQuery(String, QueryPart...) - Method in class org.jooq.impl.Factory
-
Create a new query holding plain SQL.
- resultQuery(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- resultQuery(String, Object...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- resultQuery(String, QueryPart...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- ResultQuery<R extends Record> - Interface in org.jooq
-
A query that can return results.
- resultSet() - Method in interface org.jooq.Cursor
-
Get the
Cursor's underlying
ResultSet
If you modify the underlying
ResultSet, the
Cursor may be affected and in some cases, rendered unusable.
- resultSet() - Method in interface org.jooq.ExecuteContext
-
The
ResultSet that is being fetched or
null if the
result set is unknown or if no result set is being fetched.
- resultSet(ResultSet) - Method in interface org.jooq.ExecuteContext
-
Override the
ResultSet that is being fetched.
- resultStart(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- resultStart(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- resultStart(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- returning(Field<?>...) - Method in interface org.jooq.DivideByReturningStep
-
Specify the fields that you want the division to return from the dividend
- returning(Collection<? extends Field<?>>) - Method in interface org.jooq.DivideByReturningStep
-
Specify the fields that you want the division to return from the dividend
- returning() - Method in interface org.jooq.InsertReturningStep
-
Configure the INSERT statement to return all fields in
R.
- returning(Field<?>...) - Method in interface org.jooq.InsertReturningStep
-
Configure the INSERT statement to return a list of fields in
R.
- returning(Collection<? extends Field<?>>) - Method in interface org.jooq.InsertReturningStep
-
Configure the INSERT statement to return a list of fields in
R.
- rightOuterJoin(TableLike<?>) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the
FROM clause using
Table.rightOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it
- rightOuterJoin(String) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the
FROM clause using
Table.rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- rightOuterJoin(String, Object...) - Method in interface org.jooq.SelectJoinStep
-
- rightOuterJoin(String, QueryPart...) - Method in interface org.jooq.SelectJoinStep
-
- rightOuterJoin(TableLike<?>) - Method in interface org.jooq.Table
-
RIGHT OUTER JOIN a table to this table.
- rightOuterJoin(String) - Method in interface org.jooq.Table
-
RIGHT OUTER JOIN a table to this table.
- rightOuterJoin(String, Object...) - Method in interface org.jooq.Table
-
RIGHT OUTER JOIN a table to this table.
- rightOuterJoin(String, QueryPart...) - Method in interface org.jooq.Table
-
RIGHT OUTER JOIN a table to this table.
- rightPad(String, int) - Static method in class org.jooq.tools.StringUtils
-
Right pad a String with spaces (' ').
- rightPad(String, int, char) - Static method in class org.jooq.tools.StringUtils
-
Right pad a String with a specified character.
- rightPad(String, int, String) - Static method in class org.jooq.tools.StringUtils
-
Right pad a String with a specified String.
- rollback(Savepoint) - Method in interface org.jooq.FactoryOperations
-
- rollback() - Method in interface org.jooq.FactoryOperations
-
- rollback() - Method in class org.jooq.impl.Factory
-
- rollback(Savepoint) - Method in class org.jooq.impl.Factory
-
- rollback(Savepoint) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- rollback() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- rollup(Field<?>...) - Static method in class org.jooq.impl.Factory
-
Create a ROLLUP(field1, field2, .., fieldn) grouping field
This has been observed to work with the following databases:
CUBRID (simulated using the GROUP BY ..
- round() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- round(int) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- round(T) - Static method in class org.jooq.impl.Factory
-
Get rounded value of a numeric field: round(field)
- round(Field<T>) - Static method in class org.jooq.impl.Factory
-
Get rounded value of a numeric field: round(field)
This renders the round function where available:
round([field]) or
round([field], 0)
... or simulates it elsewhere using floor and ceil
- round(T, int) - Static method in class org.jooq.impl.Factory
-
Get rounded value of a numeric field: round(field, decimals)
- round(Field<T>, int) - Static method in class org.jooq.impl.Factory
-
Get rounded value of a numeric field: round(field, decimals)
This renders the round function where available:
round([field], [decimals])
... or simulates it elsewhere using floor and ceil
- routine() - Method in interface org.jooq.ExecuteContext
-
The jOOQ
Routine that is being executed or
null if
the query is unknown or if there was no jOOQ
Routine
- Routine<T> - Interface in org.jooq
-
A routine is a callable object in your RDBMS.
- row(T1) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 1
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 2
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2, T3) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 3
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2, T3, T4) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 4
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2, T3, T4, T5) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 5
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2, T3, T4, T5, T6) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 6
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2, T3, T4, T5, T6, T7) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 7
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(T1, T2, T3, T4, T5, T6, T7, T8) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 8
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Object...) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree N > 8
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 1
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 2
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>, Field<T3>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 3
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>, Field<T3>, Field<T4>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 4
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 5
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 6
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>, Field<T7>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 7
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<T1>, Field<T2>, Field<T3>, Field<T4>, Field<T5>, Field<T6>, Field<T7>, Field<T8>) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree 8
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row(Field<?>...) - Static method in class org.jooq.impl.Factory
-
Create a row value expression of degree N > 8
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- row() - Method in interface org.jooq.LoaderError
-
The row data that caused the error
- Row - Interface in org.jooq
-
A model type for a row value expression.
- ROW - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- Row1<T1> - Interface in org.jooq
-
A model type for a row value expression with degree 1
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- Row2<T1,T2> - Interface in org.jooq
-
A model type for a row value expression with degree 2
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- Row3<T1,T2,T3> - Interface in org.jooq
-
A model type for a row value expression with degree 3
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases.
- Row4<T1,T2,T3,T4> - Interface in org.jooq
-
A model type for a row value expression with degree 4
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases.
- Row5<T1,T2,T3,T4,T5> - Interface in org.jooq
-
A model type for a row value expression with degree 5
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases.
- Row6<T1,T2,T3,T4,T5,T6> - Interface in org.jooq
-
A model type for a row value expression with degree 6
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases.
- Row7<T1,T2,T3,T4,T5,T6,T7> - Interface in org.jooq
-
A model type for a row value expression with degree 7
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases.
- Row8<T1,T2,T3,T4,T5,T6,T7,T8> - Interface in org.jooq
-
A model type for a row value expression with degree 8
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases.
- ROWID - Static variable in class org.jooq.util.db2.DB2DataType
-
- rowid() - Static method in class org.jooq.util.oracle.OracleFactory
-
Retrieve the Oracle-specific ROWID pseudo-field
- rowid() - Static method in class org.jooq.util.sqlite.SQLiteFactory
-
Retrieve the SQLite-specific _rowid_ pseudo-field.
- rowIndex() - Method in interface org.jooq.LoaderError
-
The processed row index starting with 0 that caused the error
- RowN - Interface in org.jooq
-
A model type for a row value expression with degree N > 8
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases.
- rownum() - Static method in class org.jooq.util.oracle.OracleFactory
-
Retrieve the Oracle-specific ROWNUM pseudo-field
- rowNumber() - Static method in class org.jooq.impl.Factory
-
The row_number() over ([analytic clause]) function.
- rowsBetweenCurrentRow() - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS BETWEEN CURRENT ROW ...
- rowsBetweenFollowing(int) - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS BETWEEN [number] FOLLOWING ...
- rowsBetweenPreceding(int) - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS BETWEEN [number] PRECEDING ...
- rowsBetweenUnboundedFollowing() - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS BETWEEN UNBOUNDED FOLLOWING ...
- rowsBetweenUnboundedPreceding() - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS BETWEEN UNBOUNDED PRECEDING ...
- rowsCurrentRow() - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS CURRENT ROW frame clause to the window function.
- rowsFollowing(int) - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS [number] FOLLOWING frame clause to the window
function.
- rowsPreceding(int) - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS [number] PRECEDING frame clause to the window
function.
- rowsUnboundedFollowing() - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS UNBOUNDED FOLLOWING frame clause to the window
function.
- rowsUnboundedPreceding() - Method in interface org.jooq.WindowRowsStep
-
Add a ROWS UNBOUNDED PRECEDING frame clause to the window
function.
- ROWVERSION - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- rpad(Field<? extends Number>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- rpad(int) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- rpad(Field<? extends Number>, Field<String>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- rpad(int, char) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- rpad(Field<String>, int) - Static method in class org.jooq.impl.Factory
-
Get the rpad(field, length) function
- rpad(Field<String>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the rpad(field, length) function
This renders the rpad function where available:
rpad([field], [length]) ... or simulates it
elsewhere using concat, repeat, and length, which may be simulated as
well, depending on the RDBMS:
concat([field], repeat(' ', [length] - length([field])))
- rpad(Field<String>, int, char) - Static method in class org.jooq.impl.Factory
-
Get the rpad(field, length, character) function
- rpad(Field<String>, int, String) - Static method in class org.jooq.impl.Factory
-
Get the rpad(field, length, character) function
- rpad(Field<String>, Field<? extends Number>, Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the rpad(field, length, character) function
This renders the rpad function where available:
rpad([field], [length]) ... or simulates it
elsewhere using concat, repeat, and length, which may be simulated as
well, depending on the RDBMS:
concat([field], repeat([character], [length] - length([field])))
In
SQLDialect.SQLITE, this is simulated as such:
[field] || replace(replace(substr(quote(zeroblob(([length] + 1) / 2)), 3, ([length] - length([field]))), '''', ''), '0', [character])
- rtrim() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- rtrim(String) - Static method in class org.jooq.impl.Factory
-
Get the rtrim(field) function
- rtrim(Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the rtrim(field) function
This renders the rtrim function in all dialects:
rtrim([field])
S
- Schema - Interface in org.jooq
-
An entity representing a database schema
- schemaByName(String) - Static method in class org.jooq.impl.Factory
-
Create a qualified schema, given its schema name
This constructs a schema reference given the schema's qualified name.
- SchemaImpl - Class in org.jooq.impl
-
A common base class for database schemata
This type is for JOOQ INTERNAL USE only.
- SchemaImpl(String) - Constructor for class org.jooq.impl.SchemaImpl
-
- SchemaMapping - Class in org.jooq
-
Deprecated.
- 2.0.5 - Use runtime configuration Settings instead
- SchemaMapping() - Constructor for class org.jooq.SchemaMapping
-
Deprecated.
Construct an empty mapping
- SchemaMapping(Settings) - Constructor for class org.jooq.SchemaMapping
-
Deprecated.
Construct a mapping from a
Settings object
- SchemaMapping(Configuration) - Constructor for class org.jooq.SchemaMapping
-
Deprecated.
- SchemaProvider - Interface in org.jooq
-
Deprecated.
- 2.5.0 [#1580] - The org.jooq.SchemaProvider marker
interface has not proven to be useful to the public API so far.
There is no real need to abstract its implementations with a
single interface
- schemata - Variable in class org.jooq.conf.RenderMapping
-
- score(int) - Static method in class org.jooq.util.oracle.OracleFactory
-
The Oracle-Text specific SCORE function
- second(Date) - Static method in class org.jooq.impl.Factory
-
- second(Field<? extends Date>) - Static method in class org.jooq.impl.Factory
-
- select(Field<?>...) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement.
- select(Collection<? extends Field<?>>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement.
- select(Field<?>...) - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement.
- select(Collection<? extends Field<?>>) - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement.
- select(Field<?>...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- select(Collection<? extends Field<?>>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- select(Select<?>) - Method in interface org.jooq.InsertSetStep
-
Use a SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT ..
- select(Select<?>) - Method in interface org.jooq.InsertValuesStep
-
Use a SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT ..
- select(Select<?>) - Method in interface org.jooq.MergeValuesStep
-
Use a SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE ..
- Select<R extends Record> - Interface in org.jooq
-
- select(Field<?>...) - Method in interface org.jooq.SelectSelectStep
-
Add additional fields to the SELECT clause of this query
- select(Collection<? extends Field<?>>) - Method in interface org.jooq.SelectSelectStep
-
Add additional fields to the SELECT clause of this query
- SelectConditionStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectConnectByConditionStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectConnectByStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- selectCount() - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement for COUNT(*)
Example:
Factory create = new Factory();
create.selectCount()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
- selectCount() - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement for COUNT(*)
Example:
Factory create = new Factory();
create.selectCount()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
- selectCount() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- selectDistinct(Field<?>...) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement.
- selectDistinct(Collection<? extends Field<?>>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement.
- selectDistinct(Field<?>...) - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement.
- selectDistinct(Collection<? extends Field<?>>) - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement.
- selectDistinct(Field<?>...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- selectDistinct(Collection<? extends Field<?>>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- SelectFinalStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectForUpdateOfStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectForUpdateStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectForUpdateWaitStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- selectFrom(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
- selectFrom(Table<R>) - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
- selectFrom(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- SelectFromStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectGroupByStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectHavingConditionStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectHavingStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectJoinPartitionByStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectJoinStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectLimitStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectOffsetStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectOnConditionStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- selectOne() - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement for constant 1 literal
Example:
Factory create = new Factory();
create.selectOne()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
- selectOne() - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement for constant 1 literal
Example:
Factory create = new Factory();
create.selectOne()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
- selectOne() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- SelectOnStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectOptionalOnStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectOrderByStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- selectQuery() - Method in interface org.jooq.FactoryOperations
-
- selectQuery(TableLike<R>) - Method in interface org.jooq.FactoryOperations
-
- selectQuery() - Method in class org.jooq.impl.Factory
-
- selectQuery(TableLike<R>) - Method in class org.jooq.impl.Factory
-
- selectQuery() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- selectQuery(TableLike<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- SelectQuery - Interface in org.jooq
-
A query for data selection
- SelectSelectStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectStartWithStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- SelectWhereStep - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting generic
Record types.
- selectZero() - Method in interface org.jooq.FactoryOperations
-
Create a new DSL select statement for constant 0 literal
Example:
Factory create = new Factory();
create.selectZero()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
- selectZero() - Method in class org.jooq.impl.Factory
-
Create a new DSL select statement for constant 0 literal
Example:
Factory create = new Factory();
create.selectZero()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
- selectZero() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- separator(String) - Method in interface org.jooq.GroupConcatSeparatorStep
-
Specify the separator on the GROUP_CONCAT function
- separator(char) - Method in interface org.jooq.LoaderCSVOptionsStep
-
Specify the separator character.
- Sequence<T extends Number> - Interface in org.jooq
-
A type representing sequences in databases that support this.
- SEQUENCE - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- SequenceImpl<T extends Number> - Class in org.jooq.impl
-
A common base class for sequences
This type is for JOOQ INTERNAL USE only.
- SequenceImpl(String, Schema, DataType<T>) - Constructor for class org.jooq.impl.SequenceImpl
-
- SERIAL - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- SERIAL4 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- SERIAL8 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- set(Array) - Method in interface org.jooq.ArrayRecord
-
Set the contained array
- set(E...) - Method in interface org.jooq.ArrayRecord
-
Set the contained array
- set(T...) - Method in class org.jooq.impl.ArrayRecordImpl
-
- set(Array) - Method in class org.jooq.impl.ArrayRecordImpl
-
- set(Field<T>, T) - Method in interface org.jooq.InsertOnDuplicateSetStep
-
Set values for UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause
- set(Field<T>, Field<T>) - Method in interface org.jooq.InsertOnDuplicateSetStep
-
Set values for UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause
- set(Map<? extends Field<?>, ?>) - Method in interface org.jooq.InsertOnDuplicateSetStep
-
Set multiple values for UPDATE in the INSERT
statement's ON DUPLICATE KEY UPDATE clause
Please assure that key/value pairs have matching <T>
types.
- set(Field<T>, T) - Method in interface org.jooq.InsertSetStep
-
Set a value for a field in the UPDATE statement
- set(Field<T>, Field<T>) - Method in interface org.jooq.InsertSetStep
-
Set a value for a field in the UPDATE statement
- set(Map<? extends Field<?>, ?>) - Method in interface org.jooq.InsertSetStep
-
Set a value for a field in the UPDATE statement
Please assure that key/value pairs have matching <T>
types.
- set(Field<T>, T) - Method in interface org.jooq.MergeMatchedSetStep
-
Set values for UPDATE in the MERGE statement's
WHEN MATCHED clause
- set(Field<T>, Field<T>) - Method in interface org.jooq.MergeMatchedSetStep
-
Set values for UPDATE in the MERGE statement's
WHEN MATCHED clause
- set(Map<? extends Field<?>, ?>) - Method in interface org.jooq.MergeMatchedSetStep
-
Set multiple values for UPDATE in the MERGE
statement's WHEN MATCHED clause.
- set(Field<T>, T) - Method in interface org.jooq.MergeNotMatchedSetStep
-
Set values for INSERT in the MERGE statement's
WHEN NOT MATCHED clause
- set(Field<T>, Field<T>) - Method in interface org.jooq.MergeNotMatchedSetStep
-
Set values for INSERT in the MERGE statement's
WHEN NOT MATCHED clause
- set(Map<? extends Field<?>, ?>) - Method in interface org.jooq.MergeNotMatchedSetStep
-
Set multiple values for INSERT in the MERGE
statement's WHEN NOT MATCHED clause.
- set(String, Object) - Method in class org.jooq.tools.reflect.Reflect
-
Set a field value.
- set(Field<T>, T) - Method in interface org.jooq.UpdateSetStep
-
Set a value for a field in the UPDATE statement
- set(Field<T>, Field<T>) - Method in interface org.jooq.UpdateSetStep
-
Set a value for a field in the UPDATE statement
- set(Map<? extends Field<?>, ?>) - Method in interface org.jooq.UpdateSetStep
-
Set a value for a field in the UPDATE statement
Please assure that key/value pairs have matching <T>
types.
- SET - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- SET - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- setAttachRecords(Boolean) - Method in class org.jooq.conf.Settings
-
Sets the value of the attachRecords property.
- setAutoCommit(boolean) - Method in interface org.jooq.FactoryOperations
-
- setAutoCommit(boolean) - Method in class org.jooq.impl.Factory
-
- setAutoCommit(boolean) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setConnectByStartWith(Condition) - Method in interface org.jooq.SelectQuery
-
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause
- setConnection(Connection) - Method in interface org.jooq.Configuration
-
Set the configured connection
If you provide a JDBC connection to a jOOQ Factory, jOOQ will use that
connection for creating statements, but it will never call any of these
methods:
Connection.commit()
Connection.rollback()
Connection.close()
Use this constructor if you want to handle transactions directly on the
connection.
- setConnection(Connection) - Method in interface org.jooq.ExecuteContext
-
Override the
Connection that is being used for execution.
- setConnection(Connection) - Method in class org.jooq.impl.Factory
-
Set the configured connection
If you provide a JDBC connection to a jOOQ Factory, jOOQ will use that
connection for creating statements, but it will never call any of these
methods:
Connection.commit()
Connection.rollback()
Connection.close()
Use this constructor if you want to handle transactions directly on the
connection.
- setConnection(Connection) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setConverted(Object) - Method in interface org.jooq.Param
-
- setData(String, Object) - Method in interface org.jooq.Configuration
-
Set some custom data to this
Configuration
Use custom data if you want to pass data to your custom
QueryPart
or
ExecuteListener objects to be made available at render, bind,
execution, fetch time.
- setData(String, Object) - Method in class org.jooq.impl.Factory
-
Set some custom data to this
Configuration
Use custom data if you want to pass data to your custom
QueryPart
or
ExecuteListener objects to be made available at render, bind,
execution, fetch time.
- setData(String, Object) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setDataSource(DataSource) - Method in interface org.jooq.Configuration
-
Set the configured data source
If you provide a JDBC data source to a jOOQ Factory, jOOQ will use that
data source for initialising connections, and creating statements.
- setDataSource(DataSource) - Method in class org.jooq.impl.Factory
-
Set the configured data source
If you provide a JDBC data source to a jOOQ Factory, jOOQ will use that
data source for initialising connections, and creating statements.
- setDataSource(DataSource) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setDefaultSchema(String) - Method in class org.jooq.conf.RenderMapping
-
Sets the value of the defaultSchema property.
- setDefaultSchema(String) - Method in class org.jooq.SchemaMapping
-
Deprecated.
- setDialect(SQLDialect) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setDistinct(boolean) - Method in interface org.jooq.SelectQuery
-
Add "distinct" keyword to the select clause
- setExecuteListeners(List<String>) - Method in class org.jooq.conf.Settings
-
- setExecuteLogging(Boolean) - Method in class org.jooq.conf.Settings
-
Sets the value of the executeLogging property.
- setExecuteWithOptimisticLocking(Boolean) - Method in class org.jooq.conf.Settings
-
Sets the value of the executeWithOptimisticLocking property.
- setFactory(Factory) - Method in class org.jooq.impl.DAOImpl
-
Inject an attached factory
- setField(Parameter<?>, Field<?>) - Method in class org.jooq.impl.AbstractRoutine
-
- setForShare(boolean) - Method in interface org.jooq.LockProvider
-
Deprecated.
- setForShare(boolean) - Method in interface org.jooq.SelectQuery
-
- setForShare(boolean) - Method in interface org.jooq.SimpleSelectQuery
-
- setForUpdate(boolean) - Method in interface org.jooq.LockProvider
-
Deprecated.
Sets the "FOR UPDATE" flag onto the query
Native implementation This has been observed to be supported by
any of these dialects:
setForUpdate(boolean) - Method in interface org.jooq.
SelectQuery
-
Sets the "FOR UPDATE" flag onto the query
Native implementation This has been observed to be supported by
any of these dialects:
setForUpdate(boolean) - Method in interface org.jooq.
SimpleSelectQuery
-
Sets the "FOR UPDATE" flag onto the query
Native implementation This has been observed to be supported by
any of these dialects:
setForUpdateNoWait() - Method in interface org.jooq.
LockProvider
-
Deprecated.
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateNoWait() - Method in interface org.jooq.SelectQuery
-
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateNoWait() - Method in interface org.jooq.SimpleSelectQuery
-
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateOf(Field<?>...) - Method in interface org.jooq.LockProvider
-
Deprecated.
Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Collection<? extends Field<?>>) - Method in interface org.jooq.LockProvider
-
Deprecated.
Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Table<?>...) - Method in interface org.jooq.LockProvider
-
Deprecated.
Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Field<?>...) - Method in interface org.jooq.SelectQuery
-
Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Collection<? extends Field<?>>) - Method in interface org.jooq.SelectQuery
-
Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Table<?>...) - Method in interface org.jooq.SelectQuery
-
Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Field<?>...) - Method in interface org.jooq.SimpleSelectQuery
-
Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Collection<? extends Field<?>>) - Method in interface org.jooq.SimpleSelectQuery
-
Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Table<?>...) - Method in interface org.jooq.SimpleSelectQuery
-
Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateSkipLocked() - Method in interface org.jooq.LockProvider
-
Deprecated.
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateSkipLocked() - Method in interface org.jooq.SelectQuery
-
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateSkipLocked() - Method in interface org.jooq.SimpleSelectQuery
-
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateWait(int) - Method in interface org.jooq.LockProvider
-
Deprecated.
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateWait(int) - Method in interface org.jooq.SelectQuery
-
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateWait(int) - Method in interface org.jooq.SimpleSelectQuery
-
Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setHoldability(int) - Method in interface org.jooq.FactoryOperations
-
- setHoldability(int) - Method in class org.jooq.impl.Factory
-
- setHoldability(int) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setInline(boolean) - Method in interface org.jooq.Param
-
A flag on the bind value to force it to be inlined in rendered SQL
- setInput(String) - Method in class org.jooq.conf.MappedSchema
-
Sets the value of the input property.
- setInput(String) - Method in class org.jooq.conf.MappedTable
-
Sets the value of the input property.
- setList(List<? extends E>) - Method in interface org.jooq.ArrayRecord
-
Set the contained array as a
List
- setList(List<? extends T>) - Method in class org.jooq.impl.ArrayRecordImpl
-
- setNetworkTimeout(Executor, int) - Method in class org.jooq.tools.jdbc.JDBC41Connection
-
- setNumber(Parameter<? extends Number>, Number) - Method in class org.jooq.impl.AbstractRoutine
-
- setNumber(Parameter<? extends Number>, Field<? extends Number>) - Method in class org.jooq.impl.AbstractRoutine
-
- setOrderBySiblings(boolean) - Method in interface org.jooq.OrderProvider
-
Deprecated.
Indicate whether the SIBLINGS keyword should be used in an
ORDER BY clause to form an ORDER SIBLINGS BY
clause.
- setOrderBySiblings(boolean) - Method in interface org.jooq.SelectQuery
-
Indicate whether the SIBLINGS keyword should be used in an
ORDER BY clause to form an ORDER SIBLINGS BY
clause.
- setOrderBySiblings(boolean) - Method in interface org.jooq.SimpleSelectQuery
-
Indicate whether the SIBLINGS keyword should be used in an
ORDER BY clause to form an ORDER SIBLINGS BY
clause.
- setOutput(String) - Method in class org.jooq.conf.MappedSchema
-
Sets the value of the output property.
- setOutput(String) - Method in class org.jooq.conf.MappedTable
-
Sets the value of the output property.
- setOverloaded(boolean) - Method in class org.jooq.impl.AbstractRoutine
-
- setProvider(ConfigurationProvider) - Static method in class org.jooq.ConfigurationRegistry
-
Deprecated.
- setRecord(R) - Method in interface org.jooq.StoreQuery
-
Add values to the store statement
- setRenderFormatted(Boolean) - Method in class org.jooq.conf.Settings
-
Sets the value of the renderFormatted property.
- setRenderKeywordStyle(RenderKeywordStyle) - Method in class org.jooq.conf.Settings
-
Sets the value of the renderKeywordStyle property.
- setRenderMapping(RenderMapping) - Method in class org.jooq.conf.Settings
-
Sets the value of the renderMapping property.
- setRenderNameStyle(RenderNameStyle) - Method in class org.jooq.conf.Settings
-
Sets the value of the renderNameStyle property.
- setRenderSchema(Boolean) - Method in class org.jooq.conf.Settings
-
Sets the value of the renderSchema property.
- setReturning() - Method in interface org.jooq.InsertQuery
-
Configure the INSERT statement to return all fields in
R.
- setReturning(Identity<R, ? extends Number>) - Method in interface org.jooq.InsertQuery
-
Configure the INSERT statement to return the generated
identity value.
- setReturning(Field<?>...) - Method in interface org.jooq.InsertQuery
-
Configure the INSERT statement to return a list of fields in
R.
- setReturning(Collection<? extends Field<?>>) - Method in interface org.jooq.InsertQuery
-
Configure the INSERT statement to return a list of fields in
R.
- setReturnParameter(Parameter<T>) - Method in class org.jooq.impl.AbstractRoutine
-
- setSavepoint(String) - Method in interface org.jooq.FactoryOperations
-
- setSavepoint() - Method in interface org.jooq.FactoryOperations
-
- setSavepoint() - Method in class org.jooq.impl.Factory
-
- setSavepoint(String) - Method in class org.jooq.impl.Factory
-
- setSavepoint(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setSavepoint() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setSchema(String) - Method in class org.jooq.tools.jdbc.JDBC41Connection
-
- setSchemaMapping(Map<String, String>) - Method in class org.jooq.SchemaMapping
-
Deprecated.
Initialise SchemaMapping.
- setSchemata(List<MappedSchema>) - Method in class org.jooq.conf.RenderMapping
-
- setSettings(Settings) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setStatementType(StatementType) - Method in class org.jooq.conf.Settings
-
Sets the value of the statementType property.
- setTables(List<MappedTable>) - Method in class org.jooq.conf.MappedSchema
-
- Settings - Class in org.jooq.conf
-
Java class for Settings complex type.
- Settings() - Constructor for class org.jooq.conf.Settings
-
- SettingsTools - Class in org.jooq.conf
-
Convenience methods for jOOQ runtime settings
- SettingsTools() - Constructor for class org.jooq.conf.SettingsTools
-
- setTransactionIsolation(int) - Method in interface org.jooq.FactoryOperations
-
- setTransactionIsolation(int) - Method in class org.jooq.impl.Factory
-
- setTransactionIsolation(int) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- setValue(Parameter<?>, Object) - Method in class org.jooq.impl.AbstractRoutine
-
- setValue(T) - Method in interface org.jooq.Param
-
Set the parameter's underlying value.
- setValue(Field<T>, T) - Method in interface org.jooq.Record
-
Set a value into this record.
- setValue(Field<T>, U, Converter<T, ? super U>) - Method in interface org.jooq.Record
-
Set a value into this record.
- sha1(String) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific SHA1() function
- sha1(Field<String>) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific SHA1() function
- sha2(String, int) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific SHA2() function
- sha2(Field<String>, Field<Integer>) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific SHA2() function
- shl(T, T) - Static method in class org.jooq.impl.Factory
-
The bitwise left shift operator.
- shl(T, Field<T>) - Static method in class org.jooq.impl.Factory
-
The bitwise left shift operator.
- shl(Field<T>, T) - Static method in class org.jooq.impl.Factory
-
The bitwise left shift operator.
- shl(Field<T>, Field<T>) - Static method in class org.jooq.impl.Factory
-
The bitwise left shift operator.
- SHORT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- shortValue() - Method in interface org.jooq.types.Interval
-
- shr(T, T) - Static method in class org.jooq.impl.Factory
-
The bitwise right shift operator.
- shr(T, Field<T>) - Static method in class org.jooq.impl.Factory
-
The bitwise right shift operator.
- shr(Field<T>, T) - Static method in class org.jooq.impl.Factory
-
The bitwise right shift operator.
- shr(Field<T>, Field<T>) - Static method in class org.jooq.impl.Factory
-
The bitwise right shift operator.
- sign() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- sign(Number) - Static method in class org.jooq.impl.Factory
-
Get the sign of a numeric field: sign(field)
- sign(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sign of a numeric field: sign(field)
This renders the sign function where available:
sign([field])
... or simulates it elsewhere (without bind variables on values -1, 0, 1):
CASE WHEN [this] > 0 THEN 1
WHEN [this] < 0 THEN -1
ELSE 0
END
- SIGNED - Static variable in class org.jooq.util.h2.H2DataType
-
- SIGNTYPE - Static variable in class org.jooq.util.oracle.OracleDataType
-
- SimpleSelectConditionStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectFinalStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectForUpdateOfStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectForUpdateStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectForUpdateWaitStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectLimitStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectOffsetStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectOrderByStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- SimpleSelectQuery<R extends Record> - Interface in org.jooq
-
A simple select query that provides Records from a single table, with no
joins allowed.
- SimpleSelectWhereStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Select's DSL API when selecting specific
Record types.
- sin() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- sin(Number) - Static method in class org.jooq.impl.Factory
-
Get the sine(field) function
- sin(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sine(field) function
This renders the sin function where available:
sin([field])
- sinh() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- sinh(Number) - Static method in class org.jooq.impl.Factory
-
Get the hyperbolic sine function: sinh(field)
- sinh(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the hyperbolic sine function: sinh(field)
This renders the sinh function where available:
sinh([field]) ... or simulates it elsewhere using
exp: (exp([field] * 2) - 1) / (exp([field] * 2))
- size() - Method in interface org.jooq.ArrayRecord
-
Get the size of the contained array
- size() - Method in class org.jooq.impl.ArrayRecordImpl
-
- size() - Method in interface org.jooq.Record
-
Get the number of fields of this record.
- size() - Method in interface org.jooq.Store
-
Deprecated.
Get the size of this
Store.
- skipLocked() - Method in interface org.jooq.SelectForUpdateWaitStep
-
Add a WAIT clause to the FOR UPDATE clause at
the end of the query.
- skipLocked() - Method in interface org.jooq.SimpleSelectForUpdateWaitStep
-
Add a WAIT clause to the FOR UPDATE clause at
the end of the query.
- SMALLDATETIME - Static variable in class org.jooq.util.ase.ASEDataType
-
- SMALLDATETIME - Static variable in class org.jooq.util.h2.H2DataType
-
- SMALLDATETIME - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- SMALLDATETIME - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- SMALLINT - Static variable in class org.jooq.impl.SQLDataType
-
- SMALLINT - Static variable in class org.jooq.util.ase.ASEDataType
-
- SMALLINT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- SMALLINT - Static variable in class org.jooq.util.db2.DB2DataType
-
- SMALLINT - Static variable in class org.jooq.util.derby.DerbyDataType
-
- SMALLINT - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- SMALLINT - Static variable in class org.jooq.util.h2.H2DataType
-
- SMALLINT - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- SMALLINT - Static variable in class org.jooq.util.ingres.IngresDataType
-
- SMALLINT - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- SMALLINT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- SMALLINT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- SMALLINT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- SMALLINT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- SMALLINT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- SMALLINTUNSIGNED - Static variable in class org.jooq.impl.SQLDataType
-
- SMALLINTUNSIGNED - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- SMALLMONEY - Static variable in class org.jooq.util.ase.ASEDataType
-
- SMALLMONEY - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- SMALLMONEY - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- sort(SortOrder) - Method in interface org.jooq.Field
-
Create an ascending/descending sort field from this field
- sort(Map<T, Z>) - Method in interface org.jooq.Field
-
Create a sort field of the form (in pseudo code)
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
WHEN [sortMap.key(1)] THEN sortMap.value(1)
...
- sortAsc(Collection<T>) - Method in interface org.jooq.Field
-
Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
...
- sortAsc(T...) - Method in interface org.jooq.Field
-
Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
...
- sortAsc(Field<T>) - Method in interface org.jooq.Result
-
Sort this result by one of its contained fields.
- sortAsc(Field<T>, Comparator<? super T>) - Method in interface org.jooq.Result
-
Sort this result by one of its contained fields using a comparator.
- sortAsc(Comparator<? super R>) - Method in interface org.jooq.Result
-
Sort this result using a comparator that can compare records.
- sortDesc(Collection<T>) - Method in interface org.jooq.Field
-
Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
...
- sortDesc(T...) - Method in interface org.jooq.Field
-
Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
...
- sortDesc(Field<T>) - Method in interface org.jooq.Result
-
Reverse-sort this result by one of its contained fields.
- sortDesc(Field<T>, Comparator<? super T>) - Method in interface org.jooq.Result
-
Reverse-sort this result by one of its contained fields using a
comparator.
- sortDesc(Comparator<? super R>) - Method in interface org.jooq.Result
-
Reverse-sort this result using a comparator that can compare records.
- SortField<T> - Interface in org.jooq
-
- SortOrder - Enum in org.jooq
-
The sorting order used in OrderByFieldLists
- split(String, CharSequence) - Static method in class org.jooq.tools.StringUtils
-
- splitDebug(String) - Method in class org.jooq.tools.StopWatch
-
Split the time and debug log a message, if trace logging is enabled
- splitInfo(String) - Method in class org.jooq.tools.StopWatch
-
Split the time and info log a message, if trace logging is enabled
- splitTrace(String) - Method in class org.jooq.tools.StopWatch
-
Split the time and trace log a message, if trace logging is enabled
- sql() - Method in interface org.jooq.ExecuteContext
-
The SQL that is being executed or null if the SQL statement
is unknown or if there was no SQL statement
- sql(String) - Method in interface org.jooq.ExecuteContext
-
Override the SQL statement that is being executed.
- sql(String) - Method in interface org.jooq.RenderContext
-
- sql(char) - Method in interface org.jooq.RenderContext
-
- sql(int) - Method in interface org.jooq.RenderContext
-
- sql(QueryPart) - Method in interface org.jooq.RenderContext
-
Recurse rendering
- SQLDataType<T> - Class in org.jooq.impl
-
The SQL standard data types, as described in
Types.
- SQLDialect - Enum in org.jooq
-
This enumeration lists all supported dialects.
- SQLDialectNotSupportedException - Exception in org.jooq.exception
-
- SQLDialectNotSupportedException(String) - Constructor for exception org.jooq.exception.SQLDialectNotSupportedException
-
- SQLDialectNotSupportedException(String, boolean) - Constructor for exception org.jooq.exception.SQLDialectNotSupportedException
-
- sqlException() - Method in interface org.jooq.ExecuteContext
-
- sqlException(SQLException) - Method in interface org.jooq.ExecuteContext
-
- SQLiteDataType<T> - Class in org.jooq.util.sqlite
-
- SQLiteFactory - Class in org.jooq.util.sqlite
-
- SQLiteFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
- SQLiteFactory(Connection, Settings) - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
Create a factory with connection and a settings configured
- SQLiteFactory(DataSource, Settings) - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
Create a factory with a data source and a settings configured
- SQLiteFactory(Connection) - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
Create a factory with connection
- SQLiteFactory(DataSource) - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
Create a factory with a data source
- SQLiteFactory(Settings) - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- SQLiteFactory() - Constructor for class org.jooq.util.sqlite.SQLiteFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- SQLServerDataType<T> - Class in org.jooq.util.sqlserver
-
- SQLServerFactory - Class in org.jooq.util.sqlserver
-
- SQLServerFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
- SQLServerFactory(Connection, Settings) - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
Create a factory with connection and a settings configured
- SQLServerFactory(DataSource, Settings) - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
Create a factory with a data source and a settings configured
- SQLServerFactory(Connection) - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
Create a factory with connection
- SQLServerFactory(DataSource) - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
Create a factory with a data source
- SQLServerFactory(Settings) - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- SQLServerFactory() - Constructor for class org.jooq.util.sqlserver.SQLServerFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- sqrt() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- sqrt(Number) - Static method in class org.jooq.impl.Factory
-
Get the sqrt(field) function
- sqrt(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sqrt(field) function
This renders the sqrt function where available:
sqrt([field]) ... or simulates it elsewhere using
power (which in turn may also be simulated using ln and exp functions):
power([field], 0.5)
- start(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
- start(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- start(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- startsWith(T) - Method in interface org.jooq.Field
-
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping
SQL:
this like (escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWith(11)
- startsWith(Field<T>) - Method in interface org.jooq.Field
-
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping
SQL:
this like (escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWith(11)
- startWith(Condition) - Method in interface org.jooq.SelectStartWithStep
-
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause
- startWith(String) - Method in interface org.jooq.SelectStartWithStep
-
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- startWith(String, Object...) - Method in interface org.jooq.SelectStartWithStep
-
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- startWith(String, QueryPart...) - Method in interface org.jooq.SelectStartWithStep
-
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- statement() - Method in interface org.jooq.BindContext
-
- statement() - Method in interface org.jooq.ExecuteContext
-
The
PreparedStatement that is being executed or
null
if the statement is unknown or if there was no statement.
- statement(PreparedStatement) - Method in interface org.jooq.ExecuteContext
-
- statementType - Variable in class org.jooq.conf.Settings
-
- StatementType - Enum in org.jooq.conf
-
Java class for StatementType.
- stddevPop() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- stddevPop(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the population standard deviation of a numeric field: stddev_pop(field)
- stddevPopOver() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- stddevSamp() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- stddevSamp(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sample standard deviation of a numeric field: stddev_samp(field)
- stddevSampOver() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- StopWatch - Class in org.jooq.tools
-
A time measuring device
- StopWatch() - Constructor for class org.jooq.tools.StopWatch
-
Initialise the stop watch
- StopWatchListener - Class in org.jooq.tools
-
- StopWatchListener() - Constructor for class org.jooq.tools.StopWatchListener
-
- store() - Method in class org.jooq.impl.UpdatableRecordImpl
-
- Store<E> - Interface in org.jooq
-
Deprecated.
- 2.6.0 [#1840] - This type provides no useful abstraction over
Record and ArrayRecord and will be removed in the
future. Do not reference it directly.
- store() - Method in interface org.jooq.UpdatableRecord
-
Store this record back to the database.
- stored() - Method in interface org.jooq.Loader
-
The number of inserted or updated rows
- StoreQuery<R extends Record> - Interface in org.jooq
-
A query storing objects to the database.
- storeUsing(TableField<R, ?>...) - Method in class org.jooq.impl.TableRecordImpl
-
- storeUsing(TableField<R, ?>...) - Method in interface org.jooq.TableRecord
-
Deprecated.
- 2.5.0 [#1736] - These methods will be made part of jOOQ's
internal API soon. Do not reuse these methods.
- STRING - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- StringUtils - Class in org.jooq.tools
-
Operations on
String that are
null safe.
- sub(Number) - Method in interface org.jooq.Field
-
An arithmetic expression subtracting value from this.
- sub(Field<?>) - Method in interface org.jooq.Field
-
An arithmetic expression subtracting value from this.
- subquery() - Method in interface org.jooq.Context
-
Whether the current context is rendering a sub-query (nested query)
- subquery(boolean) - Method in interface org.jooq.Context
-
- substring(int) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- substring(Field<? extends Number>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- substring(int, int) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- substring(Field<? extends Number>, Field<? extends Number>) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- substring(Field<String>, int) - Static method in class org.jooq.impl.Factory
-
Get the substring(field, startingPosition) function
- substring(Field<String>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the substring(field, startingPosition) function
This renders the substr or substring function:
substr([field], [startingPosition]) or
substring([field], [startingPosition])
- substring(Field<String>, int, int) - Static method in class org.jooq.impl.Factory
-
Get the substring(field, startingPosition, length) function
- substring(Field<String>, Field<? extends Number>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the substring(field, startingPosition, length) function
This renders the substr or substring function:
substr([field], [startingPosition], [length]) or
substring([field], [startingPosition], [length])
- sum() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- sum(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sum over a numeric field: sum(field)
- sumDistinct(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sum over a numeric field: sum(distinct field)
- sumOver() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- Support - Annotation Type in org.jooq
-
A formal declaration of whether any API element is supported by a given
SQLDialect
The annotation is mainly used in three modes:
The annotation is absent on a method.
- SybaseDataType<T> - Class in org.jooq.util.sybase
-
- SybaseFactory - Class in org.jooq.util.sybase
-
- SybaseFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.sybase.SybaseFactory
-
- SybaseFactory(Connection, Settings) - Constructor for class org.jooq.util.sybase.SybaseFactory
-
Create a factory with connection and a settings configured
- SybaseFactory(DataSource, Settings) - Constructor for class org.jooq.util.sybase.SybaseFactory
-
Create a factory with a data source and a settings configured
- SybaseFactory(Connection) - Constructor for class org.jooq.util.sybase.SybaseFactory
-
Create a factory with connection
- SybaseFactory(DataSource) - Constructor for class org.jooq.util.sybase.SybaseFactory
-
Create a factory with a data source
- SybaseFactory(Settings) - Constructor for class org.jooq.util.sybase.SybaseFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- SybaseFactory() - Constructor for class org.jooq.util.sybase.SybaseFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- sysConnectByPath(Field<?>, String) - Static method in class org.jooq.impl.Factory
-
Retrieve the Oracle-specific
SYS_CONNECT_BY_PATH(field, separator) function (to be used
along with CONNECT BY clauses).
- sysContext(String, String) - Static method in class org.jooq.util.oracle.OracleFactory
-
The Oracle-specific SYS_CONTEXT function
- sysContext(String, String, int) - Static method in class org.jooq.util.oracle.OracleFactory
-
The Oracle-specific SYS_CONTEXT function
- SYSNAME - Static variable in class org.jooq.util.ase.ASEDataType
-
T
- table(Select<R>) - Static method in class org.jooq.impl.Factory
-
- table(List<?>) - Static method in class org.jooq.impl.Factory
-
- table(Object[]) - Static method in class org.jooq.impl.Factory
-
- table(ArrayRecord<?>) - Static method in class org.jooq.impl.Factory
-
- table(Field<?>) - Static method in class org.jooq.impl.Factory
-
- table(String) - Static method in class org.jooq.impl.Factory
-
A custom SQL clause that can render arbitrary table expressions.
- table(String, Object...) - Static method in class org.jooq.impl.Factory
-
A custom SQL clause that can render arbitrary table expressions.
- table(String, QueryPart...) - Static method in class org.jooq.impl.Factory
-
A custom SQL clause that can render arbitrary table expressions.
- Table<R extends Record> - Interface in org.jooq
-
A table to be used in queries
- tableByName(String...) - Static method in class org.jooq.impl.Factory
-
Create a qualified table, given its table name
This constructs a table reference given the table's qualified name. jOOQ
will render the table name according to your
Settings.getRenderNameStyle() settings.
- TableField<R extends Record,T> - Interface in org.jooq
-
A field contained in a table
- TableImpl<R extends Record> - Class in org.jooq.impl
-
A common base type for tables
This type is for JOOQ INTERNAL USE only.
- TableImpl(String) - Constructor for class org.jooq.impl.TableImpl
-
- TableImpl(String, Table<R>) - Constructor for class org.jooq.impl.TableImpl
-
- TableImpl(String, Schema) - Constructor for class org.jooq.impl.TableImpl
-
- TableImpl(String, Schema, Table<R>) - Constructor for class org.jooq.impl.TableImpl
-
- TableLike<R extends Record> - Interface in org.jooq
-
An object that can behave like a table (a table-like object)
- TableOnConditionStep - Interface in org.jooq
-
An intermediate (optional) type for the construction of a
JOIN
clause, where the join criteria is added using an
ON clause
(with a
Condition.
- TableOnStep - Interface in org.jooq
-
An intermediate type for the construction of a
JOIN clause,
where there must be a join criteria added using an
ON clause
(with a
Condition), or using a
USING clause (with a list
of
Field)
- TableOptionalOnStep - Interface in org.jooq
-
An intermediate type for the construction of a
JOIN clause,
where there may optionally be a join criteria added using an
ON
clause (with a
Condition), or using a
USING clause (with
a list of
Field)
- TablePartitionByStep - Interface in org.jooq
-
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause.
- TableRecord<R extends TableRecord<R>> - Interface in org.jooq
-
A record originating from a single table
- TableRecordImpl<R extends TableRecord<R>> - Class in org.jooq.impl
-
A record implementation for a record originating from a single table
This type is for JOOQ INTERNAL USE only.
- TableRecordImpl(Table<R>) - Constructor for class org.jooq.impl.TableRecordImpl
-
- tables - Variable in class org.jooq.conf.MappedSchema
-
- tan() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- tan(Number) - Static method in class org.jooq.impl.Factory
-
Get the tangent(field) function
- tan(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the tangent(field) function
This renders the tan function where available:
tan([field])
- tanh() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- tanh(Number) - Static method in class org.jooq.impl.Factory
-
Get the hyperbolic tangent function: tanh(field)
- tanh(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the hyperbolic tangent function: tanh(field)
This renders the tanh function where available:
tanh([field]) ... or simulates it elsewhere using
exp:
(exp([field] * 2) - 1) / (exp([field] * 2) + 1)
- TEXT - Static variable in class org.jooq.util.ase.ASEDataType
-
- TEXT - Static variable in class org.jooq.util.h2.H2DataType
-
- TEXT - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TEXT - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- TEXT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TEXT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- TEXT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- TEXT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- TID - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIME - Static variable in class org.jooq.impl.SQLDataType
-
- TIME - Static variable in class org.jooq.util.ase.ASEDataType
-
- TIME - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- TIME - Static variable in class org.jooq.util.db2.DB2DataType
-
- TIME - Static variable in class org.jooq.util.derby.DerbyDataType
-
- TIME - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- TIME - Static variable in class org.jooq.util.h2.H2DataType
-
- TIME - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- TIME - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIME - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- TIME - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIME - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- TIME - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- TIMESTAMP - Static variable in class org.jooq.impl.SQLDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.ase.ASEDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.db2.DB2DataType
-
- TIMESTAMP - Static variable in class org.jooq.util.derby.DerbyDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.h2.H2DataType
-
- TIMESTAMP - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.oracle.OracleDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- TIMESTAMP - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- timestampAdd(Timestamp, Number) - Static method in class org.jooq.impl.Factory
-
Add an interval to a timestamp
This translates into any dialect
- timestampAdd(Field<Timestamp>, Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Add an interval to a timestamp
This translates into any dialect
- timestampDiff(Timestamp, Timestamp) - Static method in class org.jooq.impl.Factory
-
Get the timestamp difference as a INTERVAL DAY TO SECOND
type
This translates into any dialect
- timestampDiff(Field<Timestamp>, Timestamp) - Static method in class org.jooq.impl.Factory
-
Get the timestamp difference as a INTERVAL DAY TO SECOND
type
This translates into any dialect
- timestampDiff(Timestamp, Field<Timestamp>) - Static method in class org.jooq.impl.Factory
-
Get the timestamp difference as a INTERVAL DAY TO SECOND
type
This translates into any dialect
- timestampDiff(Field<Timestamp>, Field<Timestamp>) - Static method in class org.jooq.impl.Factory
-
Get the timestamp difference as a INTERVAL DAY TO SECOND
type
This translates into any dialect
- TIMESTAMPTZ - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIMESTAMPWITHLOCALTIMEZONE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMESTAMPWITHOUTTIMEZONE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMESTAMPWITHOUTTIMEZONE - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIMESTAMPWITHTIMEZONE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMESTAMPWITHTIMEZONE - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIMESTAMPWITHTIMEZONE - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- TIMETZ - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIMEWITHLOCALTIMEZONE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMEWITHOUTTIMEZONE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMEWITHOUTTIMEZONE - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TIMEWITHTIMEZONE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TIMEWITHTIMEZONE - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- TINYBLOB - Static variable in class org.jooq.util.h2.H2DataType
-
- TINYBLOB - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- TINYINT - Static variable in class org.jooq.impl.SQLDataType
-
- TINYINT - Static variable in class org.jooq.util.ase.ASEDataType
-
- TINYINT - Static variable in class org.jooq.util.h2.H2DataType
-
- TINYINT - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- TINYINT - Static variable in class org.jooq.util.ingres.IngresDataType
-
- TINYINT - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- TINYINT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- TINYINT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- TINYINT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- TINYINTUNSIGNED - Static variable in class org.jooq.impl.SQLDataType
-
- TINYINTUNSIGNED - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- TINYTEXT - Static variable in class org.jooq.util.h2.H2DataType
-
- to(U) - Method in interface org.jooq.Converter
-
Convert a user object to a database object
- to(U) - Method in class org.jooq.impl.EnumConverter
-
Subclasses may override this method to provide a custom reverse mapping
implementation
Convert a user object to a database object
- toBigInteger() - Method in class org.jooq.tools.unsigned.UByte
-
- toBigInteger() - Method in class org.jooq.tools.unsigned.UNumber
-
- toBytes(String) - Static method in class org.jooq.util.postgres.PostgresUtils
-
Parse a Postgres-encoded bytea string
- toCamelCase(String) - Static method in class org.jooq.tools.StringUtils
-
Convert a string to camel case
- toCamelCaseLC(String) - Static method in class org.jooq.tools.StringUtils
-
Convert a string to camel case starting with a lower case letter
- toDayToSecond(Object) - Static method in class org.jooq.util.postgres.PGIntervalConverter
-
- toDayToSecond(Object) - Static method in class org.jooq.util.postgres.PostgresUtils
-
Convert a Postgres interval to a jOOQ DAY TO SECOND interval
- toJSONString(List<?>) - Static method in class org.jooq.tools.json.JSONArray
-
Convert a list to JSON text.
- toJSONString(Map<?, ?>) - Static method in class org.jooq.tools.json.JSONObject
-
Convert a map to JSON text.
- toJSONString(Object) - Static method in class org.jooq.tools.json.JSONValue
-
Convert an object to JSON text.
- toLC(String) - Static method in class org.jooq.tools.StringUtils
-
Change a string's first letter to lower case
- toPGInterval(DayToSecond) - Static method in class org.jooq.util.postgres.PGIntervalConverter
-
- toPGInterval(YearToMonth) - Static method in class org.jooq.util.postgres.PGIntervalConverter
-
- toPGInterval(DayToSecond) - Static method in class org.jooq.util.postgres.PostgresUtils
-
Convert a jOOQ DAY TO SECOND interval to a Postgres representation
- toPGInterval(YearToMonth) - Static method in class org.jooq.util.postgres.PostgresUtils
-
Convert a jOOQ YEAR TO MONTH interval to a Postgres representation
- toPGObject(String) - Static method in class org.jooq.util.postgres.PostgresUtils
-
Tokenize a PGObject input string
- toSQL() - Method in enum org.jooq.Comparator
-
- toSQL() - Method in enum org.jooq.DatePart
-
- toSQL(RenderContext) - Method in class org.jooq.impl.AbstractRoutine
-
- toSQL(RenderContext) - Method in class org.jooq.impl.CustomCondition
-
Subclasses must implement this method
Render this
QueryPart to a SQL string contained in
context.sql().
- toSQL(RenderContext) - Method in class org.jooq.impl.CustomField
-
Subclasses must implement this method
Render this
QueryPart to a SQL string contained in
context.sql().
- toSQL(RenderContext) - Method in class org.jooq.impl.PackageImpl
-
- toSQL(RenderContext) - Method in class org.jooq.impl.SchemaImpl
-
- toSQL(RenderContext) - Method in class org.jooq.impl.TableImpl
-
- toSQL(RenderContext) - Method in class org.jooq.impl.UDTImpl
-
- toSQL() - Method in enum org.jooq.JoinType
-
- toSQL(RenderContext) - Method in interface org.jooq.QueryPartInternal
-
Render this
QueryPart to a SQL string contained in
context.sql().
- toSQL() - Method in enum org.jooq.SortOrder
-
- toString() - Method in class org.jooq.impl.AbstractDataType
-
- toString() - Method in class org.jooq.impl.ArrayRecordImpl
-
- toString() - Method in class org.jooq.impl.Factory
-
- toString() - Method in class org.jooq.SchemaMapping
-
Deprecated.
- toString(String, Object) - Static method in class org.jooq.tools.json.JSONObject
-
- toString() - Method in class org.jooq.tools.reflect.Reflect
- toString() - Method in class org.jooq.tools.unsigned.UByte
-
- toString() - Method in class org.jooq.tools.unsigned.UInteger
-
- toString() - Method in class org.jooq.tools.unsigned.ULong
-
- toString() - Method in class org.jooq.tools.unsigned.UShort
-
- toString() - Method in class org.jooq.types.DayToSecond
-
- toString() - Method in class org.jooq.types.YearToMonth
-
- toType() - Method in interface org.jooq.Converter
-
The user type
- toType() - Method in class org.jooq.impl.EnumConverter
-
- toYearToMonth(Object) - Static method in class org.jooq.util.postgres.PGIntervalConverter
-
- toYearToMonth(Object) - Static method in class org.jooq.util.postgres.PostgresUtils
-
Convert a Postgres interval to a jOOQ YEAR TO MONTH interval
- trace(Object) - Method in class org.jooq.tools.JooqLogger
-
- trace(Object, Object) - Method in class org.jooq.tools.JooqLogger
-
- trace(Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- trace(Object, Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- trim() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- trim(String) - Static method in class org.jooq.impl.Factory
-
Get the trim(field) function
- trim(Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the trim(field) function
This renders the trim function where available:
trim([field]) ... or simulates it elsewhere using
rtrim and ltrim: ltrim(rtrim([field]))
- TRUE_VALUES - Static variable in class org.jooq.tools.Convert
-
- trueCondition() - Static method in class org.jooq.impl.Factory
-
Return a Condition that will always evaluate to true
- trunc(T) - Static method in class org.jooq.impl.Factory
-
Truncate a number to a given number of decimals
- trunc(T, int) - Static method in class org.jooq.impl.Factory
-
Truncate a number to a given number of decimals
- trunc(Field<T>, int) - Static method in class org.jooq.impl.Factory
-
Truncate a number to a given number of decimals
- trunc(T, Field<Integer>) - Static method in class org.jooq.impl.Factory
-
Truncate a number to a given number of decimals
- trunc(Field<T>, Field<Integer>) - Static method in class org.jooq.impl.Factory
-
Truncate a number to a given number of decimals
This function truncates number to the amount of decimals
specified in decimals.
- truncate(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL truncate statement.
- truncate(Table<R>) - Method in class org.jooq.impl.Factory
-
Create a new DSL truncate statement.
- truncate(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- Truncate<R extends Record> - Interface in org.jooq
-
A
Query that can truncate a table in the database.
- two() - Static method in class org.jooq.impl.Factory
-
A 2 literal.
- type() - Method in interface org.jooq.ExecuteContext
-
The type of database interaction that is being executed
- type() - Method in class org.jooq.tools.reflect.Reflect
-
Get the type of the wrapped object.
- Type<R extends Record> - Interface in org.jooq
-
Deprecated.
- 2.5.0 [#1579] - The org.jooq.TypeTable and
UDT with a single interface
U
- UByte - Class in org.jooq.tools.unsigned
-
The unsigned byte type
- UByte(long) - Constructor for class org.jooq.tools.unsigned.UByte
-
- UByte(int) - Constructor for class org.jooq.tools.unsigned.UByte
-
- UByte(short) - Constructor for class org.jooq.tools.unsigned.UByte
-
- UByte(byte) - Constructor for class org.jooq.tools.unsigned.UByte
-
- UByte(String) - Constructor for class org.jooq.tools.unsigned.UByte
-
- ubyte(String) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned byte
- ubyte(byte) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned byte by masking it with 0xFF
i.e.
- ubyte(short) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned byte
- ubyte(int) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned byte
- ubyte(long) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned byte
- UDT<R extends UDTRecord<R>> - Interface in org.jooq
-
UDT definition
- UDTField<R extends UDTRecord<R>,T> - Interface in org.jooq
-
A field contained in a UDT
- UDTImpl<R extends UDTRecord<R>> - Class in org.jooq.impl
-
A common base type for UDT's
This type is for JOOQ INTERNAL USE only.
- UDTImpl(String, Schema) - Constructor for class org.jooq.impl.UDTImpl
-
- UDTRecord<R extends UDTRecord<R>> - Interface in org.jooq
-
An object holding data of a UDT
- UDTRecordImpl<R extends UDTRecord<R>> - Class in org.jooq.impl
-
A record implementation for a record originating from a single UDT
This type is for JOOQ INTERNAL USE only.
- UDTRecordImpl(UDT<R>) - Constructor for class org.jooq.impl.UDTRecordImpl
-
- uint(String) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned int
- uint(int) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned int by masking it with
0xFFFFFFFF i.e.
- uint(long) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned int
- UInteger - Class in org.jooq.tools.unsigned
-
The unsigned int type
- UInteger(long) - Constructor for class org.jooq.tools.unsigned.UInteger
-
- UInteger(int) - Constructor for class org.jooq.tools.unsigned.UInteger
-
- UInteger(String) - Constructor for class org.jooq.tools.unsigned.UInteger
-
- ULong - Class in org.jooq.tools.unsigned
-
The unsigned long type
- ULong(BigInteger) - Constructor for class org.jooq.tools.unsigned.ULong
-
- ULong(long) - Constructor for class org.jooq.tools.unsigned.ULong
-
- ULong(String) - Constructor for class org.jooq.tools.unsigned.ULong
-
- ulong(String) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned long
- ulong(long) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned long by masking it with
0xFFFFFFFFFFFFFFFF i.e.
- ulong(BigInteger) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned long
- uncompress(String) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific UNCOMPRESS() function
- uncompress(Field<String>) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific UNCOMPRESS() function
- uncompressedLength(String) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific UNCOMPRESSED_LENGTH() function
- uncompressedLength(Field<String>) - Static method in class org.jooq.util.mysql.MySQLFactory
-
Get the MySQL-specific UNCOMPRESSED_LENGTH() function
- UNICHAR - Static variable in class org.jooq.util.ase.ASEDataType
-
- union(Select<R>) - Method in interface org.jooq.Select
-
Combine with other selects
- unionAll(Select<R>) - Method in interface org.jooq.Select
-
Combine with other selects
- UNIQUEIDENTIFIER - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- UNIQUEIDENTIFIER - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- UNIQUEIDENTIFIERSTR - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- UniqueKey<R extends Record> - Interface in org.jooq
-
A UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY.
- UNITEXT - Static variable in class org.jooq.util.ase.ASEDataType
-
- UNIVARCHAR - Static variable in class org.jooq.util.ase.ASEDataType
-
- unnest(List<?>) - Static method in class org.jooq.impl.Factory
-
Create a table from a list of values
This is equivalent to the
TABLE function for H2, or the
UNNEST function in HSQLDB and Postgres
For Oracle, use
Factory.table(ArrayRecord) instead, as Oracle knows only
typed arrays
In all other dialects, unnesting of arrays is simulated using several
UNION ALL connected subqueries.
- unnest(Object[]) - Static method in class org.jooq.impl.Factory
-
Create a table from an array of values
This is equivalent to the
TABLE function for H2, or the
UNNEST function in HSQLDB and Postgres
For Oracle, use
Factory.table(ArrayRecord) instead, as Oracle knows only
typed arrays
In all other dialects, unnesting of arrays is simulated using several
UNION ALL connected subqueries.
- unnest(ArrayRecord<?>) - Static method in class org.jooq.impl.Factory
-
Create a table from an array of values
This wraps the argument array in a TABLE function for
Oracle.
- unnest(Field<?>) - Static method in class org.jooq.impl.Factory
-
Create a table from a field.
- Unsigned - Class in org.jooq.tools.unsigned
-
A utility class for static access to unsigned number functionality.
- UNSIGNEDBIGINT - Static variable in class org.jooq.util.ase.ASEDataType
-
- UNSIGNEDBIGINT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- UNSIGNEDBIGINT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- UNSIGNEDINT - Static variable in class org.jooq.util.ase.ASEDataType
-
- UNSIGNEDINT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- UNSIGNEDSMALLLINT - Static variable in class org.jooq.util.ase.ASEDataType
-
- UNSIGNEDSMALLLINT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- UNumber - Class in org.jooq.tools.unsigned
-
A base type for unsigned numbers.
- UNumber() - Constructor for class org.jooq.tools.unsigned.UNumber
-
- Updatable<R extends Record> - Interface in org.jooq
-
A common interface for objects (tables, records) that can be updated or
deleted using their primary keys.
- UpdatableRecord<R extends UpdatableRecord<R>> - Interface in org.jooq
-
A common interface for records that can be stored back to the database again.
- UpdatableRecordImpl<R extends UpdatableRecord<R>> - Class in org.jooq.impl
-
A record implementation for a record holding a primary key
This type is for JOOQ INTERNAL USE only.
- UpdatableRecordImpl(UpdatableTable<R>) - Constructor for class org.jooq.impl.UpdatableRecordImpl
-
- UpdatableTable<R extends Record> - Interface in org.jooq
-
A common interface for tables whose records can be stored back to the
database again.
- UpdatableTableImpl<R extends Record> - Class in org.jooq.impl
-
A table implementation for a table holding a primary key
This type is for JOOQ INTERNAL USE only.
- UpdatableTableImpl(String) - Constructor for class org.jooq.impl.UpdatableTableImpl
-
- UpdatableTableImpl(String, Schema) - Constructor for class org.jooq.impl.UpdatableTableImpl
-
- UpdatableTableImpl(String, Schema, Table<R>) - Constructor for class org.jooq.impl.UpdatableTableImpl
-
- update(P) - Method in interface org.jooq.DAO
-
Performs an UPDATE statement for a given POJO
- update(P...) - Method in interface org.jooq.DAO
-
Performs a batch UPDATE statement for a given set of POJOs
- update(Collection<P>) - Method in interface org.jooq.DAO
-
Performs a batch UPDATE statement for a given set of POJOs
- update(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL update statement.
- update(P) - Method in class org.jooq.impl.DAOImpl
-
- update(P...) - Method in class org.jooq.impl.DAOImpl
-
- update(Collection<P>) - Method in class org.jooq.impl.DAOImpl
-
- update(Table<R>) - Method in class org.jooq.impl.Factory
-
Create a new DSL update statement.
- update(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- Update<R extends Record> - Interface in org.jooq
-
A
Query that can update data in the database.
- UpdateConditionStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Update's DSL API.
- UpdateFinalStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Update's DSL API.
- updateQuery(Table<R>) - Method in interface org.jooq.FactoryOperations
-
- updateQuery(Table<R>) - Method in class org.jooq.impl.Factory
-
- updateQuery(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- UpdateQuery<R extends Record> - Interface in org.jooq
-
A query for data updating
- UpdateSetMoreStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Update's DSL API.
- UpdateSetStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Update's DSL API.
- UpdateWhereStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Update's DSL API.
- upper() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- upper(String) - Static method in class org.jooq.impl.Factory
-
Get the upper(field) function
- upper(Field<String>) - Static method in class org.jooq.impl.Factory
-
Get the upper(field) function
This renders the upper function in all dialects:
upper([field])
- use(Schema) - Method in interface org.jooq.FactoryOperations
-
Use a schema as the default schema of the underlying connection.
- use(String) - Method in interface org.jooq.FactoryOperations
-
Use a schema as the default schema of the underlying connection.
- use(Schema) - Method in class org.jooq.impl.Factory
-
Use a schema as the default schema of the underlying connection.
- use(String) - Method in class org.jooq.impl.Factory
-
Use a schema as the default schema of the underlying connection.
- use(Schema) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- use(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- use(Schema) - Method in class org.jooq.SchemaMapping
-
Deprecated.
Set a schema as the default schema.
- use(String) - Method in class org.jooq.SchemaMapping
-
Deprecated.
Set a schema as the default schema.
- ushort(String) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned short
- ushort(short) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned short by masking it with
0xFFFF i.e.
- ushort(int) - Static method in class org.jooq.tools.unsigned.Unsigned
-
Create an unsigned short
- UShort - Class in org.jooq.tools.unsigned
-
The unsigned short type
- UShort(int) - Constructor for class org.jooq.tools.unsigned.UShort
-
- UShort(short) - Constructor for class org.jooq.tools.unsigned.UShort
-
- UShort(String) - Constructor for class org.jooq.tools.unsigned.UShort
-
- using(TableLike<?>) - Method in interface org.jooq.MergeUsingStep
-
Add the USING clause to the SQL standard MERGE
statement
- using(Field<?>...) - Method in interface org.jooq.SelectOnStep
-
Join the previous table with the USING(column [, column...])
- using(Collection<? extends Field<?>>) - Method in interface org.jooq.SelectOnStep
-
Join the previous table with the USING(column [, column...])
- using(Field<?>...) - Method in interface org.jooq.TableOnStep
-
Join the table with the USING(column [, column...])
- using(Collection<? extends Field<?>>) - Method in interface org.jooq.TableOnStep
-
Join the table with the USING(column [, column...])
- usingDual() - Method in interface org.jooq.MergeUsingStep
-
Add a dummy USING clause to the SQL standard
MERGE statement
This results in USING(SELECT 1 FROM DUAL) for most RDBMS, or
in USING(SELECT 1) AS [dummy_table(dummy_field)] in SQL
Server, where derived tables need to be aliased.
- UUID - Static variable in class org.jooq.util.h2.H2DataType
-
V
- val(T) - Static method in class org.jooq.impl.Factory
-
Get a bind value
jOOQ tries to derive the RDBMS
DataType from the provided Java
type
<T>.
- val(Object, Class<? extends T>) - Static method in class org.jooq.impl.Factory
-
Get a bind value with an associated type, taken from a field
- val(Object, Field<T>) - Static method in class org.jooq.impl.Factory
-
Get a bind value with an associated type, taken from a field
- val(Object, DataType<T>) - Static method in class org.jooq.impl.Factory
-
Get a bind value with an associated type
This will try to bind value as type in a
PreparedStatement.
- vals(Object...) - Static method in class org.jooq.impl.Factory
-
Get a list of bind values and fields
- value(V) - Method in interface org.jooq.Case
-
This construct can be used to create expressions of the type
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
- value(Field<V>) - Method in interface org.jooq.Case
-
This construct can be used to create expressions of the type
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
- value() - Method in enum org.jooq.conf.RenderKeywordStyle
-
- value() - Method in enum org.jooq.conf.RenderNameStyle
-
- value() - Method in enum org.jooq.conf.StatementType
-
- value(T) - Static method in class org.jooq.impl.Factory
-
A synonym for
Factory.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword.
- value(Object, Class<? extends T>) - Static method in class org.jooq.impl.Factory
-
- value(Object, Field<T>) - Static method in class org.jooq.impl.Factory
-
- value(Object, DataType<T>) - Static method in class org.jooq.impl.Factory
-
- valueOf(String) - Static method in enum org.jooq.Comparator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.conf.RenderKeywordStyle
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.conf.RenderNameStyle
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.conf.StatementType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.DatePart
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.ExecuteType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.JoinType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.Operator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.RenderContext.CastMode
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.SortOrder
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.jooq.SQLDialect
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in class org.jooq.tools.unsigned.UByte
-
Get an instance of an unsigned byte
- valueOf(byte) - Static method in class org.jooq.tools.unsigned.UByte
-
Get an instance of an unsigned byte by masking it with
0xFF i.e.
- valueOf(short) - Static method in class org.jooq.tools.unsigned.UByte
-
Get an instance of an unsigned byte
- valueOf(int) - Static method in class org.jooq.tools.unsigned.UByte
-
Get an instance of an unsigned byte
- valueOf(long) - Static method in class org.jooq.tools.unsigned.UByte
-
Get an instance of an unsigned byte
- valueOf(String) - Static method in class org.jooq.tools.unsigned.UInteger
-
Create an unsigned int
- valueOf(int) - Static method in class org.jooq.tools.unsigned.UInteger
-
Create an unsigned int by masking it with
0xFFFFFFFF i.e.
- valueOf(long) - Static method in class org.jooq.tools.unsigned.UInteger
-
Create an unsigned int
- valueOf(String) - Static method in class org.jooq.tools.unsigned.ULong
-
Create an unsigned long
- valueOf(long) - Static method in class org.jooq.tools.unsigned.ULong
-
Create an unsigned long by masking it with
0xFFFFFFFFFFFFFFFF i.e.
- valueOf(BigInteger) - Static method in class org.jooq.tools.unsigned.ULong
-
Create an unsigned long
- valueOf(String) - Static method in class org.jooq.tools.unsigned.UShort
-
Create an unsigned short
- valueOf(short) - Static method in class org.jooq.tools.unsigned.UShort
-
Create an unsigned short by masking it with
0xFFFF i.e.
- valueOf(int) - Static method in class org.jooq.tools.unsigned.UShort
-
Create an unsigned short
- valueOf(String) - Static method in class org.jooq.types.DayToSecond
-
Parse a string representation of a INTERVAL DAY TO SECOND
- valueOf(double) - Static method in class org.jooq.types.DayToSecond
-
Load a
Double representation of a
INTERVAL DAY TO SECOND
- valueOf(String) - Static method in class org.jooq.types.YearToMonth
-
Parse a string representation of a INTERVAL YEAR TO MONTH
- values() - Static method in enum org.jooq.Comparator
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.conf.RenderKeywordStyle
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.conf.RenderNameStyle
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.conf.StatementType
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.DatePart
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.ExecuteType
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values(Object...) - Method in interface org.jooq.InsertSetStep
-
Add values to the insert statement with implicit field names
- values(Field<?>...) - Method in interface org.jooq.InsertSetStep
-
Add values to the insert statement with implicit field names
- values(Collection<?>) - Method in interface org.jooq.InsertSetStep
-
Add values to the insert statement with implicit field names
- values(Object...) - Method in interface org.jooq.InsertValuesStep
-
Add values to the insert statement
- values(Field<?>...) - Method in interface org.jooq.InsertValuesStep
-
Add values to the insert statement
- values(Collection<?>) - Method in interface org.jooq.InsertValuesStep
-
Add values to the insert statement
- values() - Static method in enum org.jooq.JoinType
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values(Object...) - Method in interface org.jooq.MergeNotMatchedValuesStep
-
Set VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.
- values(Field<?>...) - Method in interface org.jooq.MergeNotMatchedValuesStep
-
Set VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.
- values(Collection<?>) - Method in interface org.jooq.MergeNotMatchedValuesStep
-
Set VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.
- values(Object...) - Method in interface org.jooq.MergeValuesStep
-
Specify a VALUES clause
- values(Field<?>...) - Method in interface org.jooq.MergeValuesStep
-
Specify a VALUES clause
- values(Collection<?>) - Method in interface org.jooq.MergeValuesStep
-
Specify a VALUES clause
- values() - Static method in enum org.jooq.Operator
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.RenderContext.CastMode
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.SortOrder
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- values() - Static method in enum org.jooq.SQLDialect
-
Returns an array containing the constants of this enum type, in
the order they are declared.
- VARBINARY - Static variable in class org.jooq.impl.SQLDataType
-
- VARBINARY - Static variable in class org.jooq.util.ase.ASEDataType
-
- VARBINARY - Static variable in class org.jooq.util.h2.H2DataType
-
- VARBINARY - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- VARBINARY - Static variable in class org.jooq.util.ingres.IngresDataType
-
- VARBINARY - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- VARBINARY - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- VARBINARY - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- VARBIT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- VARBIT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- VARBIT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- VARBYTE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- VARCHAR - Static variable in class org.jooq.impl.SQLDataType
-
- VARCHAR - Static variable in class org.jooq.util.ase.ASEDataType
-
- VARCHAR - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- VARCHAR - Static variable in class org.jooq.util.db2.DB2DataType
-
- VARCHAR - Static variable in class org.jooq.util.derby.DerbyDataType
-
- VARCHAR - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- VARCHAR - Static variable in class org.jooq.util.h2.H2DataType
-
- VARCHAR - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- VARCHAR - Static variable in class org.jooq.util.ingres.IngresDataType
-
- VARCHAR - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- VARCHAR - Static variable in class org.jooq.util.oracle.OracleDataType
-
- VARCHAR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- VARCHAR - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- VARCHAR - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- VARCHAR - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- VARCHAR2 - Static variable in class org.jooq.util.h2.H2DataType
-
- VARCHAR2 - Static variable in class org.jooq.util.oracle.OracleDataType
-
- VARCHAR_CASESENSITIVE - Static variable in class org.jooq.util.h2.H2DataType
-
- VARCHAR_IGNORECASE - Static variable in class org.jooq.util.h2.H2DataType
-
- VARCHARFORBITDATA - Static variable in class org.jooq.util.db2.DB2DataType
-
- VARCHARFORBITDATA - Static variable in class org.jooq.util.derby.DerbyDataType
-
- VARCHARIGNORECASE - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- VARGRAPHIC - Static variable in class org.jooq.util.db2.DB2DataType
-
- VARNCHAR - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- varPop() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- varPop(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the population variance of a numeric field: var_pop(field)
- varPopOver() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- varSamp() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- varSamp(Field<? extends Number>) - Static method in class org.jooq.impl.Factory
-
Get the sample variance of a numeric field: var_samp(field)
- varSampOver() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- VARYINGCHARACTER - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- VERSION - Static variable in class org.jooq.Constants
-
The latest jOOQ version
W
- wait(int) - Method in interface org.jooq.SelectForUpdateWaitStep
-
Add a WAIT clause to the FOR UPDATE clause at
the end of the query.
- wait(int) - Method in interface org.jooq.SimpleSelectForUpdateWaitStep
-
Add a WAIT clause to the FOR UPDATE clause at
the end of the query.
- warn(Object) - Method in class org.jooq.tools.JooqLogger
-
- warn(Object, Object) - Method in class org.jooq.tools.JooqLogger
-
- warn(Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- warn(Object, Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- when(Condition, T) - Method in interface org.jooq.Case
-
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
- when(Condition, Field<T>) - Method in interface org.jooq.Case
-
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
- when(Condition, T) - Method in interface org.jooq.CaseConditionStep
-
Compare a condition to the already constructed case statement, return
result if the condition holds true
- when(Condition, Field<T>) - Method in interface org.jooq.CaseConditionStep
-
Compare a condition to the already constructed case statement, return
result if the condition holds true
- when(V, T) - Method in interface org.jooq.CaseValueStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(V, Field<T>) - Method in interface org.jooq.CaseValueStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(Field<V>, T) - Method in interface org.jooq.CaseValueStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(Field<V>, Field<T>) - Method in interface org.jooq.CaseValueStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(V, T) - Method in interface org.jooq.CaseWhenStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(V, Field<T>) - Method in interface org.jooq.CaseWhenStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(Field<V>, T) - Method in interface org.jooq.CaseWhenStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- when(Field<V>, Field<T>) - Method in interface org.jooq.CaseWhenStep
-
Compare a value to the already constructed case statement, return result
if values are equal.
- whenMatchedThenUpdate() - Method in interface org.jooq.MergeMatchedStep
-
Add the WHEN MATCHED THEN UPDATE clause to the
MERGE statement
- whenNotMatchedThenInsert() - Method in interface org.jooq.MergeNotMatchedStep
-
Add the WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement.
- whenNotMatchedThenInsert(Field<?>...) - Method in interface org.jooq.MergeNotMatchedStep
-
Add the WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement
- whenNotMatchedThenInsert(Collection<? extends Field<?>>) - Method in interface org.jooq.MergeNotMatchedStep
-
Add the WHEN MATCHED THEN UPDATE clause to the
MERGE statement
- where(Condition...) - Method in interface org.jooq.DeleteWhereStep
-
Add conditions to the query
- where(Collection<Condition>) - Method in interface org.jooq.DeleteWhereStep
-
Add conditions to the query
- where(String) - Method in interface org.jooq.DeleteWhereStep
-
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, Object...) - Method in interface org.jooq.DeleteWhereStep
-
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, QueryPart...) - Method in interface org.jooq.DeleteWhereStep
-
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(Condition) - Method in interface org.jooq.MergeMatchedWhereStep
-
Add an additional WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause.
- where(Condition) - Method in interface org.jooq.MergeNotMatchedWhereStep
-
Add an additional WHERE clause to the preceding
WHEN NOT MATCHED THEN INSERT clause.
- where(Condition...) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE clause to the query
- where(Collection<Condition>) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE clause to the query
- where(String) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, Object...) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, QueryPart...) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(Condition...) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE clause to the query
- where(Collection<Condition>) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE clause to the query
- where(String) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, Object...) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, QueryPart...) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(Condition...) - Method in interface org.jooq.UpdateWhereStep
-
Add conditions to the query
- where(Collection<Condition>) - Method in interface org.jooq.UpdateWhereStep
-
Add conditions to the query
- where(String) - Method in interface org.jooq.UpdateWhereStep
-
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, Object...) - Method in interface org.jooq.UpdateWhereStep
-
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- where(String, QueryPart...) - Method in interface org.jooq.UpdateWhereStep
-
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- whereExists(Select<?>) - Method in interface org.jooq.DeleteWhereStep
-
Add an EXISTS clause to the query
- whereExists(Select<?>) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE EXISTS clause to the query
- whereExists(Select<?>) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE EXISTS clause to the query
- whereExists(Select<?>) - Method in interface org.jooq.UpdateWhereStep
-
Add an EXISTS clause to the query
- whereNotExists(Select<?>) - Method in interface org.jooq.DeleteWhereStep
-
Add a NOT EXISTS clause to the query
- whereNotExists(Select<?>) - Method in interface org.jooq.SelectWhereStep
-
Add a WHERE NOT EXISTS clause to the query
- whereNotExists(Select<?>) - Method in interface org.jooq.SimpleSelectWhereStep
-
Add a WHERE NOT EXISTS clause to the query
- whereNotExists(Select<?>) - Method in interface org.jooq.UpdateWhereStep
-
Add a NOT EXISTS clause to the query
- WindowBeforeOverStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowFinalStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowIgnoreNullsStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowOrderByStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowOverStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowPartitionByStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowRowsAndStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- WindowRowsStep<T> - Interface in org.jooq
-
This type is used for the window function DSL API.
- withAttachRecords(Boolean) - Method in class org.jooq.conf.Settings
-
- withDefaultSchema(String) - Method in class org.jooq.conf.RenderMapping
-
- withExecuteListeners(String...) - Method in class org.jooq.conf.Settings
-
- withExecuteListeners(Collection<String>) - Method in class org.jooq.conf.Settings
-
- withExecuteListeners(List<String>) - Method in class org.jooq.conf.Settings
-
- withExecuteLogging(Boolean) - Method in class org.jooq.conf.Settings
-
- withExecuteWithOptimisticLocking(Boolean) - Method in class org.jooq.conf.Settings
-
- withinGroupOrderBy(Field<?>...) - Method in interface org.jooq.OrderedAggregateFunction
-
Add an WITHIN GROUP (ORDER BY ..)
- withinGroupOrderBy(SortField<?>...) - Method in interface org.jooq.OrderedAggregateFunction
-
Add an WITHIN GROUP (ORDER BY ..)
- withinGroupOrderBy(Collection<SortField<?>>) - Method in interface org.jooq.OrderedAggregateFunction
-
Add an WITHIN GROUP (ORDER BY ..)
- withInput(String) - Method in class org.jooq.conf.MappedSchema
-
- withInput(String) - Method in class org.jooq.conf.MappedTable
-
- withOutput(String) - Method in class org.jooq.conf.MappedSchema
-
- withOutput(String) - Method in class org.jooq.conf.MappedTable
-
- withRenderFormatted(Boolean) - Method in class org.jooq.conf.Settings
-
- withRenderKeywordStyle(RenderKeywordStyle) - Method in class org.jooq.conf.Settings
-
- withRenderMapping(RenderMapping) - Method in class org.jooq.conf.Settings
-
- withRenderNameStyle(RenderNameStyle) - Method in class org.jooq.conf.Settings
-
- withRenderSchema(Boolean) - Method in class org.jooq.conf.Settings
-
- withSchemata(MappedSchema...) - Method in class org.jooq.conf.RenderMapping
-
- withSchemata(Collection<MappedSchema>) - Method in class org.jooq.conf.RenderMapping
-
- withSchemata(List<MappedSchema>) - Method in class org.jooq.conf.RenderMapping
-
- withStatementType(StatementType) - Method in class org.jooq.conf.Settings
-
- withTables(MappedTable...) - Method in class org.jooq.conf.MappedSchema
-
- withTables(Collection<MappedTable>) - Method in class org.jooq.conf.MappedSchema
-
- withTables(List<MappedTable>) - Method in class org.jooq.conf.MappedSchema
-
- wrapper(Class<?>) - Static method in class org.jooq.tools.reflect.Reflect
-
Get a wrapper type for a primitive type, or the argument type itself, if
it is not a primitive type.
- writeJSONString(List<?>, Writer) - Static method in class org.jooq.tools.json.JSONArray
-
Encode a list into JSON text and write it to out.
- writeJSONString(Map<?, ?>, Writer) - Static method in class org.jooq.tools.json.JSONObject
-
Encode a map into JSON text and write it to out.
- writeJSONString(Object, Writer) - Static method in class org.jooq.tools.json.JSONValue
-
Encode an object into JSON text and write it to out.
- writeSQL(SQLOutput) - Method in class org.jooq.impl.UDTRecordImpl
-
- writeToSQLOutput(SQLOutput, Field<T>, T) - Static method in class org.jooq.impl.FieldTypeHelper
-
- writeToSQLOutput(SQLOutput, Class<? extends T>, T) - Static method in class org.jooq.impl.FieldTypeHelper
-
Deprecated.
- 2.3.0 - Do not reuse this method
X
- XID - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- XML - Static variable in class org.jooq.util.db2.DB2DataType
-
- XML - Static variable in class org.jooq.util.sybase.SybaseDataType
-
Y
- year(Date) - Static method in class org.jooq.impl.Factory
-
- year(Field<? extends Date>) - Static method in class org.jooq.impl.Factory
-
- YEAR - Static variable in class org.jooq.util.h2.H2DataType
-
- YEAR - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- YearToMonth - Class in org.jooq.types
-
An implementation for the SQL standard INTERVAL YEAR TO MONTH
data type.
- YearToMonth(int) - Constructor for class org.jooq.types.YearToMonth
-
Create a new year-month interval.
- YearToMonth(int, int) - Constructor for class org.jooq.types.YearToMonth
-
Create a new year-month interval.
Z
- zero() - Static method in class org.jooq.impl.Factory
-
A 0 literal.
_
- __BIGINT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.ase.ASEDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.db2.DB2DataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.h2.H2DataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.ingres.IngresDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __BIGINTEGER - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- __BINARY - Static variable in class org.jooq.util.db2.DB2DataType
-
- __BINARY - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __BINARY - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __BINARY - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __BINARY - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __BINARY - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- __BIT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __BIT - Static variable in class org.jooq.util.db2.DB2DataType
-
- __BIT - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __BIT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __BIT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __BIT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- __BLOB - Static variable in class org.jooq.util.ase.ASEDataType
-
- __BLOB - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __BLOB - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- __BOOL - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __BOOLEAN - Static variable in class org.jooq.util.ase.ASEDataType
-
- __BOOLEAN - Static variable in class org.jooq.util.db2.DB2DataType
-
- __BOOLEAN - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __BOOLEAN - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __BOOLEAN - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- __DOUBLE - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __DOUBLE - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __FLOAT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __FLOAT - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __FLOAT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __FLOAT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- __INTEGER - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.ase.ASEDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.db2.DB2DataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.h2.H2DataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- __LONGNVARCHAR - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.ase.ASEDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.db2.DB2DataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __LONGVARBINARY - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __LONGVARCHAR - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __LONGVARCHAR - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __LONGVARCHAR - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __LONGVARCHAR - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __LONGVARCHAR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __LONGVARCHAR - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __NCHAR - Static variable in class org.jooq.util.db2.DB2DataType
-
- __NCHAR - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __NCHAR - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __NCHAR - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- __NCHAR - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __NCHAR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __NCLOB - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __NCLOB - Static variable in class org.jooq.util.db2.DB2DataType
-
- __NCLOB - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __NCLOB - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __NCLOB - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- __NCLOB - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __NCLOB - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __NCLOB - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- __NCLOB - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- __NUMERIC - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __NUMERIC - Static variable in class org.jooq.util.db2.DB2DataType
-
- __NUMERIC - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __NVARCHAR - Static variable in class org.jooq.util.db2.DB2DataType
-
- __NVARCHAR - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __NVARCHAR - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __NVARCHAR - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- __NVARCHAR - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- __NVARCHAR - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __REAL - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __RESULT - Static variable in class org.jooq.util.h2.H2DataType
-
- __SMALLINT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __TIME - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __TIME - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- __TINYINT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- __TINYINT - Static variable in class org.jooq.util.db2.DB2DataType
-
- __TINYINT - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __TINYINT - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __TINYINT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __TINYINT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __VARBINARY - Static variable in class org.jooq.util.db2.DB2DataType
-
- __VARBINARY - Static variable in class org.jooq.util.derby.DerbyDataType
-
- __VARBINARY - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- __VARBINARY - Static variable in class org.jooq.util.oracle.OracleDataType
-
- __VARBINARY - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- __VARBINARY - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _ Copyright © 2013. All Rights Reserved.