Add support for lock timeouts

Description

It would be nice to support (pessimistic) lock timeouts, as with Oracle's SELECT ... FOR UPDATE WAIT [seconds] syntax:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_103a.htm#2079058

I marked this as "minor" priority since one could retry in the Java layer, but obviously retrying in the app server has much different semantics than waiting for a lock in the database.

Environment

Hibernate 2.1.3, Oracle 9.2.0.4, JDK 1.4.1

Assignee

Unassigned

Reporter

Nate Boyd

Labels

None

Feedback Requested

None

Feedback Requested By

None

backPortable

None

Suitable for new contributors

None

Pull Request

None

backportDecision

None

backportReEvaluate

None

Components

Affects versions

Priority

Minor
Configure