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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole updated HHH-6452:
--------------------------------

    Affects Version/s:     (was: 4.x)

Would you be willing to make these changes, test them out and send a pull request?

> 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
>            Reporter: Hannes Erven
>            Priority: Trivial
>   Original Estimate: 0.5h
>  Remaining Estimate: 0.5h
>
> 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