org.quartz.impl.jdbcjobstore
Interface StdJDBCConstants

All Superinterfaces:

Constants

All Known Implementing Classes:

CacheDelegate, CalendarIntervalTriggerPersistenceDelegate, CronTriggerPersistenceDelegate, CUBRIDDelegate, DailyTimeIntervalTriggerPersistenceDelegate, DB2v6Delegate, DB2v7Delegate, DB2v8Delegate, DBSemaphore, HSQLDBDelegate, MSSQLDelegate, OracleDelegate, PointbaseDelegate, PostgreSQLDelegate, SimplePropertiesTriggerPersistenceDelegateSupport, SimpleTriggerPersistenceDelegate, StdJDBCDelegate, StdRowLockSemaphore, SybaseDelegate, UpdateLockRowSemaphore, WebLogicDelegate, WebLogicOracleDelegate

public interface StdJDBCConstants
extends Constants

This interface extends Constants to include the query string constants in use by the StdJDBCDelegate class.

Author:

Jeffrey Wescott

Field Summary

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

Field Detail

TABLE_PREFIX_SUBST

static final String TABLE_PREFIX_SUBST

See Also:

Constant Field Values

SCHED_NAME_SUBST

static final String SCHED_NAME_SUBST

See Also:

Constant Field Values

UPDATE_TRIGGER_STATES_FROM_OTHER_STATES

static final String UPDATE_TRIGGER_STATES_FROM_OTHER_STATES

See Also:

Constant Field Values

SELECT_MISFIRED_TRIGGERS

static final String SELECT_MISFIRED_TRIGGERS

See Also:

Constant Field Values

SELECT_TRIGGERS_IN_STATE

static final String SELECT_TRIGGERS_IN_STATE

See Also:

Constant Field Values

SELECT_MISFIRED_TRIGGERS_IN_STATE

static final String SELECT_MISFIRED_TRIGGERS_IN_STATE

See Also:

Constant Field Values

COUNT_MISFIRED_TRIGGERS_IN_STATE

static final String COUNT_MISFIRED_TRIGGERS_IN_STATE

See Also:

Constant Field Values

SELECT_HAS_MISFIRED_TRIGGERS_IN_STATE

static final String SELECT_HAS_MISFIRED_TRIGGERS_IN_STATE

See Also:

Constant Field Values

SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE

static final String SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE

See Also:

Constant Field Values

DELETE_FIRED_TRIGGERS

static final String DELETE_FIRED_TRIGGERS

See Also:

Constant Field Values

INSERT_JOB_DETAIL

static final String INSERT_JOB_DETAIL

See Also:

Constant Field Values

UPDATE_JOB_DETAIL

static final String UPDATE_JOB_DETAIL

See Also:

Constant Field Values

SELECT_TRIGGERS_FOR_JOB

static final String SELECT_TRIGGERS_FOR_JOB

See Also:

Constant Field Values

SELECT_TRIGGERS_FOR_CALENDAR

static final String SELECT_TRIGGERS_FOR_CALENDAR

See Also:

Constant Field Values

DELETE_JOB_DETAIL

static final String DELETE_JOB_DETAIL

See Also:

Constant Field Values

SELECT_JOB_NONCONCURRENT

static final String SELECT_JOB_NONCONCURRENT

See Also:

Constant Field Values

SELECT_JOB_EXISTENCE

static final String SELECT_JOB_EXISTENCE

See Also:

Constant Field Values

UPDATE_JOB_DATA

static final String UPDATE_JOB_DATA

See Also:

Constant Field Values

SELECT_JOB_DETAIL

static final String SELECT_JOB_DETAIL

See Also:

Constant Field Values

SELECT_NUM_JOBS

static final String SELECT_NUM_JOBS

See Also:

Constant Field Values

SELECT_JOB_GROUPS

static final String SELECT_JOB_GROUPS

See Also:

Constant Field Values

SELECT_JOBS_IN_GROUP_LIKE

static final String SELECT_JOBS_IN_GROUP_LIKE

See Also:

Constant Field Values

SELECT_JOBS_IN_GROUP

static final String SELECT_JOBS_IN_GROUP

See Also:

Constant Field Values

INSERT_TRIGGER

static final String INSERT_TRIGGER

See Also:

Constant Field Values

INSERT_SIMPLE_TRIGGER

static final String INSERT_SIMPLE_TRIGGER

See Also:

Constant Field Values

INSERT_CRON_TRIGGER

static final String INSERT_CRON_TRIGGER

See Also:

Constant Field Values

INSERT_BLOB_TRIGGER

static final String INSERT_BLOB_TRIGGER

See Also:

Constant Field Values

UPDATE_TRIGGER_SKIP_DATA

static final String UPDATE_TRIGGER_SKIP_DATA

See Also:

Constant Field Values

UPDATE_TRIGGER

static final String UPDATE_TRIGGER

See Also:

Constant Field Values

UPDATE_SIMPLE_TRIGGER

static final String UPDATE_SIMPLE_TRIGGER

See Also:

Constant Field Values

UPDATE_CRON_TRIGGER

static final String UPDATE_CRON_TRIGGER

See Also:

Constant Field Values

UPDATE_BLOB_TRIGGER

static final String UPDATE_BLOB_TRIGGER

See Also:

Constant Field Values

SELECT_TRIGGER_EXISTENCE

static final String SELECT_TRIGGER_EXISTENCE

See Also:

Constant Field Values

UPDATE_TRIGGER_STATE

static final String UPDATE_TRIGGER_STATE

See Also:

Constant Field Values

UPDATE_TRIGGER_STATE_FROM_STATE

static final String UPDATE_TRIGGER_STATE_FROM_STATE

See Also:

Constant Field Values

UPDATE_TRIGGER_GROUP_STATE_FROM_STATE

static final String UPDATE_TRIGGER_GROUP_STATE_FROM_STATE

See Also:

Constant Field Values

UPDATE_TRIGGER_STATE_FROM_STATES

static final String UPDATE_TRIGGER_STATE_FROM_STATES

See Also:

Constant Field Values

UPDATE_TRIGGER_GROUP_STATE_FROM_STATES

static final String UPDATE_TRIGGER_GROUP_STATE_FROM_STATES

See Also:

Constant Field Values

UPDATE_JOB_TRIGGER_STATES

static final String UPDATE_JOB_TRIGGER_STATES

See Also:

Constant Field Values

UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE

static final String UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE

See Also:

Constant Field Values

DELETE_SIMPLE_TRIGGER

static final String DELETE_SIMPLE_TRIGGER

See Also:

Constant Field Values

DELETE_CRON_TRIGGER

static final String DELETE_CRON_TRIGGER

See Also:

Constant Field Values

DELETE_BLOB_TRIGGER

static final String DELETE_BLOB_TRIGGER

See Also:

Constant Field Values

DELETE_TRIGGER

static final String DELETE_TRIGGER

See Also:

Constant Field Values

SELECT_NUM_TRIGGERS_FOR_JOB

static final String SELECT_NUM_TRIGGERS_FOR_JOB

See Also:

Constant Field Values

SELECT_JOB_FOR_TRIGGER

static final String SELECT_JOB_FOR_TRIGGER

See Also:

Constant Field Values

SELECT_TRIGGER

static final String SELECT_TRIGGER

See Also:

Constant Field Values

SELECT_TRIGGER_DATA

static final String SELECT_TRIGGER_DATA

See Also:

Constant Field Values

SELECT_TRIGGER_STATE

static final String SELECT_TRIGGER_STATE

See Also:

Constant Field Values

SELECT_TRIGGER_STATUS

static final String SELECT_TRIGGER_STATUS

See Also:

Constant Field Values

SELECT_SIMPLE_TRIGGER

static final String SELECT_SIMPLE_TRIGGER

See Also:

Constant Field Values

SELECT_CRON_TRIGGER

static final String SELECT_CRON_TRIGGER

See Also:

Constant Field Values

SELECT_BLOB_TRIGGER

static final String SELECT_BLOB_TRIGGER

See Also:

Constant Field Values

SELECT_NUM_TRIGGERS

static final String SELECT_NUM_TRIGGERS

See Also:

Constant Field Values

SELECT_NUM_TRIGGERS_IN_GROUP

static final String SELECT_NUM_TRIGGERS_IN_GROUP

See Also:

Constant Field Values

SELECT_TRIGGER_GROUPS

static final String SELECT_TRIGGER_GROUPS

See Also:

Constant Field Values

SELECT_TRIGGER_GROUPS_FILTERED

static final String SELECT_TRIGGER_GROUPS_FILTERED

See Also:

Constant Field Values

SELECT_TRIGGERS_IN_GROUP_LIKE

static final String SELECT_TRIGGERS_IN_GROUP_LIKE

See Also:

Constant Field Values

SELECT_TRIGGERS_IN_GROUP

static final String SELECT_TRIGGERS_IN_GROUP

See Also:

Constant Field Values

INSERT_CALENDAR

static final String INSERT_CALENDAR

See Also:

Constant Field Values

UPDATE_CALENDAR

static final String UPDATE_CALENDAR

See Also:

Constant Field Values

SELECT_CALENDAR_EXISTENCE

static final String SELECT_CALENDAR_EXISTENCE

See Also:

Constant Field Values

SELECT_CALENDAR

static final String SELECT_CALENDAR

See Also:

Constant Field Values

SELECT_REFERENCED_CALENDAR

static final String SELECT_REFERENCED_CALENDAR

See Also:

Constant Field Values

DELETE_CALENDAR

static final String DELETE_CALENDAR

See Also:

Constant Field Values

SELECT_NUM_CALENDARS

static final String SELECT_NUM_CALENDARS

See Also:

Constant Field Values

SELECT_CALENDARS

static final String SELECT_CALENDARS

See Also:

Constant Field Values

SELECT_NEXT_FIRE_TIME

static final String SELECT_NEXT_FIRE_TIME

See Also:

Constant Field Values

SELECT_TRIGGER_FOR_FIRE_TIME

static final String SELECT_TRIGGER_FOR_FIRE_TIME

See Also:

Constant Field Values

SELECT_NEXT_TRIGGER_TO_ACQUIRE

static final String SELECT_NEXT_TRIGGER_TO_ACQUIRE

See Also:

Constant Field Values

INSERT_FIRED_TRIGGER

static final String INSERT_FIRED_TRIGGER

See Also:

Constant Field Values

UPDATE_FIRED_TRIGGER

static final String UPDATE_FIRED_TRIGGER

See Also:

Constant Field Values

SELECT_INSTANCES_FIRED_TRIGGERS

static final String SELECT_INSTANCES_FIRED_TRIGGERS

See Also:

Constant Field Values

SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS

static final String SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS

See Also:

Constant Field Values

SELECT_JOB_EXECUTION_COUNT

static final String SELECT_JOB_EXECUTION_COUNT

See Also:

Constant Field Values

SELECT_FIRED_TRIGGERS

static final String SELECT_FIRED_TRIGGERS

See Also:

Constant Field Values

SELECT_FIRED_TRIGGER

static final String SELECT_FIRED_TRIGGER

See Also:

Constant Field Values

SELECT_FIRED_TRIGGER_GROUP

static final String SELECT_FIRED_TRIGGER_GROUP

See Also:

Constant Field Values

SELECT_FIRED_TRIGGERS_OF_JOB

static final String SELECT_FIRED_TRIGGERS_OF_JOB

See Also:

Constant Field Values

SELECT_FIRED_TRIGGERS_OF_JOB_GROUP

static final String SELECT_FIRED_TRIGGERS_OF_JOB_GROUP

See Also:

Constant Field Values

DELETE_FIRED_TRIGGER

static final String DELETE_FIRED_TRIGGER

See Also:

Constant Field Values

DELETE_INSTANCES_FIRED_TRIGGERS

static final String DELETE_INSTANCES_FIRED_TRIGGERS

See Also:

Constant Field Values

DELETE_NO_RECOVERY_FIRED_TRIGGERS

static final String DELETE_NO_RECOVERY_FIRED_TRIGGERS

See Also:

Constant Field Values

DELETE_ALL_SIMPLE_TRIGGERS

static final String DELETE_ALL_SIMPLE_TRIGGERS

See Also:

Constant Field Values

DELETE_ALL_SIMPROP_TRIGGERS

static final String DELETE_ALL_SIMPROP_TRIGGERS

See Also:

Constant Field Values

DELETE_ALL_CRON_TRIGGERS

static final String DELETE_ALL_CRON_TRIGGERS

See Also:

Constant Field Values

DELETE_ALL_BLOB_TRIGGERS

static final String DELETE_ALL_BLOB_TRIGGERS

See Also:

Constant Field Values

DELETE_ALL_TRIGGERS

static final String DELETE_ALL_TRIGGERS

See Also:

Constant Field Values

DELETE_ALL_JOB_DETAILS

static final String DELETE_ALL_JOB_DETAILS

See Also:

Constant Field Values

DELETE_ALL_CALENDARS

static final String DELETE_ALL_CALENDARS

See Also:

Constant Field Values

DELETE_ALL_PAUSED_TRIGGER_GRPS

static final String DELETE_ALL_PAUSED_TRIGGER_GRPS

See Also:

Constant Field Values

SELECT_FIRED_TRIGGER_INSTANCE_NAMES

static final String SELECT_FIRED_TRIGGER_INSTANCE_NAMES

See Also:

Constant Field Values

INSERT_SCHEDULER_STATE

static final String INSERT_SCHEDULER_STATE

See Also:

Constant Field Values

SELECT_SCHEDULER_STATE

static final String SELECT_SCHEDULER_STATE

See Also:

Constant Field Values

SELECT_SCHEDULER_STATES

static final String SELECT_SCHEDULER_STATES

See Also:

Constant Field Values

DELETE_SCHEDULER_STATE

static final String DELETE_SCHEDULER_STATE

See Also:

Constant Field Values

UPDATE_SCHEDULER_STATE

static final String UPDATE_SCHEDULER_STATE

See Also:

Constant Field Values

INSERT_PAUSED_TRIGGER_GROUP

static final String INSERT_PAUSED_TRIGGER_GROUP

See Also:

Constant Field Values

SELECT_PAUSED_TRIGGER_GROUP

static final String SELECT_PAUSED_TRIGGER_GROUP

See Also:

Constant Field Values

SELECT_PAUSED_TRIGGER_GROUPS

static final String SELECT_PAUSED_TRIGGER_GROUPS

See Also:

Constant Field Values

DELETE_PAUSED_TRIGGER_GROUP

static final String DELETE_PAUSED_TRIGGER_GROUP

See Also:

Constant Field Values

DELETE_PAUSED_TRIGGER_GROUPS

static final String DELETE_PAUSED_TRIGGER_GROUPS

See Also:

Constant Field Values