How to use

UpdateLockingStrategy

in

org.hibernate.dialect.lock

@Override
public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
  // InterSystems Cache' does not current support "SELECT ... FOR UPDATE" syntax...
  // Set your transaction mode to READ_COMMITTED before using
  if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
    return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
    return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.PESSIMISTIC_READ) {
    return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.OPTIMISTIC) {
    return new OptimisticLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
    return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode.greaterThan( LockMode.READ ) ) {
    return new UpdateLockingStrategy( lockable, lockMode );
  }
  else {
    return new SelectLockingStrategy( lockable, lockMode );
  }
}

/**
 * Construct a locking strategy based on SQL UPDATE statements.
 *
 * @param lockable The metadata for the entity to be locked.
 * @param lockMode Indictates the type of lock to be acquired.  Note that
 * read-locks are not valid for this strategy.
 */
public UpdateLockingStrategy(Lockable lockable, LockMode lockMode) {
  this.lockable = lockable;
  this.lockMode = lockMode;
  if ( lockMode.lessThan( LockMode.UPGRADE ) ) {
    throw new HibernateException( "[" + lockMode + "] not valid for update statement" );
  }
  if ( !lockable.isVersioned() ) {
    LOG.writeLocksNotSupported( lockable.getEntityName() );
    this.sql = null;
  }
  else {
    this.sql = generateLockString();
  }
}

throw session.getJdbcServices().getSqlExceptionHelper().convert(
    e,
    "Could not bind version value(s) to lock entity: " + MessageHelper.infoString( getLockable(), id, session.getFactory() ),
    sql
);
throw session.getJdbcServices().getSqlExceptionHelper().convert(
    e,
    "Could not bind id value(s) to lock entity: " + MessageHelper.infoString( getLockable(), id, session.getFactory() ),
    sql
);

@Override
public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
  // TimesTen has no known variation of a "SELECT ... FOR UPDATE" syntax...
  if ( lockMode == LockMode.PESSIMISTIC_FORCE_INCREMENT ) {
    return new PessimisticForceIncrementLockingStrategy( lockable, lockMode );
  }
  else if ( lockMode == LockMode.PESSIMISTIC_WRITE ) {
    return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode );
  }
  else if ( lockMode == LockMode.PESSIMISTIC_READ ) {
    return new PessimisticReadUpdateLockingStrategy( lockable, lockMode );
  }
  else if ( lockMode == LockMode.OPTIMISTIC ) {
    return new OptimisticLockingStrategy( lockable, lockMode );
  }
  else if ( lockMode == LockMode.OPTIMISTIC_FORCE_INCREMENT ) {
    return new OptimisticForceIncrementLockingStrategy( lockable, lockMode );
  }
  else if ( lockMode.greaterThan( LockMode.READ ) ) {
    return new UpdateLockingStrategy( lockable, lockMode );
  }
  else {
    return new SelectLockingStrategy( lockable, lockMode );
  }
}

/**
 * Construct a locking strategy based on SQL UPDATE statements.
 *
 * @param lockable The metadata for the entity to be locked.
 * @param lockMode Indictates the type of lock to be acquired.  Note that
 * read-locks are not valid for this strategy.
 */
public UpdateLockingStrategy(Lockable lockable, LockMode lockMode) {
  this.lockable = lockable;
  this.lockMode = lockMode;
  if ( lockMode.lessThan( LockMode.UPGRADE ) ) {
    throw new HibernateException( "[" + lockMode + "] not valid for update statement" );
  }
  if ( !lockable.isVersioned() ) {
    log.warn( "write locks via update not supported for non-versioned entities [" + lockable.getEntityName() + "]" );
    this.sql = null;
  }
  else {
    this.sql = generateLockString();
  }
}

  @Override
  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // RDMS has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode == LockMode.PESSIMISTIC_FORCE_INCREMENT ) {
      return new PessimisticForceIncrementLockingStrategy( lockable, lockMode );
    }
    else if ( lockMode == LockMode.PESSIMISTIC_WRITE ) {
      return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode );
    }
    else if ( lockMode == LockMode.PESSIMISTIC_READ ) {
      return new PessimisticReadUpdateLockingStrategy( lockable, lockMode );
    }
    else if ( lockMode == LockMode.OPTIMISTIC ) {
      return new OptimisticLockingStrategy( lockable, lockMode );
    }
    else if ( lockMode == LockMode.OPTIMISTIC_FORCE_INCREMENT ) {
      return new OptimisticForceIncrementLockingStrategy( lockable, lockMode );
    }
    else if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

