- Factory - Class in org.jooq.impl
-
A factory providing implementations to the org.jooq interfaces
This factory is the main entry point for client code, to access jOOQ classes
and functionality.
- Factory(Connection, SQLDialect) - Constructor for class org.jooq.impl.Factory
-
Create a factory with a connection and a dialect configured.
- Factory(DataSource, SQLDialect) - Constructor for class org.jooq.impl.Factory
-
Create a factory with a data source and a dialect configured.
- Factory(SQLDialect) - Constructor for class org.jooq.impl.Factory
-
Create a factory with a dialect configured.
- Factory(Connection, SQLDialect, SchemaMapping) - Constructor for class org.jooq.impl.Factory
-
- Factory(Connection, SQLDialect, Settings) - Constructor for class org.jooq.impl.Factory
-
Create a factory with a connection, a dialect and settings configured.
- Factory(DataSource, SQLDialect, Settings) - Constructor for class org.jooq.impl.Factory
-
Create a factory with a data source, a dialect and settings configured.
- Factory(SQLDialect, Settings) - Constructor for class org.jooq.impl.Factory
-
Create a factory with a dialect and settings configured
Without a connection or data source, this factory cannot execute queries.
- FactoryOperations - Interface in org.jooq
-
The public API for the jOOQ
Factory
- FactoryProxy - Class in org.jooq.impl
-
- FactoryProxy() - Constructor for class org.jooq.impl.FactoryProxy
-
Deprecated.
- FALSE_VALUES - Static variable in class org.jooq.tools.Convert
-
- falseCondition() - Static method in class org.jooq.impl.Factory
-
Return a Condition
that will always evaluate to false
- fetch() - Method in interface org.jooq.Cursor
-
Fetch all remaining records as a result.
- fetch(int) - Method in interface org.jooq.Cursor
-
Fetch the next couple of records from the cursor.
- fetch(RecordMapper<? super R, E>) - Method in interface org.jooq.Cursor
-
Fetch results into a custom mapper callback
- fetch(Field<Z>, Z...) - Method in interface org.jooq.DAO
-
Find records by a given field and a set of values.
- fetch(ResultSet) - Method in interface org.jooq.FactoryOperations
-
- fetch(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Execute and return all records for
SELECT * FROM [table]
The result and its contained records are attached to this
Configuration
by default.
- fetch(Table<R>, Condition) - Method in interface org.jooq.FactoryOperations
-
Execute and return all records for
SELECT * FROM [table] WHERE [condition]
The result and its contained records are attached to this
Configuration
by default.
- fetch(String) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL.
- fetch(String, Object...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL.
- fetch(String, QueryPart...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL.
- fetch(Field<Z>, Z...) - Method in class org.jooq.impl.DAOImpl
-
- fetch(String) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL.
- fetch(String, Object...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL.
- fetch(String, QueryPart...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL.
- fetch(ResultSet) - Method in class org.jooq.impl.Factory
-
- fetch(Table<R>) - Method in class org.jooq.impl.Factory
-
Execute and return all records for
SELECT * FROM [table]
The result and its contained records are attached to this
Configuration
by default.
- fetch(Table<R>, Condition) - Method in class org.jooq.impl.Factory
-
Execute and return all records for
SELECT * FROM [table] WHERE [condition]
The result and its contained records are attached to this
Configuration
by default.
- fetch(ResultSet) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetch(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetch(String, Object...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetch(String, QueryPart...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetch(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetch(Table<R>, Condition) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetch() - Method in interface org.jooq.InsertResultStep
-
The result holding returned values as specified by the
InsertReturningStep
This currently only works well for DB2, HSQLDB, MySQL, and Postgres
- fetch() - Method in interface org.jooq.ResultQuery
-
- fetch(Field<T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field from the generated
result.
- fetch(Field<?>, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field from the generated
result.
- fetch(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field from the generated
result.
- fetch(int) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field index from the
generated result.
- fetch(int, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field index from the
generated result.
- fetch(int, Converter<?, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field index from the
generated result.
- fetch(String) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field name from the
generated result.
- fetch(String, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field name from the
generated result.
- fetch(String, Converter<?, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field name from the
generated result.
- fetch(RecordMapper<? super R, E>) - Method in interface org.jooq.ResultQuery
-
Fetch results into a custom mapper callback
- fetchAny(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1
The resulting record is attached to this
Configuration
by
default.
- fetchAny(Table<R>) - Method in class org.jooq.impl.Factory
-
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1
The resulting record is attached to this
Configuration
by
default.
- fetchAny(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchAny() - Method in interface org.jooq.ResultQuery
-
Execute the query and return at most one resulting record.
- fetchArray(int) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field index from the
generated result.
- fetchArray(int, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field index from the
generated result.
- fetchArray(int, Converter<?, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field index from the
generated result.
- fetchArray(String) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field name from the
generated result.
- fetchArray(String, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field name from the
generated result.
- fetchArray(String, Converter<?, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field name from the
generated result.
- fetchArray(Field<T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field from the generated
result.
- fetchArray(Field<?>, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field from the generated
result.
- fetchArray(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return all values for a field from the generated
result.
- fetchArrays() - Method in interface org.jooq.ResultQuery
-
Execute the query and return the generated result as an Object matrix
You can access data like this
query.fetchArray()[recordIndex][fieldIndex]
- fetchEnd(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
Called after fetching data from a ResultSet
.
- fetchEnd(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- fetchEnd(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- fetchFromCSV(String) - Method in interface org.jooq.FactoryOperations
-
Fetch all data from a CSV string.
- fetchFromCSV(String, char) - Method in interface org.jooq.FactoryOperations
-
Fetch all data from a CSV string.
- fetchFromCSV(String) - Method in class org.jooq.impl.Factory
-
Fetch all data from a CSV string.
- fetchFromCSV(String, char) - Method in class org.jooq.impl.Factory
-
Fetch all data from a CSV string.
- fetchFromCSV(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchFromCSV(String, char) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchGroups(Field<K>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with one of the result's
columns as key and a list of corresponding records as value.
- fetchGroups(Field<K>, Field<V>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with one of the result's
columns as key and another one of the result's columns as value
Unlike
ResultQuery.fetchMap(Field, Field)
, this method allows for non-unique
keys in the result set.
- fetchGroups(Field<?>[]) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with the result grouped by the
given keys.
- fetchGroups(Field<?>[], Class<? extends E>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with results grouped by the
given keys and mapped into the given entity type.
- fetchGroups(Field<K>, Class<? extends E>) - Method in interface org.jooq.ResultQuery
-
Return a
Map
with results grouped by the given key and mapped
into the given entity type.
- fetchInto(H) - Method in interface org.jooq.Cursor
-
Fetch results into a custom handler callback
The resulting records are attached to the original
Configuration
by default.
- fetchInto(Class<? extends E>) - Method in interface org.jooq.Cursor
-
Map resulting records onto a custom type.
- fetchInto(Table<Z>) - Method in interface org.jooq.Cursor
-
Map resulting records onto a custom record.
- fetchInto(Class<? extends E>) - Method in interface org.jooq.ResultQuery
-
Map resulting records onto a custom type.
- fetchInto(Table<Z>) - Method in interface org.jooq.ResultQuery
-
Map resulting records onto a custom record.
- fetchInto(H) - Method in interface org.jooq.ResultQuery
-
Fetch results into a custom handler callback
The resulting records are attached to the original
Configuration
by default.
- fetchLater() - Method in interface org.jooq.ResultQuery
-
Fetch results asynchronously.
- fetchLater(ExecutorService) - Method in interface org.jooq.ResultQuery
-
Fetch results asynchronously.
- fetchLazy(ResultSet) - Method in interface org.jooq.FactoryOperations
-
- fetchLazy(String) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL and "lazily" return the generated
result.
- fetchLazy(String, QueryPart...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL and "lazily" return the generated
result.
- fetchLazy(String, Object...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL and "lazily" return the generated
result.
- fetchLazy(String) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL and "lazily" return the generated
result.
- fetchLazy(String, Object...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL and "lazily" return the generated
result.
- fetchLazy(String, QueryPart...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL and "lazily" return the generated
result.
- fetchLazy(ResultSet) - Method in class org.jooq.impl.Factory
-
- fetchLazy(ResultSet) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchLazy(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchLazy(String, Object...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchLazy(String, QueryPart...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchLazy() - Method in interface org.jooq.ResultQuery
-
Execute the query and "lazily" return the generated result
The returned
Cursor
holds a reference to the executed
PreparedStatement
and the associated
ResultSet
.
- fetchLazy(int) - Method in interface org.jooq.ResultQuery
-
Execute the query and "lazily" return the generated result
The returned
Cursor
holds a reference to the executed
PreparedStatement
and the associated
ResultSet
.
- fetchMany(String) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL, possibly returning several result
sets
Example (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- fetchMany(String, Object...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL, possibly returning several result
sets.
- fetchMany(String, QueryPart...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL, possibly returning several result
sets.
- fetchMany(String) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL, possibly returning several result
sets
Example (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- fetchMany(String, Object...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL, possibly returning several result
sets.
- fetchMany(String, QueryPart...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL, possibly returning several result
sets.
- fetchMany(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchMany(String, Object...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchMany(String, QueryPart...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchMany() - Method in interface org.jooq.ResultQuery
-
Execute a query, possibly returning several result sets.
- fetchMap(Field<K>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with one of the result's
columns as key and the corresponding records as value.
- fetchMap(Field<K>, Field<V>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with one of the result's
columns as key and another one of the result's columns as value
An exception is thrown, if the key turns out to be non-unique in the
result set.
- fetchMap(Field<?>[]) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with keys as a map key and the
corresponding record as value.
- fetchMap(Field<?>[], Class<? extends E>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with results grouped by the
given keys and mapped into the given entity type.
- fetchMap(Field<K>, Class<? extends E>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return a
Map
with results grouped by the
given key and mapped into the given entity type.
- fetchMaps() - Method in interface org.jooq.ResultQuery
-
Execute the query and return the generated result as a list of name/value
maps.
- fetchOne() - Method in interface org.jooq.Cursor
-
Fetch the next record from the cursor
This will conveniently close the Cursor
, after the last
Record
was fetched.
- fetchOne(RecordMapper<? super R, E>) - Method in interface org.jooq.Cursor
-
Fetch the next record into a custom mapper callback
This will conveniently close the Cursor
, after the last
Record
was fetched.
- fetchOne(Field<Z>, Z) - Method in interface org.jooq.DAO
-
Find a unique record by a given field and a value.
- fetchOne(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Execute and return zero or one record for
SELECT * FROM [table]
The resulting record is attached to this
Configuration
by
default.
- fetchOne(Table<R>, Condition) - Method in interface org.jooq.FactoryOperations
-
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition]
The resulting record is attached to this
Configuration
by
default.
- fetchOne(String) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL.
- fetchOne(String, Object...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL.
- fetchOne(String, QueryPart...) - Method in interface org.jooq.FactoryOperations
-
Execute a new query holding plain SQL.
- fetchOne(Field<Z>, Z) - Method in class org.jooq.impl.DAOImpl
-
- fetchOne(String) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL.
- fetchOne(String, Object...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL.
- fetchOne(String, QueryPart...) - Method in class org.jooq.impl.Factory
-
Execute a new query holding plain SQL.
- fetchOne(Table<R>) - Method in class org.jooq.impl.Factory
-
Execute and return zero or one record for
SELECT * FROM [table]
The resulting record is attached to this
Configuration
by
default.
- fetchOne(Table<R>, Condition) - Method in class org.jooq.impl.Factory
-
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition]
The resulting record is attached to this
Configuration
by
default.
- fetchOne(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchOne(String, Object...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchOne(String, QueryPart...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchOne(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchOne(Table<R>, Condition) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- fetchOne() - Method in interface org.jooq.InsertResultStep
-
- fetchOne(Field<T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field from the generated result.
- fetchOne(Field<?>, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field from the generated result.
- fetchOne(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field from the generated result.
- fetchOne(int) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field index from the generated result.
- fetchOne(int, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field index from the generated result.
- fetchOne(int, Converter<?, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field index from the generated result.
- fetchOne(String) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field name from the generated result.
- fetchOne(String, Class<? extends T>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field name from the generated result.
- fetchOne(String, Converter<?, U>) - Method in interface org.jooq.ResultQuery
-
Execute the query and return return at most one resulting value for a
field name from the generated result.
- fetchOne() - Method in interface org.jooq.ResultQuery
-
Execute the query and return at most one resulting record.
- fetchOneArray() - Method in interface org.jooq.ResultQuery
-
Execute the query and return at most one resulting record as an array
You can access data like this
query.fetchOneArray()[fieldIndex]
- fetchOneInto(H) - Method in interface org.jooq.Cursor
-
Fetch the next record into a custom handler callback
This will conveniently close the Cursor
, after the last
Record
was fetched.
- fetchOneInto(Class<? extends E>) - Method in interface org.jooq.Cursor
-
Map the next resulting record onto a custom type.
- fetchOneInto(Table<Z>) - Method in interface org.jooq.Cursor
-
Map the next resulting record onto a custom record.
- fetchOneMap() - Method in interface org.jooq.ResultQuery
-
Execute the query and return at most one resulting record as a name/value
map.
- fetchResultSet() - Method in interface org.jooq.ResultQuery
-
Execute the query and return the generated result as a JDBC
ResultSet
This will return the
ResultSet
returned by the JDBC driver,
leaving it untouched.
- fetchStart(ExecuteContext) - Method in interface org.jooq.ExecuteListener
-
Called before fetching data from a ResultSet
.
- fetchStart(ExecuteContext) - Method in class org.jooq.impl.DefaultExecuteListener
-
- fetchStart(ExecuteContext) - Method in class org.jooq.tools.StopWatchListener
-
- Field<T> - Interface in org.jooq
-
A field used in tables and conditions
- field(String, QueryPart...) - Static method in class org.jooq.impl.Factory
-
A custom SQL clause that can render arbitrary SQL elements.
- field(String, Class<T>, QueryPart...) - Static method in class org.jooq.impl.Factory
-
A custom SQL clause that can render arbitrary SQL elements.
- field(String, DataType<T>, QueryPart...) - Static method in class org.jooq.impl.Factory
-
A custom SQL clause that can render arbitrary SQL elements.
- field(String) - Static method in class org.jooq.impl.Factory
-
A PlainSQLField is a field that can contain user-defined plain SQL,
because sometimes it is easier to express things directly in SQL, for
instance complex proprietary functions.
- field(String, Object...) - Static method in class org.jooq.impl.Factory
-
A PlainSQLField is a field that can contain user-defined plain SQL,
because sometimes it is easier to express things directly in SQL, for
instance complex proprietary functions.
- field(String, Class<T>) - Static method in class org.jooq.impl.Factory
-
A PlainSQLField is a field that can contain user-defined plain SQL,
because sometimes it is easier to express things directly in SQL, for
instance complex proprietary functions.
- field(String, Class<T>, Object...) - Static method in class org.jooq.impl.Factory
-
A PlainSQLField is a field that can contain user-defined plain SQL,
because sometimes it is easier to express things directly in SQL, for
instance complex proprietary functions.
- field(String, DataType<T>) - Static method in class org.jooq.impl.Factory
-
A PlainSQLField is a field that can contain user-defined plain SQL,
because sometimes it is easier to express things directly in SQL, for
instance complex proprietary functions.
- field(String, DataType<T>, Object...) - Static method in class org.jooq.impl.Factory
-
A PlainSQLField is a field that can contain user-defined plain SQL,
because sometimes it is easier to express things directly in SQL, for
instance complex proprietary functions.
- field(String) - Method in class org.jooq.tools.reflect.Reflect
-
Get a wrapped field.
- field1() - Method in interface org.jooq.Row1
-
Get the first field
- field1() - Method in interface org.jooq.Row2
-
Get the first field
- field1() - Method in interface org.jooq.Row3
-
Get the first field
- field1() - Method in interface org.jooq.Row4
-
Get the first field
- field1() - Method in interface org.jooq.Row5
-
Get the first field
- field1() - Method in interface org.jooq.Row6
-
Get the first field
- field1() - Method in interface org.jooq.Row7
-
Get the first field
- field1() - Method in interface org.jooq.Row8
-
Get the first field
- field2() - Method in interface org.jooq.Row2
-
Get the second field
- field2() - Method in interface org.jooq.Row3
-
Get the second field
- field2() - Method in interface org.jooq.Row4
-
Get the second field
- field2() - Method in interface org.jooq.Row5
-
Get the second field
- field2() - Method in interface org.jooq.Row6
-
Get the second field
- field2() - Method in interface org.jooq.Row7
-
Get the second field
- field2() - Method in interface org.jooq.Row8
-
Get the second field
- field3() - Method in interface org.jooq.Row3
-
Get the third field
- field3() - Method in interface org.jooq.Row4
-
Get the third field
- field3() - Method in interface org.jooq.Row5
-
Get the third field
- field3() - Method in interface org.jooq.Row6
-
Get the third field
- field3() - Method in interface org.jooq.Row7
-
Get the third field
- field3() - Method in interface org.jooq.Row8
-
Get the third field
- field4() - Method in interface org.jooq.Row4
-
Get the fourth field
- field4() - Method in interface org.jooq.Row5
-
Get the fourth field
- field4() - Method in interface org.jooq.Row6
-
Get the fourth field
- field4() - Method in interface org.jooq.Row7
-
Get the fourth field
- field4() - Method in interface org.jooq.Row8
-
Get the fourth field
- field5() - Method in interface org.jooq.Row5
-
Get the fifth field
- field5() - Method in interface org.jooq.Row6
-
Get the fifth field
- field5() - Method in interface org.jooq.Row7
-
Get the fifth field
- field5() - Method in interface org.jooq.Row8
-
Get the fifth field
- field6() - Method in interface org.jooq.Row6
-
Get the sixth field
- field6() - Method in interface org.jooq.Row7
-
Get the sixth field
- field6() - Method in interface org.jooq.Row8
-
Get the sixth field
- field7() - Method in interface org.jooq.Row7
-
Get the seventh field
- field7() - Method in interface org.jooq.Row8
-
Get the seventh field
- field8() - Method in interface org.jooq.Row8
-
Get the eight field
- fieldByName(String...) - Static method in class org.jooq.impl.Factory
-
Create a qualified field, given its (qualified) field name.
- fieldByName(Class<T>, String...) - Static method in class org.jooq.impl.Factory
-
Create a qualified field, given its (qualified) field name.
- fieldByName(DataType<T>, String...) - Static method in class org.jooq.impl.Factory
-
Create a qualified field, given its (qualified) field name.
- FieldLike - Interface in org.jooq
-
An object that can behave like a field (a field-like object)
- FieldProvider - Interface in org.jooq
-
- fields(Field<?>...) - Method in interface org.jooq.LoaderCSVStep
-
Specify the the fields to be loaded into the table in the correct order.
- fields(Collection<? extends Field<?>>) - Method in interface org.jooq.LoaderCSVStep
-
Specify the the fields to be loaded into the table in the correct order.
- fields() - Method in class org.jooq.tools.reflect.Reflect
-
Get a Map containing field names and wrapped values for the fields'
values.
- FieldTypeHelper - Class in org.jooq.impl
-
Utility methods related to the treatment of fields and their types
This class is for JOOQ INTERNAL USE only.
- findAll() - Method in interface org.jooq.DAO
-
Find all records of the underlying table.
- findAll() - Method in class org.jooq.impl.DAOImpl
-
- findById(T) - Method in interface org.jooq.DAO
-
Find a record of the underlying table by ID.
- findById(T) - Method in class org.jooq.impl.DAOImpl
-
- FirebirdDataType<T> - Class in org.jooq.util.firebird
-
- FirebirdFactory - Class in org.jooq.util.firebird
-
- FirebirdFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
- FirebirdFactory(Connection, Settings) - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
Create a factory with connection and a settings configured
- FirebirdFactory(DataSource, Settings) - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
Create a factory with a data source and a settings configured
- FirebirdFactory(Connection) - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
Create a factory with connection
- FirebirdFactory(DataSource) - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
Create a factory with a data source
- FirebirdFactory(Settings) - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- FirebirdFactory() - Constructor for class org.jooq.util.firebird.FirebirdFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- firstValue() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- firstValue(Field<T>) - Static method in class org.jooq.impl.Factory
-
The first_value(field) over ([analytic clause])
function.
- FLOAT - Static variable in class org.jooq.impl.SQLDataType
-
- FLOAT - Static variable in class org.jooq.util.ase.ASEDataType
-
- FLOAT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- FLOAT - Static variable in class org.jooq.util.derby.DerbyDataType
-
- FLOAT - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- FLOAT - Static variable in class org.jooq.util.h2.H2DataType
-
- FLOAT - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- FLOAT - Static variable in class org.jooq.util.ingres.IngresDataType
-
- FLOAT - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- FLOAT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- FLOAT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- FLOAT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- FLOAT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- FLOAT4 - Static variable in class org.jooq.util.h2.H2DataType
-
- FLOAT4 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- FLOAT4 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- FLOAT8 - Static variable in class org.jooq.util.h2.H2DataType
-
- FLOAT8 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- FLOAT8 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- floatValue() - Method in class org.jooq.tools.unsigned.UByte
-
- floatValue() - Method in class org.jooq.tools.unsigned.UInteger
-
- floatValue() - Method in class org.jooq.tools.unsigned.ULong
-
- floatValue() - Method in class org.jooq.tools.unsigned.UShort
-
- floatValue() - Method in class org.jooq.types.DayToSecond
-
- floatValue() - Method in interface org.jooq.types.Interval
-
- floatValue() - Method in class org.jooq.types.YearToMonth
-
- floor() - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- floor(T) - Static method in class org.jooq.impl.Factory
-
Get the largest integer value not greater than [this]
- floor(Field<T>) - Static method in class org.jooq.impl.Factory
-
Get the largest integer value not greater than [this]
This renders the floor function where available:
floor([this])
... or simulates it elsewhere using round:
round([this] - 0.499999999999999)
- ForeignKey<R extends Record,U extends Record> - Interface in org.jooq
-
A
ForeignKey
is an object referencing a
UniqueKey
.
- format() - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result.
- format(int) - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result.
- format(long) - Static method in class org.jooq.tools.StopWatch
-
- formatCSV() - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result as CSV.
- formatCSV(char) - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result as CSV.
- formatCSV(char, String) - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result as CSV.
- formatHours(long) - Static method in class org.jooq.tools.StopWatch
-
- formatHTML() - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result as HTML.
- formatIndentEnd() - Method in interface org.jooq.RenderContext
-
- formatIndentEnd(int) - Method in interface org.jooq.RenderContext
-
- formatIndentLockEnd() - Method in interface org.jooq.RenderContext
-
- formatIndentLockStart() - Method in interface org.jooq.RenderContext
-
- formatIndentStart() - Method in interface org.jooq.RenderContext
-
- formatIndentStart(int) - Method in interface org.jooq.RenderContext
-
- formatJSON() - Method in interface org.jooq.Result
-
Get a simple formatted representation of this result as a JSON array of
array.
- formatNewLine() - Method in interface org.jooq.RenderContext
-
- formatNewLineAfterPrintMargin() - Method in interface org.jooq.RenderContext
-
- formatPrintMargin(int) - Method in interface org.jooq.RenderContext
-
- formatSeparator() - Method in interface org.jooq.RenderContext
-
- formatXML() - Method in interface org.jooq.Result
-
Get this result formatted as XML
- forShare() - Method in interface org.jooq.SelectForUpdateStep
-
Add a FOR SHARE
clause to the end of the query.
- forShare() - Method in interface org.jooq.SimpleSelectForUpdateStep
-
Add a FOR SHARE
clause to the end of the query.
- forUpdate() - Method in interface org.jooq.SelectForUpdateStep
-
Add a FOR UPDATE
clause to the end of the query.
- forUpdate() - Method in interface org.jooq.SimpleSelectForUpdateStep
-
Add a FOR UPDATE
clause to the end of the query.
- from(T) - Method in interface org.jooq.Converter
-
Convert a database object to a user object
- from(T) - Method in class org.jooq.impl.EnumConverter
-
- from(Object) - Method in interface org.jooq.Record
-
Load data into this record from a source.
- from(TableLike<?>...) - Method in interface org.jooq.SelectFromStep
-
Add a FROM
clause to the query
- from(Collection<? extends TableLike<?>>) - Method in interface org.jooq.SelectFromStep
-
Add a FROM
clause to the query
- from(String) - Method in interface org.jooq.SelectFromStep
-
Add a FROM
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- from(String, Object...) - Method in interface org.jooq.SelectFromStep
-
Add a FROM
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- from(String, QueryPart...) - Method in interface org.jooq.SelectFromStep
-
Add a FROM
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- fromType() - Method in interface org.jooq.Converter
-
The database type
- fromType() - Method in class org.jooq.impl.EnumConverter
-
- fromValue(String) - Static method in enum org.jooq.conf.RenderKeywordStyle
-
- fromValue(String) - Static method in enum org.jooq.conf.RenderNameStyle
-
- fromValue(String) - Static method in enum org.jooq.conf.StatementType
-
- fullOuterJoin(TableLike<?>) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
FULL OUTER JOIN
a table to the last
table added to the
FROM
clause using
Table.fullOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it
- fullOuterJoin(String) - Method in interface org.jooq.SelectJoinStep
-
Convenience method to
FULL OUTER JOIN
a table to the last
table added to the
FROM
clause using
Table.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- fullOuterJoin(String, Object...) - Method in interface org.jooq.SelectJoinStep
-
- fullOuterJoin(String, QueryPart...) - Method in interface org.jooq.SelectJoinStep
-
- fullOuterJoin(TableLike<?>) - Method in interface org.jooq.Table
-
FULL OUTER JOIN
a table to this table.
- fullOuterJoin(String) - Method in interface org.jooq.Table
-
FULL OUTER JOIN
a table to this table.
- fullOuterJoin(String, Object...) - Method in interface org.jooq.Table
-
FULL OUTER JOIN
a table to this table.
- fullOuterJoin(String, QueryPart...) - Method in interface org.jooq.Table
-
FULL OUTER JOIN
a table to this table.
- function(String, Class<T>, Field<?>...) - Static method in class org.jooq.impl.Factory
-
function()
can be used to access native functions that are
not yet or insufficiently supported by jOOQ
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- function(String, DataType<T>, Field<?>...) - Static method in class org.jooq.impl.Factory
-
function()
can be used to access native functions that are
not yet or insufficiently supported by jOOQ
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- FutureResult<R extends Record> - Interface in org.jooq
-
Fetch results asynchronously.
- ge(T) - Method in interface org.jooq.Field
-
this >= value
- ge(Field<T>) - Method in interface org.jooq.Field
-
this >= field
- ge(Select<?>) - Method in interface org.jooq.Field
-
this >= (Select
- get() - Method in interface org.jooq.ArrayRecord
-
Get the contained array
- get() - Method in class org.jooq.impl.ArrayRecordImpl
-
- get() - Method in class org.jooq.tools.reflect.Reflect
-
Get the wrapped object
- get(String) - Method in class org.jooq.tools.reflect.Reflect
-
Get a field value.
- getArrayDataType() - Method in interface org.jooq.DataType
-
Retrieve the data type for an ARRAY of this data type
- getArrayDataType() - Method in class org.jooq.impl.AbstractDataType
-
- getArrayType() - Method in interface org.jooq.DataType
-
Retrieve the Java type associated with ARRAYs of this data type
- getArrayType() - Method in class org.jooq.impl.AbstractDataType
-
- getAttachables() - Method in interface org.jooq.AttachableInternal
-
Deprecated.
- 2.5.0 [#1544] - This internal method will be removed soon.
Do not reuse.
- getAttachables() - Method in class org.jooq.impl.AbstractRoutine
-
- getAttachables() - Method in class org.jooq.impl.ArrayRecordImpl
-
- getAutoCommit() - Method in interface org.jooq.FactoryOperations
-
- getAutoCommit() - Method in class org.jooq.impl.Factory
-
- getAutoCommit() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getBindValues() - Method in interface org.jooq.Query
-
Retrieve the bind values that will be bound by this Query.
- getBindValues() - Method in interface org.jooq.QueryPartInternal
-
- getCastTypeName() - Method in interface org.jooq.DataType
-
Retrieve the dialect-specific type name associated with this data type
used for casting
This is useful for some dialects that have specialised type names for
cast expressions.
- getCastTypeName(Configuration) - Method in interface org.jooq.DataType
-
Retrieve the dialect-specific type name associated with this data type
used for casting
This is useful for some dialects that have specialised type names for
cast expressions.
- getCastTypeName(Configuration, int) - Method in interface org.jooq.DataType
-
Retrieve the dialect-specific type name associated with this data type
used for casting
This is useful for some dialects that have specialised type names for
cast expressions.
- getCastTypeName(Configuration, int, int) - Method in interface org.jooq.DataType
-
Retrieve the dialect-specific type name associated with this data type
used for casting
This is useful for some dialects that have specialised type names for
cast expressions.
- getCastTypeName() - Method in class org.jooq.impl.AbstractDataType
-
- getCastTypeName(Configuration, int) - Method in class org.jooq.impl.AbstractDataType
-
- getCastTypeName(Configuration, int, int) - Method in class org.jooq.impl.AbstractDataType
-
- getCastTypeName(Configuration) - Method in class org.jooq.impl.AbstractDataType
-
- getClass(int, int, int) - Static method in class org.jooq.impl.FieldTypeHelper
-
- getConfiguration() - Method in interface org.jooq.AttachableInternal
-
Get the underlying configuration
- getConfiguration() - Method in class org.jooq.impl.AbstractRoutine
-
- getConnection() - Method in interface org.jooq.Configuration
-
- getConnection() - Method in interface org.jooq.ExecuteContext
-
- getConnection() - Method in class org.jooq.impl.Factory
-
- getConnection() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getData() - Method in interface org.jooq.Configuration
-
- getData(String) - Method in interface org.jooq.Configuration
-
- getData() - Method in class org.jooq.impl.Factory
-
- getData(String) - Method in class org.jooq.impl.Factory
-
- getData() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getData(String) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getDataSource() - Method in interface org.jooq.Configuration
-
Retrieve the configured data source
- getDataSource() - Method in class org.jooq.impl.Factory
-
Retrieve the configured data source
- getDataSource() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getDataType() - Method in interface org.jooq.ArrayRecord
-
Get the data type of the array type
- getDataType(Configuration) - Method in interface org.jooq.DataType
-
The dialect-specific data type representing this data type.
- getDataType() - Method in interface org.jooq.Field
-
The type of this field (might not be dialect-specific)
- getDataType(Configuration) - Method in interface org.jooq.Field
-
The dialect-specific type of this field
- getDataType(Configuration) - Method in class org.jooq.impl.AbstractDataType
-
- getDataType(SQLDialect, String) - Static method in class org.jooq.impl.AbstractDataType
-
- getDataType(SQLDialect, Class<? extends T>) - Static method in class org.jooq.impl.AbstractDataType
-
- getDataType() - Method in class org.jooq.impl.ArrayRecordImpl
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.impl.Factory
-
Get the default data type for the
Factory
's underlying
SQLDialect
and a given Java type.
- getDataType(SQLDialect, Class<? extends T>) - Static method in class org.jooq.impl.FieldTypeHelper
-
- getDataType() - Method in class org.jooq.impl.SequenceImpl
-
- getDataType() - Method in class org.jooq.impl.UDTImpl
-
- getDataType() - Method in interface org.jooq.NamedTypeProviderQueryPart
-
Deprecated.
The type of this object (might not be dialect-specific)
- getDataType(Configuration) - Method in interface org.jooq.NamedTypeProviderQueryPart
-
Deprecated.
The dialect-specific type of this object
- getDataType() - Method in interface org.jooq.Parameter
-
The type of this parameter (might not be dialect-specific)
- getDataType(Configuration) - Method in interface org.jooq.Parameter
-
The dialect-specific type of this parameter
- getDataType() - Method in interface org.jooq.Sequence
-
Get the sequence data type
- getDataType() - Method in interface org.jooq.UDT
-
The UDT's data type as known to the database
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.ase.ASEDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.cubrid.CUBRIDDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.db2.DB2DataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.derby.DerbyDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.firebird.FirebirdDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.h2.H2DataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.hsqldb.HSQLDBDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.ingres.IngresDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.mysql.MySQLDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.oracle.OracleDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.postgres.PostgresDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.sqlite.SQLiteDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.sqlserver.SQLServerDataType
-
- getDataType(Class<? extends T>) - Static method in class org.jooq.util.sybase.SybaseDataType
-
- getDays() - Method in class org.jooq.types.DayToSecond
-
Get the day-part of this interval
- getDefaultDataType(SQLDialect, String) - Static method in class org.jooq.impl.AbstractDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.ase.ASEDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.cubrid.CUBRIDDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.db2.DB2DataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.derby.DerbyDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.firebird.FirebirdDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.h2.H2DataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.hsqldb.HSQLDBDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.ingres.IngresDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.mysql.MySQLDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.oracle.OracleDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.postgres.PostgresDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.sqlite.SQLiteDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.sqlserver.SQLServerDataType
-
- getDefaultDataType(String) - Static method in class org.jooq.util.sybase.SybaseDataType
-
- getDefaultSchema() - Method in class org.jooq.conf.RenderMapping
-
Gets the value of the defaultSchema property.
- getDegree() - Method in interface org.jooq.Row
-
Get the degree of this row value expression
- getDialect() - Method in interface org.jooq.Configuration
-
Retrieve the configured dialect
- getDialect() - Method in interface org.jooq.DataType
-
- getDialect() - Method in class org.jooq.impl.AbstractDataType
-
- getDialect() - Method in class org.jooq.impl.Factory
-
Retrieve the configured dialect
- getDialect() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getDialect() - Method in interface org.jooq.QueryPartInternal
-
Deprecated.
- 2.0.2 - The attached SQL dialect of a QueryPart
should no longer be referenced, as query parts become more
and more Configuration
- independent
- getDialectDataType(SQLDialect, String, int, int) - Static method in class org.jooq.impl.FieldTypeHelper
-
Convert a type name (using precision and scale) into a Java class
- getDialectJavaType(SQLDialect, String, int, int) - Static method in class org.jooq.impl.FieldTypeHelper
-
Convert a type name (using precision and scale) into a Java class
- getExecuteListeners() - Method in class org.jooq.conf.Settings
-
- getFactory() - Method in enum org.jooq.SQLDialect
-
A
Factory
class whose instances are pre-configured with this
dialect.
- getField(Field<T>) - Method in interface org.jooq.FieldProvider
-
Get a specific field from this field provider.
- getField(String) - Method in interface org.jooq.FieldProvider
-
Get a specific field from this field provider.
- getField(int) - Method in interface org.jooq.FieldProvider
-
Get a specific field from this field provider.
- getField() - Method in interface org.jooq.Identity
-
The IDENTITY
column.
- getField(int) - Method in interface org.jooq.Row
-
Get a field at a given index
- getFieldList() - Method in class org.jooq.impl.TableImpl
-
- getFieldList() - Method in class org.jooq.impl.UDTImpl
-
- getFields() - Method in interface org.jooq.FieldProvider
-
- getFields() - Method in interface org.jooq.Key
-
The fields that make up the KEY
- getFields() - Method in interface org.jooq.Row
-
Get all fields of this row value expression
- getFieldsArray() - Method in interface org.jooq.Key
-
The fields that make up the KEY
- getFromSQLInput(Configuration, SQLInput, Field<T>) - Static method in class org.jooq.impl.FieldTypeHelper
-
- getFromStatement(ExecuteContext, Class<? extends T>, int) - Static method in class org.jooq.impl.FieldTypeHelper
-
- getHoldability() - Method in interface org.jooq.FactoryOperations
-
- getHoldability() - Method in class org.jooq.impl.Factory
-
- getHoldability() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getHours() - Method in class org.jooq.types.DayToSecond
-
Get the hour-part of this interval
- getId(P) - Method in class org.jooq.impl.DAOImpl
-
- getIdentity() - Method in class org.jooq.impl.CustomTable
-
- getIdentity() - Method in interface org.jooq.Table
-
Retrieve the table's IDENTITY
information, if available.
- getIndex(Field<?>) - Method in interface org.jooq.FieldProvider
-
Get a fields index from this field provider
- getInParameters() - Method in class org.jooq.impl.AbstractRoutine
-
- getInParameters() - Method in interface org.jooq.Routine
-
A list of IN parameters passed to the stored procedure as argument.
- getInput() - Method in class org.jooq.conf.MappedSchema
-
Gets the value of the input property.
- getInput() - Method in class org.jooq.conf.MappedTable
-
Gets the value of the input property.
- getInValues() - Method in class org.jooq.impl.AbstractRoutine
-
- getKey() - Method in interface org.jooq.ForeignKey
-
The referenced Key
- getKeys() - Method in class org.jooq.impl.UpdatableTableImpl
-
Retrieve all of the table's unique keys.
- getKeys() - Method in interface org.jooq.UpdatableTable
-
Retrieve all of the table's unique keys.
- getList() - Method in interface org.jooq.ArrayRecord
-
Get the contained array as a
List
- getList() - Method in class org.jooq.impl.ArrayRecordImpl
-
- getLiteral() - Method in interface org.jooq.EnumType
-
The literal as defined in the database
- getLogger(Class<?>) - Static method in class org.jooq.tools.JooqLogger
-
- getMainKey() - Method in class org.jooq.impl.UpdatableTableImpl
-
Retrieve the table's main unique key.
- getMainKey() - Method in interface org.jooq.UpdatableTable
-
Retrieve the table's main unique key.
- getMicro() - Method in class org.jooq.types.DayToSecond
-
Get the (truncated) micro-part of this interval
- getMilli() - Method in class org.jooq.types.DayToSecond
-
Get the (truncated) milli-part of this interval
- getMinutes() - Method in class org.jooq.types.DayToSecond
-
Get the minute-part of this interval
- getMonths() - Method in class org.jooq.types.YearToMonth
-
- getName() - Method in interface org.jooq.ArrayRecord
-
Get the name of the array type
- getName() - Method in interface org.jooq.EnumType
-
The type name as registered in the database, if applicable (Postgres
schema-scope enum type only).
- getName() - Method in interface org.jooq.Field
-
The name of the field.
- getName() - Method in class org.jooq.impl.ArrayRecordImpl
-
- getName() - Method in class org.jooq.impl.SequenceImpl
-
- getName() - Method in interface org.jooq.Name
-
The qualified name of this SQL identifier
- getName() - Method in interface org.jooq.NamedQueryPart
-
Deprecated.
The name of this query part
- getName() - Method in interface org.jooq.Package
-
The name of this package
- getName() - Method in interface org.jooq.Param
-
The name of the field.
- getName() - Method in interface org.jooq.Parameter
-
The name of this parameter
- getName() - Method in interface org.jooq.Routine
-
The name of this routine
- getName() - Method in interface org.jooq.Schema
-
The name of this schema
- getName() - Method in interface org.jooq.Sequence
-
Get the sequence name
- getName() - Method in interface org.jooq.SortField
-
The name of this sort field
- getName() - Method in enum org.jooq.SQLDialect
-
The name of this dialect as it appears in related class names.
- getName() - Method in interface org.jooq.Table
-
The name of this table
- getName() - Method in interface org.jooq.UDT
-
The name of this UDT
- getNameLC() - Method in enum org.jooq.SQLDialect
-
The name of this dialect as it appears in related package names.
- getNameUC() - Method in enum org.jooq.SQLDialect
-
The name of this dialect as it appears in related enum values
- getNano() - Method in class org.jooq.types.DayToSecond
-
Get the nano-part of this interval
- getNetworkTimeout() - Method in class org.jooq.tools.jdbc.JDBC41Connection
-
- getObject(int, Class<T>) - Method in class org.jooq.tools.jdbc.JDBC41ResultSet
-
- getObject(String, Class<T>) - Method in class org.jooq.tools.jdbc.JDBC41ResultSet
-
- getObject(int, Class<T>) - Method in class org.jooq.tools.jdbc.JDBC41Statement
-
- getObject(String, Class<T>) - Method in class org.jooq.tools.jdbc.JDBC41Statement
-
- getOrder() - Method in interface org.jooq.SortField
-
Get the underlying sort order of this sort field
- getOutParameters() - Method in class org.jooq.impl.AbstractRoutine
-
- getOutParameters() - Method in interface org.jooq.Routine
-
A list of OUT parameters passed to the stored procedure as argument.
- getOutput() - Method in class org.jooq.conf.MappedSchema
-
Gets the value of the output property.
- getOutput() - Method in class org.jooq.conf.MappedTable
-
Gets the value of the output property.
- getPackage() - Method in class org.jooq.impl.AbstractRoutine
-
- getPackage() - Method in interface org.jooq.Routine
-
The container package of this stored procedure or function.
- getParam(String) - Method in interface org.jooq.Query
-
Get a named parameter from the
Query
, provided its name.
- getParam(String) - Method in interface org.jooq.QueryPartInternal
-
- getParameters() - Method in class org.jooq.impl.AbstractRoutine
-
- getParameters() - Method in interface org.jooq.Routine
-
- getParamName() - Method in interface org.jooq.Param
-
The parameter name.
- getParams() - Method in interface org.jooq.Query
-
Get a Map
of named parameters.
- getParams() - Method in interface org.jooq.QueryPartInternal
-
- getPrimaryKey() - Method in interface org.jooq.MasterDataType
-
Deprecated.
- 2.5.0 [#1741] - This feature will be removed as of jOOQ 3.0
- getQuery() - Method in interface org.jooq.SelectFinalStep
-
Get the underlying
Query
that is being constructed.
- getQuery() - Method in interface org.jooq.SimpleSelectFinalStep
-
Get the underlying
Query
that is being constructed.
- getRecordTimestamp() - Method in class org.jooq.impl.UpdatableTableImpl
-
- getRecordTimestamp() - Method in interface org.jooq.UpdatableTable
-
- getRecordType() - Method in class org.jooq.impl.CustomTable
-
Subclasses must implement this method
Subclasses must override this method if they use the generic type
parameter
for other types than Record
- getRecordType() - Method in class org.jooq.impl.TableImpl
-
Subclasses must override this method if they use the generic type
parameter
for other types than Record
- getRecordType() - Method in class org.jooq.impl.UDTImpl
-
Subclasses must override this method if they use the generic type
parameter
for other types than Record
- getRecordType() - Method in interface org.jooq.ResultQuery
-
The record type produced by this query
- getRecordType() - Method in interface org.jooq.Table
-
- getRecordType() - Method in interface org.jooq.Type
-
Deprecated.
- getRecordType() - Method in interface org.jooq.UDT
-
- getRecordVersion() - Method in class org.jooq.impl.UpdatableTableImpl
-
- getRecordVersion() - Method in interface org.jooq.UpdatableTable
-
- getReferences() - Method in class org.jooq.impl.CustomTable
-
- getReferences() - Method in interface org.jooq.Table
-
Get the list of FOREIGN KEY
's of this table
- getReferences() - Method in interface org.jooq.UniqueKey
-
A list of all ForeignKeys
, referencing this
UniqueKey
- getReferencesFrom(Table<O>) - Method in class org.jooq.impl.UpdatableTableImpl
-
- getReferencesFrom(Table<O>) - Method in interface org.jooq.UpdatableTable
-
Get a list of FOREIGN KEY
's of a specific table, referencing
a this table.
- getReferencesTo(Table<O>) - Method in interface org.jooq.Table
-
Get a list of FOREIGN KEY
's of this table, referencing a
specific table.
- getRenderKeywordStyle() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderKeywordStyle property.
- getRenderMapping() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderMapping property.
- getRenderMapping(Settings) - Static method in class org.jooq.conf.SettingsTools
-
- getRenderNameStyle() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderNameStyle property.
- getResult() - Method in interface org.jooq.ResultQuery
-
Return the result generated by a previous call to execute();
- getReturnedRecord() - Method in interface org.jooq.InsertQuery
-
- getReturnedRecords() - Method in interface org.jooq.InsertQuery
-
- getReturnParameter() - Method in class org.jooq.impl.AbstractRoutine
-
- getReturnValue() - Method in class org.jooq.impl.AbstractRoutine
-
- getReturnValue() - Method in interface org.jooq.Routine
-
- getSchema() - Method in class org.jooq.impl.SequenceImpl
-
- getSchema() - Method in interface org.jooq.Package
-
Get the package schema
- getSchema() - Method in interface org.jooq.Routine
-
Get the routine schema
- getSchema() - Method in interface org.jooq.SchemaProvider
-
Deprecated.
- getSchema() - Method in interface org.jooq.Sequence
-
Get the sequence schema
- getSchema() - Method in interface org.jooq.Table
-
Get the table schema
- getSchema() - Method in class org.jooq.tools.jdbc.JDBC41Connection
-
- getSchema() - Method in interface org.jooq.UDT
-
Get the UDT schema
- getSchemaMapping() - Method in interface org.jooq.Configuration
-
- getSchemaMapping() - Method in class org.jooq.impl.Factory
-
Deprecated.
- getSchemaMapping() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getSchemata() - Method in class org.jooq.conf.RenderMapping
-
- getSeconds() - Method in class org.jooq.types.DayToSecond
-
Get the second-part of this interval
- getSelect() - Method in interface org.jooq.Select
-
All fields selected in this query
- getSequence(String) - Method in class org.jooq.impl.SchemaImpl
-
- getSequence(String) - Method in interface org.jooq.Schema
-
Get a sequence by its name (case-sensitive) in this schema, or
null
if no such sequence exists
- getSequences() - Method in class org.jooq.impl.SchemaImpl
-
List all sequences contained in this schema
- getSequences() - Method in interface org.jooq.Schema
-
List all sequences contained in this schema
- getSettings() - Method in interface org.jooq.Configuration
-
Retrieve the runtime configuration settings
- getSettings() - Method in class org.jooq.impl.Factory
-
Retrieve the runtime configuration settings
- getSettings() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getSign() - Method in class org.jooq.types.DayToSecond
-
- getSign() - Method in interface org.jooq.types.Interval
-
The sign of the interval
- getSign() - Method in class org.jooq.types.YearToMonth
-
- getSQL() - Method in interface org.jooq.Query
-
Retrieve the SQL code rendered by this Query
This method can be expected to work correctly for any SQL dialect, as a
query is usually "attached" when created from a
Factory
.
- getSQL(boolean) - Method in interface org.jooq.Query
-
Retrieve the SQL code rendered by this Query
See
Query.getSQL()
for more details
- getSQL() - Method in interface org.jooq.QueryPartInternal
-
Deprecated.
- 2.5.0 [#1544] - This method will be removed from the
internal API. Do not reuse it, except through
Query.getSQL()
- getSQL(boolean) - Method in interface org.jooq.QueryPartInternal
-
Deprecated.
- 2.5.0 [#1544] - This method will be removed from the
internal API. Do not reuse it, except through
Query.getSQL(boolean)
- getSQLDataType() - Method in interface org.jooq.DataType
-
Get the standard SQL data type of this (dialect-specific) data type if
available.
- getSQLDataType() - Method in class org.jooq.impl.AbstractDataType
-
- getSQLType() - Method in interface org.jooq.DataType
-
- getSQLType() - Method in class org.jooq.impl.AbstractDataType
-
- getSQLTypeName() - Method in class org.jooq.impl.UDTRecordImpl
-
- getStatementType() - Method in class org.jooq.conf.Settings
-
Gets the value of the statementType property.
- getStatementType(Settings) - Static method in class org.jooq.conf.SettingsTools
-
Get the statement type from the settings
- getTable() - Method in interface org.jooq.DAO
-
Get the underlying table
- getTable() - Method in interface org.jooq.Identity
-
The IDENTITY
's owner table
- getTable() - Method in class org.jooq.impl.CustomRecord
-
- getTable() - Method in class org.jooq.impl.DAOImpl
-
- getTable(String) - Method in class org.jooq.impl.SchemaImpl
-
- getTable() - Method in class org.jooq.impl.TableRecordImpl
-
- getTable() - Method in class org.jooq.impl.UpdatableRecordImpl
-
- getTable() - Method in interface org.jooq.Key
-
The Key
's owner table
- getTable(String) - Method in interface org.jooq.Schema
-
Get a table by its name (case-sensitive) in this schema, or
null
if no such table exists
- getTable() - Method in interface org.jooq.TableField
-
- getTable() - Method in interface org.jooq.TableRecord
-
The table from which this record was read
- getTable() - Method in interface org.jooq.UpdatableRecord
-
The table from which this record was read
- getTables() - Method in class org.jooq.conf.MappedSchema
-
- getTables() - Method in class org.jooq.impl.SchemaImpl
-
List all tables contained in this schema
- getTables() - Method in interface org.jooq.Schema
-
List all tables contained in this schema
- getTotalDays() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in days
- getTotalHours() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in hours
- getTotalMicro() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in micro-seconds
- getTotalMilli() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in milli-seconds
- getTotalMinutes() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in minutes
- getTotalNano() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in nano-seconds
- getTotalSeconds() - Method in class org.jooq.types.DayToSecond
-
Get the whole interval in seconds
- getTransactionIsolation() - Method in interface org.jooq.FactoryOperations
-
- getTransactionIsolation() - Method in class org.jooq.impl.Factory
-
- getTransactionIsolation() - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- getType() - Method in interface org.jooq.DAO
-
Get the underlying POJO type
- getType() - Method in interface org.jooq.DataType
-
Retrieve the Java type associated with this data type
- getType(int, int) - Method in interface org.jooq.DataType
-
Retrieve a Java type associated with this data type and precision/scale
- getType() - Method in interface org.jooq.Field
-
The Java type of the field.
- getType() - Method in class org.jooq.impl.AbstractDataType
-
- getType(int, int) - Method in class org.jooq.impl.AbstractDataType
-
- getType() - Method in class org.jooq.impl.DAOImpl
-
- getType() - Method in interface org.jooq.NamedTypeProviderQueryPart
-
Deprecated.
The type of this object
- getType() - Method in interface org.jooq.Parameter
-
The Java type of the parameter.
- getTypeMapping(Class<?>) - Static method in class org.jooq.impl.FieldTypeHelper
-
Deprecated.
- 2.3.0 - Do not reuse this method
- getTypeMapping() - Method in class org.jooq.impl.SchemaImpl
-
Deprecated.
- getTypeMapping() - Method in class org.jooq.impl.UDTImpl
-
Deprecated.
- getTypeMapping() - Method in interface org.jooq.Schema
-
Deprecated.
- 2.3.0 - Do not reuse this method
- getTypeMapping() - Method in interface org.jooq.UDT
-
Deprecated.
- 2.3.0 - Do not reuse this method. It will be moved to
jOOQ's internals, soon
- getTypeName() - Method in interface org.jooq.DataType
-
Retrieve the dialect-specific type name associated with this data type
- getTypeName(Configuration) - Method in interface org.jooq.DataType
-
Retrieve the dialect-specific type name associated with this data type
- getTypeName() - Method in class org.jooq.impl.AbstractDataType
-
- getTypeName(Configuration) - Method in class org.jooq.impl.AbstractDataType
-
- getUDT(String) - Method in class org.jooq.impl.SchemaImpl
-
- getUDT() - Method in class org.jooq.impl.UDTRecordImpl
-
- getUDT(String) - Method in interface org.jooq.Schema
-
Get a UDT by its name (case-sensitive) in this schema, or
null
if no such UDT exists
- getUDT() - Method in interface org.jooq.UDTField
-
- getUDT() - Method in interface org.jooq.UDTRecord
-
The UDT from which this record was read
- getUDTs() - Method in class org.jooq.impl.SchemaImpl
-
List all UDTs contained in this schema
- getUDTs() - Method in interface org.jooq.Schema
-
List all UDTs contained in this schema
- getValue(Parameter<Z>) - Method in class org.jooq.impl.AbstractRoutine
-
- getValue(int) - Method in class org.jooq.impl.ArrayRecordImpl
-
- getValue() - Method in interface org.jooq.Param
-
Get the parameter's underlying value.
- getValue(Field<T>) - Method in interface org.jooq.Record
-
Get a value from this Record, providing a field.
- getValue(Field<T>, T) - Method in interface org.jooq.Record
-
Get a value from this record, providing a field.
- getValue(Field<?>, Class<? extends T>) - Method in interface org.jooq.Record
-
Get a converted value from this Record, providing a field.
- getValue(Field<?>, Class<? extends T>, T) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field.
- getValue(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.Record
-
Get a converted value from this Record, providing a field.
- getValue(Field<T>, Converter<? super T, U>, U) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field.
- getValue(String) - Method in interface org.jooq.Record
-
Get a value from this Record, providing a field name.
- getValue(String, Object) - Method in interface org.jooq.Record
-
Get a value from this record, providing a field name.
- getValue(String, Class<? extends T>) - Method in interface org.jooq.Record
-
Get a converted value from this Record, providing a field name.
- getValue(String, Class<? extends T>, T) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field name.
- getValue(String, Converter<?, U>) - Method in interface org.jooq.Record
-
Get a converted value from this Record, providing a field name.
- getValue(String, Converter<?, U>, U) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field name.
- getValue(int) - Method in interface org.jooq.Record
-
Get a value from this record, providing a field index.
- getValue(int, Object) - Method in interface org.jooq.Record
-
Get a value from this record, providing a field index.
- getValue(int, Class<? extends T>) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field index.
- getValue(int, Class<? extends T>, T) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field index.
- getValue(int, Converter<?, U>) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field index.
- getValue(int, Converter<?, U>, U) - Method in interface org.jooq.Record
-
Get a converted value from this record, providing a field index.
- getValue(int, Field<T>) - Method in interface org.jooq.Result
-
Convenience method to fetch a value at a given position in the result.
- getValue(int, Field<T>, T) - Method in interface org.jooq.Result
-
Convenience method to fetch a value at a given position in the result.
- getValue(int, int) - Method in interface org.jooq.Result
-
Convenience method to fetch a value at a given position in the result.
- getValue(int, int, Object) - Method in interface org.jooq.Result
-
Convenience method to fetch a value at a given position in the result.
- getValue(int, String) - Method in interface org.jooq.Result
-
Convenience method to fetch a value at a given position in the result.
- getValue(int, String, Object) - Method in interface org.jooq.Result
-
Convenience method to fetch a value at a given position in the result.
- getValue(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValue(int, E) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValue(int, Class<? extends T>) - Method in interface org.jooq.Store
-
Deprecated.
Get a converted value from this Store, providing a field index.
- getValue(int, Class<? extends T>, T) - Method in interface org.jooq.Store
-
Deprecated.
Get a converted value from this Store, providing a field index.
- getValueAsArray(Field<A>) - Method in interface org.jooq.Record
-
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse
- getValueAsArray(Field<A>, T[]) - Method in interface org.jooq.Record
-
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse
- getValueAsArray(int, Field<A>) - Method in interface org.jooq.Result
-
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse
- getValueAsArray(int, Field<A>, T[]) - Method in interface org.jooq.Result
-
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse
- getValueAsBigDecimal(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsBigDecimal(Field<?>, BigDecimal) - Method in interface org.jooq.Record
-
- getValueAsBigDecimal(String) - Method in interface org.jooq.Record
-
- getValueAsBigDecimal(String, BigDecimal) - Method in interface org.jooq.Record
-
- getValueAsBigDecimal(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsBigDecimal(int, Field<?>, BigDecimal) - Method in interface org.jooq.Result
-
- getValueAsBigDecimal(int, int) - Method in interface org.jooq.Result
-
- getValueAsBigDecimal(int, int, BigDecimal) - Method in interface org.jooq.Result
-
- getValueAsBigDecimal(int, String) - Method in interface org.jooq.Result
-
- getValueAsBigDecimal(int, String, BigDecimal) - Method in interface org.jooq.Result
-
- getValueAsBigDecimal(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsBigDecimal(int, BigDecimal) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsBigInteger(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsBigInteger(Field<?>, BigInteger) - Method in interface org.jooq.Record
-
- getValueAsBigInteger(String) - Method in interface org.jooq.Record
-
- getValueAsBigInteger(String, BigInteger) - Method in interface org.jooq.Record
-
- getValueAsBigInteger(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsBigInteger(int, Field<?>, BigInteger) - Method in interface org.jooq.Result
-
- getValueAsBigInteger(int, int) - Method in interface org.jooq.Result
-
- getValueAsBigInteger(int, int, BigInteger) - Method in interface org.jooq.Result
-
- getValueAsBigInteger(int, String) - Method in interface org.jooq.Result
-
- getValueAsBigInteger(int, String, BigInteger) - Method in interface org.jooq.Result
-
- getValueAsBigInteger(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsBigInteger(int, BigInteger) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsBoolean(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsBoolean(Field<?>, Boolean) - Method in interface org.jooq.Record
-
- getValueAsBoolean(String) - Method in interface org.jooq.Record
-
- getValueAsBoolean(String, Boolean) - Method in interface org.jooq.Record
-
- getValueAsBoolean(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsBoolean(int, Field<?>, Boolean) - Method in interface org.jooq.Result
-
- getValueAsBoolean(int, int) - Method in interface org.jooq.Result
-
- getValueAsBoolean(int, int, Boolean) - Method in interface org.jooq.Result
-
- getValueAsBoolean(int, String) - Method in interface org.jooq.Result
-
- getValueAsBoolean(int, String, Boolean) - Method in interface org.jooq.Result
-
- getValueAsBoolean(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsBoolean(int, Boolean) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsByte(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsByte(Field<?>, Byte) - Method in interface org.jooq.Record
-
- getValueAsByte(String) - Method in interface org.jooq.Record
-
- getValueAsByte(String, Byte) - Method in interface org.jooq.Record
-
- getValueAsByte(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsByte(int, Field<?>, Byte) - Method in interface org.jooq.Result
-
- getValueAsByte(int, int) - Method in interface org.jooq.Result
-
- getValueAsByte(int, int, Byte) - Method in interface org.jooq.Result
-
- getValueAsByte(int, String) - Method in interface org.jooq.Result
-
- getValueAsByte(int, String, Byte) - Method in interface org.jooq.Result
-
- getValueAsByte(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsByte(int, Byte) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsDate(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsDate(Field<?>, Date) - Method in interface org.jooq.Record
-
- getValueAsDate(String) - Method in interface org.jooq.Record
-
- getValueAsDate(String, Date) - Method in interface org.jooq.Record
-
- getValueAsDate(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsDate(int, Field<?>, Date) - Method in interface org.jooq.Result
-
- getValueAsDate(int, int) - Method in interface org.jooq.Result
-
- getValueAsDate(int, int, Date) - Method in interface org.jooq.Result
-
- getValueAsDate(int, String) - Method in interface org.jooq.Result
-
- getValueAsDate(int, String, Date) - Method in interface org.jooq.Result
-
- getValueAsDate(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsDate(int, Date) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsDouble(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsDouble(Field<?>, Double) - Method in interface org.jooq.Record
-
- getValueAsDouble(String) - Method in interface org.jooq.Record
-
- getValueAsDouble(String, Double) - Method in interface org.jooq.Record
-
- getValueAsDouble(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsDouble(int, Field<?>, Double) - Method in interface org.jooq.Result
-
- getValueAsDouble(int, int) - Method in interface org.jooq.Result
-
- getValueAsDouble(int, int, Double) - Method in interface org.jooq.Result
-
- getValueAsDouble(int, String) - Method in interface org.jooq.Result
-
- getValueAsDouble(int, String, Double) - Method in interface org.jooq.Result
-
- getValueAsDouble(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsDouble(int, Double) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsFloat(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsFloat(Field<?>, Float) - Method in interface org.jooq.Record
-
- getValueAsFloat(String) - Method in interface org.jooq.Record
-
- getValueAsFloat(String, Float) - Method in interface org.jooq.Record
-
- getValueAsFloat(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsFloat(int, Field<?>, Float) - Method in interface org.jooq.Result
-
- getValueAsFloat(int, int) - Method in interface org.jooq.Result
-
- getValueAsFloat(int, int, Float) - Method in interface org.jooq.Result
-
- getValueAsFloat(int, String) - Method in interface org.jooq.Result
-
- getValueAsFloat(int, String, Float) - Method in interface org.jooq.Result
-
- getValueAsFloat(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsFloat(int, Float) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsInteger(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsInteger(Field<?>, Integer) - Method in interface org.jooq.Record
-
- getValueAsInteger(String) - Method in interface org.jooq.Record
-
- getValueAsInteger(String, Integer) - Method in interface org.jooq.Record
-
- getValueAsInteger(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsInteger(int, Field<?>, Integer) - Method in interface org.jooq.Result
-
- getValueAsInteger(int, int) - Method in interface org.jooq.Result
-
- getValueAsInteger(int, int, Integer) - Method in interface org.jooq.Result
-
- getValueAsInteger(int, String) - Method in interface org.jooq.Result
-
- getValueAsInteger(int, String, Integer) - Method in interface org.jooq.Result
-
- getValueAsInteger(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsInteger(int, Integer) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsLong(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsLong(Field<?>, Long) - Method in interface org.jooq.Record
-
- getValueAsLong(String) - Method in interface org.jooq.Record
-
- getValueAsLong(String, Long) - Method in interface org.jooq.Record
-
- getValueAsLong(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsLong(int, Field<?>, Long) - Method in interface org.jooq.Result
-
- getValueAsLong(int, int) - Method in interface org.jooq.Result
-
- getValueAsLong(int, int, Long) - Method in interface org.jooq.Result
-
- getValueAsLong(int, String) - Method in interface org.jooq.Result
-
- getValueAsLong(int, String, Long) - Method in interface org.jooq.Result
-
- getValueAsLong(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsLong(int, Long) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsShort(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsShort(Field<?>, Short) - Method in interface org.jooq.Record
-
- getValueAsShort(String) - Method in interface org.jooq.Record
-
- getValueAsShort(String, Short) - Method in interface org.jooq.Record
-
- getValueAsShort(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsShort(int, Field<?>, Short) - Method in interface org.jooq.Result
-
- getValueAsShort(int, int) - Method in interface org.jooq.Result
-
- getValueAsShort(int, int, Short) - Method in interface org.jooq.Result
-
- getValueAsShort(int, String) - Method in interface org.jooq.Result
-
- getValueAsShort(int, String, Short) - Method in interface org.jooq.Result
-
- getValueAsShort(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsShort(int, Short) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsString(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsString(Field<?>, String) - Method in interface org.jooq.Record
-
- getValueAsString(String) - Method in interface org.jooq.Record
-
- getValueAsString(String, String) - Method in interface org.jooq.Record
-
- getValueAsString(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsString(int, Field<?>, String) - Method in interface org.jooq.Result
-
- getValueAsString(int, int) - Method in interface org.jooq.Result
-
- getValueAsString(int, int, String) - Method in interface org.jooq.Result
-
- getValueAsString(int, String) - Method in interface org.jooq.Result
-
- getValueAsString(int, String, String) - Method in interface org.jooq.Result
-
- getValueAsString(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsString(int, String) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsTime(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsTime(Field<?>, Time) - Method in interface org.jooq.Record
-
- getValueAsTime(String) - Method in interface org.jooq.Record
-
- getValueAsTime(String, Time) - Method in interface org.jooq.Record
-
- getValueAsTime(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsTime(int, Field<?>, Time) - Method in interface org.jooq.Result
-
- getValueAsTime(int, int) - Method in interface org.jooq.Result
-
- getValueAsTime(int, int, Time) - Method in interface org.jooq.Result
-
- getValueAsTime(int, String) - Method in interface org.jooq.Result
-
- getValueAsTime(int, String, Time) - Method in interface org.jooq.Result
-
- getValueAsTime(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsTime(int, Time) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsTimestamp(Field<?>) - Method in interface org.jooq.Record
-
- getValueAsTimestamp(Field<?>, Timestamp) - Method in interface org.jooq.Record
-
- getValueAsTimestamp(String) - Method in interface org.jooq.Record
-
- getValueAsTimestamp(String, Timestamp) - Method in interface org.jooq.Record
-
- getValueAsTimestamp(int, Field<?>) - Method in interface org.jooq.Result
-
- getValueAsTimestamp(int, Field<?>, Timestamp) - Method in interface org.jooq.Result
-
- getValueAsTimestamp(int, int) - Method in interface org.jooq.Result
-
- getValueAsTimestamp(int, int, Timestamp) - Method in interface org.jooq.Result
-
- getValueAsTimestamp(int, String) - Method in interface org.jooq.Result
-
- getValueAsTimestamp(int, String, Timestamp) - Method in interface org.jooq.Result
-
- getValueAsTimestamp(int) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValueAsTimestamp(int, Timestamp) - Method in interface org.jooq.Store
-
Deprecated.
Get a value from this Store, providing a field index.
- getValues(Field<T>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(Field<?>, Class<? extends T>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(int) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(int, Class<? extends T>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(int, Converter<?, U>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(String) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(String, Class<? extends T>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValues(String, Converter<?, U>) - Method in interface org.jooq.Result
-
Convenience method to fetch all values for a given field.
- getValuesAsBigDecimal(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsBigDecimal(int) - Method in interface org.jooq.Result
-
- getValuesAsBigDecimal(String) - Method in interface org.jooq.Result
-
- getValuesAsBigInteger(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsBigInteger(int) - Method in interface org.jooq.Result
-
- getValuesAsBigInteger(String) - Method in interface org.jooq.Result
-
- getValuesAsByte(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsByte(int) - Method in interface org.jooq.Result
-
- getValuesAsByte(String) - Method in interface org.jooq.Result
-
- getValuesAsDate(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsDate(int) - Method in interface org.jooq.Result
-
- getValuesAsDate(String) - Method in interface org.jooq.Result
-
- getValuesAsDouble(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsDouble(int) - Method in interface org.jooq.Result
-
- getValuesAsDouble(String) - Method in interface org.jooq.Result
-
- getValuesAsFloat(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsFloat(int) - Method in interface org.jooq.Result
-
- getValuesAsFloat(String) - Method in interface org.jooq.Result
-
- getValuesAsInteger(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsInteger(int) - Method in interface org.jooq.Result
-
- getValuesAsInteger(String) - Method in interface org.jooq.Result
-
- getValuesAsLong(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsLong(int) - Method in interface org.jooq.Result
-
- getValuesAsLong(String) - Method in interface org.jooq.Result
-
- getValuesAsShort(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsShort(int) - Method in interface org.jooq.Result
-
- getValuesAsShort(String) - Method in interface org.jooq.Result
-
- getValuesAsString(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsString(int) - Method in interface org.jooq.Result
-
- getValuesAsString(String) - Method in interface org.jooq.Result
-
- getValuesAsTime(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsTime(int) - Method in interface org.jooq.Result
-
- getValuesAsTime(String) - Method in interface org.jooq.Result
-
- getValuesAsTimestamp(Field<?>) - Method in interface org.jooq.Result
-
- getValuesAsTimestamp(int) - Method in interface org.jooq.Result
-
- getValuesAsTimestamp(String) - Method in interface org.jooq.Result
-
- getYears() - Method in class org.jooq.types.YearToMonth
-
- GRAPHIC - Static variable in class org.jooq.util.db2.DB2DataType
-
- greaterOrEqual(T) - Method in interface org.jooq.Field
-
this >= value
- greaterOrEqual(Field<T>) - Method in interface org.jooq.Field
-
this >= field
- greaterOrEqual(Select<?>) - Method in interface org.jooq.Field
-
this >= (Select
- greaterOrEqualAll(Select<?>) - Method in interface org.jooq.Field
-
this >= all (Select
- greaterOrEqualAll(T...) - Method in interface org.jooq.Field
-
- greaterOrEqualAll(Field<T[]>) - Method in interface org.jooq.Field
-
- greaterOrEqualAny(Select<?>) - Method in interface org.jooq.Field
-
this >= any (Select
- greaterOrEqualAny(T...) - Method in interface org.jooq.Field
-
- greaterOrEqualAny(Field<T[]>) - Method in interface org.jooq.Field
-
- greaterOrEqualSome(Select<?>) - Method in interface org.jooq.Field
-
- greaterThan(T) - Method in interface org.jooq.Field
-
this > value
- greaterThan(Field<T>) - Method in interface org.jooq.Field
-
this > field
- greaterThan(Select<?>) - Method in interface org.jooq.Field
-
this > (Select
- greaterThanAll(Select<?>) - Method in interface org.jooq.Field
-
this > all (Select
- greaterThanAll(T...) - Method in interface org.jooq.Field
-
- greaterThanAll(Field<T[]>) - Method in interface org.jooq.Field
-
- greaterThanAny(Select<?>) - Method in interface org.jooq.Field
-
this > any (Select
- greaterThanAny(T...) - Method in interface org.jooq.Field
-
- greaterThanAny(Field<T[]>) - Method in interface org.jooq.Field
-
- greaterThanSome(Select<?>) - Method in interface org.jooq.Field
-
- greatest(T...) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- greatest(Field<?>...) - Method in interface org.jooq.Field
-
This method is part of the pre-2.0 API.
- greatest(T, T...) - Static method in class org.jooq.impl.Factory
-
Find the greatest among all values
This function has no equivalent in Adaptive Server, Derby, SQL Server and
Sybase SQL Anywhere.
- greatest(Field<T>, Field<?>...) - Static method in class org.jooq.impl.Factory
-
Find the greatest among all values
This function has no equivalent in Adaptive Server, Derby, SQL Server and
Sybase SQL Anywhere.
- groupBy(Field<?>...) - Method in interface org.jooq.SelectGroupByStep
-
Add a GROUP BY
clause to the query
Calling this with an empty argument list will result in an empty
GROUP BY ()
clause being rendered.
- groupBy(Collection<? extends Field<?>>) - Method in interface org.jooq.SelectGroupByStep
-
Add a GROUP BY
clause to the query
Calling this with an empty argument list will result in an empty
GROUP BY ()
clause being rendered.
- groupConcat(Field<?>) - Static method in class org.jooq.impl.Factory
-
Get the aggregated concatenation for a field.
- groupConcatDistinct(Field<?>) - Static method in class org.jooq.impl.Factory
-
Get the aggregated concatenation for a field.
- GroupConcatOrderByStep - Interface in org.jooq
-
MySQL's GROUP_CONCAT
function.
- GroupConcatSeparatorStep - Interface in org.jooq
-
MySQL's GROUP_CONCAT
function.
- grouping(Field<?>) - Static method in class org.jooq.impl.Factory
-
Create a GROUPING(field) aggregation field to be used along with
CUBE
, ROLLUP
, and GROUPING SETS
groupings
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
- groupingId(Field<?>...) - Static method in class org.jooq.impl.Factory
-
Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be
used along with CUBE
, ROLLUP
, and
GROUPING SETS
groupings
This has been observed to work with the following databases:
Oracle
SQL Server
- groupingSets(Field<?>...) - Static method in class org.jooq.impl.Factory
-
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where
each grouping set only consists of a single field.
- groupingSets(Field<?>[]...) - Static method in class org.jooq.impl.Factory
-
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
Please check the SQL Server documentation for a very nice explanation of
CUBE
,
ROLLUP
, and
GROUPING SETS
clauses in grouping contexts:
http://msdn.microsoft.com/en-US/library/bb522495.aspx
- groupingSets(Collection<Field<?>>...) - Static method in class org.jooq.impl.Factory
-
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
Please check the SQL Server documentation for a very nice explanation of
CUBE
,
ROLLUP
, and
GROUPING SETS
clauses in grouping contexts:
http://msdn.microsoft.com/en-US/library/bb522495.aspx
- gt(T) - Method in interface org.jooq.Field
-
this > value
- gt(Field<T>) - Method in interface org.jooq.Field
-
this > field
- gt(Select<?>) - Method in interface org.jooq.Field
-
this > (Select
- I1 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- I2 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- I4 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- I8 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- Identity<R extends Record,T> - Interface in org.jooq
-
An Identity
is an object representing an IDENTITY
column as understood by the SQL:2003 standard.
- IDENTITY - Static variable in class org.jooq.util.h2.H2DataType
-
- ignored() - Method in interface org.jooq.Loader
-
The number of ignored rows
- ignoreNulls() - Method in interface org.jooq.WindowIgnoreNullsStep
-
Add an IGNORE NULLS
clause to the window function.
- ignoreRows(int) - Method in interface org.jooq.LoaderCSVOptionsStep
-
Specify that a certain number of rows should be ignored from the CSV
file.
- IMAGE - Static variable in class org.jooq.util.ase.ASEDataType
-
- IMAGE - Static variable in class org.jooq.util.h2.H2DataType
-
- IMAGE - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- IMAGE - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- in(Collection<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
SQL: this in (values...)
- in(T...) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
SQL: this in (values...)
- in(Field<?>...) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
SQL: this in (values...)
- in(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.
- in(T...) - Method in interface org.jooq.PivotInStep
-
Specify the acceptable values for pivoting
- in(Field<?>...) - Method in interface org.jooq.PivotInStep
-
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE
.
- in(Collection<? extends Field<T>>) - Method in interface org.jooq.PivotInStep
-
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE
.
- in(Select<?>) - Method in interface org.jooq.Row
-
Compare this row value expression with a subselect for equality
Note that the subquery must return a table of the same degree as this row
value expression.
- in(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 IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4))
is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
, which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row1<T1>...) - Method in interface org.jooq.Row1
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4))
is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
, which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4))
is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
, which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row2<T1, T2>...) - Method in interface org.jooq.Row2
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4))
is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
, which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(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 IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
,
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends RowN>) - Method in interface org.jooq.RowN
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4))
is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
, which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(RowN...) - Method in interface org.jooq.RowN
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4))
is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4))
, which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- incr(Field<T>) - Static method in class org.jooq.util.cubrid.CUBRIDFactory
-
Use the CUBRID-specific INCR()
function.
- INDEX_NOT_FOUND - Static variable in class org.jooq.tools.StringUtils
-
Represents a failed index search.
- info(Object) - Method in class org.jooq.tools.JooqLogger
-
- info(Object, Object) - Method in class org.jooq.tools.JooqLogger
-
- info(Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- info(Object, Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- IngresDataType<T> - Class in org.jooq.util.ingres
-
- INGRESDATE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- IngresFactory - Class in org.jooq.util.ingres
-
- IngresFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.ingres.IngresFactory
-
- IngresFactory(Connection, Settings) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with connection and a settings configured
- IngresFactory(DataSource, Settings) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with a data source and a settings configured
- IngresFactory(Connection) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with connection
- IngresFactory(DataSource) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with a data source
- IngresFactory(Settings) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- IngresFactory() - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- INITIAL_READ_SIZE - Static variable in class org.jooq.tools.csv.CSVParser
-
- inline(T) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(char) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Character) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(CharSequence) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Object, Class<? extends T>) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Object, Field<T>) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Object, DataType<T>) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline() - Method in interface org.jooq.RenderContext
-
Whether bind variables should be inlined, rather than rendered as
'?'
- inline(boolean) - Method in interface org.jooq.RenderContext
-
- input - Variable in class org.jooq.conf.MappedSchema
-
- input - Variable in class org.jooq.conf.MappedTable
-
- insert(P) - Method in interface org.jooq.DAO
-
Performs an INSERT
statement for a given POJO
- insert(P...) - Method in interface org.jooq.DAO
-
Performs a batch INSERT
statement for a given set of POJOs
- insert(Collection<P>) - Method in interface org.jooq.DAO
-
Performs a batch INSERT
statement for a given set of POJOs
- insert(P) - Method in class org.jooq.impl.DAOImpl
-
- insert(P...) - Method in class org.jooq.impl.DAOImpl
-
- insert(Collection<P>) - Method in class org.jooq.impl.DAOImpl
-
- Insert<R extends Record> - Interface in org.jooq
-
A
Query
that can insert data in the database.
- InsertFinalStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- insertInto(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL insert statement.
- insertInto(Table<R>, Field<?>...) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL insert statement.
- insertInto(Table<R>, Collection<? extends Field<?>>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL insert statement.
- insertInto(Table<R>, Select<?>) - Method in interface org.jooq.FactoryOperations
-
Deprecated.
- 2.0.3 - Use any of these methods instead:
- insertInto(Table<R>) - Method in class org.jooq.impl.Factory
-
Create a new DSL insert statement.
- insertInto(Table<R>, Field<?>...) - Method in class org.jooq.impl.Factory
-
Create a new DSL insert statement.
- insertInto(Table<R>, Collection<? extends Field<?>>) - Method in class org.jooq.impl.Factory
-
Create a new DSL insert statement.
- insertInto(Table<R>, Select<?>) - Method in class org.jooq.impl.Factory
-
Deprecated.
- insertInto(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- insertInto(Table<R>, Field<?>...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- insertInto(Table<R>, Collection<? extends Field<?>>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- insertInto(Table<R>, Select<?>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- InsertOnDuplicateSetMoreStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- InsertOnDuplicateSetStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- InsertOnDuplicateStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- insertQuery(Table<R>) - Method in interface org.jooq.FactoryOperations
-
- insertQuery(Table<R>) - Method in class org.jooq.impl.Factory
-
- insertQuery(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- InsertQuery<R extends Record> - Interface in org.jooq
-
A query for data insertion
- InsertResultStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- InsertReturningStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- InsertSetMoreStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's alternative DSL API.
- InsertSetStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's alternative DSL API.
- InsertValuesStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert
's DSL API.
- INT - Static variable in class org.jooq.util.ase.ASEDataType
-
- INT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- INT - Static variable in class org.jooq.util.derby.DerbyDataType
-
- INT - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INT - Static variable in class org.jooq.util.h2.H2DataType
-
- INT - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INT - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- INT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- INT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- INT2 - Static variable in class org.jooq.util.h2.H2DataType
-
- INT2 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT2 - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INT4 - Static variable in class org.jooq.util.h2.H2DataType
-
- INT4 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT64 - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INT8 - Static variable in class org.jooq.util.h2.H2DataType
-
- INT8 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT8 - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INTEGER - Static variable in class org.jooq.impl.SQLDataType
-
- INTEGER - Static variable in class org.jooq.util.ase.ASEDataType
-
- INTEGER - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- INTEGER - Static variable in class org.jooq.util.db2.DB2DataType
-
- INTEGER - Static variable in class org.jooq.util.derby.DerbyDataType
-
- INTEGER - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INTEGER - Static variable in class org.jooq.util.h2.H2DataType
-
- INTEGER - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTEGER - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- INTEGER - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTEGER - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INTEGER - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INTEGER - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- INTEGER1 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER2 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER4 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER8 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGERUNSIGNED - Static variable in class org.jooq.impl.SQLDataType
-
- INTEGERUNSIGNED - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- internalAPI(Class<I>) - Method in interface org.jooq.Adapter
-
Deprecated.
- 2.5.0 [#1639] - This part of the internal API will be
removed in the near future. Do not reuse.
- intersect(Select<R>) - Method in interface org.jooq.Select
-
Combine with other selects
- Interval - Interface in org.jooq.types
-
A substitute for JDBC's missing java.sql.Interval
data type.
- INTERVALDAYTOSECOND - Static variable in class org.jooq.impl.SQLDataType
-
The SQL standard INTERVAL DAY TO SECOND
data type
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.impl.SQLDataType
-
The SQL standard INTERVAL YEAR TO MONTH
data type
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- into(Class<? extends E>) - Method in interface org.jooq.Record
-
Map resulting records onto a custom type.
- into(E) - Method in interface org.jooq.Record
-
Map resulting records onto a custom type.
- into(Table<R>) - Method in interface org.jooq.Record
-
Map resulting records onto a custom record type.
- into(Class<? extends E>) - Method in interface org.jooq.Result
-
Map resulting records onto a custom type.
- into(Table<Z>) - Method in interface org.jooq.Result
-
Map resulting records onto a custom record.
- into(H) - Method in interface org.jooq.Result
-
Map results into a custom handler callback
- intoArray() - Method in interface org.jooq.Record
-
Convert this record into an array.
- intoArray() - Method in interface org.jooq.Result
-
Convert this result into an array of arrays
The resulting array has the same number of first-dimension elements as
this result has records.
- intoArray(int) - Method in interface org.jooq.Result
-
Return all values for a field index from the result.
- intoArray(int, Class<? extends T>) - Method in interface org.jooq.Result
-
Return all values for a field index from the result.
- intoArray(int, Converter<?, U>) - Method in interface org.jooq.Result
-
Return all values for a field index from the result.
- intoArray(String) - Method in interface org.jooq.Result
-
Return all values for a field name from the result.
- intoArray(String, Class<? extends T>) - Method in interface org.jooq.Result
-
Return all values for a field name from the result.
- intoArray(String, Converter<?, U>) - Method in interface org.jooq.Result
-
Return all values for a field name from the result.
- intoArray(Field<T>) - Method in interface org.jooq.Result
-
Return all values for a field from the result.
- intoArray(Field<?>, Class<? extends T>) - Method in interface org.jooq.Result
-
Return all values for a field from the result.
- intoArray(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.Result
-
Return all values for a field from the result.
- intoGroups(Field<K>) - Method in interface org.jooq.Result
-
Return a
Map
with one of the result's columns as key and a list
of corresponding records as value.
- intoGroups(Field<K>, Field<V>) - Method in interface org.jooq.Result
-
Return a
Map
with one of the result's columns as key and another
one of the result's columns as value
Unlike
Result.intoMap(Field, Field)
, this method allows for non-unique
keys in the result set.
- intoGroups(Field<?>[]) - Method in interface org.jooq.Result
-
Return a
Map
with the result grouped by the given keys.
- intoGroups(Field<K>, Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map
with results grouped by the given key and mapped
into the given entity type.
- intoGroups(Field<?>[], Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map
with results grouped by the given keys and mapped
into the given entity type.
- intoMap() - Method in interface org.jooq.Record
-
Return this record as a name/value map.
- intoMap(Field<K>) - Method in interface org.jooq.Result
-
Return a
Map
with one of the result's columns as key and the
corresponding records as value.
- intoMap(Field<K>, Field<V>) - Method in interface org.jooq.Result
-
Return a
Map
with one of the result's columns as key and another
one of the result's columns as value
An
InvalidResultException
is thrown, if the key turns out to be
non-unique in the result set.
- intoMap(Field<?>[]) - Method in interface org.jooq.Result
-
Return a
Map
with the given keys as a map key and the
corresponding record as value.
- intoMap(Field<K>, Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map
with results grouped by the given key and mapped
into the given entity type.
- intoMap(Field<?>[], Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map
with results grouped by the given keys and mapped
into the given entity type.
- intoMaps() - Method in interface org.jooq.Result
-
Return the generated result as a list of name/value maps.
- intoResultSet() - Method in interface org.jooq.Result
-
Generate an in-memory JDBC
ResultSet
containing the data of this
Result
.
- intoXML() - Method in interface org.jooq.Result
-
Get this result as XML
- INTUNSIGNED - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- intValue() - Method in class org.jooq.tools.unsigned.UByte
-
- intValue() - Method in class org.jooq.tools.unsigned.UInteger
-
- intValue() - Method in class org.jooq.tools.unsigned.ULong
-
- intValue() - Method in class org.jooq.tools.unsigned.UShort
-
- intValue() - Method in class org.jooq.types.DayToSecond
-
- intValue() - Method in interface org.jooq.types.Interval
-
- intValue() - Method in class org.jooq.types.YearToMonth
-
- InvalidResultException - Exception in org.jooq.exception
-
An unexpected result was encountered after executing a
Query
.
- InvalidResultException(String) - Constructor for exception org.jooq.exception.InvalidResultException
-
Constructor for InvalidResultException.
- isAllWhiteSpace(CharSequence) - Method in class org.jooq.tools.csv.CSVParser
-
precondition: sb.length() > 0
- isArray() - Method in interface org.jooq.DataType
-
Whether this data type is an array type.
- isArray() - Method in class org.jooq.impl.AbstractDataType
-
- isAttachRecords() - Method in class org.jooq.conf.Settings
-
Gets the value of the attachRecords property.
- isBinary() - Method in interface org.jooq.DataType
-
Whether this data type is any binary type.
- isBinary() - Method in class org.jooq.impl.AbstractDataType
-
- isBlank(String) - Static method in class org.jooq.tools.StringUtils
-
Checks if a String is whitespace, empty ("") or null.
- isClosed() - Method in interface org.jooq.Cursor
-
Check whether this Cursor
has been explicitly or
"conveniently" closed.
- isCloseOnCompletion() - Method in class org.jooq.tools.jdbc.JDBC41Statement
-
- isDateTime() - Method in interface org.jooq.DataType
-
Whether this data type is any date or time type.
- isDateTime() - Method in class org.jooq.impl.AbstractDataType
-
- isDebugEnabled() - Method in class org.jooq.tools.JooqLogger
-
- isDefaulted() - Method in interface org.jooq.Parameter
-
Whether this parameter has a default value
Procedures and functions with defaulted parameters behave slightly
different from ones without defaulted parameters.
- isDistinctFrom(T) - Method in interface org.jooq.Field
-
Create a condition to check if this field is DISTINCT
from
another value
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [value] IS NULL THEN FALSE
WHEN [this] IS NULL AND [value] IS NOT NULL THEN TRUE
WHEN [this] IS NOT NULL AND [value] IS NULL THEN TRUE
WHEN [this] = [value] THEN FALSE
ELSE TRUE
END
SQL: this is distinct from value
- isDistinctFrom(Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check if this field is DISTINCT
from
another field
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [field] IS NULL THEN FALSE
WHEN [this] IS NULL AND [field] IS NOT NULL THEN TRUE
WHEN [this] IS NOT NULL AND [field] IS NULL THEN TRUE
WHEN [this] = [field] THEN FALSE
ELSE TRUE
END
SQL: this is distinct from field
- isEmpty() - Method in interface org.jooq.Result
-
Whether there are any records contained in this Result
- isEmpty(String) - Static method in class org.jooq.tools.StringUtils
-
Checks if a String is empty ("") or null.
- isExecutable() - Method in interface org.jooq.Query
-
Whether this query is executable in its current state
DML queries may be incomplete in structure and thus not executable.
- isExecuteLogging() - Method in class org.jooq.conf.Settings
-
Gets the value of the executeLogging property.
- isExecuteWithOptimisticLocking() - Method in class org.jooq.conf.Settings
-
Gets the value of the executeWithOptimisticLocking property.
- isFalse() - Method in interface org.jooq.Field
-
Create a condition to check this field against known string literals for
false
SQL:
lcase(this) in ("0", "n", "no", "false", "off", "disabled")
- isInfoEnabled() - Method in class org.jooq.tools.JooqLogger
-
- isInline() - Method in interface org.jooq.Param
-
A flag on the bind value to force it to be inlined in rendered SQL
- isInterval() - Method in interface org.jooq.DataType
-
Whether this data type is any interval type.
- isInterval() - Method in class org.jooq.impl.AbstractDataType
-
- isLob() - Method in interface org.jooq.DataType
-
Whether this data type is best deserialised as a LOB
.
- isLob() - Method in class org.jooq.impl.AbstractDataType
-
- isNextCharacterEscapable(String, boolean, int) - Method in class org.jooq.tools.csv.CSVParser
-
precondition: the current character is an escape
- isNotDistinctFrom(T) - Method in interface org.jooq.Field
-
Create a condition to check if this field is NOT DISTINCT
from another value
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [value] IS NULL THEN TRUE
WHEN [this] IS NULL AND [value] IS NOT NULL THEN FALSE
WHEN [this] IS NOT NULL AND [value] IS NULL THEN FALSE
WHEN [this] = [value] THEN TRUE
ELSE FALSE
END
SQL: this is not distinct from value
- isNotDistinctFrom(Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check if this field is NOT DISTINCT
from another field
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [field] IS NULL THEN TRUE
WHEN [this] IS NULL AND [field] IS NOT NULL THEN FALSE
WHEN [this] IS NOT NULL AND [field] IS NULL THEN FALSE
WHEN [this] = [value] THEN TRUE
ELSE FALSE
END
SQL: this is not distinct from field
- isNotEmpty() - Method in interface org.jooq.Result
-
Whether there are any records contained in this Result
- isNotNull() - Method in interface org.jooq.Field
-
Create a condition to check this field against null
.
- isNull() - Method in interface org.jooq.Field
-
Create a condition to check this field against null
.
- isNullLiteral() - Method in interface org.jooq.Field
-
Whether this field represents a null
literal.
- isNullLiteral() - Method in class org.jooq.impl.CustomField
-
Subclasses may further override this method
Whether this field represents a null
literal.
- isNumeric() - Method in interface org.jooq.DataType
-
Whether this data type is any numeric data type.
- isNumeric() - Method in class org.jooq.impl.AbstractDataType
-
- isOverloaded() - Method in class org.jooq.impl.AbstractRoutine
-
- isPending() - Method in class org.jooq.tools.csv.CSVParser
-
- isRenderFormatted() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderFormatted property.
- isRenderSchema() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderSchema property.
- isString() - Method in interface org.jooq.DataType
-
Whether this data type is any character data type.
- isString() - Method in class org.jooq.impl.AbstractDataType
-
- isTemporal() - Method in interface org.jooq.DataType
-
Whether this data type is any date or time type.
- isTemporal() - Method in class org.jooq.impl.AbstractDataType
-
- isTraceEnabled() - Method in class org.jooq.tools.JooqLogger
-
- isTrue() - Method in interface org.jooq.Field
-
Create a condition to check this field against known string literals for
true
SQL:
lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
- iterator() - Method in class org.jooq.impl.ArrayRecordImpl
-