org.quartz.impl.jdbcjobstore
Interface StdJDBCConstants

All Superinterfaces:
Constants
All Known Implementing Classes:
StdJDBCDelegate, StdRowLockSemaphore

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 java.lang.String DELETE_BLOB_TRIGGER
           
static java.lang.String DELETE_CALENDAR
           
static java.lang.String DELETE_CRON_TRIGGER
           
static java.lang.String DELETE_FIRED_TRIGGER
           
static java.lang.String DELETE_FIRED_TRIGGERS
           
static java.lang.String DELETE_INSTANCES_FIRED_TRIGGERS
           
static java.lang.String DELETE_JOB_DETAIL
           
static java.lang.String DELETE_JOB_LISTENERS
           
static java.lang.String DELETE_NO_RECOVERY_FIRED_TRIGGERS
           
static java.lang.String DELETE_PAUSED_TRIGGER_GROUP
           
static java.lang.String DELETE_PAUSED_TRIGGER_GROUPS
           
static java.lang.String DELETE_SCHEDULER_STATE
           
static java.lang.String DELETE_SIMPLE_TRIGGER
           
static java.lang.String DELETE_TRIGGER
           
static java.lang.String DELETE_TRIGGER_LISTENERS
           
static java.lang.String DELETE_VOLATILE_FIRED_TRIGGERS
           
static java.lang.String INSERT_BLOB_TRIGGER
           
static java.lang.String INSERT_CALENDAR
           
static java.lang.String INSERT_CRON_TRIGGER
           
static java.lang.String INSERT_FIRED_TRIGGER
           
static java.lang.String INSERT_JOB_DETAIL
           
static java.lang.String INSERT_JOB_LISTENER
           
static java.lang.String INSERT_PAUSED_TRIGGER_GROUP
           
static java.lang.String INSERT_SCHEDULER_STATE
           
static java.lang.String INSERT_SIMPLE_TRIGGER
           
static java.lang.String INSERT_TRIGGER
           
static java.lang.String INSERT_TRIGGER_LISTENER
           
static java.lang.String SELECT_BLOB_TRIGGER
           
static java.lang.String SELECT_CALENDAR
           
static java.lang.String SELECT_CALENDAR_EXISTENCE
           
static java.lang.String SELECT_CALENDARS
           
static java.lang.String SELECT_CRON_TRIGGER
           
static java.lang.String SELECT_FIRED_TRIGGER
           
static java.lang.String SELECT_FIRED_TRIGGER_GROUP
           
static java.lang.String SELECT_FIRED_TRIGGERS
           
static java.lang.String SELECT_FIRED_TRIGGERS_OF_JOB
           
static java.lang.String SELECT_FIRED_TRIGGERS_OF_JOB_GROUP
           
static java.lang.String SELECT_INSTANCES_FIRED_TRIGGERS
           
static java.lang.String SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS
           
static java.lang.String SELECT_JOB_DETAIL
           
static java.lang.String SELECT_JOB_EXECUTION_COUNT
           
static java.lang.String SELECT_JOB_EXISTENCE
           
static java.lang.String SELECT_JOB_FOR_TRIGGER
           
static java.lang.String SELECT_JOB_GROUPS
           
static java.lang.String SELECT_JOB_LISTENERS
           
static java.lang.String SELECT_JOB_STATEFUL
           
static java.lang.String SELECT_JOBS_IN_GROUP
           
static java.lang.String SELECT_MISFIRED_TRIGGERS
           
static java.lang.String SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE
           
static java.lang.String SELECT_MISFIRED_TRIGGERS_IN_STATE
           
static java.lang.String SELECT_NEXT_FIRE_TIME
           
static java.lang.String SELECT_NUM_CALENDARS
           
static java.lang.String SELECT_NUM_JOBS
           
static java.lang.String SELECT_NUM_TRIGGERS
           
static java.lang.String SELECT_NUM_TRIGGERS_FOR_JOB
           
