R
- The record type being returned by this querypublic interface SimpleSelectForUpdateOfStep<R extends Record> extends SimpleSelectForUpdateWaitStep<R>
Select
's DSL API when selecting specific
Record
types.
Example:
Refer to the manual for more details
create.selectFrom(T_AUTHOR)
.where(TBook.LANGUAGE.equal("DE"))
.and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
.orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
.limit(2)
.offset(1)
.forUpdate()
.of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.noWait();
Modifier and Type | Method and Description |
---|---|
SimpleSelectForUpdateWaitStep<R> |
of(Collection<Field<?>> fields)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
SimpleSelectForUpdateWaitStep<R> |
of(Field<?>... fields)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
SimpleSelectForUpdateWaitStep<R> |
of(Table<?>... tables)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
noWait, skipLocked, wait
getQuery
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
cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable
internalAPI
@Support(value={DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,ORACLE,SYBASE}) SimpleSelectForUpdateWaitStep<R> of(Field<?>... fields)
OF
clause to the FOR UPDATE
clause at
the end of the query.see LockProvider for more
details
@Support(value={DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,ORACLE,SYBASE}) SimpleSelectForUpdateWaitStep<R> of(Collection<Field<?>> fields)
OF
clause to the FOR UPDATE
clause at
the end of the query.see LockProvider for
more details
Copyright © 2013. All Rights Reserved.