[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6452) PostgreSQL Dialect does not fully implement NOWAIT locking

[Hannes Erven (JIRA)]

PostgreSQL Dialect does not fully implement NOWAIT locking
----------------------------------------------------------

                 Key: HHH-6452
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6452
             Project: Hibernate Core
          Issue Type: Improvement
          Components: core
    Affects Versions: 3.6.6, 4.x
            Reporter: Hannes Erven
            Priority: Trivial


The PostgreSQL dialect should override the following methods from Dialect to fully support NOWAIT locks:

	@Override
	public String getForUpdateNowaitString() {
		return getForUpdateString()+" NOWAIT ";
	}

	@Override
	public String getForUpdateNowaitString(String aliases) {
		return getForUpdateString(aliases)+" NOWAIT ";
	}

The syntax is documented at http://www.postgresql.org/docs/8.2/static/sql-select.html

A possible workaround is to implement a custom PostgreSQL dialect, like discussed in https://forum.hibernate.org/viewtopic.php?p=2426758 .

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira