org.quartz.impl.jdbcjobstore
Class SimplePropertiesTriggerPersistenceDelegateSupport

java.lang.Object
  org.quartz.impl.jdbcjobstore.SimplePropertiesTriggerPersistenceDelegateSupport

All Implemented Interfaces:

Constants, StdJDBCConstants, TriggerPersistenceDelegate

Direct Known Subclasses:

CalendarIntervalTriggerPersistenceDelegate, DailyTimeIntervalTriggerPersistenceDelegate

public abstract class SimplePropertiesTriggerPersistenceDelegateSupport
extends Object
implements TriggerPersistenceDelegate, StdJDBCConstants

A base implementation of TriggerPersistenceDelegate that persists trigger fields in the "QRTZ_SIMPROP_TRIGGERS" table. This allows extending concrete classes to simply implement a couple methods that do the work of getting/setting the trigger's fields, and creating the ScheduleBuilder for the particular type of trigger.

Author:

jhouse

See Also:

for an example extension

Nested Class Summary

Nested classes/interfaces inherited from interface org.quartz.impl.jdbcjobstore.TriggerPersistenceDelegate

TriggerPersistenceDelegate.TriggerPropertyBundle

Field Summary

protected static String	COL_BOOL_PROP_1
protected static String	COL_BOOL_PROP_2
protected static String	COL_DEC_PROP_1
protected static String	COL_DEC_PROP_2
protected static String	COL_INT_PROP_1
protected static String	COL_INT_PROP_2
protected static String	COL_LONG_PROP_1
protected static String	COL_LONG_PROP_2
protected static String	COL_STR_PROP_1
protected static String	COL_STR_PROP_2
protected static String	COL_STR_PROP_3
protected static String	DELETE_SIMPLE_PROPS_TRIGGER
protected static String	INSERT_SIMPLE_PROPS_TRIGGER
protected String	schedNameLiteral
protected static String	SELECT_SIMPLE_PROPS_TRIGGER
protected static String	TABLE_SIMPLE_PROPERTIES_TRIGGERS
protected String	tablePrefix
protected static String	UPDATE_SIMPLE_PROPS_TRIGGER

Fields inherited from interface org.quartz.impl.jdbcjobstore.StdJDBCConstants

COUNT_MISFIRED_TRIGGERS_IN_STATE, DELETE_ALL_BLOB_TRIGGERS, DELETE_ALL_CALENDARS, DELETE_ALL_CRON_TRIGGERS, DELETE_ALL_JOB_DETAILS, DELETE_ALL_PAUSED_TRIGGER_GRPS, DELETE_ALL_SIMPLE_TRIGGERS, DELETE_ALL_SIMPROP_TRIGGERS, DELETE_ALL_TRIGGERS, DELETE_BLOB_TRIGGER, DELETE_CALENDAR, DELETE_CRON_TRIGGER, DELETE_FIRED_TRIGGER, DELETE_FIRED_TRIGGERS, DELETE_INSTANCES_FIRED_TRIGGERS, DELETE_JOB_DETAIL, DELETE_NO_RECOVERY_FIRED_TRIGGERS, DELETE_PAUSED_TRIGGER_GROUP, DELETE_PAUSED_TRIGGER_GROUPS, DELETE_SCHEDULER_STATE, DELETE_SIMPLE_TRIGGER, DELETE_TRIGGER, INSERT_BLOB_TRIGGER, INSERT_CALENDAR, INSERT_CRON_TRIGGER, INSERT_FIRED_TRIGGER, INSERT_JOB_DETAIL, INSERT_PAUSED_TRIGGER_GROUP, INSERT_SCHEDULER_STATE, INSERT_SIMPLE_TRIGGER, INSERT_TRIGGER, SCHED_NAME_SUBST, SELECT_BLOB_TRIGGER, SELECT_CALENDAR, SELECT_CALENDAR_EXISTENCE, SELECT_CALENDARS, SELECT_CRON_TRIGGER, SELECT_FIRED_TRIGGER, SELECT_FIRED_TRIGGER_GROUP, SELECT_FIRED_TRIGGER_INSTANCE_NAMES, SELECT_FIRED_TRIGGERS, SELECT_FIRED_TRIGGERS_OF_JOB, SELECT_FIRED_TRIGGERS_OF_JOB_GROUP, SELECT_HAS_MISFIRED_TRIGGERS_IN_STATE, SELECT_INSTANCES_FIRED_TRIGGERS, SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS, SELECT_JOB_DETAIL, SELECT_JOB_EXECUTION_COUNT, SELECT_JOB_EXISTENCE, SELECT_JOB_FOR_TRIGGER, SELECT_JOB_GROUPS, SELECT_JOB_NONCONCURRENT, SELECT_JOBS_IN_GROUP, SELECT_JOBS_IN_GROUP_LIKE, SELECT_MISFIRED_TRIGGERS, SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE, SELECT_MISFIRED_TRIGGERS_IN_STATE, SELECT_NEXT_FIRE_TIME, SELECT_NEXT_TRIGGER_TO_ACQUIRE, SELECT_NUM_CALENDARS, SELECT_NUM_JOBS, SELECT_NUM_TRIGGERS, SELECT_NUM_TRIGGERS_FOR_JOB, SELECT_NUM_TRIGGERS_IN_GROUP, SELECT_PAUSED_TRIGGER_GROUP, SELECT_PAUSED_TRIGGER_GROUPS, SELECT_REFERENCED_CALENDAR, SELECT_SCHEDULER_STATE, SELECT_SCHEDULER_STATES, SELECT_SIMPLE_TRIGGER, SELECT_TRIGGER, SELECT_TRIGGER_DATA, SELECT_TRIGGER_EXISTENCE, SELECT_TRIGGER_FOR_FIRE_TIME, SELECT_TRIGGER_GROUPS, SELECT_TRIGGER_GROUPS_FILTERED, SELECT_TRIGGER_STATE, SELECT_TRIGGER_STATUS, SELECT_TRIGGERS_FOR_CALENDAR, SELECT_TRIGGERS_FOR_JOB, SELECT_TRIGGERS_IN_GROUP, SELECT_TRIGGERS_IN_GROUP_LIKE, SELECT_TRIGGERS_IN_STATE, TABLE_PREFIX_SUBST, UPDATE_BLOB_TRIGGER, UPDATE_CALENDAR, UPDATE_CRON_TRIGGER, UPDATE_FIRED_TRIGGER, UPDATE_JOB_DATA, UPDATE_JOB_DETAIL, UPDATE_JOB_TRIGGER_STATES, UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE, UPDATE_SCHEDULER_STATE, UPDATE_SIMPLE_TRIGGER, UPDATE_TRIGGER, UPDATE_TRIGGER_GROUP_STATE_FROM_STATE, UPDATE_TRIGGER_GROUP_STATE_FROM_STATES, UPDATE_TRIGGER_SKIP_DATA, UPDATE_TRIGGER_STATE, UPDATE_TRIGGER_STATE_FROM_STATE, UPDATE_TRIGGER_STATE_FROM_STATES, UPDATE_TRIGGER_STATES_FROM_OTHER_STATES

Fields inherited from interface org.quartz.impl.jdbcjobstore.Constants

ALIAS_COL_NEXT_FIRE_TIME, ALL_GROUPS_PAUSED, COL_BLOB, COL_CALENDAR, COL_CALENDAR_NAME, COL_CHECKIN_INTERVAL, COL_CRON_EXPRESSION, COL_DESCRIPTION, COL_END_TIME, COL_ENTRY_ID, COL_ENTRY_STATE, COL_FIRED_TIME, COL_INSTANCE_NAME, COL_IS_DURABLE, COL_IS_NONCONCURRENT, COL_IS_UPDATE_DATA, COL_IS_VOLATILE, COL_JOB_CLASS, COL_JOB_DATAMAP, COL_JOB_GROUP, COL_JOB_NAME, COL_LAST_CHECKIN_TIME, COL_LOCK_NAME, COL_MISFIRE_INSTRUCTION, COL_NEXT_FIRE_TIME, COL_PREV_FIRE_TIME, COL_PRIORITY, COL_REPEAT_COUNT, COL_REPEAT_INTERVAL, COL_REQUESTS_RECOVERY, COL_SCHED_TIME, COL_SCHEDULER_NAME, COL_START_TIME, COL_TIME_ZONE_ID, COL_TIMES_TRIGGERED, COL_TRIGGER_GROUP, COL_TRIGGER_NAME, COL_TRIGGER_STATE, COL_TRIGGER_TYPE, DEFAULT_TABLE_PREFIX, STATE_ACQUIRED, STATE_BLOCKED, STATE_COMPLETE, STATE_DELETED, STATE_ERROR, STATE_EXECUTING, STATE_MISFIRED, STATE_PAUSED, STATE_PAUSED_BLOCKED, STATE_WAITING, TABLE_BLOB_TRIGGERS, TABLE_CALENDARS, TABLE_CRON_TRIGGERS, TABLE_FIRED_TRIGGERS, TABLE_JOB_DETAILS, TABLE_LOCKS, TABLE_PAUSED_TRIGGERS, TABLE_SCHEDULER_STATE, TABLE_SIMPLE_TRIGGERS, TABLE_TRIGGERS, TTYPE_BLOB, TTYPE_CAL_INT, TTYPE_CRON, TTYPE_DAILY_TIME_INT, TTYPE_SIMPLE

Constructor Summary

SimplePropertiesTriggerPersistenceDelegateSupport()

Method Summary

