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 updateSQLException
Key[] 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
objectsSQLException
Key[] 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
objectsSQLException
boolean 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.SQLException
int 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 ConnectionSQLException
Key[] 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
objectsSQLException
Trigger[] 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
objectsSQLException
IOException
ClassNotFoundException
int deleteFiredTriggers(Connection conn) throws SQLException
Delete all fired triggers.
conn
- the DB ConnectionSQLException
int deleteFiredTriggers(Connection conn, String instanceId) throws SQLException
Delete all fired triggers of the given instance.
conn
- the DB ConnectionSQLException
int deleteVolatileFiredTriggers(Connection conn) throws SQLException
Delete all volatile fired triggers.
conn
- the DB ConnectionSQLException
Key[] selectVolatileTriggers(Connection conn) throws SQLException
Get the names of all of the triggers that are volatile.
conn
- the DB ConnectionKey
objectsSQLException
Key[] selectVolatileJobs(Connection conn) throws SQLException
Get the names of all of the jobs that are volatile.
conn
- the DB ConnectionKey
objectsSQLException
int 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 JobDataMapSQLException
int 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 JobDataMapSQLException
Key[] 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
objectsSQLException
int 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 jobSQLException
int 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 jobSQLException
boolean 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 jobSQLException
boolean 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 jobSQLException
int 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 JobDataMapSQLException
int 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 insertSQLException
String[] 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 namesSQLException
JobDetail 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 errorSQLException
int selectNumJobs(Connection conn) throws SQLException
Select the total number of jobs stored.
conn
- the DB ConnectionSQLException
String[] selectJobGroups(Connection conn) throws SQLException
Select all of the job group names that are stored.
conn
- the DB ConnectionString
group namesSQLException
String[] 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 namesSQLException
int 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 inSQLException
IOException
int insertSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException
Insert the simple trigger data.
conn
- the DB Connectiontrigger
- the trigger to insertSQLException
int insertBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException
Insert the blob trigger data.
conn
- the DB Connectiontrigger
- the trigger to insertSQLException
IOException
int insertCronTrigger(Connection conn, CronTrigger trigger) throws SQLException
Insert the cron trigger data.
conn
- the DB Connectiontrigger
- the trigger to insertSQLException
int 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 inSQLException
IOException
int updateSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException
Update the simple trigger data.
conn
- the DB Connectiontrigger
- the trigger to insertSQLException
int updateCronTrigger(Connection conn, CronTrigger trigger) throws SQLException
Update the cron trigger data.
conn
- the DB Connectiontrigger
- the trigger to insertSQLException
int updateBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException
Update the blob trigger data.
conn
- the DB Connectiontrigger
- the trigger to insertSQLException
IOException
boolean 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 triggerSQLException
int 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 triggerSQLException
int 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 inSQLException
int 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 inSQLException
int 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 beSQLException
int 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 inSQLException
int 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 inSQLException
int 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 triggersSQLException
int 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 triggersSQLException
int 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 triggerSQLException
int 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 triggerSQLException
String[] 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 namesSQLException
int 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 triggerSQLException
int 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 triggerSQLException
int 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 triggerSQLException
int 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 triggerSQLException
int 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 jobSQLException
JobDetail 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 triggerClassNotFoundException
SQLException
List 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 groupSQLException
Trigger[] 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.SQLException
ClassNotFoundException
IOException
Trigger[] 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.SQLException
ClassNotFoundException
IOException
Trigger 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
objectSQLException
ClassNotFoundException
IOException
JobDataMap 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.SQLException
ClassNotFoundException
IOException
String 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
objectSQLException
TriggerStatus 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 nullSQLException
int selectNumTriggers(Connection conn) throws SQLException
Select the total number of triggers stored.
conn
- the DB ConnectionSQLException
String[] selectTriggerGroups(Connection conn) throws SQLException
Select all of the trigger group names that are stored.
conn
- the DB ConnectionString
group namesSQLException
String[] 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 namesSQLException
Key[] 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
sSQLException
int insertPausedTriggerGroup(Connection conn, String groupName) throws SQLException
SQLException
int deletePausedTriggerGroup(Connection conn, String groupName) throws SQLException
SQLException
int deleteAllPausedTriggerGroups(Connection conn) throws SQLException
SQLException
boolean isTriggerGroupPaused(Connection conn, String groupName) throws SQLException
SQLException
Set selectPausedTriggerGroups(Connection conn) throws SQLException
SQLException
boolean isExistingTriggerGroup(Connection conn, String groupName) throws SQLException
SQLException
int 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 calendarSQLException
int 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 calendarSQLException
boolean calendarExists(Connection conn, String calendarName) throws SQLException
Check whether or not a calendar exists.
conn
- the DB ConnectioncalendarName
- the name of the calendarSQLException
Calendar 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 calendarSQLException
boolean 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 calendarSQLException
int deleteCalendar(Connection conn, String calendarName) throws SQLException
Delete a calendar.
conn
- the DB ConnectioncalendarName
- the name of the triggerSQLException
int selectNumCalendars(Connection conn) throws SQLException
Select the total number of calendars stored.
conn
- the DB ConnectionSQLException
String[] selectCalendars(Connection conn) throws SQLException
Select all of the stored calendars.
conn
- the DB ConnectionString
calendar namesSQLException
long selectNextFireTime(Connection conn) throws SQLException
Select the next time that a trigger will be fired.
conn
- the DB ConnectionSQLException
Key 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 timeSQLException
List 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)SQLException
int 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 inSQLException
List 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
.
SQLException
List 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
.
SQLException
List selectInstancesFiredTriggerRecords(Connection conn, String instanceName) throws SQLException
Select the states of all fired-trigger records for a given scheduler instance.
SQLException
Set 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.)
SQLException
int deleteFiredTrigger(Connection conn, String entryId) throws SQLException
Delete a fired trigger.
conn
- the DB ConnectionentryId
- the fired trigger entry to deleteSQLException
int selectJobExecutionCount(Connection conn, String jobName, String jobGroup) throws SQLException
Get the number instances of the identified job currently executing.
conn
- the DB ConnectionSQLException
int insertSchedulerState(Connection conn, String instanceId, long checkInTime, long interval) throws SQLException
Insert a scheduler-instance state record.
conn
- the DB ConnectionSQLException
int deleteSchedulerState(Connection conn, String instanceId) throws SQLException
Delete a scheduler-instance state record.
conn
- the DB ConnectionSQLException
int updateSchedulerState(Connection conn, String instanceId, long checkInTime) throws SQLException
Update a scheduler-instance state record.
conn
- the DB ConnectionSQLException
List 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 ConnectionSQLException
Copyright © 2014. All rights reserved.