/* */ {
/* 2624 */ PreparedStatement ps = null;
/* 2625 */ ResultSet rs = null;
/* */ try
/* */ {
/* 2628 */ TriggerStatus status = null;
/* */
/* 2630 */ ps = conn.prepareStatement(rtp("SELECT TRIGGER_STATE, NEXT_FIRE_TIME, JOB_NAME, JOB_GROUP FROM {0}TRIGGERS WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"));
/* 2631 */ ps.setString(1, triggerName);
/* 2632 */ ps.setString(2, groupName);
/* 2633 */ rs = ps.executeQuery();
/* */
/* 2635 */ if (rs.next()) {
/* 2636 */ state = rs.getString("TRIGGER_STATE");
/* 2637 */ long nextFireTime = rs.getLong("NEXT_FIRE_TIME");
/* 2638 */ String jobName = rs.getString("JOB_NAME");
/* 2639 */ String jobGroup = rs.getString("JOB_GROUP");
/* */
/* 2641 */ Date nft = null;
/* 2642 */ if (nextFireTime > 0L) {
/* 2643 */ nft = new Date(nextFireTime);
/* */ }
/* */
/* 2646 */ status = new TriggerStatus(state, nft);
/* 2647 */ status.setKey(new Key(triggerName, groupName));
/* 2648 */ status.setJobKey(new Key(jobName, jobGroup));
/* */ }
/* */
/* 2651 */ state = status;
/* */ }
/* */ finally