int	deleteExtendedTriggerProperties(Connection conn, TriggerKey triggerKey)
protected abstract SimplePropertiesTriggerProperties	getTriggerProperties(OperableTrigger trigger)
protected abstract TriggerPersistenceDelegate.TriggerPropertyBundle	getTriggerPropertyBundle(SimplePropertiesTriggerProperties properties)
void	initialize(String theTablePrefix, String schedName)
int	insertExtendedTriggerProperties(Connection conn, OperableTrigger trigger, String state, JobDetail jobDetail)
TriggerPersistenceDelegate.TriggerPropertyBundle	loadExtendedTriggerProperties(Connection conn, TriggerKey triggerKey)
int	updateExtendedTriggerProperties(Connection conn, OperableTrigger trigger, String state, JobDetail jobDetail)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.quartz.impl.jdbcjobstore.TriggerPersistenceDelegate

canHandleTriggerType, getHandledTriggerTypeDiscriminator

Field Detail

TABLE_SIMPLE_PROPERTIES_TRIGGERS

protected static final String TABLE_SIMPLE_PROPERTIES_TRIGGERS

See Also:

Constant Field Values

COL_STR_PROP_1

protected static final String COL_STR_PROP_1

See Also:

Constant Field Values

COL_STR_PROP_2

protected static final String COL_STR_PROP_2

See Also:

Constant Field Values

COL_STR_PROP_3

protected static final String COL_STR_PROP_3

See Also:

Constant Field Values

COL_INT_PROP_1

protected static final String COL_INT_PROP_1

See Also:

Constant Field Values

COL_INT_PROP_2

protected static final String COL_INT_PROP_2

See Also:

Constant Field Values

COL_LONG_PROP_1

protected static final String COL_LONG_PROP_1

See Also:

Constant Field Values

COL_LONG_PROP_2

protected static final String COL_LONG_PROP_2

See Also:

Constant Field Values

COL_DEC_PROP_1

protected static final String COL_DEC_PROP_1

See Also:

Constant Field Values

COL_DEC_PROP_2

protected static final String COL_DEC_PROP_2

See Also:

Constant Field Values

COL_BOOL_PROP_1

protected static final String COL_BOOL_PROP_1

See Also:

Constant Field Values

COL_BOOL_PROP_2

protected static final String COL_BOOL_PROP_2

See Also:

Constant Field Values

SELECT_SIMPLE_PROPS_TRIGGER

protected static final String SELECT_SIMPLE_PROPS_TRIGGER

See Also:

Constant Field Values

DELETE_SIMPLE_PROPS_TRIGGER

protected static final String DELETE_SIMPLE_PROPS_TRIGGER

See Also:

Constant Field Values

INSERT_SIMPLE_PROPS_TRIGGER

protected static final String INSERT_SIMPLE_PROPS_TRIGGER

See Also:

Constant Field Values

UPDATE_SIMPLE_PROPS_TRIGGER

protected static final String UPDATE_SIMPLE_PROPS_TRIGGER

See Also:

Constant Field Values

tablePrefix

protected String tablePrefix

schedNameLiteral

protected String schedNameLiteral

Constructor Detail

SimplePropertiesTriggerPersistenceDelegateSupport

public SimplePropertiesTriggerPersistenceDelegateSupport()

Method Detail

initialize

public void initialize(String theTablePrefix,
                       String schedName)

Specified by:

initialize in interface TriggerPersistenceDelegate

getTriggerProperties

protected abstract SimplePropertiesTriggerProperties getTriggerProperties(OperableTrigger trigger)

getTriggerPropertyBundle

protected abstract TriggerPersistenceDelegate.TriggerPropertyBundle getTriggerPropertyBundle(SimplePropertiesTriggerProperties properties)

deleteExtendedTriggerProperties

public int deleteExtendedTriggerProperties(Connection conn,
                                           TriggerKey triggerKey)
                                    throws SQLException

Specified by:

deleteExtendedTriggerProperties in interface TriggerPersistenceDelegate

Throws:

SQLException

insertExtendedTriggerProperties

public int insertExtendedTriggerProperties(Connection conn,
                                           OperableTrigger trigger,
                                           String state,
                                           JobDetail jobDetail)
                                    throws SQLException,
                                           IOException

Specified by:

insertExtendedTriggerProperties in interface TriggerPersistenceDelegate

Throws:

SQLException

IOException

loadExtendedTriggerProperties

public TriggerPersistenceDelegate.TriggerPropertyBundle loadExtendedTriggerProperties(Connection conn,
                                                                                      TriggerKey triggerKey)
                                                                               throws SQLException

Specified by:

loadExtendedTriggerProperties in interface TriggerPersistenceDelegate

Throws:

SQLException

updateExtendedTriggerProperties

public int updateExtendedTriggerProperties(Connection conn,
                                           OperableTrigger trigger,
                                           String state,
                                           JobDetail jobDetail)
                                    throws SQLException,
                                           IOException

Specified by:

updateExtendedTriggerProperties in interface TriggerPersistenceDelegate

Throws:

SQLException

IOException