Constant Field Values

Contents

org.quartz.*

  • org.quartz.impl.jdbcjobstore.Constants 
    Modifier and Type Constant Field Value
    public static final java.lang.String ALIAS_COL_NEXT_FIRE_TIME "ALIAS_NXT_FR_TM"
    public static final java.lang.String ALL_GROUPS_PAUSED "_$_ALL_GROUPS_PAUSED_$_"
    public static final java.lang.String COL_BLOB "BLOB_DATA"
    public static final java.lang.String COL_CALENDAR "CALENDAR"
    public static final java.lang.String COL_CALENDAR_NAME "CALENDAR_NAME"
    public static final java.lang.String COL_CHECKIN_INTERVAL "CHECKIN_INTERVAL"
    public static final java.lang.String COL_CRON_EXPRESSION "CRON_EXPRESSION"
    public static final java.lang.String COL_DESCRIPTION "DESCRIPTION"
    public static final java.lang.String COL_END_TIME "END_TIME"
    public static final java.lang.String COL_ENTRY_ID "ENTRY_ID"
    public static final java.lang.String COL_ENTRY_STATE "STATE"
    public static final java.lang.String COL_FIRED_TIME "FIRED_TIME"
    public static final java.lang.String COL_INSTANCE_NAME "INSTANCE_NAME"
    public static final java.lang.String COL_IS_DURABLE "IS_DURABLE"
    public static final java.lang.String COL_IS_NONCONCURRENT "IS_NONCONCURRENT"
    public static final java.lang.String COL_IS_UPDATE_DATA "IS_UPDATE_DATA"
    public static final java.lang.String COL_IS_VOLATILE "IS_VOLATILE"
    public static final java.lang.String COL_JOB_CLASS "JOB_CLASS_NAME"
    public static final java.lang.String COL_JOB_DATAMAP "JOB_DATA"
    public static final java.lang.String COL_JOB_GROUP "JOB_GROUP"
    public static final java.lang.String COL_JOB_NAME "JOB_NAME"
    public static final java.lang.String COL_LAST_CHECKIN_TIME "LAST_CHECKIN_TIME"
    public static final java.lang.String COL_LOCK_NAME "LOCK_NAME"
    public static final java.lang.String COL_MISFIRE_INSTRUCTION "MISFIRE_INSTR"
    public static final java.lang.String COL_NEXT_FIRE_TIME "NEXT_FIRE_TIME"
    public static final java.lang.String COL_PREV_FIRE_TIME "PREV_FIRE_TIME"
    public static final java.lang.String COL_PRIORITY "PRIORITY"
    public static final java.lang.String COL_REPEAT_COUNT "REPEAT_COUNT"
    public static final java.lang.String COL_REPEAT_INTERVAL "REPEAT_INTERVAL"
    public static final java.lang.String COL_REQUESTS_RECOVERY "REQUESTS_RECOVERY"
    public static final java.lang.String COL_SCHED_TIME "SCHED_TIME"
    public static final java.lang.String COL_SCHEDULER_NAME "SCHED_NAME"
    public static final java.lang.String COL_START_TIME "START_TIME"
    public static final java.lang.String COL_TIME_ZONE_ID "TIME_ZONE_ID"
    public static final java.lang.String COL_TIMES_TRIGGERED "TIMES_TRIGGERED"
    public static final java.lang.String COL_TRIGGER_GROUP "TRIGGER_GROUP"
    public static final java.lang.String COL_TRIGGER_NAME "TRIGGER_NAME"
    public static final java.lang.String COL_TRIGGER_STATE "TRIGGER_STATE"
    public static final java.lang.String COL_TRIGGER_TYPE "TRIGGER_TYPE"
    public static final java.lang.String DEFAULT_TABLE_PREFIX "QRTZ_"
    public static final java.lang.String STATE_ACQUIRED "ACQUIRED"
    public static final java.lang.String STATE_BLOCKED "BLOCKED"
    public static final java.lang.String STATE_COMPLETE "COMPLETE"
    public static final java.lang.String STATE_DELETED "DELETED"
    public static final java.lang.String STATE_ERROR "ERROR"
    public static final java.lang.String STATE_EXECUTING "EXECUTING"
    public static final java.lang.String STATE_MISFIRED "MISFIRED"
    public static final java.lang.String STATE_PAUSED "PAUSED"
    public static final java.lang.String STATE_PAUSED_BLOCKED "PAUSED_BLOCKED"
    public static final java.lang.String STATE_WAITING "WAITING"
    public static final java.lang.String TABLE_BLOB_TRIGGERS "BLOB_TRIGGERS"
    public static final java.lang.String TABLE_CALENDARS "CALENDARS"
    public static final java.lang.String TABLE_CRON_TRIGGERS "CRON_TRIGGERS"
    public static final java.lang.String TABLE_FIRED_TRIGGERS "FIRED_TRIGGERS"
    public static final java.lang.String TABLE_JOB_DETAILS "JOB_DETAILS"
    public static final java.lang.String TABLE_LOCKS "LOCKS"
    public static final java.lang.String TABLE_PAUSED_TRIGGERS "PAUSED_TRIGGER_GRPS"
    public static final java.lang.String TABLE_SCHEDULER_STATE "SCHEDULER_STATE"
    public static final java.lang.String TABLE_SIMPLE_TRIGGERS "SIMPLE_TRIGGERS"
    public static final java.lang.String TABLE_TRIGGERS "TRIGGERS"
    public static final java.lang.String TTYPE_BLOB "BLOB"
    public static final java.lang.String TTYPE_CAL_INT "CAL_INT"
    public static final java.lang.String TTYPE_CRON "CRON"
    public static final java.lang.String TTYPE_DAILY_TIME_INT "DAILY_I"
    public static final java.lang.String TTYPE_SIMPLE "SIMPLE"
  • org.quartz.impl.jdbcjobstore.DB2v6Delegate 
    Modifier and Type Constant Field Value
    public static final java.lang.String SELECT_NUM_CALENDARS "SELECT COUNT(*) FROM {0}CALENDARS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_NUM_JOBS "SELECT COUNT(*) FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_NUM_TRIGGERS "SELECT COUNT(*) FROM {0}TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_NUM_TRIGGERS_FOR_JOB "SELECT COUNT(*) FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
  • org.quartz.impl.jdbcjobstore.JobStoreSupport 
    Modifier and Type Constant Field Value
    protected static final java.lang.String LOCK_STATE_ACCESS "STATE_ACCESS"
    protected static final java.lang.String LOCK_TRIGGER_ACCESS "TRIGGER_ACCESS"
  • org.quartz.impl.jdbcjobstore.JTANonClusteredSemaphore 
    Modifier and Type Constant Field Value
    public static final java.lang.String DEFAULT_TRANSACTION_MANANGER_LOCATION "java:TransactionManager"
  • org.quartz.impl.jdbcjobstore.SimplePropertiesTriggerPersistenceDelegateSupport 
    Modifier and Type Constant Field Value
    protected static final java.lang.String COL_BOOL_PROP_1 "BOOL_PROP_1"
    protected static final java.lang.String COL_BOOL_PROP_2 "BOOL_PROP_2"
    protected static final java.lang.String COL_DEC_PROP_1 "DEC_PROP_1"
    protected static final java.lang.String COL_DEC_PROP_2 "DEC_PROP_2"
    protected static final java.lang.String COL_INT_PROP_1 "INT_PROP_1"
    protected static final java.lang.String COL_INT_PROP_2 "INT_PROP_2"
    protected static final java.lang.String COL_LONG_PROP_1 "LONG_PROP_1"
    protected static final java.lang.String COL_LONG_PROP_2 "LONG_PROP_2"
    protected static final java.lang.String COL_STR_PROP_1 "STR_PROP_1"
    protected static final java.lang.String COL_STR_PROP_2 "STR_PROP_2"
    protected static final java.lang.String COL_STR_PROP_3 "STR_PROP_3"
    protected static final java.lang.String DELETE_SIMPLE_PROPS_TRIGGER "DELETE FROM {0}SIMPROP_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    protected static final java.lang.String INSERT_SIMPLE_PROPS_TRIGGER "INSERT INTO {0}SIMPROP_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, STR_PROP_1, STR_PROP_2, STR_PROP_3, INT_PROP_1, INT_PROP_2, LONG_PROP_1, LONG_PROP_2, DEC_PROP_1, DEC_PROP_2, BOOL_PROP_1, BOOL_PROP_2) VALUES({1}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    protected static final java.lang.String SELECT_SIMPLE_PROPS_TRIGGER "SELECT * FROM {0}SIMPROP_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    protected static final java.lang.String TABLE_SIMPLE_PROPERTIES_TRIGGERS "SIMPROP_TRIGGERS"
    protected static final java.lang.String UPDATE_SIMPLE_PROPS_TRIGGER "UPDATE {0}SIMPROP_TRIGGERS SET STR_PROP_1 = ?, STR_PROP_2 = ?, STR_PROP_3 = ?, INT_PROP_1 = ?, INT_PROP_2 = ?, LONG_PROP_1 = ?, LONG_PROP_2 = ?, DEC_PROP_1 = ?, DEC_PROP_2 = ?, BOOL_PROP_1 = ?, BOOL_PROP_2 = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
  • org.quartz.impl.jdbcjobstore.StdJDBCConstants 
    Modifier and Type Constant Field Value
    public static final java.lang.String COUNT_MISFIRED_TRIGGERS_IN_STATE "SELECT COUNT(TRIGGER_NAME) FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?"
    public static final java.lang.String DELETE_ALL_BLOB_TRIGGERS "DELETE FROM {0}BLOB_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_CALENDARS "DELETE FROM {0}CALENDARS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_CRON_TRIGGERS "DELETE FROM {0}CRON_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_JOB_DETAILS "DELETE FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_PAUSED_TRIGGER_GRPS "DELETE FROM {0}PAUSED_TRIGGER_GRPS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_SIMPLE_TRIGGERS "DELETE FROM {0}SIMPLE_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_SIMPROP_TRIGGERS "DELETE FROM {0}SIMPROP_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_ALL_TRIGGERS "DELETE FROM {0}TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_BLOB_TRIGGER "DELETE FROM {0}BLOB_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String DELETE_CALENDAR "DELETE FROM {0}CALENDARS WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String DELETE_CRON_TRIGGER "DELETE FROM {0}CRON_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String DELETE_FIRED_TRIGGER "DELETE FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND ENTRY_ID = ?"
    public static final java.lang.String DELETE_FIRED_TRIGGERS "DELETE FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_INSTANCES_FIRED_TRIGGERS "DELETE FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ?"
    public static final java.lang.String DELETE_JOB_DETAIL "DELETE FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String DELETE_NO_RECOVERY_FIRED_TRIGGERS "DELETE FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ?REQUESTS_RECOVERY = ?"
    public static final java.lang.String DELETE_PAUSED_TRIGGER_GROUP "DELETE FROM {0}PAUSED_TRIGGER_GRPS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP LIKE ?"
    public static final java.lang.String DELETE_PAUSED_TRIGGER_GROUPS "DELETE FROM {0}PAUSED_TRIGGER_GRPS WHERE SCHED_NAME = {1}"
    public static final java.lang.String DELETE_SCHEDULER_STATE "DELETE FROM {0}SCHEDULER_STATE WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ?"
    public static final java.lang.String DELETE_SIMPLE_TRIGGER "DELETE FROM {0}SIMPLE_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String DELETE_TRIGGER "DELETE FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String INSERT_BLOB_TRIGGER "INSERT INTO {0}BLOB_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, BLOB_DATA) VALUES({1}, ?, ?, ?)"
    public static final java.lang.String INSERT_CALENDAR "INSERT INTO {0}CALENDARS (SCHED_NAME, CALENDAR_NAME, CALENDAR) VALUES({1}, ?, ?)"
    public static final java.lang.String INSERT_CRON_TRIGGER "INSERT INTO {0}CRON_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, CRON_EXPRESSION, TIME_ZONE_ID) VALUES({1}, ?, ?, ?, ?)"
    public static final java.lang.String INSERT_FIRED_TRIGGER "INSERT INTO {0}FIRED_TRIGGERS (SCHED_NAME, ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, INSTANCE_NAME, FIRED_TIME, SCHED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_NONCONCURRENT, REQUESTS_RECOVERY, PRIORITY) VALUES({1}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    public static final java.lang.String INSERT_JOB_DETAIL "INSERT INTO {0}JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES({1}, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    public static final java.lang.String INSERT_PAUSED_TRIGGER_GROUP "INSERT INTO {0}PAUSED_TRIGGER_GRPS (SCHED_NAME, TRIGGER_GROUP) VALUES({1}, ?)"
    public static final java.lang.String INSERT_SCHEDULER_STATE "INSERT INTO {0}SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES({1}, ?, ?, ?)"
    public static final java.lang.String INSERT_SIMPLE_TRIGGER "INSERT INTO {0}SIMPLE_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, REPEAT_COUNT, REPEAT_INTERVAL, TIMES_TRIGGERED) VALUES({1}, ?, ?, ?, ?, ?)"
    public static final java.lang.String INSERT_TRIGGER "INSERT INTO {0}TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, JOB_NAME, JOB_GROUP, DESCRIPTION, NEXT_FIRE_TIME, PREV_FIRE_TIME, TRIGGER_STATE, TRIGGER_TYPE, START_TIME, END_TIME, CALENDAR_NAME, MISFIRE_INSTR, JOB_DATA, PRIORITY) VALUES({1}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    public static final java.lang.String SCHED_NAME_SUBST "{1}"
    public static final java.lang.String SELECT_BLOB_TRIGGER "SELECT * FROM {0}BLOB_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_CALENDAR "SELECT * FROM {0}CALENDARS WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String SELECT_CALENDAR_EXISTENCE "SELECT CALENDAR_NAME FROM {0}CALENDARS WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String SELECT_CALENDARS "SELECT CALENDAR_NAME FROM {0}CALENDARS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_CRON_TRIGGER "SELECT * FROM {0}CRON_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_FIRED_TRIGGER "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_FIRED_TRIGGER_GROUP "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_FIRED_TRIGGER_INSTANCE_NAMES "SELECT DISTINCT INSTANCE_NAME FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_FIRED_TRIGGERS "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_FIRED_TRIGGERS_OF_JOB "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_FIRED_TRIGGERS_OF_JOB_GROUP "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_HAS_MISFIRED_TRIGGERS_IN_STATE "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ? ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC"
    public static final java.lang.String SELECT_INSTANCES_FIRED_TRIGGERS "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ?"
    public static final java.lang.String SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS "SELECT * FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ? AND REQUESTS_RECOVERY = ?"
    public static final java.lang.String SELECT_JOB_DETAIL "SELECT * FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_JOB_EXECUTION_COUNT "SELECT COUNT(TRIGGER_NAME) FROM {0}FIRED_TRIGGERS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_JOB_EXISTENCE "SELECT JOB_NAME FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_JOB_FOR_TRIGGER "SELECT J.JOB_NAME, J.JOB_GROUP, J.IS_DURABLE, J.JOB_CLASS_NAME, J.REQUESTS_RECOVERY FROM {0}TRIGGERS T, {0}JOB_DETAILS J WHERE T.SCHED_NAME = {1} AND J.SCHED_NAME = {1} AND T.TRIGGER_NAME = ? AND T.TRIGGER_GROUP = ? AND T.JOB_NAME = J.JOB_NAME AND T.JOB_GROUP = J.JOB_GROUP"
    public static final java.lang.String SELECT_JOB_GROUPS "SELECT DISTINCT(JOB_GROUP) FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_JOB_NONCONCURRENT "SELECT IS_NONCONCURRENT FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_JOBS_IN_GROUP "SELECT JOB_NAME, JOB_GROUP FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_JOBS_IN_GROUP_LIKE "SELECT JOB_NAME, JOB_GROUP FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_GROUP LIKE ?"
    public static final java.lang.String SELECT_MISFIRED_TRIGGERS "SELECT * FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC"
    public static final java.lang.String SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE "SELECT TRIGGER_NAME FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_GROUP = ? AND TRIGGER_STATE = ? ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC"
    public static final java.lang.String SELECT_MISFIRED_TRIGGERS_IN_STATE "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ? ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC"
    public static final java.lang.String SELECT_NEXT_FIRE_TIME "SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_STATE = ? AND NEXT_FIRE_TIME >= 0"
    public static final java.lang.String SELECT_NEXT_TRIGGER_TO_ACQUIRE "SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_STATE = ? AND NEXT_FIRE_TIME <= ? AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR <> -1 AND NEXT_FIRE_TIME >= ?)) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC"
    public static final java.lang.String SELECT_NUM_CALENDARS "SELECT COUNT(CALENDAR_NAME) FROM {0}CALENDARS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_NUM_JOBS "SELECT COUNT(JOB_NAME) FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_NUM_TRIGGERS "SELECT COUNT(TRIGGER_NAME) FROM {0}TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_NUM_TRIGGERS_FOR_JOB "SELECT COUNT(TRIGGER_NAME) FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_NUM_TRIGGERS_IN_GROUP "SELECT COUNT(TRIGGER_NAME) FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_PAUSED_TRIGGER_GROUP "SELECT TRIGGER_GROUP FROM {0}PAUSED_TRIGGER_GRPS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_PAUSED_TRIGGER_GROUPS "SELECT TRIGGER_GROUP FROM {0}PAUSED_TRIGGER_GRPS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_REFERENCED_CALENDAR "SELECT CALENDAR_NAME FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String SELECT_SCHEDULER_STATE "SELECT * FROM {0}SCHEDULER_STATE WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ?"
    public static final java.lang.String SELECT_SCHEDULER_STATES "SELECT * FROM {0}SCHEDULER_STATE WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_SIMPLE_TRIGGER "SELECT * FROM {0}SIMPLE_TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGER "SELECT * FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGER_DATA "SELECT JOB_DATA FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGER_EXISTENCE "SELECT TRIGGER_NAME FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGER_FOR_FIRE_TIME "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_STATE = ? AND NEXT_FIRE_TIME = ?"
    public static final java.lang.String SELECT_TRIGGER_GROUPS "SELECT DISTINCT(TRIGGER_GROUP) FROM {0}TRIGGERS WHERE SCHED_NAME = {1}"
    public static final java.lang.String SELECT_TRIGGER_GROUPS_FILTERED "SELECT DISTINCT(TRIGGER_GROUP) FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP LIKE ?"
    public static final java.lang.String SELECT_TRIGGER_STATE "SELECT TRIGGER_STATE FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGER_STATUS "SELECT TRIGGER_STATE, NEXT_FIRE_TIME, JOB_NAME, JOB_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGERS_FOR_CALENDAR "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String SELECT_TRIGGERS_FOR_JOB "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGERS_IN_GROUP "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP = ?"
    public static final java.lang.String SELECT_TRIGGERS_IN_GROUP_LIKE "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_GROUP LIKE ?"
    public static final java.lang.String SELECT_TRIGGERS_IN_STATE "SELECT TRIGGER_NAME, TRIGGER_GROUP FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_STATE = ?"
    public static final java.lang.String TABLE_PREFIX_SUBST "{0}"
    public static final java.lang.String UPDATE_BLOB_TRIGGER "UPDATE {0}BLOB_TRIGGERS SET BLOB_DATA = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_CALENDAR "UPDATE {0}CALENDARS SET CALENDAR = ? WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String UPDATE_CRON_TRIGGER "UPDATE {0}CRON_TRIGGERS SET CRON_EXPRESSION = ?, TIME_ZONE_ID = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_FIRED_TRIGGER "UPDATE {0}FIRED_TRIGGERS SET INSTANCE_NAME = ?, FIRED_TIME = ?, SCHED_TIME = ?, STATE = ?, JOB_NAME = ?, JOB_GROUP = ?, IS_NONCONCURRENT = ?, REQUESTS_RECOVERY = ? WHERE SCHED_NAME = {1} AND ENTRY_ID = ?"
    public static final java.lang.String UPDATE_JOB_DATA "UPDATE {0}JOB_DETAILS SET JOB_DATA = ? WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String UPDATE_JOB_DETAIL "UPDATE {0}JOB_DETAILS SET DESCRIPTION = ?, JOB_CLASS_NAME = ?, IS_DURABLE = ?, IS_NONCONCURRENT = ?, IS_UPDATE_DATA = ?, REQUESTS_RECOVERY = ?, JOB_DATA = ? WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String UPDATE_JOB_TRIGGER_STATES "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ? AND TRIGGER_STATE = ?"
    public static final java.lang.String UPDATE_SCHEDULER_STATE "UPDATE {0}SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = {1} AND INSTANCE_NAME = ?"
    public static final java.lang.String UPDATE_SIMPLE_TRIGGER "UPDATE {0}SIMPLE_TRIGGERS SET REPEAT_COUNT = ?, REPEAT_INTERVAL = ?, TIMES_TRIGGERED = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_TRIGGER "UPDATE {0}TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ?, JOB_DATA = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_TRIGGER_GROUP_STATE_FROM_STATE "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND TRIGGER_GROUP LIKE ? AND TRIGGER_STATE = ?"
    public static final java.lang.String UPDATE_TRIGGER_GROUP_STATE_FROM_STATES "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND TRIGGER_GROUP LIKE ? AND (TRIGGER_STATE = ? OR TRIGGER_STATE = ? OR TRIGGER_STATE = ?)"
    public static final java.lang.String UPDATE_TRIGGER_SKIP_DATA "UPDATE {0}TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_TRIGGER_STATE "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_TRIGGER_STATE_FROM_STATE "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? AND TRIGGER_STATE = ?"
    public static final java.lang.String UPDATE_TRIGGER_STATE_FROM_STATES "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? AND (TRIGGER_STATE = ? OR TRIGGER_STATE = ? OR TRIGGER_STATE = ?)"
    public static final java.lang.String UPDATE_TRIGGER_STATES_FROM_OTHER_STATES "UPDATE {0}TRIGGERS SET TRIGGER_STATE = ? WHERE SCHED_NAME = {1} AND (TRIGGER_STATE = ? OR TRIGGER_STATE = ?)"
  • org.quartz.impl.jdbcjobstore.StdRowLockSemaphore 
    Modifier and Type Constant Field Value
    public static final java.lang.String INSERT_LOCK "INSERT INTO {0}LOCKS(SCHED_NAME, LOCK_NAME) VALUES ({1}, ?)"
    public static final java.lang.String SELECT_FOR_LOCK "SELECT * FROM {0}LOCKS WHERE SCHED_NAME = {1} AND LOCK_NAME = ? FOR UPDATE"
  • org.quartz.impl.jdbcjobstore.UpdateLockRowSemaphore 
    Modifier and Type Constant Field Value
    public static final java.lang.String INSERT_LOCK "INSERT INTO {0}LOCKS(SCHED_NAME, LOCK_NAME) VALUES ({1}, ?)"
    public static final java.lang.String UPDATE_FOR_LOCK "UPDATE {0}LOCKS SET LOCK_NAME = LOCK_NAME WHERE SCHED_NAME = {1} AND LOCK_NAME = ? "
  • org.quartz.impl.jdbcjobstore.oracle.OracleDelegate 
    Modifier and Type Constant Field Value
    public static final java.lang.String INSERT_ORACLE_CALENDAR "INSERT INTO {0}CALENDARS (SCHED_NAME, CALENDAR_NAME, CALENDAR) VALUES({1}, ?, EMPTY_BLOB())"
    public static final java.lang.String INSERT_ORACLE_JOB_DETAIL "INSERT INTO {0}JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES({1}, ?, ?, ?, ?, ?, ?, ?, ?, EMPTY_BLOB())"
    public static final java.lang.String SELECT_ORACLE_CALENDAR_BLOB "SELECT CALENDAR FROM {0}CALENDARS WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ? FOR UPDATE"
    public static final java.lang.String SELECT_ORACLE_JOB_DETAIL_BLOB "SELECT JOB_DATA FROM {0}JOB_DETAILS WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ? FOR UPDATE"
    public static final java.lang.String SELECT_ORACLE_TRIGGER_JOB_DETAIL_BLOB "SELECT JOB_DATA FROM {0}TRIGGERS WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? FOR UPDATE"
    public static final java.lang.String UPDATE_ORACLE_CALENDAR_BLOB "UPDATE {0}CALENDARS SET CALENDAR = ? WHERE SCHED_NAME = {1} AND CALENDAR_NAME = ?"
    public static final java.lang.String UPDATE_ORACLE_JOB_DETAIL "UPDATE {0}JOB_DETAILS SET DESCRIPTION = ?, JOB_CLASS_NAME = ?, IS_DURABLE = ?, IS_NONCONCURRENT = ?, IS_UPDATE_DATA = ?, REQUESTS_RECOVERY = ?, JOB_DATA = EMPTY_BLOB() WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String UPDATE_ORACLE_JOB_DETAIL_BLOB "UPDATE {0}JOB_DETAILS SET JOB_DATA = ? WHERE SCHED_NAME = {1} AND JOB_NAME = ? AND JOB_GROUP = ?"
    public static final java.lang.String UPDATE_ORACLE_TRIGGER "UPDATE {0}TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_ORACLE_TRIGGER_JOB_DETAIL_BLOB "UPDATE {0}TRIGGERS SET JOB_DATA = ? WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"
    public static final java.lang.String UPDATE_ORACLE_TRIGGER_JOB_DETAIL_EMPTY_BLOB "UPDATE {0}TRIGGERS SET JOB_DATA = EMPTY_BLOB() WHERE SCHED_NAME = {1} AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"