@Override public String getWriteLockString(int timeout) { if ( timeout == LockOptions.NO_WAIT ) { return getForUpdateNowaitString(); } else if ( timeout == LockOptions.SKIP_LOCKED ) { return getForUpdateSkipLockedString(); } return super.getWriteLockString( timeout ); }
@Override public String getForUpdateNowaitString(String aliases) { return getForUpdateString( aliases ) + " nowait "; }
public MySQL8Dialect() { // MySQL doesn't add the new reserved keywords to their JDBC driver to preserve backward compatibility. registerKeyword("CUME_DIST"); registerKeyword("DENSE_RANK"); registerKeyword("EMPTY"); registerKeyword("EXCEPT"); registerKeyword("FIRST_VALUE"); registerKeyword("GROUPS"); registerKeyword("JSON_TABLE"); registerKeyword("LAG"); registerKeyword("LAST_VALUE"); registerKeyword("LEAD"); registerKeyword("NTH_VALUE"); registerKeyword("NTILE"); registerKeyword("PERSIST"); registerKeyword("PERCENT_RANK"); registerKeyword("PERSIST_ONLY"); registerKeyword("RANK"); registerKeyword("ROW_NUMBER"); }
@Override public String getWriteLockString(String aliases, int timeout) { if ( timeout == LockOptions.NO_WAIT ) { return getForUpdateNowaitString(aliases); } else if ( timeout == LockOptions.SKIP_LOCKED ) { return getForUpdateSkipLockedString(aliases); } return super.getWriteLockString( aliases, timeout ); }
@Override public String getForUpdateString(String aliases) { return getForUpdateString() + " of " + aliases; }
public MySQL8Dialect() { // MySQL doesn't add the new reserved keywords to their JDBC driver to preserve backward compatibility. registerKeyword("CUME_DIST"); registerKeyword("DENSE_RANK"); registerKeyword("EMPTY"); registerKeyword("EXCEPT"); registerKeyword("FIRST_VALUE"); registerKeyword("GROUPS"); registerKeyword("JSON_TABLE"); registerKeyword("LAG"); registerKeyword("LAST_VALUE"); registerKeyword("LEAD"); registerKeyword("NTH_VALUE"); registerKeyword("NTILE"); registerKeyword("PERSIST"); registerKeyword("PERCENT_RANK"); registerKeyword("PERSIST_ONLY"); registerKeyword("RANK"); registerKeyword("ROW_NUMBER"); }
@Override public String getWriteLockString(String aliases, int timeout) { if ( timeout == LockOptions.NO_WAIT ) { return getForUpdateNowaitString(aliases); } else if ( timeout == LockOptions.SKIP_LOCKED ) { return getForUpdateSkipLockedString(aliases); } return super.getWriteLockString( aliases, timeout ); }
@Override public String getForUpdateSkipLockedString(String aliases) { return getForUpdateString() + " of " + aliases + " skip locked"; }
@Override public String getWriteLockString(int timeout) { if ( timeout == LockOptions.NO_WAIT ) { return getForUpdateNowaitString(); } else if ( timeout == LockOptions.SKIP_LOCKED ) { return getForUpdateSkipLockedString(); } return super.getWriteLockString( timeout ); }
@Override public String getForUpdateNowaitString() { return getForUpdateString() + " nowait "; }
@Override public String getForUpdateString(String aliases) { return getForUpdateString() + " of " + aliases; }
@Override public String getForUpdateNowaitString(String aliases) { return getForUpdateString( aliases ) + " nowait "; }
@Override public String getForUpdateSkipLockedString(String aliases) { return getForUpdateString() + " of " + aliases + " skip locked"; }
@Override public String getForUpdateNowaitString() { return getForUpdateString() + " nowait "; }