static java.lang.String SELECT_NUM_TRIGGERS_IN_GROUP
           
static java.lang.String SELECT_PAUSED_TRIGGER_GROUP
           
static java.lang.String SELECT_PAUSED_TRIGGER_GROUPS
           
static java.lang.String SELECT_REFERENCED_CALENDAR
           
static java.lang.String SELECT_SCHEDULER_STATE
           
static java.lang.String SELECT_SCHEDULER_STATES
           
static java.lang.String SELECT_SIMPLE_TRIGGER
           
static java.lang.String SELECT_STATEFUL_JOBS_OF_TRIGGER_GROUP
           
static java.lang.String SELECT_TRIGGER
           
static java.lang.String SELECT_TRIGGER_EXISTENCE
           
static java.lang.String SELECT_TRIGGER_FOR_FIRE_TIME
           
static java.lang.String SELECT_TRIGGER_GROUPS
           
static java.lang.String SELECT_TRIGGER_LISTENERS
           
static java.lang.String SELECT_TRIGGER_STATE
           
static java.lang.String SELECT_TRIGGER_STATUS
           
static java.lang.String SELECT_TRIGGERS_FOR_CALENDAR
           
static java.lang.String SELECT_TRIGGERS_FOR_JOB
           
static java.lang.String SELECT_TRIGGERS_IN_GROUP
           
static java.lang.String SELECT_TRIGGERS_IN_STATE
           
static java.lang.String SELECT_VOLATILE_JOBS
           
static java.lang.String SELECT_VOLATILE_TRIGGERS
           
static java.lang.String TABLE_PREFIX_SUBST
           
static java.lang.String UPDATE_BLOB_TRIGGER
           
static java.lang.String UPDATE_CALENDAR
           
static java.lang.String UPDATE_CRON_TRIGGER
           
static java.lang.String UPDATE_INSTANCES_FIRED_TRIGGER_STATE
           
static java.lang.String UPDATE_JOB_DATA
           
static java.lang.String UPDATE_JOB_DETAIL
           
static java.lang.String UPDATE_JOB_TRIGGER_STATES
           
static java.lang.String UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE
           
static java.lang.String UPDATE_SIMPLE_TRIGGER
           
static java.lang.String UPDATE_TRIGGER
           
static java.lang.String UPDATE_TRIGGER_GROUP_STATE
           
static java.lang.String UPDATE_TRIGGER_GROUP_STATE_FROM_STATE
           
static java.lang.String UPDATE_TRIGGER_GROUP_STATE_FROM_STATES
           
static java.lang.String UPDATE_TRIGGER_STATE
           
static java.lang.String UPDATE_TRIGGER_STATE_FROM_OTHER_STATES_BEFORE_TIME
           
static java.lang.String UPDATE_TRIGGER_STATE_FROM_STATE
           
static java.lang.String UPDATE_TRIGGER_STATE_FROM_STATES
           
static java.lang.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_STATEFUL, COL_IS_VOLATILE, COL_JOB_CLASS, COL_JOB_DATAMAP, COL_JOB_GROUP, COL_JOB_LISTENER, COL_JOB_NAME, COL_LAST_CHECKIN_TIME, COL_LOCK_NAME, COL_MISFIRE_INSTRUCTION, COL_NEXT_FIRE_TIME, COL_PREV_FIRE_TIME, COL_RECOVERER, COL_REPEAT_COUNT, COL_REPEAT_INTERVAL, COL_REQUESTS_RECOVERY, COL_START_TIME, COL_TIME_ZONE_ID, COL_TIMES_TRIGGERED, COL_TRIGGER_GROUP, COL_TRIGGER_LISTENER, 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_WAITING, TABLE_BLOB_TRIGGERS, TABLE_CALENDARS, TABLE_CRON_TRIGGERS, TABLE_FIRED_TRIGGERS, TABLE_JOB_DETAILS, TABLE_JOB_LISTENERS, TABLE_LOCKS, TABLE_PAUSED_TRIGGERS, TABLE_SCHEDULER_STATE, TABLE_SIMPLE_TRIGGERS, TABLE_TRIGGER_LISTENERS, TABLE_TRIGGERS, TTYPE_BLOB, TTYPE_CRON, TTYPE_SIMPLE
 

