hibernate - Spring data JPA native query skip locked -


i want execute skip locked query on oracle using spring data jpa, tried following:

@lock(lockmodetype.pessimistic_write) @query(value = "select * user id=?1 update skip locked", nativequery = true) user findone(uuid id); 

i tried above , found generated query contains for update, not skip locked (below generated query logs):

select ent0_.column1 name, ent0_.created_date created_2_33_0_ table_name alias_name ent0_.column1=? update 

if remove @lock query method, generated query not have for update.

please suggest how can generate query for update skip locked, required.


Comments

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -