should LockMode be a FetchOption?

[gavinking]

Is this even implementable?

[sebersole]

Yes, but not "cleanly". At the ideal level, the fetch would be a join - some databases support distinct locking per table or select item, but not all. So in some cases you'd have to downgrade the "fetch type" based on the lock mode to use subsequent selects (aka, Hibernate's follow-on locking).

Personally I'd leave this off.

[gavinking]

Personally I'd leave this off.

Definitely "off" for 4.0.