JPAQuery with select for update?

[Desert]

How to build a select...for update skip locked with JPAQuery?

This does not work:

JPAQuery query = new JPAQuery(entityManager);

query.getMetadata().addFlag(new QueryFlag(Position.END, "\nFOR UPDATE SKIP LOCKED "));

        return query.from(table).where(table.ok.eq(false))

                    .limit(1).uniqueResult(table);

[timowest]

You can use query.setLockMode(...) to set the lock mode for the query. For example using LockModeType.PESSIMISTIC_WRITE.

[Desert]

Thank you for the fast response. This will generate select ... for update, but I want to use select .... for update skip locked (Oracle), is this possible with querydsl/JPA?

[timowest]

I am not sure. That depends on how your JPA provider maps the lock modes to the RDBMS engine.