You know what? I just realized rownum is determined before results are ordered, so my query above wouldn't work. Take out pagination though, and it would still be nice to see pessimistic locking at least enabled for non-paginated queries.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira