How to use

updateTriggerStateFromOtherState

method

in

org.quartz.impl.jdbcjobstore.DriverDelegate

void resetTriggerFromErrorState(Connection conn, final TriggerKey triggerKey)
  throws JobPersistenceException {
  try {
    String newState = STATE_WAITING;
    if(getDelegate().isTriggerGroupPaused(conn, triggerKey.getGroup())) {
      newState = STATE_PAUSED;
    }
    getDelegate().updateTriggerStateFromOtherState(conn, triggerKey, newState, STATE_ERROR);
    getLog().info("Trigger " + triggerKey + " reset from ERROR state to: " + newState);
  } catch (SQLException e) {
    throw new JobPersistenceException(
        "Couldn't reset from error state of trigger (" + triggerKey + "): " + e.getMessage(), e);
  }
}

void resetTriggerFromErrorState(Connection conn, final TriggerKey triggerKey)
  throws JobPersistenceException {
  try {
    String newState = STATE_WAITING;
    if(getDelegate().isTriggerGroupPaused(conn, triggerKey.getGroup())) {
      newState = STATE_PAUSED;
    }
    getDelegate().updateTriggerStateFromOtherState(conn, triggerKey, newState, STATE_ERROR);
    getLog().info("Trigger " + triggerKey + " reset from ERROR state to: " + newState);
  } catch (SQLException e) {
    throw new JobPersistenceException(
        "Couldn't reset from error state of trigger (" + triggerKey + "): " + e.getMessage(), e);
  }
}

protected void releaseAcquiredTrigger(Connection conn,
    OperableTrigger trigger)
  throws JobPersistenceException {
  try {
    getDelegate().updateTriggerStateFromOtherState(conn,
        trigger.getKey(), STATE_WAITING, STATE_ACQUIRED);
    getDelegate().deleteFiredTrigger(conn, trigger.getFireInstanceId());
  } catch (SQLException e) {
    throw new JobPersistenceException(
        "Couldn't release acquired trigger: " + e.getMessage(), e);
  }
}

protected void releaseAcquiredTrigger(Connection conn,
    OperableTrigger trigger)
  throws JobPersistenceException {
  try {
    getDelegate().updateTriggerStateFromOtherState(conn,
        trigger.getKey(), STATE_WAITING, STATE_ACQUIRED);
    getDelegate().deleteFiredTrigger(conn, trigger.getFireInstanceId());
  } catch (SQLException e) {
    throw new JobPersistenceException(
        "Couldn't release acquired trigger: " + e.getMessage(), e);
  }
}

  getDelegate().updateTriggerStateFromOtherState(conn,
      key, newState, STATE_PAUSED_BLOCKED);
} else {
  getDelegate().updateTriggerStateFromOtherState(conn,
      key, newState, STATE_PAUSED);

  getDelegate().updateTriggerStateFromOtherState(conn,
      key, newState, STATE_PAUSED_BLOCKED);
} else {
  getDelegate().updateTriggerStateFromOtherState(conn,
      key, newState, STATE_PAUSED);

int rowsUpdated = getDelegate().updateTriggerStateFromOtherState(conn, triggerKey, STATE_ACQUIRED, STATE_WAITING);
if (rowsUpdated <= 0) {
  continue; // next trigger

int rowsUpdated = getDelegate().updateTriggerStateFromOtherState(conn, triggerKey, STATE_ACQUIRED, STATE_WAITING);
if (rowsUpdated <= 0) {
  continue; // next trigger

getDelegate().updateTriggerStateFromOtherState(
    conn, tKey, STATE_WAITING,
    STATE_ACQUIRED);

getDelegate().updateTriggerStateFromOtherState(
    conn, tKey, STATE_WAITING,
    STATE_ACQUIRED);

protected void releaseAcquiredTrigger(Connection conn,
    SchedulingContext ctxt, Trigger trigger)
  throws JobPersistenceException {
  try {
    getDelegate().updateTriggerStateFromOtherState(conn,
        trigger.getName(), trigger.getGroup(), STATE_WAITING,
        STATE_ACQUIRED);
    getDelegate().deleteFiredTrigger(conn, trigger.getFireInstanceId());
  } catch (SQLException e) {
    throw new JobPersistenceException(
        "Couldn't release acquired trigger: " + e.getMessage(), e);
  }
}

protected void releaseAcquiredTrigger(Connection conn,
    SchedulingContext ctxt, Trigger trigger)
  throws JobPersistenceException {
  try {
    getDelegate().updateTriggerStateFromOtherState(conn,
        trigger.getName(), trigger.getGroup(), STATE_WAITING,
        STATE_ACQUIRED);
    getDelegate().deleteFiredTrigger(conn, trigger.getFireInstanceId());
  } catch (SQLException e) {
    throw new JobPersistenceException(
        "Couldn't release acquired trigger: " + e.getMessage(), e);
  }
}

  getDelegate().updateTriggerStateFromOtherState(conn,
      triggerName, groupName, newState, STATE_PAUSED_BLOCKED);
} else {
  getDelegate().updateTriggerStateFromOtherState(conn,
      triggerName, groupName, newState, STATE_PAUSED);

  getDelegate().updateTriggerStateFromOtherState(conn,
      triggerName, groupName, newState, STATE_PAUSED_BLOCKED);
} else {
  getDelegate().updateTriggerStateFromOtherState(conn,
      triggerName, groupName, newState, STATE_PAUSED);

getDelegate().updateTriggerStateFromOtherState(
  conn,
  triggerKey.getName(), triggerKey.getGroup(), 

getDelegate().updateTriggerStateFromOtherState(
    conn, tKey.getName(), tKey.getGroup(),
    STATE_WAITING, STATE_ACQUIRED);

getDelegate().updateTriggerStateFromOtherState(
    conn, tKey.getName(), tKey.getGroup(),
    STATE_WAITING, STATE_ACQUIRED);

getDelegate().updateTriggerStateFromOtherState(
  conn,
  triggerKey.getName(), triggerKey.getGroup(),