Skip to content

Instantly share code, notes, and snippets.

@kenota
Created December 14, 2012 01:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kenota/4281689 to your computer and use it in GitHub Desktop.
Save kenota/4281689 to your computer and use it in GitHub Desktop.
PostgreSQL dialect which supports "FOR UPDATE NOWAIT" syntax for PostgreSQL
package com.binarybuffer.postgres;
import org.hibernate.LockMode;
import org.hibernate.dialect.PostgreSQLDialect;
/**
* Simple extension to standard {@link PostgreSQLDialect} adding support for
* {@link LockMode#UPGRADE_NOWAIT} lock mode which is achieved using
* "FOR UPDATE NOWAIT" syntax in PostgreSQL
*
* @author kenota
*
*/
public class NoWaitPgDialect extends PostgreSQLDialect {
@Override
public String getForUpdateNowaitString() {
return "for update nowait";
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment