public class StdJDBCDelegate extends Object implements DriverDelegate, StdJDBCConstants
This is meant to be an abstract base class for most, if not all,
implementations. Subclasses should override only those methods that need
special handling for the DBMS driver in question.
DriverDelegate
| Modifier and Type | Field and Description |
|---|---|
protected String |
instanceId |
protected org.apache.commons.logging.Log |
logger |
protected String |
tablePrefix |
protected boolean |
useProperties |
COUNT_MISFIRED_TRIGGERS_IN_STATES, DELETE_BLOB_TRIGGER, DELETE_CALENDAR, DELETE_CRON_TRIGGER, DELETE_FIRED_TRIGGER, DELETE_FIRED_TRIGGERS, DELETE_INSTANCES_FIRED_TRIGGERS, DELETE_JOB_DETAIL, DELETE_JOB_LISTENERS, DELETE_NO_RECOVERY_FIRED_TRIGGERS, DELETE_PAUSED_TRIGGER_GROUP, DELETE_PAUSED_TRIGGER_GROUPS, DELETE_SCHEDULER_STATE, DELETE_SIMPLE_TRIGGER, DELETE_TRIGGER, DELETE_TRIGGER_LISTENERS, DELETE_VOLATILE_FIRED_TRIGGERS, INSERT_BLOB_TRIGGER, INSERT_CALENDAR, INSERT_CRON_TRIGGER, INSERT_FIRED_TRIGGER, INSERT_JOB_DETAIL, INSERT_JOB_LISTENER, INSERT_PAUSED_TRIGGER_GROUP, INSERT_SCHEDULER_STATE, INSERT_SIMPLE_TRIGGER, INSERT_TRIGGER, INSERT_TRIGGER_LISTENER, SELECT_BLOB_TRIGGER, SELECT_CALENDAR, SELECT_CALENDAR_EXISTENCE, SELECT_CALENDARS, SELECT_CRON_TRIGGER, SELECT_FIRED_TRIGGER, SELECT_FIRED_TRIGGER_GROUP, SELECT_FIRED_TRIGGER_INSTANCE_NAMES, SELECT_FIRED_TRIGGERS, SELECT_FIRED_TRIGGERS_OF_JOB, SELECT_FIRED_TRIGGERS_OF_JOB_GROUP, SELECT_INSTANCES_FIRED_TRIGGERS, SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS, SELECT_JOB_DETAIL, SELECT_JOB_EXECUTION_COUNT, SELECT_JOB_EXISTENCE, SELECT_JOB_FOR_TRIGGER, SELECT_JOB_GROUPS, SELECT_JOB_LISTENERS, SELECT_JOB_STATEFUL, SELECT_JOBS_IN_GROUP, SELECT_MISFIRED_TRIGGERS, SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE, SELECT_MISFIRED_TRIGGERS_IN_STATE, SELECT_MISFIRED_TRIGGERS_IN_STATES, SELECT_NEXT_FIRE_TIME, SELECT_NEXT_TRIGGER_TO_ACQUIRE, SELECT_NUM_CALENDARS, SELECT_NUM_JOBS, SELECT_NUM_TRIGGERS, SELECT_NUM_TRIGGERS_FOR_JOB, SELECT_NUM_TRIGGERS_IN_GROUP, SELECT_PAUSED_TRIGGER_GROUP, SELECT_PAUSED_TRIGGER_GROUPS, SELECT_REFERENCED_CALENDAR, SELECT_SCHEDULER_STATE, SELECT_SCHEDULER_STATES, SELECT_SIMPLE_TRIGGER, SELECT_STATEFUL_JOBS_OF_TRIGGER_GROUP, SELECT_TRIGGER, SELECT_TRIGGER_DATA, SELECT_TRIGGER_EXISTENCE, SELECT_TRIGGER_FOR_FIRE_TIME, SELECT_TRIGGER_GROUPS, SELECT_TRIGGER_LISTENERS, SELECT_TRIGGER_STATE, SELECT_TRIGGER_STATUS, SELECT_TRIGGERS_FOR_CALENDAR, SELECT_TRIGGERS_FOR_JOB, SELECT_TRIGGERS_IN_GROUP, SELECT_TRIGGERS_IN_STATE, SELECT_VOLATILE_JOBS, SELECT_VOLATILE_TRIGGERS, TABLE_PREFIX_SUBST, UPDATE_BLOB_TRIGGER, UPDATE_CALENDAR, UPDATE_CRON_TRIGGER, UPDATE_INSTANCES_FIRED_TRIGGER_STATE, UPDATE_JOB_DATA, UPDATE_JOB_DETAIL, UPDATE_JOB_TRIGGER_STATES, UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE, UPDATE_SCHEDULER_STATE, UPDATE_SIMPLE_TRIGGER, UPDATE_TRIGGER, UPDATE_TRIGGER_GROUP_STATE, UPDATE_TRIGGER_GROUP_STATE_FROM_STATE, UPDATE_TRIGGER_GROUP_STATE_FROM_STATES, UPDATE_TRIGGER_SKIP_DATA, UPDATE_TRIGGER_STATE, UPDATE_TRIGGER_STATE_FROM_OTHER_STATES_BEFORE_TIME, UPDATE_TRIGGER_STATE_FROM_STATE, UPDATE_TRIGGER_STATE_FROM_STATES, UPDATE_TRIGGER_STATES_FROM_OTHER_STATESALIAS_COL_NEXT_FIRE_TIME, ALL_GROUPS_PAUSED, COL_BLOB, COL_CALENDAR, COL_CALENDAR_NAME, COL_CHECKIN_INTERVAL, COL_CRON_EXPRESSION, COL_DESCRIPTION, COL_END_TIME, COL_ENTRY_ID, COL_ENTRY_STATE, COL_FIRED_TIME, COL_INSTANCE_NAME, COL_IS_DURABLE, COL_IS_STATEFUL, COL_IS_VOLATILE, COL_JOB_CLASS, COL_JOB_DATAMAP, COL_JOB_GROUP, COL_JOB_LISTENER, COL_JOB_NAME, COL_LAST_CHECKIN_TIME, COL_LOCK_NAME, COL_MISFIRE_INSTRUCTION, COL_NEXT_FIRE_TIME, COL_PREV_FIRE_TIME, COL_PRIORITY, COL_REPEAT_COUNT, COL_REPEAT_INTERVAL, COL_REQUESTS_RECOVERY, COL_START_TIME, COL_TIME_ZONE_ID, COL_TIMES_TRIGGERED, COL_TRIGGER_GROUP, COL_TRIGGER_LISTENER, COL_TRIGGER_NAME, COL_TRIGGER_STATE, COL_TRIGGER_TYPE, DEFAULT_TABLE_PREFIX, STATE_ACQUIRED, STATE_BLOCKED, STATE_COMPLETE, STATE_DELETED, STATE_ERROR, STATE_EXECUTING, STATE_MISFIRED, STATE_PAUSED, STATE_PAUSED_BLOCKED, STATE_WAITING, TABLE_BLOB_TRIGGERS, TABLE_CALENDARS, TABLE_CRON_TRIGGERS, TABLE_FIRED_TRIGGERS, TABLE_JOB_DETAILS, TABLE_JOB_LISTENERS, TABLE_LOCKS, TABLE_PAUSED_TRIGGERS, TABLE_SCHEDULER_STATE, TABLE_SIMPLE_TRIGGERS, TABLE_TRIGGER_LISTENERS, TABLE_TRIGGERS, TTYPE_BLOB, TTYPE_CRON, TTYPE_SIMPLE| Constructor and Description |
|---|
StdJDBCDelegate(org.apache.commons.logging.Log logger,
String tablePrefix,
String instanceId)
Create new StdJDBCDelegate instance.
|
StdJDBCDelegate(org.apache.commons.logging.Log logger,
String tablePrefix,
String instanceId,
Boolean useProperties)
Create new StdJDBCDelegate instance.
|
| 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.
|
protected boolean |
canUseProperties() |
protected void |
closeResultSet(ResultSet rs)
Cleanup helper method that closes the given
ResultSet
while ignoring any errors. |
protected void |
closeStatement(Statement statement)
Cleanup helper method that closes the given
Statement
while ignoring any errors. |
protected Map |
convertFromProperty(Properties properties)
convert the JobDataMap into a list of properties
|
protected Properties |
convertToProperty(Map data)
convert the JobDataMap into a list of properties
|
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 cron 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.
|
protected boolean |
getBoolean(ResultSet rs,
int columnIndex)
Retrieves the value of the designated column index in the current row as
a
boolean. |
protected boolean |
getBoolean(ResultSet rs,
String columnName)
Retrieves the value of the designated column in the current row as
a
boolean. |
protected Object |
getJobDetailFromBlob(ResultSet rs,
String colName)
This method should be overridden by any delegate subclasses that need
special handling for BLOBs for job details.
|
protected Object |
getKeyOfNonSerializableValue(Map data)
Find the key of the first non-serializable value in the given Map.
|
protected Object |
getObjectFromBlob(ResultSet rs,
String colName)
This method should be overridden by any delegate subclasses that need
special handling for BLOBs.
|
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 job)
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.
|
protected String |
rtp(String query)
Replace the table prefix in a query by replacing any occurrences of
"{0}" with the table prefix.
|
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.
|
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.
|
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.
|
protected ByteArrayOutputStream |
serializeJobData(JobDataMap data)
Remove the transient data from and then create a serialized
java.util.ByteArrayOutputStream
version of a . |
protected ByteArrayOutputStream |
serializeObject(Object obj)
Create a serialized
java.util.ByteArrayOutputStream
version of an Object. |
protected void |
setBoolean(PreparedStatement ps,
int index,
boolean val)
Sets the designated parameter to the given Java
boolean value. |
protected void |
setBytes(PreparedStatement ps,
int index,
ByteArrayOutputStream baos)
Sets the designated parameter to the byte array of the given
ByteArrayOutputStream. |
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)
Insert the job detail record.
|
protected org.apache.commons.logging.Log logger
protected String tablePrefix
protected String instanceId
protected boolean useProperties
public StdJDBCDelegate(org.apache.commons.logging.Log logger,
String tablePrefix,
String instanceId)
Create new StdJDBCDelegate instance.
logger - the logger to use during executiontablePrefix - the prefix of all table namesprotected boolean canUseProperties()
public int updateTriggerStatesFromOtherStates(Connection conn, String newState, String oldState1, String oldState2) throws SQLException
Insert the job detail record.
updateTriggerStatesFromOtherStates in interface DriverDelegateconn - the DB ConnectionnewState - the new state for the triggersoldState1 - the first old state to updateoldState2 - the second old state to updateSQLExceptionpublic Key[] selectMisfiredTriggers(Connection conn, long ts) throws SQLException
Get the names of all of the triggers that have misfired.
selectMisfiredTriggers in interface DriverDelegateconn - the DB ConnectionKey objectsSQLExceptionpublic Key[] selectTriggersInState(Connection conn, String state) throws SQLException
Select all of the triggers in a given state.
selectTriggersInState in interface DriverDelegateconn - the DB Connectionstate - the state the triggers must be inKey sSQLExceptionpublic Key[] selectMisfiredTriggersInState(Connection conn, String state, long ts) throws SQLException
DriverDelegateGet the names of all of the triggers in the given state that have misfired - according to the given timestamp.
selectMisfiredTriggersInState in interface DriverDelegateconn - the DB ConnectionKey objectsSQLExceptionpublic 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.
selectMisfiredTriggersInStates in interface DriverDelegateconn - The DB Connectioncount - The most misfired triggers to return, negative for allresultList - Output parameter. A List of
Key objects. Must not be null.SQLExceptionpublic 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.
countMisfiredTriggersInStates in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic 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.
selectMisfiredTriggersInGroupInState in interface DriverDelegateconn - the DB ConnectionKey objectsSQLExceptionpublic 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.
selectTriggersForRecoveringJobs in interface DriverDelegateconn - the DB ConnectionTrigger objectsSQLExceptionIOExceptionClassNotFoundExceptionpublic int deleteFiredTriggers(Connection conn) throws SQLException
Delete all fired triggers.
deleteFiredTriggers in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic int deleteFiredTriggers(Connection conn, String instanceId) throws SQLException
DriverDelegateDelete all fired triggers of the given instance.
deleteFiredTriggers in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic int insertJobDetail(Connection conn, JobDetail job) throws IOException, SQLException
Insert the job detail record.
insertJobDetail in interface DriverDelegateconn - the DB Connectionjob - the job to insertIOException - if there were problems serializing the JobDataMapSQLExceptionpublic int updateJobDetail(Connection conn, JobDetail job) throws IOException, SQLException
Update the job detail record.
updateJobDetail in interface DriverDelegateconn - the DB Connectionjob - the job to updateIOException - if there were problems serializing the JobDataMapSQLExceptionpublic Key[] selectTriggerNamesForJob(Connection conn, String jobName, String groupName) throws SQLException
Get the names of all of the triggers associated with the given job.
selectTriggerNamesForJob in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobKey objectsSQLExceptionpublic int deleteJobListeners(Connection conn, String jobName, String groupName) throws SQLException
Delete all job listeners for the given job.
deleteJobListeners in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionpublic int deleteJobDetail(Connection conn, String jobName, String groupName) throws SQLException
Delete the job detail record for the given job.
deleteJobDetail in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionpublic boolean isJobStateful(Connection conn, String jobName, String groupName) throws SQLException
Check whether or not the given job is stateful.
isJobStateful in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionpublic boolean jobExists(Connection conn, String jobName, String groupName) throws SQLException
Check whether or not the given job exists.
jobExists in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionpublic int updateJobData(Connection conn, JobDetail job) throws IOException, SQLException
Update the job data map for the given job.
updateJobData in interface DriverDelegateconn - the DB Connectionjob - the job to updateIOException - if there were problems serializing the JobDataMapSQLExceptionpublic int insertJobListener(Connection conn, JobDetail job, String listener) throws SQLException
Associate a listener with a job.
insertJobListener in interface DriverDelegateconn - the DB Connectionjob - the job to associate with the listenerlistener - the listener to insertSQLExceptionpublic String[] selectJobListeners(Connection conn, String jobName, String groupName) throws SQLException
Get all of the listeners for a given job.
selectJobListeners in interface DriverDelegateconn - the DB ConnectionjobName - the job name whose listeners are wantedgroupName - the group containing the jobString listener namesSQLExceptionpublic 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.
selectJobDetail in interface DriverDelegateconn - 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 errorSQLExceptionpublic int selectNumJobs(Connection conn) throws SQLException
Select the total number of jobs stored.
selectNumJobs in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic String[] selectJobGroups(Connection conn) throws SQLException
Select all of the job group names that are stored.
selectJobGroups in interface DriverDelegateconn - the DB ConnectionString group namesSQLExceptionpublic String[] selectJobsInGroup(Connection conn, String groupName) throws SQLException
Select all of the jobs contained in a given group.
selectJobsInGroup in interface DriverDelegateconn - the DB ConnectiongroupName - the group containing the jobsString job namesSQLExceptionpublic int insertTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException
Insert the base trigger data.
insertTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertstate - the state that the trigger should be stored inSQLExceptionIOExceptionpublic int insertSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException
Insert the simple trigger data.
insertSimpleTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertSQLExceptionpublic int insertCronTrigger(Connection conn, CronTrigger trigger) throws SQLException
Insert the cron trigger data.
insertCronTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertSQLExceptionpublic int insertBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException
Insert the blob trigger data.
insertBlobTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertSQLExceptionIOExceptionpublic int updateTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException
Update the base trigger data.
updateTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertstate - the state that the trigger should be stored inSQLExceptionIOExceptionpublic int updateSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException
Update the simple trigger data.
updateSimpleTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertSQLExceptionpublic int updateCronTrigger(Connection conn, CronTrigger trigger) throws SQLException
Update the cron trigger data.
updateCronTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertSQLExceptionpublic int updateBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException
Update the blob trigger data.
updateBlobTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the trigger to insertSQLExceptionIOExceptionpublic boolean triggerExists(Connection conn, String triggerName, String groupName) throws SQLException
Check whether or not a trigger exists.
triggerExists in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionpublic int updateTriggerState(Connection conn, String triggerName, String groupName, String state) throws SQLException
Update the state for a given trigger.
updateTriggerState in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerstate - the new state for the triggerSQLExceptionpublic 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.
updateTriggerStateFromOtherStates in interface DriverDelegateconn - 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 inSQLExceptionpublic int updateTriggerStateFromOtherStatesBeforeTime(Connection conn, String newState, String oldState1, String oldState2, long time) throws SQLException
DriverDelegateUpdate 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.
updateTriggerStateFromOtherStatesBeforeTime in interface DriverDelegateconn - 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 beSQLExceptionpublic 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.
updateTriggerGroupStateFromOtherStates in interface DriverDelegateconn - 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 inSQLExceptionpublic 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.
updateTriggerStateFromOtherState in interface DriverDelegateconn - 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 inSQLExceptionpublic 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.
updateTriggerGroupStateFromOtherState in interface DriverDelegateconn - the DB connectiongroupName - the group containing the triggersnewState - the new state for the trigger groupoldState - the old state the triggers must be inSQLExceptionpublic int updateTriggerStatesForJob(Connection conn, String jobName, String groupName, String state) throws SQLException
Update the states of all triggers associated with the given job.
updateTriggerStatesForJob in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobstate - the new state for the triggersSQLExceptionpublic int updateTriggerStatesForJobFromOtherState(Connection conn, String jobName, String groupName, String state, String oldState) throws SQLException
DriverDelegateUpdate the states of any triggers associated with the given job, that are the given current state.
updateTriggerStatesForJobFromOtherState in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobstate - the new state for the triggersoldState - the old state of the triggersSQLExceptionpublic int deleteTriggerListeners(Connection conn, String triggerName, String groupName) throws SQLException
Delete all of the listeners associated with a given trigger.
deleteTriggerListeners in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the trigger whose listeners will be deletedgroupName - the name of the group containing the triggerSQLExceptionpublic int insertTriggerListener(Connection conn, Trigger trigger, String listener) throws SQLException
Associate a listener with the given trigger.
insertTriggerListener in interface DriverDelegateconn - the DB Connectiontrigger - the triggerlistener - the name of the listener to associate with the triggerSQLExceptionpublic String[] selectTriggerListeners(Connection conn, String triggerName, String groupName) throws SQLException
Select the listeners associated with a given trigger.
selectTriggerListeners in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerString trigger listener namesSQLExceptionpublic int deleteSimpleTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the simple trigger data for a trigger.
deleteSimpleTrigger in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionpublic int deleteCronTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the cron trigger data for a trigger.
deleteCronTrigger in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionpublic int deleteBlobTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the cron trigger data for a trigger.
deleteBlobTrigger in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionpublic int deleteTrigger(Connection conn, String triggerName, String groupName) throws SQLException
Delete the base trigger data for a trigger.
deleteTrigger in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerSQLExceptionpublic int selectNumTriggersForJob(Connection conn, String jobName, String groupName) throws SQLException
Select the number of triggers associated with a given job.
selectNumTriggersForJob in interface DriverDelegateconn - the DB ConnectionjobName - the name of the jobgroupName - the group containing the jobSQLExceptionpublic JobDetail selectJobForTrigger(Connection conn, String triggerName, String groupName, ClassLoadHelper loadHelper) throws ClassNotFoundException, SQLException
Select the job to which the trigger is associated.
selectJobForTrigger in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerJobDetail object
associated with the given triggerSQLExceptionClassNotFoundExceptionpublic Trigger[] selectTriggersForJob(Connection conn, String jobName, String groupName) throws SQLException, ClassNotFoundException, IOException
Select the triggers for a job
selectTriggersForJob in interface DriverDelegateconn - the DB ConnectionjobName - the name of the triggergroupName - the group containing the trigger(@link org.quartz.Trigger) objects
associated with a given job.SQLExceptionClassNotFoundExceptionIOExceptionpublic Trigger[] selectTriggersForCalendar(Connection conn, String calName) throws SQLException, ClassNotFoundException, IOException
DriverDelegateSelect the triggers for a calendar
selectTriggersForCalendar in interface DriverDelegateconn - the DB ConnectioncalName - the name of the calendar(@link org.quartz.Trigger) objects
associated with the given calendar.SQLExceptionClassNotFoundExceptionIOExceptionpublic List selectStatefulJobsOfTriggerGroup(Connection conn, String groupName) throws SQLException
DriverDelegateSelect the stateful jobs which are referenced by triggers in the given trigger group.
selectStatefulJobsOfTriggerGroup in interface DriverDelegateconn - the DB ConnectiongroupName - the trigger groupSQLExceptionpublic Trigger selectTrigger(Connection conn, String triggerName, String groupName) throws SQLException, ClassNotFoundException, IOException
Select a trigger.
selectTrigger in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerTrigger objectSQLExceptionClassNotFoundExceptionIOExceptionpublic JobDataMap selectTriggerJobDataMap(Connection conn, String triggerName, String groupName) throws SQLException, ClassNotFoundException, IOException
Select a trigger's JobDataMap.
selectTriggerJobDataMap in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerJobDataMap of the Trigger,
never null, but possibly empty.SQLExceptionClassNotFoundExceptionIOExceptionpublic String selectTriggerState(Connection conn, String triggerName, String groupName) throws SQLException
Select a trigger' state value.
selectTriggerState in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerTrigger objectSQLExceptionpublic TriggerStatus selectTriggerStatus(Connection conn, String triggerName, String groupName) throws SQLException
Select a trigger' status (state & next fire time).
selectTriggerStatus in interface DriverDelegateconn - the DB ConnectiontriggerName - the name of the triggergroupName - the group containing the triggerTriggerStatus object, or nullSQLExceptionpublic int selectNumTriggers(Connection conn) throws SQLException
Select the total number of triggers stored.
selectNumTriggers in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic String[] selectTriggerGroups(Connection conn) throws SQLException
Select all of the trigger group names that are stored.
selectTriggerGroups in interface DriverDelegateconn - the DB ConnectionString group namesSQLExceptionpublic String[] selectTriggersInGroup(Connection conn, String groupName) throws SQLException
Select all of the triggers contained in a given group.
selectTriggersInGroup in interface DriverDelegateconn - the DB ConnectiongroupName - the group containing the triggersString trigger namesSQLExceptionpublic int insertPausedTriggerGroup(Connection conn, String groupName) throws SQLException
insertPausedTriggerGroup in interface DriverDelegateSQLExceptionpublic int deletePausedTriggerGroup(Connection conn, String groupName) throws SQLException
deletePausedTriggerGroup in interface DriverDelegateSQLExceptionpublic int deleteAllPausedTriggerGroups(Connection conn) throws SQLException
deleteAllPausedTriggerGroups in interface DriverDelegateSQLExceptionpublic boolean isTriggerGroupPaused(Connection conn, String groupName) throws SQLException
isTriggerGroupPaused in interface DriverDelegateSQLExceptionpublic boolean isExistingTriggerGroup(Connection conn, String groupName) throws SQLException
isExistingTriggerGroup in interface DriverDelegateSQLExceptionpublic int insertCalendar(Connection conn, String calendarName, Calendar calendar) throws IOException, SQLException
Insert a new calendar.
insertCalendar in interface DriverDelegateconn - the DB ConnectioncalendarName - the name for the new calendarcalendar - the calendarIOException - if there were problems serializing the calendarSQLExceptionpublic int updateCalendar(Connection conn, String calendarName, Calendar calendar) throws IOException, SQLException
Update a calendar.
updateCalendar in interface DriverDelegateconn - the DB ConnectioncalendarName - the name for the new calendarcalendar - the calendarIOException - if there were problems serializing the calendarSQLExceptionpublic boolean calendarExists(Connection conn, String calendarName) throws SQLException
Check whether or not a calendar exists.
calendarExists in interface DriverDelegateconn - the DB ConnectioncalendarName - the name of the calendarSQLExceptionpublic Calendar selectCalendar(Connection conn, String calendarName) throws ClassNotFoundException, IOException, SQLException
Select a calendar.
selectCalendar in interface DriverDelegateconn - 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 calendarSQLExceptionpublic boolean calendarIsReferenced(Connection conn, String calendarName) throws SQLException
Check whether or not a calendar is referenced by any triggers.
calendarIsReferenced in interface DriverDelegateconn - the DB ConnectioncalendarName - the name of the calendarSQLExceptionpublic int deleteCalendar(Connection conn, String calendarName) throws SQLException
Delete a calendar.
deleteCalendar in interface DriverDelegateconn - the DB ConnectioncalendarName - the name of the triggerSQLExceptionpublic int selectNumCalendars(Connection conn) throws SQLException
Select the total number of calendars stored.
selectNumCalendars in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic String[] selectCalendars(Connection conn) throws SQLException
Select all of the stored calendars.
selectCalendars in interface DriverDelegateconn - the DB ConnectionString calendar namesSQLExceptionpublic long selectNextFireTime(Connection conn) throws SQLException
Select the next time that a trigger will be fired.
selectNextFireTime in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic Key selectTriggerForFireTime(Connection conn, long fireTime) throws SQLException
Select the trigger that will be fired at the given fire time.
selectTriggerForFireTime in interface DriverDelegateconn - 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 timeSQLExceptionpublic 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.
selectTriggerToAcquire in interface DriverDelegateconn - the DB ConnectionnoLaterThan - highest value of getNextFireTime() of the triggers (exclusive)noEarlierThan - highest value of getNextFireTime() of the triggers (inclusive)SQLExceptionpublic int insertFiredTrigger(Connection conn, Trigger trigger, String state, JobDetail job) throws SQLException
Insert a fired trigger.
insertFiredTrigger in interface DriverDelegateconn - the DB Connectiontrigger - the triggerstate - the state that the trigger should be stored inSQLExceptionpublic 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.
selectFiredTriggerRecords in interface DriverDelegateSQLExceptionpublic 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.
selectFiredTriggerRecordsByJob in interface DriverDelegateSQLExceptionpublic List selectInstancesFiredTriggerRecords(Connection conn, String instanceName) throws SQLException
DriverDelegateSelect the states of all fired-trigger records for a given scheduler instance.
selectInstancesFiredTriggerRecords in interface DriverDelegateSQLExceptionpublic 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.)
selectFiredTriggerInstanceNames in interface DriverDelegateSQLExceptionpublic int deleteFiredTrigger(Connection conn, String entryId) throws SQLException
Delete a fired trigger.
deleteFiredTrigger in interface DriverDelegateconn - the DB ConnectionentryId - the fired trigger entry to deleteSQLExceptionpublic int selectJobExecutionCount(Connection conn, String jobName, String jobGroup) throws SQLException
DriverDelegateGet the number instances of the identified job currently executing.
selectJobExecutionCount in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic int deleteVolatileFiredTriggers(Connection conn) throws SQLException
DriverDelegateDelete all volatile fired triggers.
deleteVolatileFiredTriggers in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic int insertSchedulerState(Connection conn, String instanceId, long checkInTime, long interval) throws SQLException
DriverDelegateInsert a scheduler-instance state record.
insertSchedulerState in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic int deleteSchedulerState(Connection conn, String instanceId) throws SQLException
DriverDelegateDelete a scheduler-instance state record.
deleteSchedulerState in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic int updateSchedulerState(Connection conn, String instanceId, long checkInTime) throws SQLException
DriverDelegateUpdate a scheduler-instance state record.
updateSchedulerState in interface DriverDelegateconn - the DB ConnectionSQLExceptionpublic List selectSchedulerStateRecords(Connection conn, String instanceId) throws SQLException
DriverDelegate
A List of all current SchedulerStateRecords.
If instanceId is not null, then only the record for the identified instance will be returned.
selectSchedulerStateRecords in interface DriverDelegateconn - the DB ConnectionSQLExceptionprotected final String rtp(String query)
Replace the table prefix in a query by replacing any occurrences of "{0}" with the table prefix.
query - the unsubstitued queryprotected ByteArrayOutputStream serializeObject(Object obj) throws IOException
Create a serialized java.util.ByteArrayOutputStream
version of an Object.
obj - the object to serializeIOException - if serialization causes an errorprotected ByteArrayOutputStream serializeJobData(JobDataMap data) throws IOException
Remove the transient data from and then create a serialized java.util.ByteArrayOutputStream
version of a .
JobDataMap
data - the JobDataMap to serializeIOException - if serialization causes an errorprotected Object getKeyOfNonSerializableValue(Map data)
protected Map convertFromProperty(Properties properties) throws IOException
IOExceptionprotected Properties convertToProperty(Map data) throws IOException
IOExceptionprotected Object getObjectFromBlob(ResultSet rs, String colName) throws ClassNotFoundException, IOException, SQLException
This method should be overridden by any delegate subclasses that need
special handling for BLOBs. The default implementation uses standard
JDBC java.sql.Blob operations.
rs - the result set, already queued to the correct rowcolName - the column name for the BLOBClassNotFoundException - if a class found during deserialization cannot be foundIOException - if deserialization causes an errorSQLExceptionpublic Key[] selectVolatileTriggers(Connection conn) throws SQLException
DriverDelegateGet the names of all of the triggers that are volatile.
selectVolatileTriggers in interface DriverDelegateconn - the DB ConnectionKey objectsSQLExceptionpublic Key[] selectVolatileJobs(Connection conn) throws SQLException
DriverDelegateGet the names of all of the jobs that are volatile.
selectVolatileJobs in interface DriverDelegateconn - the DB ConnectionKey objectsSQLExceptionprotected Object getJobDetailFromBlob(ResultSet rs, String colName) throws ClassNotFoundException, IOException, SQLException
This method should be overridden by any delegate subclasses that need
special handling for BLOBs for job details. The default implementation
uses standard JDBC java.sql.Blob operations.
rs - the result set, already queued to the correct rowcolName - the column name for the BLOBClassNotFoundException - if a class found during deserialization cannot be foundIOException - if deserialization causes an errorSQLExceptionpublic Set selectPausedTriggerGroups(Connection conn) throws SQLException
selectPausedTriggerGroups in interface DriverDelegateSQLExceptionDriverDelegate.selectPausedTriggerGroups(java.sql.Connection)protected void closeResultSet(ResultSet rs)
ResultSet
while ignoring any errors.protected void closeStatement(Statement statement)
Statement
while ignoring any errors.protected void setBoolean(PreparedStatement ps, int index, boolean val) throws SQLException
boolean value.
This just wraps PreparedStatement.setBoolean(int, boolean)
by default, but it can be overloaded by subclass delegates for databases that
don't explicitly support the boolean type.SQLExceptionprotected boolean getBoolean(ResultSet rs, String columnName) throws SQLException
boolean.
This just wraps ResultSet.getBoolean(java.lang.String)
by default, but it can be overloaded by subclass delegates for databases that
don't explicitly support the boolean type.SQLExceptionprotected boolean getBoolean(ResultSet rs, int columnIndex) throws SQLException
boolean.
This just wraps ResultSet.getBoolean(java.lang.String)
by default, but it can be overloaded by subclass delegates for databases that
don't explicitly support the boolean type.SQLExceptionprotected void setBytes(PreparedStatement ps, int index, ByteArrayOutputStream baos) throws SQLException
ByteArrayOutputStream. Will set parameter value to null if the
ByteArrayOutputStream is null.
This just wraps PreparedStatement.setBytes(int, byte[])
by default, but it can be overloaded by subclass delegates for databases that
don't explicitly support storing bytes in this way.SQLExceptionCopyright © 2014. All rights reserved.