org.quartz.impl.jdbcjobstore: public class: DB2v7Delegate

org.quartz.impl.jdbcjobstore
public class: DB2v7Delegate [javadoc | source]

java.lang.Object
   org.quartz.impl.jdbcjobstore.StdJDBCDelegate
      org.quartz.impl.jdbcjobstore.DB2v7Delegate

All Implemented Interfaces:
StdJDBCConstants, DriverDelegate

Quartz JDBC delegate for DB2 v7 databases.

This differs from the StdJDBCDelegate in that it stores boolean values in an varchar(1) column, and saves serialized data in a byte array using PreparedStatement#setObject(int, java.lang.Object, int) rather than PreparedStatement#setBytes(int, byte[]) .

author: Blair - Jensen

Fields inherited from org.quartz.impl.jdbcjobstore.StdJDBCDelegate:
logger, tablePrefix, instanceId, useProperties

Constructor:
public DB2v7Delegate(Log logger, String tablePrefix, String instanceId) { super(logger, tablePrefix, instanceId); }
public DB2v7Delegate(Log log, String tablePrefix, String instanceId, Boolean useProperties) { super(log, tablePrefix, instanceId, useProperties); }

Constructor:

 public DB2v7Delegate(Log logger,
    String tablePrefix,
    String instanceId) {
        super(logger, tablePrefix, instanceId);
}

 public DB2v7Delegate(Log log,
    String tablePrefix,
    String instanceId,
    Boolean useProperties) {
        super(log, tablePrefix, instanceId, useProperties);
}

Method from org.quartz.impl.jdbcjobstore.DB2v7Delegate Summary:
setBoolean, setBytes

Methods from org.quartz.impl.jdbcjobstore.StdJDBCDelegate:
calendarExists, calendarIsReferenced, canUseProperties, closeResultSet, closeStatement, convertFromProperty, convertToProperty, countMisfiredTriggersInStates, deleteAllPausedTriggerGroups, deleteBlobTrigger, deleteCalendar, deleteCronTrigger, deleteFiredTrigger, deleteFiredTriggers, deleteFiredTriggers, deleteJobDetail, deleteJobListeners, deletePausedTriggerGroup, deleteSchedulerState, deleteSimpleTrigger, deleteTrigger, deleteTriggerListeners, deleteVolatileFiredTriggers, getBoolean, getBoolean, getJobDetailFromBlob, getKeyOfNonSerializableValue, getObjectFromBlob, insertBlobTrigger, insertCalendar, insertCronTrigger, insertFiredTrigger, insertJobDetail, insertJobListener, insertPausedTriggerGroup, insertSchedulerState, insertSimpleTrigger, insertTrigger, insertTriggerListener, isExistingTriggerGroup, isJobStateful, isTriggerGroupPaused, jobExists, rtp, selectCalendar, selectCalendars, selectFiredTriggerInstanceNames, selectFiredTriggerRecords, selectFiredTriggerRecordsByJob, selectInstancesFiredTriggerRecords, selectJobDetail, selectJobExecutionCount, selectJobForTrigger, selectJobGroups, selectJobListeners, selectJobsInGroup, selectMisfiredTriggers, selectMisfiredTriggersInGroupInState, selectMisfiredTriggersInState, selectMisfiredTriggersInStates, selectNextFireTime, selectNumCalendars, selectNumJobs, selectNumTriggers, selectNumTriggersForJob, selectPausedTriggerGroups, selectSchedulerStateRecords, selectStatefulJobsOfTriggerGroup, selectTrigger, selectTriggerForFireTime, selectTriggerGroups, selectTriggerJobDataMap, selectTriggerListeners, selectTriggerNamesForJob, selectTriggerState, selectTriggerStatus, selectTriggerToAcquire, selectTriggersForCalendar, selectTriggersForJob, selectTriggersForRecoveringJobs, selectTriggersInGroup, selectTriggersInState, selectVolatileJobs, selectVolatileTriggers, serializeJobData, serializeObject, setBoolean, setBytes, triggerExists, updateBlobTrigger, updateCalendar, updateCronTrigger, updateJobData, updateJobDetail, updateSchedulerState, updateSimpleTrigger, updateTrigger, updateTriggerGroupStateFromOtherState, updateTriggerGroupStateFromOtherStates, updateTriggerState, updateTriggerStateFromOtherState, updateTriggerStateFromOtherStates, updateTriggerStateFromOtherStatesBeforeTime, updateTriggerStatesForJob, updateTriggerStatesForJobFromOtherState, updateTriggerStatesFromOtherStates

