SelectQuery (jOOQ 2.6.4 API)

All Superinterfaces:

Adapter, Attachable, ConditionProvider, FieldLike, FieldProvider, LockProvider, OrderProvider, Query, QueryPart, ResultQuery<Record>, Select<Record>, Serializable, TableLike<Record>
```
public interface SelectQuery
extends Select<Record>, ConditionProvider, OrderProvider, LockProvider
```
A query for data selection

Author:

Lukas Eder

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`addConditions(Collection<Condition> conditions)` Adds new conditions to the query, connecting them to existing conditions with `Operator.AND`
`void`	`addConditions(Condition... conditions)` Adds new conditions to the query, connecting them to existing conditions with `Operator.AND`
`void`	`addConditions(Operator operator, Collection<Condition> conditions)` Adds new conditions to the query, connecting them to existing conditions with the provided operator
`void`	`addConditions(Operator operator, Condition... conditions)` Adds new conditions to the query, connecting them to existing conditions with the provided operator
`void`	`addConnectBy(Condition condition)` Add an Oracle-specific `CONNECT BY` clause to the query
`void`	`addConnectByNoCycle(Condition condition)` Add an Oracle-specific `CONNECT BY NOCYCLE` clause to the query
`void`	`addFrom(Collection<? extends TableLike<?>> from)` Add tables to the table product
`void`	`addFrom(TableLike<?>... from)` Add tables to the table product
`void`	`addGroupBy(Collection<? extends Field<?>> fields)` Adds grouping fields Calling this with an empty argument list will result in an empty `GROUP BY ()` clause being rendered.
`void`	`addGroupBy(Field<?>... fields)` Adds grouping fields Calling this with an empty argument list will result in an empty `GROUP BY ()` clause being rendered.
`void`	`addHaving(Collection<Condition> conditions)` Adds new conditions to the having clause of the query, connecting it to existing conditions with the and operator.
`void`	`addHaving(Condition... conditions)` Adds new conditions to the having clause of the query, connecting it to existing conditions with the and operator.
`void`	`addHaving(Operator operator, Collection<Condition> conditions)` Adds new conditions to the having clause of query, connecting them to existing conditions with the provided operator
`void`	`addHaving(Operator operator, Condition... conditions)` Adds new conditions to the having clause of query, connecting them to existing conditions with the provided operator
`void`	`addHint(String hint)` Add an Oracle-style hint to the select clause Example: `Factory create = new Factory(); create.select(field1, field2) .hint("/+ALL_ROWS/") .from(table1) .execute();`
`void`	`addJoin(TableLike<?> table, Condition... conditions)` Joins the existing table product to a new table using a condition
`void`	`addJoin(TableLike<?> table, JoinType type, Condition... conditions)` Joins the existing table product to a new table using a condition
`void`	`addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)` Joins the existing table product to a new table using a condition This adds a `PARTITION BY` clause to the right hand side of a `OUTER JOIN` expression.
`void`	`addJoinOnKey(TableLike<?> table, JoinType type)` Joins the existing table product to a new table using a foreign key
`void`	`addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?,?> key)` Joins the existing table product to a new table using a foreign key
`void`	`addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields)` Joins the existing table product to a new table using a foreign key
`void`	`addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)` Joins the existing table product to a new table with a `USING` clause If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
`void`	`addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)` Joins the existing table product to a new table with a `USING` clause If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
`void`	`addLimit(int numberOfRows)` Limit the results of this select This is the same as calling `OrderProvider.addLimit(int, int)` with offset = 0
`void`	`addLimit(int offset, int numberOfRows)` Limit the results of this select Note that some dialects do not support bind values at all in `LIMIT` or `TOP` clauses!
`void`	`addLimit(int offset, Param<Integer> numberOfRows)` Limit the results of this select using named parameters Note that some dialects do not support bind values at all in `LIMIT` or `TOP` clauses!
`void`	`addLimit(Param<Integer> numberOfRows)` Limit the results of this select using named parameters Note that some dialects do not support bind values at all in `LIMIT` or `TOP` clauses!
`void`	`addLimit(Param<Integer> offset, int numberOfRows)` Limit the results of this select Note that some dialects do not support bind values at all in `LIMIT` or `TOP` clauses!
`void`	`addLimit(Param<Integer> offset, Param<Integer> numberOfRows)` Limit the results of this select using named parameters Note that some dialects do not support bind values at all in `LIMIT` or `TOP` clauses!
`void`	`addOrderBy(Collection<SortField<?>> fields)` Adds ordering fields
`void`	`addOrderBy(Field<?>... fields)` Adds ordering fields, ordering by the default sort order
`void`	`addOrderBy(int... fieldIndexes)` Adds ordering fields Indexes start at `1` in SQL!
`void`	`addOrderBy(SortField<?>... fields)` Adds ordering fields
`void`	`addSelect(Collection<? extends Field<?>> fields)` Add a list of select fields
`void`	`addSelect(Field<?>... fields)` Add a list of select fields
`void`	`setConnectByStartWith(Condition condition)` Add an Oracle-specific `START WITH` clause to the query's `CONNECT BY` clause
`void`	`setDistinct(boolean distinct)` Add "distinct" keyword to the select clause
`void`	`setForShare(boolean forShare)` Sets the "FOR SHARE" flag onto the query This has been observed to be supported by any of these dialects: MySQL's InnoDB locking reads Postgres FOR UPDATE / FOR SHARE If your dialect does not support this clause, jOOQ will still render it, if you apply it to your query.
`void`	`setForUpdate(boolean forUpdate)` Sets the "FOR UPDATE" flag onto the query Native implementation This has been observed to be supported by any of these dialects:	`void`	`setForUpdateNoWait()` Some RDBMS allow for specifying the locking mode for the applied `FOR UPDATE` clause.
`void`	`setForUpdateOf(Collection<? extends Field<?>> fields)` Some RDBMS allow for specifying the fields that should be locked by the `FOR UPDATE` clause, instead of the full row.
`void`	`setForUpdateOf(Field<?>... fields)` Some RDBMS allow for specifying the fields that should be locked by the `FOR UPDATE` clause, instead of the full row.
`void`	`setForUpdateOf(Table<?>... tables)` Some RDBMS allow for specifying the tables that should be locked by the `FOR UPDATE` clause, instead of the full row.
`void`	`setForUpdateSkipLocked()` Some RDBMS allow for specifying the locking mode for the applied `FOR UPDATE` clause.
`void`	`setForUpdateWait(int seconds)` Some RDBMS allow for specifying the locking mode for the applied `FOR UPDATE` clause.
`void`	`setOrderBySiblings(boolean orderBySiblings)` Indicate whether the `SIBLINGS` keyword should be used in an `ORDER BY` clause to form an `ORDER SIBLINGS BY` clause.

