[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-5009) Support NOWAIT for "SELECT ... FOR UPDATE" with JPA interfaces

Support NOWAIT for "SELECT ... FOR UPDATE" with JPA interfaces -------------------------------------------------------------- Key: HHH-5009 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5009 Project: Hibernate Core Issue Type: Improvement Affects Versions: 3.5.0-CR-2 Environment: Oracle / Derby Reporter: Sergey Vladimirov Attachments: DerbyTestDialect.java, Entity.java, NowaitTest.java Original Estimate: 1 day Remaining Estimate: 1 day Test case description: - DERBY dialect extended to add /* +NOWAIT */ SQL comment to check if it's actually used. - if it's working, log should contain --- "org.hibernate.SQL DEBUG select entity0_.id as id0_0_, entity0_.value as value0_0_ from entities entity0_ where entity0_.id=? for update with rs /* +NOWAIT */" -- but currently it --- "org.hibernate.SQL DEBUG select entity0_.id as id0_0_, entity0_.value as value0_0_ from entities entity0_ where entity0_.id=? for update with rs" It seems LockOptions (like "javax.persistence.lock.timeout") are lost when converting from JPA to Hibernate. The possible place of error, from my point of view, is loadFromDatasource() (DefaultLoadEventListener:499), where persister is loaded depending only on LockMode without paying attention to lockOptions (including timeout).