How to use

selectTriggerState

method

in

org.quartz.impl.jdbcjobstore.DriverDelegate

public TriggerState getTriggerState(Connection conn, TriggerKey key)
  throws JobPersistenceException {
  try {
    String ts = getDelegate().selectTriggerState(conn, key);

public TriggerState getTriggerState(Connection conn, TriggerKey key)
  throws JobPersistenceException {
  try {
    String ts = getDelegate().selectTriggerState(conn, key);

/**
 * <p>
 * Pause the <code>{@link org.quartz.Trigger}</code> with the given name.
 * </p>
 * 
 * @see #resumeTrigger(Connection, TriggerKey)
 */
public void pauseTrigger(Connection conn, 
    TriggerKey triggerKey)
  throws JobPersistenceException {
  try {
    String oldState = getDelegate().selectTriggerState(conn,
        triggerKey);
    if (oldState.equals(STATE_WAITING)
        || oldState.equals(STATE_ACQUIRED)) {
      getDelegate().updateTriggerState(conn, triggerKey,
          STATE_PAUSED);
    } else if (oldState.equals(STATE_BLOCKED)) {
      getDelegate().updateTriggerState(conn, triggerKey,
          STATE_PAUSED_BLOCKED);
    }
  } catch (SQLException e) {
    throw new JobPersistenceException("Couldn't pause trigger '"
        + triggerKey + "': " + e.getMessage(), e);
  }
}

/**
 * <p>
 * Pause the <code>{@link org.quartz.Trigger}</code> with the given name.
 * </p>
 * 
 * @see #resumeTrigger(Connection, TriggerKey)
 */
public void pauseTrigger(Connection conn, 
    TriggerKey triggerKey)
  throws JobPersistenceException {
  try {
    String oldState = getDelegate().selectTriggerState(conn,
        triggerKey);
    if (oldState.equals(STATE_WAITING)
        || oldState.equals(STATE_ACQUIRED)) {
      getDelegate().updateTriggerState(conn, triggerKey,
          STATE_PAUSED);
    } else if (oldState.equals(STATE_BLOCKED)) {
      getDelegate().updateTriggerState(conn, triggerKey,
          STATE_PAUSED_BLOCKED);
    }
  } catch (SQLException e) {
    throw new JobPersistenceException("Couldn't pause trigger '"
        + triggerKey + "': " + e.getMessage(), e);
  }
}

for (TriggerKey triggerKey : triggerKeys) {
  if (getDelegate().selectTriggerState(conn, triggerKey).
      equals(STATE_COMPLETE)) {
    List<FiredTriggerRecord> firedTriggers =

String state = getDelegate().selectTriggerState(conn,
    trigger.getKey());
if (!state.equals(STATE_ACQUIRED)) {

String state = getDelegate().selectTriggerState(conn,
    trigger.getKey());
if (!state.equals(STATE_ACQUIRED)) {

for (TriggerKey triggerKey : triggerKeys) {
  if (getDelegate().selectTriggerState(conn, triggerKey).
      equals(STATE_COMPLETE)) {
    List<FiredTriggerRecord> firedTriggers =

throws JobPersistenceException {
try {
  String ts = getDelegate().selectTriggerState(conn, triggerName,
      groupName);

throws JobPersistenceException {
try {
  String ts = getDelegate().selectTriggerState(conn, triggerName,
      groupName);

/**
 * <p>
 * Pause the <code>{@link org.quartz.Trigger}</code> with the given name.
 * </p>
 * 
 * @see #resumeTrigger(Connection, SchedulingContext, String, String)
 */
public void pauseTrigger(Connection conn, SchedulingContext ctxt,
    String triggerName, String groupName)
  throws JobPersistenceException {
  try {
    String oldState = getDelegate().selectTriggerState(conn,
        triggerName, groupName);
    if (oldState.equals(STATE_WAITING)
        || oldState.equals(STATE_ACQUIRED)) {
      getDelegate().updateTriggerState(conn, triggerName,
          groupName, STATE_PAUSED);
    } else if (oldState.equals(STATE_BLOCKED)) {
      getDelegate().updateTriggerState(conn, triggerName,
          groupName, STATE_PAUSED_BLOCKED);
    }
  } catch (SQLException e) {
    throw new JobPersistenceException("Couldn't pause trigger '"
        + groupName + "." + triggerName + "': " + e.getMessage(), e);
  }
}

/**
 * <p>
 * Pause the <code>{@link org.quartz.Trigger}</code> with the given name.
 * </p>
 * 
 * @see #resumeTrigger(Connection, SchedulingContext, String, String)
 */
public void pauseTrigger(Connection conn, SchedulingContext ctxt,
    String triggerName, String groupName)
  throws JobPersistenceException {
  try {
    String oldState = getDelegate().selectTriggerState(conn,
        triggerName, groupName);
    if (oldState.equals(STATE_WAITING)
        || oldState.equals(STATE_ACQUIRED)) {
      getDelegate().updateTriggerState(conn, triggerName,
          groupName, STATE_PAUSED);
    } else if (oldState.equals(STATE_BLOCKED)) {
      getDelegate().updateTriggerState(conn, triggerName,
          groupName, STATE_PAUSED_BLOCKED);
    }
  } catch (SQLException e) {
    throw new JobPersistenceException("Couldn't pause trigger '"
        + groupName + "." + triggerName + "': " + e.getMessage(), e);
  }
}

Key triggerKey = (Key)triggerKeyIter.next();
if (getDelegate().selectTriggerState(conn, triggerKey.getName(), triggerKey.getGroup()).
    equals(STATE_COMPLETE)) {
  List firedTriggers = 

Key triggerKey = (Key)triggerKeyIter.next();
if (getDelegate().selectTriggerState(conn, triggerKey.getName(), triggerKey.getGroup()).
    equals(STATE_COMPLETE)) {
  List firedTriggers = 

String state = getDelegate().selectTriggerState(conn,
    trigger.getName(), trigger.getGroup());
if (!state.equals(STATE_ACQUIRED)) {

String state = getDelegate().selectTriggerState(conn,
    trigger.getName(), trigger.getGroup());
if (!state.equals(STATE_ACQUIRED)) {