Methods inherited from interface org.jooq.Select
except, getSelect, intersect, union, unionAll

Methods inherited from interface org.jooq.ResultQuery
bind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneMap, fetchResultSet, getRecordType, getResult, keepStatement, maxRows, queryTimeout

Methods inherited from interface org.jooq.Query
cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable

Methods inherited from interface org.jooq.QueryPart
attach

Methods inherited from interface org.jooq.Adapter
internalAPI

Methods inherited from interface org.jooq.TableLike
asTable, asTable

Methods inherited from interface org.jooq.FieldLike
asField, asField

Methods inherited from interface org.jooq.FieldProvider
getField, getField, getField, getFields, getIndex

- Method Detail
  - addSelect
```
@Support
void addSelect(Field<?>... fields)
```
    Add a list of select fields
    
    Parameters:
    fields -
  - addSelect
```
@Support
void addSelect(Collection<? extends Field<?>> fields)
```
    Add a list of select fields
    
    Parameters:
    fields -
  - setDistinct
```
@Support
void setDistinct(boolean distinct)
```
    Add "distinct" keyword to the select clause
  - addFrom
```
@Support
void addFrom(TableLike<?>... from)
```
    Add tables to the table product
    
    Parameters:
    from - The added tables
  - addFrom
```
@Support
void addFrom(Collection<? extends TableLike<?>> from)
```
    Add tables to the table product
    
    Parameters:
    from - The added tables
  - addJoin
```
@Support
void addJoin(TableLike<?> table,
                   Condition... conditions)
```
    Joins the existing table product to a new table using a condition
    
    Parameters:
    table - The joined table
    conditions - The joining conditions
  - addJoin
```
@Support
void addJoin(TableLike<?> table,
                   JoinType type,
                   Condition... conditions)
```
    Joins the existing table product to a new table using a condition
    
    Parameters:
    table - The joined table
    type - The type of join
    conditions - The joining conditions
  - addJoin
```
@Support(value=ORACLE)
void addJoin(TableLike<?> table,
                              JoinType type,
                              Condition[] conditions,
                              Field<?>[] partitionBy)
```
    Joins the existing table product to a new table using a condition
    This adds a PARTITION BY clause to the right hand side of a OUTER JOIN expression.
    
    Parameters:
    table - The joined table
    type - The type of join
    conditions - The joining conditions
    partitionBy - The PARTITION BY expression
    See Also:
    TablePartitionByStep
  - addJoinUsing
```
@Support
void addJoinUsing(TableLike<?> table,
                        Collection<? extends Field<?>> fields)
```
    Joins the existing table product to a new table with a USING clause
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    
    Parameters:
    table - The joined table
    fields - The fields for the USING clause
  - addJoinUsing
```
@Support
void addJoinUsing(TableLike<?> table,
                        JoinType type,
                        Collection<? extends Field<?>> fields)
```
    Joins the existing table product to a new table with a USING clause
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    
    Parameters:
    table - The joined table
    type - The type of join
    fields - The fields for the USING clause
  - addJoinOnKey
```
@Support
void addJoinOnKey(TableLike<?> table,
                        JoinType type)
                  throws DataAccessException
```
    Joins the existing table product to a new table using a foreign key
    
    Parameters:
    table - The joined table
    type - The type of join
    
    Throws:
    
    DataAccessException - If there is no non-ambiguous key definition known to jOOQ
    See Also:
    TableOnStep.onKey(ForeignKey)
  - addJoinOnKey
```
@Support
void addJoinOnKey(TableLike<?> table,
                        JoinType type,
                        TableField<?,?>... keyFields)
                  throws DataAccessException
```
    Joins the existing table product to a new table using a foreign key
    
    Parameters:
    table - The joined table
    type - The type of join
    keyFields - The foreign key fields
    
    Throws:
    
    DataAccessException - If there is no non-ambiguous key definition known to jOOQ
    See Also:
    TableOnStep.onKey(ForeignKey)
  - addJoinOnKey
```
@Support
void addJoinOnKey(TableLike<?> table,
                        JoinType type,
                        ForeignKey<?,?> key)
```
    Joins the existing table product to a new table using a foreign key
    
    Parameters:
    table - The joined table
    type - The type of join
    key - The foreign key
    See Also:
    TableOnStep.onKey(ForeignKey)
  - addGroupBy
```
@Support
void addGroupBy(Field<?>... fields)
```
    Adds grouping fields
    Calling this with an empty argument list will result in an empty GROUP BY () clause being rendered.
    
    Parameters:
    fields - The grouping fields
  - addGroupBy
```
@Support
void addGroupBy(Collection<? extends Field<?>> fields)
```
    Adds grouping fields
    Calling this with an empty argument list will result in an empty GROUP BY () clause being rendered.
    
    Parameters:
    fields - The grouping fields
  - addHaving
```
@Support
void addHaving(Condition... conditions)
```
    Adds new conditions to the having clause of the query, connecting it to existing conditions with the and operator.
    
    Parameters:
    conditions - The condition
  - addHaving
```
@Support
void addHaving(Collection<Condition> conditions)
```
    Adds new conditions to the having clause of the query, connecting it to existing conditions with the and operator.
    
    Parameters:
    conditions - The condition
  - addHaving
```
@Support
void addHaving(Operator operator,
                     Condition... conditions)
```
    Adds new conditions to the having clause of query, connecting them to existing conditions with the provided operator
    
    Parameters:
    operator - The operator to use to add the conditions to the existing conditions
    conditions - The condition
  - addHaving
```
@Support
void addHaving(Operator operator,
                     Collection<Condition> conditions)
```
    Adds new conditions to the having clause of query, connecting them to existing conditions with the provided operator
    
    Parameters:
    operator - The operator to use to add the conditions to the existing conditions
    conditions - The condition
  - addHint
```
@Support(value={CUBRID,ORACLE})
void addHint(String hint)
```
    Add an Oracle-style hint to the select clause
    Example:
```
 Factory create = new Factory();

 create.select(field1, field2)
       .hint("/*+ALL_ROWS*/")
       .from(table1)
       .execute();
 
```
  - addConnectBy
```
@Support(value={CUBRID,ORACLE})
void addConnectBy(Condition condition)
```
    Add an Oracle-specific CONNECT BY clause to the query
  - addConnectByNoCycle
```
@Support(value={CUBRID,ORACLE})
void addConnectByNoCycle(Condition condition)
```
    Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
  - setConnectByStartWith