Field Detail

TABLE_PREFIX_SUBST

public static final java.lang.String TABLE_PREFIX_SUBST

UPDATE_TRIGGER_STATES_FROM_OTHER_STATES

public static final java.lang.String UPDATE_TRIGGER_STATES_FROM_OTHER_STATES

UPDATE_TRIGGER_STATE_FROM_OTHER_STATES_BEFORE_TIME

public static final java.lang.String UPDATE_TRIGGER_STATE_FROM_OTHER_STATES_BEFORE_TIME

SELECT_MISFIRED_TRIGGERS

public static final java.lang.String SELECT_MISFIRED_TRIGGERS

SELECT_TRIGGERS_IN_STATE

public static final java.lang.String SELECT_TRIGGERS_IN_STATE

SELECT_MISFIRED_TRIGGERS_IN_STATE

public static final java.lang.String SELECT_MISFIRED_TRIGGERS_IN_STATE

SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE

public static final java.lang.String SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE

SELECT_VOLATILE_TRIGGERS

public static final java.lang.String SELECT_VOLATILE_TRIGGERS

DELETE_FIRED_TRIGGERS

public static final java.lang.String DELETE_FIRED_TRIGGERS

INSERT_JOB_DETAIL

public static final java.lang.String INSERT_JOB_DETAIL

UPDATE_JOB_DETAIL

public static final java.lang.String UPDATE_JOB_DETAIL

SELECT_TRIGGERS_FOR_JOB

public static final java.lang.String SELECT_TRIGGERS_FOR_JOB

SELECT_TRIGGERS_FOR_CALENDAR

public static final java.lang.String SELECT_TRIGGERS_FOR_CALENDAR

SELECT_STATEFUL_JOBS_OF_TRIGGER_GROUP

public static final java.lang.String SELECT_STATEFUL_JOBS_OF_TRIGGER_GROUP

DELETE_JOB_LISTENERS

public static final java.lang.String DELETE_JOB_LISTENERS

DELETE_JOB_DETAIL

public static final java.lang.String DELETE_JOB_DETAIL

SELECT_JOB_STATEFUL

public static final java.lang.String SELECT_JOB_STATEFUL

SELECT_JOB_EXISTENCE

public static final java.lang.String SELECT_JOB_EXISTENCE

UPDATE_JOB_DATA

public static final java.lang.String UPDATE_JOB_DATA

INSERT_JOB_LISTENER

public static final java.lang.String INSERT_JOB_LISTENER

SELECT_JOB_LISTENERS

public static final java.lang.String SELECT_JOB_LISTENERS

SELECT_JOB_DETAIL

public static final java.lang.String SELECT_JOB_DETAIL

SELECT_NUM_JOBS

public static final java.lang.String SELECT_NUM_JOBS

SELECT_JOB_GROUPS

public static final java.lang.String SELECT_JOB_GROUPS

SELECT_JOBS_IN_GROUP

public static final java.lang.String SELECT_JOBS_IN_GROUP

SELECT_VOLATILE_JOBS

public static final java.lang.String SELECT_VOLATILE_JOBS

INSERT_TRIGGER

public static final java.lang.String INSERT_TRIGGER

INSERT_SIMPLE_TRIGGER

public static final java.lang.String INSERT_SIMPLE_TRIGGER

INSERT_CRON_TRIGGER

public static final java.lang.String INSERT_CRON_TRIGGER

INSERT_BLOB_TRIGGER

public static final java.lang.String INSERT_BLOB_TRIGGER

UPDATE_TRIGGER

