How to use

selectTrigger

method

in

org.quartz.impl.jdbcjobstore.StdJDBCDelegate

public List<OperableTrigger> selectTriggersForCalendar(Connection conn, String calName)
  throws SQLException, ClassNotFoundException, IOException, JobPersistenceException {
  LinkedList<OperableTrigger> trigList = new LinkedList<OperableTrigger>();
  PreparedStatement ps = null;
  ResultSet rs = null;
  try {
    ps = conn.prepareStatement(rtp(SELECT_TRIGGERS_FOR_CALENDAR));
    ps.setString(1, calName);
    rs = ps.executeQuery();
    while (rs.next()) {
      trigList.add(selectTrigger(conn, triggerKey(rs.getString(COL_TRIGGER_NAME), rs.getString(COL_TRIGGER_GROUP))));
    }
  } finally {
    closeResultSet(rs);
    closeStatement(ps);
  }
  return trigList;
}

public List<OperableTrigger> selectTriggersForCalendar(Connection conn, String calName)
  throws SQLException, ClassNotFoundException, IOException, JobPersistenceException {
  LinkedList<OperableTrigger> trigList = new LinkedList<OperableTrigger>();
  PreparedStatement ps = null;
  ResultSet rs = null;
  try {
    ps = conn.prepareStatement(rtp(SELECT_TRIGGERS_FOR_CALENDAR));
    ps.setString(1, calName);
    rs = ps.executeQuery();
    while (rs.next()) {
      trigList.add(selectTrigger(conn, triggerKey(rs.getString(COL_TRIGGER_NAME), rs.getString(COL_TRIGGER_GROUP))));
    }
  } finally {
    closeResultSet(rs);
    closeStatement(ps);
  }
  return trigList;
}

OperableTrigger t = selectTrigger(conn, triggerKey(rs.getString(COL_TRIGGER_NAME), rs.getString(COL_TRIGGER_GROUP)));
if(t != null) {
  trigList.add(t);

OperableTrigger t = selectTrigger(conn, triggerKey(rs.getString(COL_TRIGGER_NAME), rs.getString(COL_TRIGGER_GROUP)));
if(t != null) {
  trigList.add(t);

public Trigger[] selectTriggersForCalendar(Connection conn, String calName)
  throws SQLException, ClassNotFoundException, IOException {
  ArrayList trigList = new ArrayList();
  PreparedStatement ps = null;
  ResultSet rs = null;
  try {
    ps = conn.prepareStatement(rtp(SELECT_TRIGGERS_FOR_CALENDAR));
    ps.setString(1, calName);
    rs = ps.executeQuery();
    while (rs.next()) {
      trigList.add(selectTrigger(conn,
          rs.getString(COL_TRIGGER_NAME), rs
              .getString(COL_TRIGGER_GROUP)));
    }
  } finally {
    closeResultSet(rs);
    closeStatement(ps);
  }
  return (Trigger[]) trigList.toArray(new Trigger[trigList.size()]);
}

public Trigger[] selectTriggersForCalendar(Connection conn, String calName)
  throws SQLException, ClassNotFoundException, IOException {
  ArrayList trigList = new ArrayList();
  PreparedStatement ps = null;
  ResultSet rs = null;
  try {
    ps = conn.prepareStatement(rtp(SELECT_TRIGGERS_FOR_CALENDAR));
    ps.setString(1, calName);
    rs = ps.executeQuery();
    while (rs.next()) {
      trigList.add(selectTrigger(conn,
          rs.getString(COL_TRIGGER_NAME), rs
              .getString(COL_TRIGGER_GROUP)));
    }
  } finally {
    closeResultSet(rs);
    closeStatement(ps);
  }
  return (Trigger[]) trigList.toArray(new Trigger[trigList.size()]);
}
 

Trigger t = selectTrigger(conn,
    rs.getString(COL_TRIGGER_NAME), 
    rs.getString(COL_TRIGGER_GROUP));

Trigger t = selectTrigger(conn,
    rs.getString(COL_TRIGGER_NAME), 
    rs.getString(COL_TRIGGER_GROUP));