```
@Support(value={CUBRID,ORACLE})
void setConnectByStartWith(Condition condition)
```
    Add an Oracle-specific START WITH clause to the query's CONNECT BY clause
  - addConditions
```
@Support
void addConditions(Condition... conditions)
```
    Adds new conditions to the query, connecting them to existing conditions with Operator.AND
    
    Specified by:
    
    addConditions in interface ConditionProvider
    
    Parameters:
    conditions - The condition
  - addConditions
```
@Support
void addConditions(Collection<Condition> conditions)
```
    Adds new conditions to the query, connecting them to existing conditions with Operator.AND
    
    Specified by:
    
    addConditions in interface ConditionProvider
    
    Parameters:
    conditions - The condition
  - addConditions
```
@Support
void addConditions(Operator operator,
                         Condition... conditions)
```
    Adds new conditions to the query, connecting them to existing conditions with the provided operator
    
    Specified by:
    
    addConditions in interface ConditionProvider
    
    conditions - The condition
  - addConditions
```
@Support
void addConditions(Operator operator,
                         Collection<Condition> conditions)
```
    Adds new conditions to the query, connecting them to existing conditions with the provided operator
    
    Specified by:
    
    addConditions in interface ConditionProvider
    
    conditions - The condition
  - addOrderBy
```
@Support
void addOrderBy(Field<?>... fields)
```
    Adds ordering fields, ordering by the default sort order
    
    Specified by:
    
    addOrderBy in interface OrderProvider
    
    Parameters:
    fields - The ordering fields
  - addOrderBy
```
@Support
void addOrderBy(SortField<?>... fields)
```
    Adds ordering fields
    
    Specified by:
    
    addOrderBy in interface OrderProvider
    
    Parameters:
    fields - The ordering fields
  - addOrderBy
```
@Support
void addOrderBy(Collection<SortField<?>> fields)
```
    Adds ordering fields
    
    Specified by:
    
    addOrderBy in interface OrderProvider
    
    Parameters:
    fields - The ordering fields
  - addOrderBy
```
@Support
void addOrderBy(int... fieldIndexes)
```
    Adds ordering fields
    Indexes start at 1 in SQL!
    Note, you can use addOrderBy(Factory.val(1).desc()) or addOrderBy(Factory.literal(1).desc()) to apply descending ordering
    
    Specified by:
    
    addOrderBy in interface OrderProvider
    
    Parameters:
    fieldIndexes - The ordering fields
  - setOrderBySiblings
```
@Support(value={CUBRID,ORACLE})
void setOrderBySiblings(boolean orderBySiblings)
```
    Indicate whether the SIBLINGS keyword should be used in an ORDER BY clause to form an ORDER SIBLINGS BY clause.
    This clause can be used only along with Oracle's CONNECT BY clause, to indicate that the hierarchical ordering should be preserved and elements of each hierarchy should be ordered among themselves.
    
    Specified by:
    
    setOrderBySiblings in interface OrderProvider
  - addLimit
```
@Support
void addLimit(int numberOfRows)
```
    Limit the results of this select
    This is the same as calling OrderProvider.addLimit(int, int) with offset = 0
    
    Specified by:
    
    addLimit in interface OrderProvider
    
    Parameters:
    numberOfRows - The number of rows to return
  - addLimit
```
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE})
void addLimit(Param<Integer> numberOfRows)
```
    Limit the results of this select using named parameters
    Note that some dialects do not support bind values at all in LIMIT or TOP clauses!
    If there is no LIMIT or TOP clause in your RDBMS, or the LIMIT or TOP clause does not support bind values, this may be simulated with a ROW_NUMBER() window function and nested SELECT statements.
    This is the same as calling OrderProvider.addLimit(int, int) with offset = 0
    
    Specified by:
    
    addLimit in interface OrderProvider
    
    Parameters:
    numberOfRows - The number of rows to return
  - addLimit
```
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE})
void addLimit(int offset,
                                                                                                     int numberOfRows)
```
    Limit the results of this select
    Note that some dialects do not support bind values at all in LIMIT or TOP clauses!
    If there is no LIMIT or TOP clause in your RDBMS, or if your RDBMS does not natively support offsets, this is simulated with a ROW_NUMBER() window function and nested SELECT statements.
    
    Specified by:
    
    addLimit in interface OrderProvider
    
    Parameters:
    offset - The lowest offset starting at 0
    numberOfRows - The number of rows to return
  - addLimit