Methods from org.quartz.impl.jdbcjobstore.StdJDBCDelegate:

calendarExists, calendarIsReferenced, canUseProperties, closeResultSet, closeStatement, convertFromProperty, convertToProperty, countMisfiredTriggersInStates, deleteAllPausedTriggerGroups, deleteBlobTrigger, deleteCalendar, deleteCronTrigger, deleteFiredTrigger, deleteFiredTriggers, deleteFiredTriggers, deleteJobDetail, deleteJobListeners, deletePausedTriggerGroup, deleteSchedulerState, deleteSimpleTrigger, deleteTrigger, deleteTriggerListeners, deleteVolatileFiredTriggers, getBoolean, getBoolean, getJobDetailFromBlob, getKeyOfNonSerializableValue, getObjectFromBlob, insertBlobTrigger, insertCalendar, insertCronTrigger, insertFiredTrigger, insertJobDetail, insertJobListener, insertPausedTriggerGroup, insertSchedulerState, insertSimpleTrigger, insertTrigger, insertTriggerListener, isExistingTriggerGroup, isJobStateful, isTriggerGroupPaused, jobExists, rtp, selectCalendar, selectCalendars, selectFiredTriggerInstanceNames, selectFiredTriggerRecords, selectFiredTriggerRecordsByJob, selectInstancesFiredTriggerRecords, selectJobDetail, selectJobExecutionCount, selectJobForTrigger, selectJobGroups, selectJobListeners, selectJobsInGroup, selectMisfiredTriggers, selectMisfiredTriggersInGroupInState, selectMisfiredTriggersInState, selectMisfiredTriggersInStates, selectNextFireTime, selectNumCalendars, selectNumJobs, selectNumTriggers, selectNumTriggersForJob, selectPausedTriggerGroups, selectSchedulerStateRecords, selectStatefulJobsOfTriggerGroup, selectTrigger, selectTriggerForFireTime, selectTriggerGroups, selectTriggerJobDataMap, selectTriggerListeners, selectTriggerNamesForJob, selectTriggerState, selectTriggerStatus, selectTriggerToAcquire, selectTriggersForCalendar, selectTriggersForJob, selectTriggersForRecoveringJobs, selectTriggersInGroup, selectTriggersInState, selectVolatileJobs, selectVolatileTriggers, serializeJobData, serializeObject, setBoolean, setBytes, triggerExists, updateBlobTrigger, updateCalendar, updateCronTrigger, updateJobData, updateJobDetail, updateSchedulerState, updateSimpleTrigger, updateTrigger, updateTriggerGroupStateFromOtherState, updateTriggerGroupStateFromOtherStates, updateTriggerState, updateTriggerStateFromOtherState, updateTriggerStateFromOtherStates, updateTriggerStateFromOtherStatesBeforeTime, updateTriggerStatesForJob, updateTriggerStatesForJobFromOtherState, updateTriggerStatesFromOtherStates

Methods from java.lang.Object:
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method from org.quartz.impl.jdbcjobstore.DB2v7Delegate Detail:
protected void setBoolean(PreparedStatement ps, int index, boolean val) throws SQLException { ps.setString(index, ((val) ? "1" : "0")); } Sets the designated parameter to the given Java `boolean` value. This translates the boolean to 1/0 for true/false.
protected void setBytes(PreparedStatement ps, int index, ByteArrayOutputStream baos) throws SQLException { ps.setObject(index, ((baos == null) ? null : baos.toByteArray()), java.sql.Types.BLOB); } Sets the designated parameter to the byte array of the given `ByteArrayOutputStream`. Will set parameter value to null if the `ByteArrayOutputStream` is null. Wraps `PreparedStatement#setObject(int, java.lang.Object, int)` rather than `PreparedStatement#setBytes(int, byte[])` as required by the DB2 v7 database.

Method from org.quartz.impl.jdbcjobstore.DB2v7Delegate Detail:

 protected  void setBoolean(PreparedStatement ps,
    int index,
    boolean val) throws SQLException {
        ps.setString(index, ((val) ? "1" : "0"));
}

boolean

 protected  void setBytes(PreparedStatement ps,
    int index,
    ByteArrayOutputStream baos) throws SQLException {
        ps.setObject(index, ((baos == null) ? null : baos.toByteArray()), java.sql.Types.BLOB);
}

ByteArrayOutputStream

PreparedStatement#setObject(int, java.lang.Object, int)

PreparedStatement#setBytes(int, byte[])