public static final java.lang.String UPDATE_TRIGGER

UPDATE_SIMPLE_TRIGGER

public static final java.lang.String UPDATE_SIMPLE_TRIGGER

UPDATE_CRON_TRIGGER

public static final java.lang.String UPDATE_CRON_TRIGGER

UPDATE_BLOB_TRIGGER

public static final java.lang.String UPDATE_BLOB_TRIGGER

SELECT_TRIGGER_EXISTENCE

public static final java.lang.String SELECT_TRIGGER_EXISTENCE

UPDATE_TRIGGER_STATE

public static final java.lang.String UPDATE_TRIGGER_STATE

UPDATE_TRIGGER_STATE_FROM_STATE

public static final java.lang.String UPDATE_TRIGGER_STATE_FROM_STATE

UPDATE_TRIGGER_GROUP_STATE

public static final java.lang.String UPDATE_TRIGGER_GROUP_STATE

UPDATE_TRIGGER_GROUP_STATE_FROM_STATE

public static final java.lang.String UPDATE_TRIGGER_GROUP_STATE_FROM_STATE

UPDATE_TRIGGER_STATE_FROM_STATES

public static final java.lang.String UPDATE_TRIGGER_STATE_FROM_STATES

UPDATE_TRIGGER_GROUP_STATE_FROM_STATES

public static final java.lang.String UPDATE_TRIGGER_GROUP_STATE_FROM_STATES

UPDATE_JOB_TRIGGER_STATES

public static final java.lang.String UPDATE_JOB_TRIGGER_STATES

UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE

public static final java.lang.String UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE

DELETE_TRIGGER_LISTENERS

public static final java.lang.String DELETE_TRIGGER_LISTENERS

INSERT_TRIGGER_LISTENER

public static final java.lang.String INSERT_TRIGGER_LISTENER

SELECT_TRIGGER_LISTENERS

public static final java.lang.String SELECT_TRIGGER_LISTENERS

DELETE_SIMPLE_TRIGGER

public static final java.lang.String DELETE_SIMPLE_TRIGGER

DELETE_CRON_TRIGGER

public static final java.lang.String DELETE_CRON_TRIGGER

DELETE_BLOB_TRIGGER

public static final java.lang.String DELETE_BLOB_TRIGGER

DELETE_TRIGGER

public static final java.lang.String DELETE_TRIGGER

SELECT_NUM_TRIGGERS_FOR_JOB

public static final java.lang.String SELECT_NUM_TRIGGERS_FOR_JOB

SELECT_JOB_FOR_TRIGGER

public static final java.lang.String SELECT_JOB_FOR_TRIGGER

SELECT_TRIGGER

public static final java.lang.String SELECT_TRIGGER

SELECT_TRIGGER_STATE

public static final java.lang.String SELECT_TRIGGER_STATE

SELECT_TRIGGER_STATUS

public static final java.lang.String SELECT_TRIGGER_STATUS

SELECT_SIMPLE_TRIGGER

public static final java.lang.String SELECT_SIMPLE_TRIGGER

SELECT_CRON_TRIGGER

public static final java.lang.String SELECT_CRON_TRIGGER

SELECT_BLOB_TRIGGER

public static final java.lang.String SELECT_BLOB_TRIGGER

SELECT_NUM_TRIGGERS

public static final java.lang.String SELECT_NUM_TRIGGERS

SELECT_NUM_TRIGGERS_IN_GROUP

public static final java.lang.String SELECT_NUM_TRIGGERS_IN_GROUP

SELECT_TRIGGER_GROUPS

public static final java.lang.String SELECT_TRIGGER_GROUPS

SELECT_TRIGGERS_IN_GROUP

public static final java.lang.String SELECT_TRIGGERS_IN_GROUP

INSERT_CALENDAR

public static final java.lang.String INSERT_CALENDAR

UPDATE_CALENDAR