```
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE})
void addLimit(Param<Integer> offset,
                                                                                               int numberOfRows)
```
    Limit the results of this select
    Note that some dialects do not support bind values at all in LIMIT or TOP clauses!
    If there is no LIMIT or TOP clause in your RDBMS, or the LIMIT or TOP clause does not support bind values, or if your RDBMS does not natively support offsets, this may be simulated with a ROW_NUMBER() window function and nested SELECT statements.
    
    Specified by:
    
    addLimit in interface OrderProvider
    
    Parameters:
    offset - The lowest offset starting at 0
    numberOfRows - The number of rows to return
  - addLimit
```
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE})
void addLimit(int offset,
                                                                                               Param<Integer> numberOfRows)
```
    Limit the results of this select using named parameters
    Note that some dialects do not support bind values at all in LIMIT or TOP clauses!
    If there is no LIMIT or TOP clause in your RDBMS, or the LIMIT or TOP clause does not support bind values, or if your RDBMS does not natively support offsets, this may be simulated with a ROW_NUMBER() window function and nested SELECT statements.
    
    Specified by:
    
    addLimit in interface OrderProvider
    
    Parameters:
    offset - The lowest offset starting at 0
    numberOfRows - The number of rows to return
  - addLimit
```
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE})
void addLimit(Param<Integer> offset,
                                                                                               Param<Integer> numberOfRows)
```
    Limit the results of this select using named parameters
    Note that some dialects do not support bind values at all in LIMIT or TOP clauses!
    If there is no LIMIT or TOP clause in your RDBMS, or the LIMIT or TOP clause does not support bind values, or if your RDBMS does not natively support offsets, this may be simulated with a ROW_NUMBER() window function and nested SELECT statements.
    
    Specified by:
    
    addLimit in interface OrderProvider
    
    Parameters:
    offset - The lowest offset starting at 0
    numberOfRows - The number of rows to return
  - setForUpdate
```
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
void setForUpdate(boolean forUpdate)
```
    Sets the "FOR UPDATE" flag onto the query
    
    Native implementation
    This has been observed to be supported by any of these dialects:
    Simulation
    These dialects can simulate the FOR UPDATE clause using a cursor. The cursor is handled by the JDBC driver, at PreparedStatement construction time, when calling Connection.prepareStatement(String, int, int) with ResultSet.CONCUR_UPDATABLE. jOOQ handles simulation of a FOR UPDATE clause using CONCUR_UPDATABLE for these dialects:
    - SQLDialect.CUBRID
    - SQLDialect.SQLSERVER
    Note: This simulation may not be efficient for large result sets!
    Not supported
    These dialects are known not to support the FOR UPDATE clause in regular SQL:
    - SQLDialect.SQLITE
    If your dialect does not support this clause, jOOQ will still render it, if you apply it to your query. This might then cause syntax errors reported either by your database or your JDBC driver.
    You shouldn't combine this with LockProvider.setForShare(boolean)
    Specified by:
    
    setForUpdate in interface LockProvider
    
    Parameters:
    forUpdate - The flag's value
  - setForUpdateOf
```
@Support(value={DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,ORACLE,SYBASE})
void setForUpdateOf(Field<?>... fields)
```
    Some RDBMS allow for specifying the fields that should be locked by the FOR UPDATE clause, instead of the full row.
    This automatically sets the LockProvider.setForUpdate(boolean) flag, and unsets the LockProvider.setForShare(boolean) flag, if it was previously set.
    This has been observed to be natively supported by any of these dialects:
    - DB2
    - Derby
    - H2
    - HSQLDB
    - Ingres
    - Oracle
    - Sybase
    Note, that SQLDialect.DB2 has some stricter requirements regarding the updatability of fields. Refer to the DB2 documentation for further details
    Specified by:
    
    setForUpdateOf in interface LockProvider
    
    Parameters:
    fields - The fields that should be locked
  - setForUpdateOf
```
@Support(value={DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,ORACLE,SYBASE})
void setForUpdateOf(Collection<? extends Field<?>> fields)
```
    Some RDBMS allow for specifying the fields that should be locked by the FOR UPDATE clause, instead of the full row.
    
    Specified by:
    
    setForUpdateOf in interface LockProvider
    
    See Also:
    LockProvider.setForUpdateOf(Field...)
  - setForUpdateOf
