| java.lang.Object org.quartz.impl.jdbcjobstore.StdJDBCDelegate org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
All known Subclasses: org.quartz.impl.jdbcjobstore.oracle.weblogic.WebLogicOracleDelegate,
Method Summary | |
protected Object | getJobDetailFromBlob(ResultSet rs, String colName) | protected Object | getObjectFromBlob(ResultSet rs, String colName) | public int | insertCalendar(Connection conn, String calendarName, Calendar calendar) | public int | insertJobDetail(Connection conn, JobDetail job) | public int | insertTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) | public int | updateCalendar(Connection conn, String calendarName, Calendar calendar) | public int | updateJobData(Connection conn, JobDetail job) | public int | updateJobDetail(Connection conn, JobDetail job) | public int | updateTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) | protected Blob | writeDataToBlob(ResultSet rs, int column, byte[] data) |
INSERT_ORACLE_CALENDAR | final public static String INSERT_ORACLE_CALENDAR(Code) | | |
SELECT_ORACLE_CALENDAR_BLOB | final public static String SELECT_ORACLE_CALENDAR_BLOB(Code) | | |
SELECT_ORACLE_JOB_DETAIL_BLOB | final public static String SELECT_ORACLE_JOB_DETAIL_BLOB(Code) | | |
SELECT_ORACLE_TRIGGER_JOB_DETAIL_BLOB | final public static String SELECT_ORACLE_TRIGGER_JOB_DETAIL_BLOB(Code) | | |
UPDATE_ORACLE_CALENDAR_BLOB | final public static String UPDATE_ORACLE_CALENDAR_BLOB(Code) | | |
UPDATE_ORACLE_JOB_DETAIL | final public static String UPDATE_ORACLE_JOB_DETAIL(Code) | | |
UPDATE_ORACLE_JOB_DETAIL_BLOB | final public static String UPDATE_ORACLE_JOB_DETAIL_BLOB(Code) | | |
UPDATE_ORACLE_JOB_DETAIL_EMPTY_BLOB | final public static String UPDATE_ORACLE_JOB_DETAIL_EMPTY_BLOB(Code) | | |
UPDATE_ORACLE_TRIGGER | final public static String UPDATE_ORACLE_TRIGGER(Code) | | |
UPDATE_ORACLE_TRIGGER_JOB_DETAIL_BLOB | final public static String UPDATE_ORACLE_TRIGGER_JOB_DETAIL_BLOB(Code) | | |
UPDATE_ORACLE_TRIGGER_JOB_DETAIL_EMPTY_BLOB | final public static String UPDATE_ORACLE_TRIGGER_JOB_DETAIL_EMPTY_BLOB(Code) | | |
OracleDelegate | public OracleDelegate(Log logger, String tablePrefix, String instanceId)(Code) | |
Create new OrcaleDelegate instance.
Parameters: logger - the logger to use during execution Parameters: tablePrefix - the prefix of all table names |
OracleDelegate | public OracleDelegate(Log logger, String tablePrefix, String instanceId, Boolean useProperties)(Code) | |
Create new OrcaleDelegate instance.
Parameters: logger - the logger to use during execution Parameters: tablePrefix - the prefix of all table names Parameters: useProperties - use java.util.Properties for storage |
Methods inherited from org.quartz.impl.jdbcjobstore.StdJDBCDelegate | public boolean calendarExists(Connection conn, String calendarName) throws SQLException(Code)(Java Doc) public boolean calendarIsReferenced(Connection conn, String calendarName) throws SQLException(Code)(Java Doc) protected boolean canUseProperties()(Code)(Java Doc) protected void closeResultSet(ResultSet rs)(Code)(Java Doc) protected void closeStatement(Statement statement)(Code)(Java Doc) protected Map convertFromProperty(Properties properties) throws IOException(Code)(Java Doc) protected Properties convertToProperty(Map data) throws IOException(Code)(Java Doc) public int countMisfiredTriggersInStates(Connection conn, String state1, String state2, long ts) throws SQLException(Code)(Java Doc) public int deleteAllPausedTriggerGroups(Connection conn) throws SQLException(Code)(Java Doc) public int deleteBlobTrigger(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public int deleteCalendar(Connection conn, String calendarName) throws SQLException(Code)(Java Doc) public int deleteCronTrigger(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public int deleteFiredTrigger(Connection conn, String entryId) throws SQLException(Code)(Java Doc) public int deleteFiredTriggers(Connection conn) throws SQLException(Code)(Java Doc) public int deleteFiredTriggers(Connection conn, String instanceId) throws SQLException(Code)(Java Doc) public int deleteJobDetail(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public int deleteJobListeners(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public int deletePausedTriggerGroup(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public int deleteSchedulerState(Connection conn, String instanceId) throws SQLException(Code)(Java Doc) public int deleteSimpleTrigger(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public int deleteTrigger(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public int deleteTriggerListeners(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public int deleteVolatileFiredTriggers(Connection conn) throws SQLException(Code)(Java Doc) protected boolean getBoolean(ResultSet rs, String columnName) throws SQLException(Code)(Java Doc) protected boolean getBoolean(ResultSet rs, int columnIndex) throws SQLException(Code)(Java Doc) protected Object getJobDetailFromBlob(ResultSet rs, String colName) throws ClassNotFoundException, IOException, SQLException(Code)(Java Doc) protected Object getKeyOfNonSerializableValue(Map data)(Code)(Java Doc) protected Object getObjectFromBlob(ResultSet rs, String colName) throws ClassNotFoundException, IOException, SQLException(Code)(Java Doc) public int insertBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException(Code)(Java Doc) public int insertCalendar(Connection conn, String calendarName, Calendar calendar) throws IOException, SQLException(Code)(Java Doc) public int insertCronTrigger(Connection conn, CronTrigger trigger) throws SQLException(Code)(Java Doc) public int insertFiredTrigger(Connection conn, Trigger trigger, String state, JobDetail job) throws SQLException(Code)(Java Doc) public int insertJobDetail(Connection conn, JobDetail job) throws IOException, SQLException(Code)(Java Doc) public int insertJobListener(Connection conn, JobDetail job, String listener) throws SQLException(Code)(Java Doc) public int insertPausedTriggerGroup(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public int insertSchedulerState(Connection conn, String instanceId, long checkInTime, long interval) throws SQLException(Code)(Java Doc) public int insertSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException(Code)(Java Doc) public int insertTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException(Code)(Java Doc) public int insertTriggerListener(Connection conn, Trigger trigger, String listener) throws SQLException(Code)(Java Doc) public boolean isExistingTriggerGroup(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public boolean isJobStateful(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public boolean isTriggerGroupPaused(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public boolean jobExists(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) final protected String rtp(String query)(Code)(Java Doc) public Calendar selectCalendar(Connection conn, String calendarName) throws ClassNotFoundException, IOException, SQLException(Code)(Java Doc) public String[] selectCalendars(Connection conn) throws SQLException(Code)(Java Doc) public Set selectFiredTriggerInstanceNames(Connection conn) throws SQLException(Code)(Java Doc) public List selectFiredTriggerRecords(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public List selectFiredTriggerRecordsByJob(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public List selectInstancesFiredTriggerRecords(Connection conn, String instanceName) throws SQLException(Code)(Java Doc) public JobDetail selectJobDetail(Connection conn, String jobName, String groupName, ClassLoadHelper loadHelper) throws ClassNotFoundException, IOException, SQLException(Code)(Java Doc) public int selectJobExecutionCount(Connection conn, String jobName, String jobGroup) throws SQLException(Code)(Java Doc) public JobDetail selectJobForTrigger(Connection conn, String triggerName, String groupName, ClassLoadHelper loadHelper) throws ClassNotFoundException, SQLException(Code)(Java Doc) public String[] selectJobGroups(Connection conn) throws SQLException(Code)(Java Doc) public String[] selectJobListeners(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public String[] selectJobsInGroup(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public Key[] selectMisfiredTriggers(Connection conn, long ts) throws SQLException(Code)(Java Doc) public Key[] selectMisfiredTriggersInGroupInState(Connection conn, String groupName, String state, long ts) throws SQLException(Code)(Java Doc) public Key[] selectMisfiredTriggersInState(Connection conn, String state, long ts) throws SQLException(Code)(Java Doc) public boolean selectMisfiredTriggersInStates(Connection conn, String state1, String state2, long ts, int count, List resultList) throws SQLException(Code)(Java Doc) public long selectNextFireTime(Connection conn) throws SQLException(Code)(Java Doc) public int selectNumCalendars(Connection conn) throws SQLException(Code)(Java Doc) public int selectNumJobs(Connection conn) throws SQLException(Code)(Java Doc) public int selectNumTriggers(Connection conn) throws SQLException(Code)(Java Doc) public int selectNumTriggersForJob(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public Set selectPausedTriggerGroups(Connection conn) throws SQLException(Code)(Java Doc) public List selectSchedulerStateRecords(Connection conn, String instanceId) throws SQLException(Code)(Java Doc) public List selectStatefulJobsOfTriggerGroup(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public Trigger selectTrigger(Connection conn, String triggerName, String groupName) throws SQLException, ClassNotFoundException, IOException(Code)(Java Doc) public Key selectTriggerForFireTime(Connection conn, long fireTime) throws SQLException(Code)(Java Doc) public String[] selectTriggerGroups(Connection conn) throws SQLException(Code)(Java Doc) public JobDataMap selectTriggerJobDataMap(Connection conn, String triggerName, String groupName) throws SQLException, ClassNotFoundException, IOException(Code)(Java Doc) public String[] selectTriggerListeners(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public Key[] selectTriggerNamesForJob(Connection conn, String jobName, String groupName) throws SQLException(Code)(Java Doc) public String selectTriggerState(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public TriggerStatus selectTriggerStatus(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public Key selectTriggerToAcquire(Connection conn, long noLaterThan, long noEarlierThan) throws SQLException(Code)(Java Doc) public Trigger[] selectTriggersForCalendar(Connection conn, String calName) throws SQLException, ClassNotFoundException, IOException(Code)(Java Doc) public Trigger[] selectTriggersForJob(Connection conn, String jobName, String groupName) throws SQLException, ClassNotFoundException, IOException(Code)(Java Doc) public Trigger[] selectTriggersForRecoveringJobs(Connection conn) throws SQLException, IOException, ClassNotFoundException(Code)(Java Doc) public String[] selectTriggersInGroup(Connection conn, String groupName) throws SQLException(Code)(Java Doc) public Key[] selectTriggersInState(Connection conn, String state) throws SQLException(Code)(Java Doc) public Key[] selectVolatileJobs(Connection conn) throws SQLException(Code)(Java Doc) public Key[] selectVolatileTriggers(Connection conn) throws SQLException(Code)(Java Doc) protected ByteArrayOutputStream serializeJobData(JobDataMap data) throws IOException(Code)(Java Doc) protected ByteArrayOutputStream serializeObject(Object obj) throws IOException(Code)(Java Doc) protected void setBoolean(PreparedStatement ps, int index, boolean val) throws SQLException(Code)(Java Doc) protected void setBytes(PreparedStatement ps, int index, ByteArrayOutputStream baos) throws SQLException(Code)(Java Doc) public boolean triggerExists(Connection conn, String triggerName, String groupName) throws SQLException(Code)(Java Doc) public int updateBlobTrigger(Connection conn, Trigger trigger) throws SQLException, IOException(Code)(Java Doc) public int updateCalendar(Connection conn, String calendarName, Calendar calendar) throws IOException, SQLException(Code)(Java Doc) public int updateCronTrigger(Connection conn, CronTrigger trigger) throws SQLException(Code)(Java Doc) public int updateJobData(Connection conn, JobDetail job) throws IOException, SQLException(Code)(Java Doc) public int updateJobDetail(Connection conn, JobDetail job) throws IOException, SQLException(Code)(Java Doc) public int updateSchedulerState(Connection conn, String instanceId, long checkInTime) throws SQLException(Code)(Java Doc) public int updateSimpleTrigger(Connection conn, SimpleTrigger trigger) throws SQLException(Code)(Java Doc) public int updateTrigger(Connection conn, Trigger trigger, String state, JobDetail jobDetail) throws SQLException, IOException(Code)(Java Doc) public int updateTriggerGroupStateFromOtherState(Connection conn, String groupName, String newState, String oldState) throws SQLException(Code)(Java Doc) public int updateTriggerGroupStateFromOtherStates(Connection conn, String groupName, String newState, String oldState1, String oldState2, String oldState3) throws SQLException(Code)(Java Doc) public int updateTriggerState(Connection conn, String triggerName, String groupName, String state) throws SQLException(Code)(Java Doc) public int updateTriggerStateFromOtherState(Connection conn, String triggerName, String groupName, String newState, String oldState) throws SQLException(Code)(Java Doc) public int updateTriggerStateFromOtherStates(Connection conn, String triggerName, String groupName, String newState, String oldState1, String oldState2, String oldState3) throws SQLException(Code)(Java Doc) public int updateTriggerStateFromOtherStatesBeforeTime(Connection conn, String newState, String oldState1, String oldState2, long time) throws SQLException(Code)(Java Doc) public int updateTriggerStatesForJob(Connection conn, String jobName, String groupName, String state) throws SQLException(Code)(Java Doc) public int updateTriggerStatesForJobFromOtherState(Connection conn, String jobName, String groupName, String state, String oldState) throws SQLException(Code)(Java Doc) public int updateTriggerStatesFromOtherStates(Connection conn, String newState, String oldState1, String oldState2) throws SQLException(Code)(Java Doc)
|
|
|