public interface DriverDelegate
This is the base interface for all driver delegate classes.
This interface is very similar to the
interface except each method has an additional JobStore
parameter.
Connection
Unless a database driver has some extremely-DB-specific
requirements, any DriverDelegate implementation classes should extend the
class.
StdJDBCDelegate
| Modifier and Type | Method and Description |
|---|---|
boolean |
calendarExists(Connection conn,
String calendarName)
Check whether or not a calendar exists.
|
boolean |
calendarIsReferenced(Connection conn,
String calendarName)
Check whether or not a calendar is referenced by any triggers.
|
int |
countMisfiredTriggersInStates(Connection conn,
String state1,
String state2,
long ts)
Get the number of triggers in the given states that have
misfired - according to the given timestamp.
|
int |
deleteAllPausedTriggerGroups(Connection conn) |
int |
deleteBlobTrigger(Connection conn,
String triggerName,
String groupName)
Delete the BLOB trigger data for a trigger.
|
int |
deleteCalendar(Connection conn,
String calendarName)
Delete a calendar.
|
int |
deleteCronTrigger(Connection conn,
String triggerName,
String groupName)
Delete the cron trigger data for a trigger.
|
int |
deleteFiredTrigger(Connection conn,
String entryId)
Delete a fired trigger.
|
int |
deleteFiredTriggers(Connection conn)
Delete all fired triggers.
|
int |
deleteFiredTriggers(Connection conn,
String instanceId)
Delete all fired triggers of the given instance.
|
int |
deleteJobDetail(Connection conn,
String jobName,
String groupName)
Delete the job detail record for the given job.
|
int |
deleteJobListeners(Connection conn,
String jobName,
String groupName)
Delete all job listeners for the given job.
|
int |
deletePausedTriggerGroup(Connection conn,
String groupName) |
int |
deleteSchedulerState(Connection conn,
String instanceId)
Delete a scheduler-instance state record.
|
int |
deleteSimpleTrigger(Connection conn,
String triggerName,
String groupName)
Delete the simple trigger data for a trigger.
|
int |
deleteTrigger(Connection conn,
String triggerName,
String groupName)
Delete the base trigger data for a trigger.
|
int |
deleteTriggerListeners(Connection conn,
String triggerName,
String groupName)
Delete all of the listeners associated with a given trigger.
|
int |
deleteVolatileFiredTriggers(Connection conn)
Delete all volatile fired triggers.
|
int |
insertBlobTrigger(Connection conn,
Trigger trigger)
Insert the blob trigger data.
|
int |
insertCalendar(Connection conn,
String calendarName,
Calendar calendar)
Insert a new calendar.
|
int |
insertCronTrigger(Connection conn,
CronTrigger trigger)
Insert the cron trigger data.
|
int |
insertFiredTrigger(Connection conn,
Trigger trigger,
String state,
JobDetail jobDetail)
Insert a fired trigger.
|
int |
insertJobDetail(Connection conn,
JobDetail job)
Insert the job detail record.
|
int |
insertJobListener(Connection conn,
JobDetail job,
String listener)
Associate a listener with a job.
|
int |
insertPausedTriggerGroup(Connection conn,
String groupName) |
int |
insertSchedulerState(Connection conn,
String instanceId,
long checkInTime,
long interval)
Insert a scheduler-instance state record.
|
int |
insertSimpleTrigger(Connection conn,
SimpleTrigger trigger)
Insert the simple trigger data.
|
int |
insertTrigger(Connection conn,
Trigger trigger,
String state,
JobDetail jobDetail)
Insert the base trigger data.
|
int |
insertTriggerListener(Connection conn,
Trigger trigger,
String listener)
Associate a listener with the given trigger.
|
boolean |
isExistingTriggerGroup(Connection conn,
String groupName) |
boolean |
isJobStateful(Connection conn,
String jobName,
String groupName)
Check whether or not the given job is stateful.
|
boolean |
isTriggerGroupPaused(Connection conn,
String groupName) |
boolean |
jobExists(Connection conn,
String jobName,
String groupName)
Check whether or not the given job exists.
|
Calendar |
selectCalendar(Connection conn,
String calendarName)
Select a calendar.
|
String[] |
selectCalendars(Connection conn)
Select all of the stored calendars.
|
Set |
selectFiredTriggerInstanceNames(Connection conn)
Select the distinct instance names of all fired-trigger records.
|
List |
selectFiredTriggerRecords(Connection conn,
String triggerName,
String groupName)
Select the states of all fired-trigger records for a given trigger, or
trigger group if trigger name is
null. |
List |
selectFiredTriggerRecordsByJob(Connection conn,
String jobName,
String groupName)
Select the states of all fired-trigger records for a given job, or job
group if job name is
null. |
List |
selectInstancesFiredTriggerRecords(Connection conn,
String instanceName)
Select the states of all fired-trigger records for a given scheduler
instance.
|
JobDetail |
selectJobDetail(Connection conn,
String jobName,
String groupName,
ClassLoadHelper loadHelper)
Select the JobDetail object for a given job name / group name.
|
int |
selectJobExecutionCount(Connection conn,
String jobName,
String jobGroup)
Get the number instances of the identified job currently executing.
|
JobDetail |
selectJobForTrigger(Connection conn,
String triggerName,
String groupName,
ClassLoadHelper loadHelper)
Select the job to which the trigger is associated.
|
String[] |
selectJobGroups(Connection conn)
Select all of the job group names that are stored.
|
String[] |
selectJobListeners(Connection conn,
String jobName,
String groupName)
Get all of the listeners for a given job.
|
String[] |
selectJobsInGroup(Connection conn,
String groupName)
Select all of the jobs contained in a given group.
|
Key[] |
selectMisfiredTriggers(Connection conn,
long ts)
Get the names of all of the triggers that have misfired - according to
the given timestamp.
|
Key[] |
selectMisfiredTriggersInGroupInState(Connection conn,
String groupName,
String state,
long ts)
Get the names of all of the triggers in the given group and state that
have misfired - according to the given timestamp.
|
Key[] |
selectMisfiredTriggersInState(Connection conn,
String state,
long ts)
Get the names of all of the triggers in the given state that have
misfired - according to the given timestamp.
|
boolean |
selectMisfiredTriggersInStates(Connection conn,
String state1,
String state2,
long ts,
int count,
List resultList)
Get the names of all of the triggers in the given states that have
misfired - according to the given timestamp.
|
long |
selectNextFireTime(Connection conn)
Deprecated.
Does not account for misfires.
|
int |
selectNumCalendars(Connection conn)
Select the total number of calendars stored.
|
int |
selectNumJobs(Connection conn)
Select the total number of jobs stored.
|
int |
selectNumTriggers(Connection conn)
Select the total number of triggers stored.
|
int |
selectNumTriggersForJob(Connection conn,
String jobName,
String groupName)
Select the number of triggers associated with a given job.
|
Set |
selectPausedTriggerGroups(Connection conn) |
List |
selectSchedulerStateRecords(Connection conn,
String instanceId)
A List of all current
SchedulerStateRecords. |
List |
selectStatefulJobsOfTriggerGroup(Connection conn,
String groupName)
Select the stateful jobs which are referenced by triggers in the given
trigger group.
|
Trigger |
selectTrigger(Connection conn,
String triggerName,
String groupName)
Select a trigger.
|
Key |
selectTriggerForFireTime(Connection conn,
long fireTime)
Select the trigger that will be fired at the given fire time.
|
String[] |
selectTriggerGroups(Connection conn)
Select all of the trigger group names that are stored.
|
JobDataMap |
selectTriggerJobDataMap(Connection conn,
String triggerName,
String groupName)
Select a trigger's JobDataMap.
|
String[] |
selectTriggerListeners(Connection conn,
String triggerName,
String groupName)
Select the listeners associated with a given trigger.
|
Key[] |
selectTriggerNamesForJob(Connection conn,
String jobName,
String groupName)
Get the names of all of the triggers associated with the given job.
|
Trigger[] |
selectTriggersForCalendar(Connection conn,
String calName)
Select the triggers for a calendar
|
Trigger[] |
selectTriggersForJob(Connection conn,
String jobName,
String groupName)
Select the triggers for a job
|
Trigger[] |
selectTriggersForRecoveringJobs(Connection conn)
Select all of the triggers for jobs that are requesting recovery.
|
String[] |
selectTriggersInGroup(Connection conn,
String groupName)
Select all of the triggers contained in a given group.
|
Key[] |
selectTriggersInState(Connection conn,
String state)
Select all of the triggers in a given state.
|
String |
selectTriggerState(Connection conn,
String triggerName,
String groupName)
Select a trigger' state value.
|
TriggerStatus |
selectTriggerStatus(Connection conn,
String triggerName,
String groupName)
Select a trigger' status (state & next fire time).
|
List |
selectTriggerToAcquire(Connection conn,
long noLaterThan,
long noEarlierThan)
Select the next trigger which will fire to fire between the two given timestamps
in ascending order of fire time, and then descending by priority.
|
Key[] |
selectVolatileJobs(Connection conn)
Get the names of all of the jobs that are volatile.
|
Key[] |
selectVolatileTriggers(Connection conn)
Get the names of all of the triggers that are volatile.
|
boolean |
triggerExists(Connection conn,
String triggerName,
String groupName)
Check whether or not a trigger exists.
|
int |
updateBlobTrigger(Connection conn,
Trigger trigger)
Update the blob trigger data.
|
int |
updateCalendar(Connection conn,
String calendarName,
Calendar calendar)
Update a calendar.
|
int |
updateCronTrigger(Connection conn,
CronTrigger trigger)
Update the cron trigger data.
|
int |
updateJobData(Connection conn,
JobDetail job)
Update the job data map for the given job.
|
int |
updateJobDetail(Connection conn,
JobDetail job)
Update the job detail record.
|
int |
updateSchedulerState(Connection conn,
String instanceId,
long checkInTime)
Update a scheduler-instance state record.
|
int |
updateSimpleTrigger(Connection conn,
SimpleTrigger trigger)
Update the simple trigger data.
|
int |
updateTrigger(Connection conn,
Trigger trigger,
String state,
JobDetail jobDetail)
Update the base trigger data.
|
int |
updateTriggerGroupStateFromOtherState(Connection conn,
String groupName,
String newState,
String oldState)
Update all of the triggers of the given group to the given new state, if
they are in the given old state.
|
int |
updateTriggerGroupStateFromOtherStates(Connection conn,
String groupName,
String newState,
String oldState1,
String oldState2,
String oldState3)
Update all triggers in the given group to the given new state, if they
are in one of the given old states.
|
int |
updateTriggerState(Connection conn,
String triggerName,
String groupName,
String state)
Update the state for a given trigger.
|
int |
updateTriggerStateFromOtherState(Connection conn,
String triggerName,
String groupName,
String newState,
String oldState)
Update the given trigger to the given new state, if it is in the given
old state.
|
int |
updateTriggerStateFromOtherStates(Connection conn,
String triggerName,
String groupName,
String newState,
String oldState1,
String oldState2,
String oldState3)
Update the given trigger to the given new state, if it is one of the
given old states.
|
int |
updateTriggerStateFromOtherStatesBeforeTime(Connection conn,
String newState,
String oldState1,
String oldState2,
long time)
Update the all triggers to the given new state, if they are in one of
the given old states AND its next fire time is before the given time.
|
int |
updateTriggerStatesForJob(Connection conn,
String jobName,
String groupName,
String state)
Update the states of all triggers associated with the given job.
|
int |
updateTriggerStatesForJobFromOtherState(Connection conn,
String jobName,
String groupName,
String state,
String oldState)
Update the states of any triggers associated with the given job, that
are the given current state.
|
int |
updateTriggerStatesFromOtherStates(Connection conn,
String newState,
String oldState1,
String oldState2)
Update all triggers having one of the two given states, to the given new
state.
|
int updateTriggerStatesFromOtherStates(Connection conn, String newState, String oldState1, String oldState2) throws SQLException
Update all triggers having one of the two given states, to the given new state.
conn - the DB ConnectionnewState - the new state for the triggersoldState1 - the first old state to updateoldState2 - the second old state to updateSQLExceptionKey[] selectMisfiredTriggers(Connection conn, long ts) throws SQLException
Get the names of all of the triggers that have misfired - according to the given timestamp.
conn - the DB ConnectionKey objectsSQLExceptionKey[] selectMisfiredTriggersInState(Connection conn, String state, long ts) throws SQLException
Get the names of all of the triggers in the given state that have misfired - according to the given timestamp.
conn - the DB ConnectionKey objectsSQLExceptionboolean selectMisfiredTriggersInStates(Connection conn, String state1, String state2, long ts, int count, List resultList) throws SQLException
Get the names of all of the triggers in the given states that have misfired - according to the given timestamp. No more than count will be returned.
conn - the DB Connectioncount - the most misfired triggers to return, negative for allresultList - Output parameter. A List of
Key objects. Must not be null.SQLExceptionint countMisfiredTriggersInStates(Connection conn, String state1, String state2, long ts) throws SQLException
Get the number of triggers in the given states that have misfired - according to the given timestamp.
conn - the DB ConnectionSQLExceptionKey[] selectMisfiredTriggersInGroupInState(Connection conn, String groupName, String state, long ts) throws SQLException
Get the names of all of the triggers in the given group and state that have misfired - according to the given timestamp.
conn - the DB ConnectionKey objectsSQLExceptionTrigger[] selectTriggersForRecoveringJobs(Connection conn) throws SQLException, IOException, ClassNotFoundException
Select all of the triggers for jobs that are requesting recovery. The
returned trigger objects will have unique "recoverXXX" trigger names and
will be in the
trigger group.
Scheduler.DEFAULT_RECOVERY_GROUP
In order to preserve the ordering of the triggers, the fire time will be
set from the COL_FIRED_TIME column in the TABLE_FIRED_TRIGGERS
table. The caller is responsible for calling computeFirstFireTime
on each returned trigger. It is also up to the caller to insert the
returned triggers to ensure that they are fired.
conn - the DB ConnectionTrigger objectsSQLExceptionIOExceptionClassNotFoundExceptionint deleteFiredTriggers(Connection conn) throws SQLException
Delete all fired triggers.
conn - the DB ConnectionSQLExceptionint deleteFiredTriggers(Connection conn, String instanceId) throws SQLException
Delete all fired triggers of the given instance.
conn - the DB ConnectionSQLExceptionint deleteVolatileFiredTriggers(Connection conn) throws SQLException
Delete all volatile fired triggers.
conn - the DB ConnectionSQLExceptionKey[] selectVolatileTriggers(Connection conn) throws SQLException
Get the names of all of the triggers that are volatile.
conn - the DB ConnectionKey objectsSQLExceptionKey[] selectVolatileJobs(Connection conn) throws SQLException
Get the names of all of the jobs that are volatile.
conn - the DB ConnectionKey objectsSQLExceptionint insertJobDetail(Connection conn, JobDetail job) throws IOException, SQLException
Insert the job detail record.
conn - the DB Connectionjob - the job to insertIOException - if there were problems serializing the JobDataMapSQLExceptionint updateJobDetail(Connection conn, JobDetail job) throws IOException, SQLException
Update the job detail record.
conn - the DB Connectionjob - the job to updateIOException - if there were problems serializing the JobDataMapSQLExceptionKey[] selectTriggerNamesForJob(Connection conn, String jobName, String groupName) throws SQLException
Get the names of all of the triggers associated with the given job.
conn - the DB ConnectionjobName - the job namegroupName - the job groupKey objectsSQLExceptionint deleteJobListeners(Connection conn, String jobName, String groupName) throws SQLException
Delete all job listeners for the given job.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionint deleteJobDetail(Connection conn, String jobName, String groupName) throws SQLException
Delete the job detail record for the given job.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionboolean isJobStateful(Connection conn, String jobName, String groupName) throws SQLException
Check whether or not the given job is stateful.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionboolean jobExists(Connection conn, String jobName, String groupName) throws SQLException
Check whether or not the given job exists.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionint updateJobData(Connection conn, JobDetail job) throws IOException, SQLException
Update the job data map for the given job.
conn - the DB Connectionjob - the job to updateIOException - if there were problems serializing the JobDataMapSQLExceptionint insertJobListener(Connection conn, JobDetail job, String listener) throws SQLException
Associate a listener with a job.
conn - the DB Connectionjob - the job to associate with the listenerlistener - the listener to insertSQLExceptionString[] selectJobListeners(Connection conn, String jobName, String groupName) throws SQLException
Get all of the listeners for a given job.
conn - the DB ConnectionjobName - the job name whose listeners are wantedgroupName - the group containing the jobString listener namesSQLExceptionJobDetail selectJobDetail(Connection conn, String jobName, String groupName, ClassLoadHelper loadHelper) throws ClassNotFoundException, IOException, SQLException
Select the JobDetail object for a given job name / group name.
conn - the DB ConnectionjobName - the job name whose listeners are wantedgroupName - the group containing the jobClassNotFoundException - if a class found during deserialization cannot be found or if
the job class could not be foundIOException - if deserialization causes an errorSQLExceptionint selectNumJobs(Connection conn) throws SQLException
Select the total number of jobs stored.
conn - the DB ConnectionSQLExceptionString[] selectJobGroups(Connection conn) throws SQLException
Select all of the job group names that are stored.
conn - the DB ConnectionString group namesSQLExceptionString[] selectJobsInGroup(Connection conn, String groupName) throws SQLException
Select all of the jobs contained in a given group.
conn - the DB ConnectiongroupName - the group containing the jobsString job namesSQLExceptionint insertTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException
Insert the base trigger data.
conn - the DB Connectiontrigger - the trigger to insertstate - the state that the trigger should be stored inSQLExceptionIOExceptionint insertSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException
Insert the simple trigger data.
conn - the DB Connectiontrigger - the trigger to insertSQLExceptionint insertBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException
Insert the blob trigger data.
conn - the DB Connectiontrigger - the trigger to insertSQLExceptionIOExceptionint insertCronTrigger(Connection conn, CronTrigger trigger) throws SQLException
Insert the cron trigger data.
conn - the DB Connectiontrigger - the trigger to insertSQLExceptionint updateTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException
Update the base trigger data.
conn - the DB Connectiontrigger - the trigger to insertstate - the state that the trigger should be stored inSQLExceptionIOExceptionint updateSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException
Update the simple trigger data.
conn - the DB Connectiontrigger - the trigger to insertSQLExceptionint updateCronTrigger(Connection conn, CronTrigger trigger) throws SQLException
Update the cron trigger data.
conn - the DB Connectiontrigger - the trigger to insertSQLExceptionint updateBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException
Update the blob trigger data.
conn - the DB Connectiontrigger - the trigger to insertSQLExceptionIOExceptionboolean triggerExists(Connection conn, String triggerName, String groupName) throws SQLException
Check whether or not a trigger exists.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionint updateTriggerState(Connection conn, String triggerName, String groupName, String state) throws SQLException
Update the state for a given trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerstate - the new state for the triggerSQLExceptionint updateTriggerStateFromOtherState(Connection conn, String triggerName, String groupName, String newState, String oldState) throws SQLException
Update the given trigger to the given new state, if it is in the given old state.
conn - the DB connectiontriggerName - the name of the triggergroupName - the group containing the triggernewState - the new state for the triggeroldState - the old state the trigger must be inSQLExceptionint updateTriggerStateFromOtherStates(Connection conn, String triggerName, String groupName, String newState, String oldState1, String oldState2, String oldState3) throws SQLException
Update the given trigger to the given new state, if it is one of the given old states.
conn - the DB connectiontriggerName - the name of the triggergroupName - the group containing the triggernewState - the new state for the triggeroldState1 - one of the old state the trigger must be inoldState2 - one of the old state the trigger must be inoldState3 - one of the old state the trigger must be inSQLExceptionint updateTriggerStateFromOtherStatesBeforeTime(Connection conn, String newState, String oldState1, String oldState2, long time) throws SQLException
Update the all triggers to the given new state, if they are in one of the given old states AND its next fire time is before the given time.
conn - the DB connectionnewState - the new state for the triggeroldState1 - one of the old state the trigger must be inoldState2 - one of the old state the trigger must be intime - the time before which the trigger's next fire time must beSQLExceptionint updateTriggerGroupStateFromOtherStates(Connection conn, String groupName, String newState, String oldState1, String oldState2, String oldState3) throws SQLException
Update all triggers in the given group to the given new state, if they are in one of the given old states.
conn - the DB connectiongroupName - the group containing the triggernewState - the new state for the triggeroldState1 - one of the old state the trigger must be inoldState2 - one of the old state the trigger must be inoldState3 - one of the old state the trigger must be inSQLExceptionint updateTriggerGroupStateFromOtherState(Connection conn, String groupName, String newState, String oldState) throws SQLException
Update all of the triggers of the given group to the given new state, if they are in the given old state.
conn - the DB connectiongroupName - the group containing the triggersnewState - the new state for the trigger groupoldState - the old state the triggers must be inSQLExceptionint updateTriggerStatesForJob(Connection conn, String jobName, String groupName, String state) throws SQLException
Update the states of all triggers associated with the given job.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobstate - the new state for the triggersSQLExceptionint updateTriggerStatesForJobFromOtherState(Connection conn, String jobName, String groupName, String state, String oldState) throws SQLException
Update the states of any triggers associated with the given job, that are the given current state.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobstate - the new state for the triggersoldState - the old state of the triggersSQLExceptionint deleteTriggerListeners(Connection conn, String triggerName, String groupName) throws SQLException
Delete all of the listeners associated with a given trigger.
conn - the DB ConnectiontriggerName - the name of the trigger whose listeners will be deletedgroupName - the name of the group containing the triggerSQLExceptionint insertTriggerListener(Connection conn, Trigger trigger, String listener) throws SQLException
Associate a listener with the given trigger.
conn - the DB Connectiontrigger - the triggerlistener - the name of the listener to associate with the triggerSQLExceptionString[] selectTriggerListeners(Connection conn, String triggerName, String groupName) throws SQLException
Select the listeners associated with a given trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerString trigger listener namesSQLExceptionint deleteSimpleTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the simple trigger data for a trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionint deleteBlobTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the BLOB trigger data for a trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionint deleteCronTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the cron trigger data for a trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionint deleteTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the base trigger data for a trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionint selectNumTriggersForJob(Connection conn, String jobName, String groupName) throws SQLException
Select the number of triggers associated with a given job.
conn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionJobDetail selectJobForTrigger(Connection conn, String triggerName, String groupName, ClassLoadHelper loadHelper) throws ClassNotFoundException, SQLException
Select the job to which the trigger is associated.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerJobDetail object
associated with the given triggerClassNotFoundExceptionSQLExceptionList selectStatefulJobsOfTriggerGroup(Connection conn, String groupName) throws SQLException
Select the stateful jobs which are referenced by triggers in the given trigger group.
conn - the DB ConnectiongroupName - the trigger groupSQLExceptionTrigger[] selectTriggersForJob(Connection conn, String jobName, String groupName) throws SQLException, ClassNotFoundException, IOException
Select the triggers for a job
conn - the DB ConnectionjobName - the name of the triggergroupName - the group containing the trigger(@link org.quartz.Trigger) objects
associated with a given job.SQLExceptionClassNotFoundExceptionIOExceptionTrigger[] selectTriggersForCalendar(Connection conn, String calName) throws SQLException, ClassNotFoundException, IOException
Select the triggers for a calendar
conn - the DB ConnectioncalName - the name of the calendar(@link org.quartz.Trigger) objects
associated with the given calendar.SQLExceptionClassNotFoundExceptionIOExceptionTrigger selectTrigger(Connection conn, String triggerName, String groupName) throws SQLException, ClassNotFoundException, IOException
Select a trigger.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerTrigger objectSQLExceptionClassNotFoundExceptionIOExceptionJobDataMap selectTriggerJobDataMap(Connection conn, String triggerName, String groupName) throws SQLException, ClassNotFoundException, IOException
Select a trigger's JobDataMap.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerJobDataMap of the Trigger,
never null, but possibly empty.SQLExceptionClassNotFoundExceptionIOExceptionString selectTriggerState(Connection conn, String triggerName, String groupName) throws SQLException
Select a trigger' state value.
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerTrigger objectSQLExceptionTriggerStatus selectTriggerStatus(Connection conn, String triggerName, String groupName) throws SQLException
Select a trigger' status (state & next fire time).
conn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerTriggerStatus object, or nullSQLExceptionint selectNumTriggers(Connection conn) throws SQLException
Select the total number of triggers stored.
conn - the DB ConnectionSQLExceptionString[] selectTriggerGroups(Connection conn) throws SQLException
Select all of the trigger group names that are stored.
conn - the DB ConnectionString group namesSQLExceptionString[] selectTriggersInGroup(Connection conn, String groupName) throws SQLException
Select all of the triggers contained in a given group.
conn - the DB ConnectiongroupName - the group containing the triggersString trigger namesSQLExceptionKey[] selectTriggersInState(Connection conn, String state) throws SQLException
Select all of the triggers in a given state.
conn - the DB Connectionstate - the state the triggers must be inKey sSQLExceptionint insertPausedTriggerGroup(Connection conn, String groupName) throws SQLException
SQLExceptionint deletePausedTriggerGroup(Connection conn, String groupName) throws SQLException
SQLExceptionint deleteAllPausedTriggerGroups(Connection conn) throws SQLException
SQLExceptionboolean isTriggerGroupPaused(Connection conn, String groupName) throws SQLException
SQLExceptionSet selectPausedTriggerGroups(Connection conn) throws SQLException
SQLExceptionboolean isExistingTriggerGroup(Connection conn, String groupName) throws SQLException
SQLExceptionint insertCalendar(Connection conn, String calendarName, Calendar calendar) throws IOException, SQLException
Insert a new calendar.
conn - the DB ConnectioncalendarName - the name for the new calendarcalendar - the calendarIOException - if there were problems serializing the calendarSQLExceptionint updateCalendar(Connection conn, String calendarName, Calendar calendar) throws IOException, SQLException
Update a calendar.
conn - the DB ConnectioncalendarName - the name for the new calendarcalendar - the calendarIOException - if there were problems serializing the calendarSQLExceptionboolean calendarExists(Connection conn, String calendarName) throws SQLException
Check whether or not a calendar exists.
conn - the DB ConnectioncalendarName - the name of the calendarSQLExceptionCalendar selectCalendar(Connection conn, String calendarName) throws ClassNotFoundException, IOException, SQLException
Select a calendar.
conn - the DB ConnectioncalendarName - the name of the calendarClassNotFoundException - if a class found during deserialization cannot be found be
foundIOException - if there were problems deserializing the calendarSQLExceptionboolean calendarIsReferenced(Connection conn, String calendarName) throws SQLException
Check whether or not a calendar is referenced by any triggers.
conn - the DB ConnectioncalendarName - the name of the calendarSQLExceptionint deleteCalendar(Connection conn, String calendarName) throws SQLException
Delete a calendar.
conn - the DB ConnectioncalendarName - the name of the triggerSQLExceptionint selectNumCalendars(Connection conn) throws SQLException
Select the total number of calendars stored.
conn - the DB ConnectionSQLExceptionString[] selectCalendars(Connection conn) throws SQLException
Select all of the stored calendars.
conn - the DB ConnectionString calendar namesSQLExceptionlong selectNextFireTime(Connection conn) throws SQLException
Select the next time that a trigger will be fired.
conn - the DB ConnectionSQLExceptionKey selectTriggerForFireTime(Connection conn, long fireTime) throws SQLException
Select the trigger that will be fired at the given fire time.
conn - the DB ConnectionfireTime - the time that the trigger will be firedKey representing the
trigger that will be fired at the given fire time, or null if no
trigger will be fired at that timeSQLExceptionList selectTriggerToAcquire(Connection conn, long noLaterThan, long noEarlierThan) throws SQLException
Select the next trigger which will fire to fire between the two given timestamps in ascending order of fire time, and then descending by priority.
conn - the DB ConnectionnoLaterThan - highest value of getNextFireTime() of the triggers (exclusive)noEarlierThan - highest value of getNextFireTime() of the triggers (inclusive)SQLExceptionint insertFiredTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException
Insert a fired trigger.
conn - the DB Connectiontrigger - the triggerstate - the state that the trigger should be stored inSQLExceptionList selectFiredTriggerRecords(Connection conn, String triggerName, String groupName) throws SQLException
Select the states of all fired-trigger records for a given trigger, or
trigger group if trigger name is null.
SQLExceptionList selectFiredTriggerRecordsByJob(Connection conn, String jobName, String groupName) throws SQLException
Select the states of all fired-trigger records for a given job, or job
group if job name is null.
SQLExceptionList selectInstancesFiredTriggerRecords(Connection conn, String instanceName) throws SQLException
Select the states of all fired-trigger records for a given scheduler instance.
SQLExceptionSet selectFiredTriggerInstanceNames(Connection conn) throws SQLException
Select the distinct instance names of all fired-trigger records.
This is useful when trying to identify orphaned fired triggers (a fired trigger without a scheduler state record.)
SQLExceptionint deleteFiredTrigger(Connection conn, String entryId) throws SQLException
Delete a fired trigger.
conn - the DB ConnectionentryId - the fired trigger entry to deleteSQLExceptionint selectJobExecutionCount(Connection conn, String jobName, String jobGroup) throws SQLException
Get the number instances of the identified job currently executing.
conn - the DB ConnectionSQLExceptionint insertSchedulerState(Connection conn, String instanceId, long checkInTime, long interval) throws SQLException
Insert a scheduler-instance state record.
conn - the DB ConnectionSQLExceptionint deleteSchedulerState(Connection conn, String instanceId) throws SQLException
Delete a scheduler-instance state record.
conn - the DB ConnectionSQLExceptionint updateSchedulerState(Connection conn, String instanceId, long checkInTime) throws SQLException
Update a scheduler-instance state record.
conn - the DB ConnectionSQLExceptionList selectSchedulerStateRecords(Connection conn, String instanceId) throws SQLException
A List of all current SchedulerStateRecords.
If instanceId is not null, then only the record for the identified instance will be returned.
conn - the DB ConnectionSQLExceptionCopyright © 2014. All rights reserved.