public static final java.lang.String UPDATE_CALENDAR

SELECT_CALENDAR_EXISTENCE

public static final java.lang.String SELECT_CALENDAR_EXISTENCE

SELECT_CALENDAR

public static final java.lang.String SELECT_CALENDAR

SELECT_REFERENCED_CALENDAR

public static final java.lang.String SELECT_REFERENCED_CALENDAR

DELETE_CALENDAR

public static final java.lang.String DELETE_CALENDAR

SELECT_NUM_CALENDARS

public static final java.lang.String SELECT_NUM_CALENDARS

SELECT_CALENDARS

public static final java.lang.String SELECT_CALENDARS

SELECT_NEXT_FIRE_TIME

public static final java.lang.String SELECT_NEXT_FIRE_TIME

SELECT_TRIGGER_FOR_FIRE_TIME

public static final java.lang.String SELECT_TRIGGER_FOR_FIRE_TIME

INSERT_FIRED_TRIGGER

public static final java.lang.String INSERT_FIRED_TRIGGER

UPDATE_INSTANCES_FIRED_TRIGGER_STATE

public static final java.lang.String UPDATE_INSTANCES_FIRED_TRIGGER_STATE

SELECT_INSTANCES_FIRED_TRIGGERS

public static final java.lang.String SELECT_INSTANCES_FIRED_TRIGGERS

SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS

public static final java.lang.String SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS

SELECT_JOB_EXECUTION_COUNT

public static final java.lang.String SELECT_JOB_EXECUTION_COUNT

SELECT_FIRED_TRIGGERS

public static final java.lang.String SELECT_FIRED_TRIGGERS

SELECT_FIRED_TRIGGER

public static final java.lang.String SELECT_FIRED_TRIGGER

SELECT_FIRED_TRIGGER_GROUP

public static final java.lang.String SELECT_FIRED_TRIGGER_GROUP

SELECT_FIRED_TRIGGERS_OF_JOB

public static final java.lang.String SELECT_FIRED_TRIGGERS_OF_JOB

SELECT_FIRED_TRIGGERS_OF_JOB_GROUP

public static final java.lang.String SELECT_FIRED_TRIGGERS_OF_JOB_GROUP

DELETE_FIRED_TRIGGER

public static final java.lang.String DELETE_FIRED_TRIGGER

DELETE_INSTANCES_FIRED_TRIGGERS

public static final java.lang.String DELETE_INSTANCES_FIRED_TRIGGERS

DELETE_VOLATILE_FIRED_TRIGGERS

public static final java.lang.String DELETE_VOLATILE_FIRED_TRIGGERS

DELETE_NO_RECOVERY_FIRED_TRIGGERS

public static final java.lang.String DELETE_NO_RECOVERY_FIRED_TRIGGERS

INSERT_SCHEDULER_STATE

public static final java.lang.String INSERT_SCHEDULER_STATE

SELECT_SCHEDULER_STATE

public static final java.lang.String SELECT_SCHEDULER_STATE

SELECT_SCHEDULER_STATES

public static final java.lang.String SELECT_SCHEDULER_STATES

DELETE_SCHEDULER_STATE

public static final java.lang.String DELETE_SCHEDULER_STATE

INSERT_PAUSED_TRIGGER_GROUP

public static final java.lang.String INSERT_PAUSED_TRIGGER_GROUP

SELECT_PAUSED_TRIGGER_GROUP

public static final java.lang.String SELECT_PAUSED_TRIGGER_GROUP

SELECT_PAUSED_TRIGGER_GROUPS

public static final java.lang.String SELECT_PAUSED_TRIGGER_GROUPS

DELETE_PAUSED_TRIGGER_GROUP

public static final java.lang.String DELETE_PAUSED_TRIGGER_GROUP

DELETE_PAUSED_TRIGGER_GROUPS

public static final java.lang.String DELETE_PAUSED_TRIGGER_GROUPS

Quartz Project Page