/**
 * Construct a locking strategy based on SQL UPDATE statements.
 *
 * @param lockable The metadata for the entity to be locked.
 * @param lockMode Indictates the type of lock to be acquired.  Note that
 * read-locks are not valid for this strategy.
 */
public UpdateLockingStrategy(Lockable lockable, LockMode lockMode) {
  this.lockable = lockable;
  this.lockMode = lockMode;
  if ( lockMode.lessThan( LockMode.UPGRADE ) ) {
    throw new HibernateException( "[" + lockMode + "] not valid for update statement" );
  }
  if ( !lockable.isVersioned() ) {
    LOG.writeLocksNotSupported( lockable.getEntityName() );
    this.sql = null;
  }
  else {
    this.sql = generateLockString();
  }
}

  @Override
  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Pointbase has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
      return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
      return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_READ) {
      return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC) {
      return new OptimisticLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
      return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

/**
 * Construct a locking strategy based on SQL UPDATE statements.
 *
 * @param lockable The metadata for the entity to be locked.
 * @param lockMode Indictates the type of lock to be acquired.  Note that
 * read-locks are not valid for this strategy.
 */
public UpdateLockingStrategy(Lockable lockable, LockMode lockMode) {
  this.lockable = lockable;
  this.lockMode = lockMode;
  if ( lockMode.lessThan( LockMode.UPGRADE ) ) {
    throw new HibernateException( "[" + lockMode + "] not valid for update statement" );
  }
  if ( !lockable.isVersioned() ) {
    LOG.writeLocksNotSupported( lockable.getEntityName() );
    this.sql = null;
  }
  else {
    this.sql = generateLockString();
  }
}

  @Override
  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Mckoi has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
      return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
      return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_READ) {
      return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC) {
      return new OptimisticLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
      return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

/**
 * Construct a locking strategy based on SQL UPDATE statements.
 *
 * @param lockable The metadata for the entity to be locked.
 * @param lockMode Indictates the type of lock to be acquired.  Note that
 * read-locks are not valid for this strategy.
 */
public UpdateLockingStrategy(Lockable lockable, LockMode lockMode) {
  this.lockable = lockable;
  this.lockMode = lockMode;
  if ( lockMode.lessThan( LockMode.UPGRADE ) ) {
    throw new HibernateException( "[" + lockMode + "] not valid for update statement" );
  }
  if ( StringHelper.isEmpty( lockable.getVersionColumnName() ) ) {
    LOG.writeLocksNotSupported( lockable.getEntityName() );
    this.sql = null;
  }
  else {
    this.sql = generateLockString();
  }
}

  @Override
  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Frontbase has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
      return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
      return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_READ) {
      return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC) {
      return new OptimisticLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
      return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Mckoi has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Pointbase has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // TimesTen has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // RDMS has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Frontbase has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
  // TimesTen has no known variation of a "SELECT ... FOR UPDATE" syntax...
  if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
    return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
    return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.PESSIMISTIC_READ) {
    return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.OPTIMISTIC) {
    return new OptimisticLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
    return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
  }
  else if ( lockMode.greaterThan( LockMode.READ ) ) {
    return new UpdateLockingStrategy( lockable, lockMode );
  }
  else {
    return new SelectLockingStrategy( lockable, lockMode );
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // RDMS has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
      return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
      return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_READ) {
      return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC) {
      return new OptimisticLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
      return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}

  public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
    // Mckoi has no known variation of a "SELECT ... FOR UPDATE" syntax...
    if ( lockMode==LockMode.PESSIMISTIC_FORCE_INCREMENT) {
      return new PessimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_WRITE) {
      return new PessimisticWriteUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.PESSIMISTIC_READ) {
      return new PessimisticReadUpdateLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC) {
      return new OptimisticLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode==LockMode.OPTIMISTIC_FORCE_INCREMENT) {
      return new OptimisticForceIncrementLockingStrategy( lockable, lockMode);
    }
    else if ( lockMode.greaterThan( LockMode.READ ) ) {
      return new UpdateLockingStrategy( lockable, lockMode );
    }
    else {
      return new SelectLockingStrategy( lockable, lockMode );
    }
  }
}