R
- The record type being returned by this querypublic interface SimpleSelectForUpdateWaitStep<R extends Record> extends SimpleSelectFinalStep<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 |
---|---|
SimpleSelectFinalStep<R> |
noWait()
Add a
WAIT clause to the FOR UPDATE clause at
the end of the query. |
SimpleSelectFinalStep<R> |
skipLocked()
Add a
WAIT clause to the FOR UPDATE clause at
the end of the query. |
SimpleSelectFinalStep<R> |
wait(int seconds)
Add a
WAIT clause to the FOR UPDATE clause at
the end of the query. |
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=ORACLE) SimpleSelectFinalStep<R> wait(int seconds)
WAIT
clause to the FOR UPDATE
clause at
the end of the query.
Be careful not to confuse this with Object.wait(long)
!
see LockProvider for more details
@Support(value=ORACLE) SimpleSelectFinalStep<R> noWait()
WAIT
clause to the FOR UPDATE
clause at
the end of the query.see LockProvider for more details
@Support(value=ORACLE) SimpleSelectFinalStep<R> skipLocked()
WAIT
clause to the FOR UPDATE
clause at
the end of the query.see LockProvider for more
details
Copyright © 2013. All Rights Reserved.