SimplePropertiesTriggerProperties properties = new SimplePropertiesTriggerProperties(); properties.setString1(rs.getString(COL_STR_PROP_1)); properties.setString2(rs.getString(COL_STR_PROP_2)); properties.setString3(rs.getString(COL_STR_PROP_3)); properties.setInt1(rs.getInt(COL_INT_PROP_1)); properties.setInt2(rs.getInt(COL_INT_PROP_2)); properties.setLong1(rs.getInt(COL_LONG_PROP_1)); properties.setLong2(rs.getInt(COL_LONG_PROP_2)); properties.setDecimal1(rs.getBigDecimal(COL_DEC_PROP_1)); properties.setDecimal2(rs.getBigDecimal(COL_DEC_PROP_2)); properties.setBoolean1(rs.getBoolean(COL_BOOL_PROP_1)); properties.setBoolean2(rs.getBoolean(COL_BOOL_PROP_2));
public int insertExtendedTriggerProperties(Connection conn, OperableTrigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException { SimplePropertiesTriggerProperties properties = getTriggerProperties(trigger); PreparedStatement ps = null; try { ps = conn.prepareStatement(Util.rtp(INSERT_SIMPLE_PROPS_TRIGGER, tablePrefix, schedNameLiteral)); ps.setString(1, trigger.getKey().getName()); ps.setString(2, trigger.getKey().getGroup()); ps.setString(3, properties.getString1()); ps.setString(4, properties.getString2()); ps.setString(5, properties.getString3()); ps.setInt(6, properties.getInt1()); ps.setInt(7, properties.getInt2()); ps.setLong(8, properties.getLong1()); ps.setLong(9, properties.getLong2()); ps.setBigDecimal(10, properties.getDecimal1()); ps.setBigDecimal(11, properties.getDecimal2()); ps.setBoolean(12, properties.isBoolean1()); ps.setBoolean(13, properties.isBoolean2()); return ps.executeUpdate(); } finally { Util.closeStatement(ps); } }
@Override protected SimplePropertiesTriggerProperties getTriggerProperties(OperableTrigger trigger) { CalendarIntervalTriggerImpl calTrig = (CalendarIntervalTriggerImpl)trigger; SimplePropertiesTriggerProperties props = new SimplePropertiesTriggerProperties(); props.setInt1(calTrig.getRepeatInterval()); props.setString1(calTrig.getRepeatIntervalUnit().name()); props.setInt2(calTrig.getTimesTriggered()); props.setString2(calTrig.getTimeZone().getID()); props.setBoolean1(calTrig.isPreserveHourOfDayAcrossDaylightSavings()); props.setBoolean2(calTrig.isSkipDayIfHourDoesNotExist()); return props; }
@Override protected TriggerPropertyBundle getTriggerPropertyBundle(SimplePropertiesTriggerProperties props) { TimeZone tz = null; // if we use null, that's ok as system default tz will be used String tzId = props.getString2(); if(tzId != null && tzId.trim().length() != 0) // there could be null entries from previously released versions tz = TimeZone.getTimeZone(tzId); ScheduleBuilder<?> sb = CalendarIntervalScheduleBuilder.calendarIntervalSchedule() .withInterval(props.getInt1(), IntervalUnit.valueOf(props.getString1())) .inTimeZone(tz) .preserveHourOfDayAcrossDaylightSavings(props.isBoolean1()) .skipDayIfHourDoesNotExist(props.isBoolean2()); int timesTriggered = props.getInt2(); String[] statePropertyNames = { "timesTriggered" }; Object[] statePropertyValues = { timesTriggered }; return new TriggerPropertyBundle(sb, statePropertyNames, statePropertyValues); }
@Override protected SimplePropertiesTriggerProperties getTriggerProperties(OperableTrigger trigger) { DailyTimeIntervalTriggerImpl dailyTrigger = (DailyTimeIntervalTriggerImpl)trigger; SimplePropertiesTriggerProperties props = new SimplePropertiesTriggerProperties(); props.setInt1(dailyTrigger.getRepeatInterval()); props.setString1(dailyTrigger.getRepeatIntervalUnit().name()); props.setInt2(dailyTrigger.getTimesTriggered()); props.setString2(daysStr); timeOfDayBuffer.append(",,,"); props.setString3(timeOfDayBuffer.toString()); props.setLong1(dailyTrigger.getRepeatCount());
@Override protected TriggerPropertyBundle getTriggerPropertyBundle(SimplePropertiesTriggerProperties props) { int repeatCount = (int)props.getLong1(); int interval = props.getInt1(); String intervalUnitStr = props.getString1(); String daysOfWeekStr = props.getString2(); String timeOfDayStr = props.getString3(); int timesTriggered = props.getInt2(); String[] statePropertyNames = { "timesTriggered" }; Object[] statePropertyValues = { timesTriggered };
@Override protected SimplePropertiesTriggerProperties getTriggerProperties(OperableTrigger trigger) { CalendarIntervalTriggerImpl calTrig = (CalendarIntervalTriggerImpl)trigger; SimplePropertiesTriggerProperties props = new SimplePropertiesTriggerProperties(); props.setInt1(calTrig.getRepeatInterval()); props.setString1(calTrig.getRepeatIntervalUnit().name()); props.setInt2(calTrig.getTimesTriggered()); props.setString2(calTrig.getTimeZone().getID()); props.setBoolean1(calTrig.isPreserveHourOfDayAcrossDaylightSavings()); props.setBoolean2(calTrig.isSkipDayIfHourDoesNotExist()); return props; }
@Override protected SimplePropertiesTriggerProperties getTriggerProperties(OperableTrigger trigger) { DailyTimeIntervalTriggerImpl dailyTrigger = (DailyTimeIntervalTriggerImpl)trigger; SimplePropertiesTriggerProperties props = new SimplePropertiesTriggerProperties(); props.setInt1(dailyTrigger.getRepeatInterval()); props.setString1(dailyTrigger.getRepeatIntervalUnit().name()); props.setInt2(dailyTrigger.getTimesTriggered()); props.setString2(daysStr); timeOfDayBuffer.append(",,,"); props.setString3(timeOfDayBuffer.toString()); props.setLong1(dailyTrigger.getRepeatCount());
@Override protected TriggerPropertyBundle getTriggerPropertyBundle(SimplePropertiesTriggerProperties props) { TimeZone tz = null; // if we use null, that's ok as system default tz will be used String tzId = props.getString2(); if(tzId != null && tzId.trim().length() != 0) // there could be null entries from previously released versions tz = TimeZone.getTimeZone(tzId); ScheduleBuilder<?> sb = CalendarIntervalScheduleBuilder.calendarIntervalSchedule() .withInterval(props.getInt1(), IntervalUnit.valueOf(props.getString1())) .inTimeZone(tz) .preserveHourOfDayAcrossDaylightSavings(props.isBoolean1()) .skipDayIfHourDoesNotExist(props.isBoolean2()); int timesTriggered = props.getInt2(); String[] statePropertyNames = { "timesTriggered" }; Object[] statePropertyValues = { timesTriggered }; return new TriggerPropertyBundle(sb, statePropertyNames, statePropertyValues); }
@Override protected TriggerPropertyBundle getTriggerPropertyBundle(SimplePropertiesTriggerProperties props) { int repeatCount = (int)props.getLong1(); int interval = props.getInt1(); String intervalUnitStr = props.getString1(); String daysOfWeekStr = props.getString2(); String timeOfDayStr = props.getString3(); int timesTriggered = props.getInt2(); String[] statePropertyNames = { "timesTriggered" }; Object[] statePropertyValues = { timesTriggered };
public int updateExtendedTriggerProperties(Connection conn, OperableTrigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException { SimplePropertiesTriggerProperties properties = getTriggerProperties(trigger); PreparedStatement ps = null; try { ps = conn.prepareStatement(Util.rtp(UPDATE_SIMPLE_PROPS_TRIGGER, tablePrefix, schedNameLiteral)); ps.setString(1, properties.getString1()); ps.setString(2, properties.getString2()); ps.setString(3, properties.getString3()); ps.setInt(4, properties.getInt1()); ps.setInt(5, properties.getInt2()); ps.setLong(6, properties.getLong1()); ps.setLong(7, properties.getLong2()); ps.setBigDecimal(8, properties.getDecimal1()); ps.setBigDecimal(9, properties.getDecimal2()); ps.setBoolean(10, properties.isBoolean1()); ps.setBoolean(11, properties.isBoolean2()); ps.setString(12, trigger.getKey().getName()); ps.setString(13, trigger.getKey().getGroup()); return ps.executeUpdate(); } finally { Util.closeStatement(ps); } }
SimplePropertiesTriggerProperties properties = new SimplePropertiesTriggerProperties(); properties.setString1(rs.getString(COL_STR_PROP_1)); properties.setString2(rs.getString(COL_STR_PROP_2)); properties.setString3(rs.getString(COL_STR_PROP_3)); properties.setInt1(rs.getInt(COL_INT_PROP_1)); properties.setInt2(rs.getInt(COL_INT_PROP_2)); properties.setLong1(rs.getInt(COL_LONG_PROP_1)); properties.setLong2(rs.getInt(COL_LONG_PROP_2)); properties.setDecimal1(rs.getBigDecimal(COL_DEC_PROP_1)); properties.setDecimal2(rs.getBigDecimal(COL_DEC_PROP_2)); properties.setBoolean1(rs.getBoolean(COL_BOOL_PROP_1)); properties.setBoolean2(rs.getBoolean(COL_BOOL_PROP_2));
public int updateExtendedTriggerProperties(Connection conn, OperableTrigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException { SimplePropertiesTriggerProperties properties = getTriggerProperties(trigger); PreparedStatement ps = null; try { ps = conn.prepareStatement(Util.rtp(UPDATE_SIMPLE_PROPS_TRIGGER, tablePrefix, schedNameLiteral)); ps.setString(1, properties.getString1()); ps.setString(2, properties.getString2()); ps.setString(3, properties.getString3()); ps.setInt(4, properties.getInt1()); ps.setInt(5, properties.getInt2()); ps.setLong(6, properties.getLong1()); ps.setLong(7, properties.getLong2()); ps.setBigDecimal(8, properties.getDecimal1()); ps.setBigDecimal(9, properties.getDecimal2()); ps.setBoolean(10, properties.isBoolean1()); ps.setBoolean(11, properties.isBoolean2()); ps.setString(12, trigger.getKey().getName()); ps.setString(13, trigger.getKey().getGroup()); return ps.executeUpdate(); } finally { Util.closeStatement(ps); } }
public int insertExtendedTriggerProperties(Connection conn, OperableTrigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException { SimplePropertiesTriggerProperties properties = getTriggerProperties(trigger); PreparedStatement ps = null; try { ps = conn.prepareStatement(Util.rtp(INSERT_SIMPLE_PROPS_TRIGGER, tablePrefix, schedNameLiteral)); ps.setString(1, trigger.getKey().getName()); ps.setString(2, trigger.getKey().getGroup()); ps.setString(3, properties.getString1()); ps.setString(4, properties.getString2()); ps.setString(5, properties.getString3()); ps.setInt(6, properties.getInt1()); ps.setInt(7, properties.getInt2()); ps.setLong(8, properties.getLong1()); ps.setLong(9, properties.getLong2()); ps.setBigDecimal(10, properties.getDecimal1()); ps.setBigDecimal(11, properties.getDecimal2()); ps.setBoolean(12, properties.isBoolean1()); ps.setBoolean(13, properties.isBoolean2()); return ps.executeUpdate(); } finally { Util.closeStatement(ps); } }