```
@Support(value={DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,ORACLE,SYBASE})
void setForUpdateOf(Table<?>... tables)
```
    Some RDBMS allow for specifying the tables that should be locked by the FOR UPDATE clause, instead of the full row.
    This automatically sets the LockProvider.setForUpdate(boolean) flag, and unsets the LockProvider.setForShare(boolean) flag, if it was previously set.
    This has been observed to be natively supported by any of these dialects:
    - Postgres
    - H2
    - HSQLDB
    - Sybase
    jOOQ simulates this by locking all known fields of [tables] for any of these dialects:
    - DB2
    - Derby
    - Ingres
    - Oracle
    Specified by:
    
    setForUpdateOf in interface LockProvider
    
    Parameters:
    tables - The tables that should be locked
  - setForUpdateWait
```
@Support(value=ORACLE)
void setForUpdateWait(int seconds)
```
    Some RDBMS allow for specifying the locking mode for the applied FOR UPDATE clause. In this case, the session will wait for some seconds, before aborting the lock acquirement if the lock is not available.
    This automatically sets the LockProvider.setForUpdate(boolean) flag, and unsets the LockProvider.setForShare(boolean) flag, if it was previously set.
    This has been observed to be supported by any of these dialects:
    - Oracle
    Specified by:
    
    setForUpdateWait in interface LockProvider
    
    Parameters:
    seconds - The number of seconds to wait for a lock
  - setForUpdateNoWait
```
@Support(value=ORACLE)
void setForUpdateNoWait()
```
    Some RDBMS allow for specifying the locking mode for the applied FOR UPDATE clause. In this case, the session will not wait before aborting the lock acquirement if the lock is not available.
    This automatically sets the LockProvider.setForUpdate(boolean) flag, and unsets the LockProvider.setForShare(boolean) flag, if it was previously set.
    This has been observed to be supported by any of these dialects:
    - Oracle
    Specified by:
    
    setForUpdateNoWait in interface LockProvider
  - setForUpdateSkipLocked
```
@Support(value=ORACLE)
void setForUpdateSkipLocked()
```
    Some RDBMS allow for specifying the locking mode for the applied FOR UPDATE clause. In this case, the session will skip all locked rows from the select statement, whose lock is not available.
    This automatically sets the LockProvider.setForUpdate(boolean) flag, and unsets the LockProvider.setForShare(boolean) flag, if it was previously set.
    This has been observed to be supported by any of these dialects:
    - Oracle
    Specified by:
    
    setForUpdateSkipLocked in interface LockProvider
  - setForShare
```
@Support(value={MYSQL,POSTGRES})
void setForShare(boolean forShare)
```
    Sets the "FOR SHARE" flag onto the query
    This has been observed to be supported by any of these dialects:
    - MySQL's InnoDB locking reads
    - Postgres FOR UPDATE / FOR SHARE
    If your dialect does not support this clause, jOOQ will still render it, if you apply it to your query. This might then cause syntax errors reported either by your database or your JDBC driver.
    You shouldn't combine this with LockProvider.setForUpdate(boolean)
    Specified by:
    
    setForShare in interface LockProvider
    
    Parameters:
    forShare - The flag's value

Interface SelectQuery

Method Summary

Methods inherited from interface org.jooq.Select

Methods inherited from interface org.jooq.ResultQuery

Methods inherited from interface org.jooq.Query

Methods inherited from interface org.jooq.QueryPart

Methods inherited from interface org.jooq.Adapter

Methods inherited from interface org.jooq.TableLike

Methods inherited from interface org.jooq.FieldLike

Methods inherited from interface org.jooq.FieldProvider

Method Detail

addSelect

addSelect

setDistinct

addFrom

addFrom

addJoin

addJoin

addJoin

addJoinUsing

addJoinUsing

addJoinOnKey

addJoinOnKey

addJoinOnKey

addGroupBy

addGroupBy

addHaving

addHaving

addHaving

addHaving

addHint

addConnectBy

addConnectByNoCycle

setConnectByStartWith

addConditions

addConditions

addConditions

addConditions

addOrderBy

addOrderBy

addOrderBy

addOrderBy

setOrderBySiblings

addLimit

addLimit

addLimit

addLimit

addLimit

addLimit

setForUpdate

Native implementation

Simulation

Not supported

setForUpdateOf

setForUpdateOf

setForUpdateOf

setForUpdateWait

setForUpdateNoWait

setForUpdateSkipLocked

setForShare