DB2Dialect and lock modes

Description

It seems to me that DB2 actually supports a lot more of the Hibernate {{LockMode}}s than what is implemented in the DB2Dialect at present. In particular:

  • DB2 has skip locked data, which I take to have the same semantics as UPGRADE_SKIPLOCKED

  • I believe, but am not certain, that the isolation-clause can be used to do the same thing as for share on other databases

  • DB2 does seem to support for update of <columns> like Oracle

We should support these things in DB2Dialect.

Environment

None

Assignee

Unassigned

Reporter

Gavin King

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Major
Configure