How to use

PointbaseDelegate

in

org.quartz.impl.jdbcjobstore

throws ClassNotFoundException, IOException, SQLException {
if (canUseProperties()) {
  byte data[] = rs.getBytes(colName);
  if(data == null) {
return getObjectFromBlob(rs, colName);

throws IOException, SQLException {
ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(INSERT_JOB_DETAIL));
  ps.setString(1, job.getKey().getName());
  ps.setString(2, job.getKey().getGroup());
  ps.setString(3, job.getDescription());
  ps.setString(4, job.getJobClass().getName());
  setBoolean(ps, 5, job.isDurable());
  setBoolean(ps, 6, job.isConcurrentExectionDisallowed());
  setBoolean(ps, 7, job.isPersistJobDataAfterExecution());
  setBoolean(ps, 8, job.requestsRecovery());
  ps.setBinaryStream(9, bais, len);
  closeStatement(ps);

  Calendar calendar) throws IOException, SQLException {
ByteArrayOutputStream baos = serializeObject(calendar);
byte buf[] = baos.toByteArray();
ByteArrayInputStream bais = new ByteArrayInputStream(buf);
  ps = conn.prepareStatement(rtp(UPDATE_CALENDAR));
  ps.setBinaryStream(1, bais, buf.length);
  ps.setString(2, calendarName);
  closeStatement(ps);

/**
 * <p>
 * Update the job data map for the given job.
 * </p>
 * 
 * @param conn
 *          the DB Connection
 * @param job
 *          the job to update
 * @return the number of rows updated
 */
@Override           
public int updateJobData(Connection conn, JobDetail job)
  throws IOException, SQLException {
  //log.debug( "Updating Job Data for Job " + job );
  ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
  int len = baos.toByteArray().length;
  ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  PreparedStatement ps = null;
  try {
    ps = conn.prepareStatement(rtp(UPDATE_JOB_DATA));
    ps.setBinaryStream(1, bais, len);
    ps.setString(2, job.getKey().getName());
    ps.setString(3, job.getKey().getGroup());
    return ps.executeUpdate();
  } finally {
    closeStatement(ps);
  }
}

  JobDetail jobDetail) throws SQLException, IOException {
ByteArrayOutputStream baos = serializeJobData(trigger.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(INSERT_TRIGGER));
  ps.setString(1, trigger.getKey().getName());
  ps.setString(2, trigger.getKey().getGroup());
  ps.setString(8, state);
  TriggerPersistenceDelegate tDel = findTriggerPersistenceDelegate(trigger);
    insertBlobTrigger(conn, trigger);
  else
    tDel.insertExtendedTriggerProperties(conn, trigger, state, jobDetail);
  closeStatement(ps);

  JobDetail jobDetail) throws SQLException, IOException {
ByteArrayOutputStream baos = serializeJobData(trigger.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(UPDATE_TRIGGER));
  ps.setString(6, state);
  TriggerPersistenceDelegate tDel = findTriggerPersistenceDelegate(trigger);
    updateBlobTrigger(conn, trigger);
  else
    tDel.updateExtendedTriggerProperties(conn, trigger, state, jobDetail);
  closeStatement(ps);

/**
 * <p>
 * Update the job data map for the given job.
 * </p>
 * 
 * @param conn
 *          the DB Connection
 * @param job
 *          the job to update
 * @return the number of rows updated
 */
@Override           
public int updateJobData(Connection conn, JobDetail job)
  throws IOException, SQLException {
  //log.debug( "Updating Job Data for Job " + job );
  ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
  int len = baos.toByteArray().length;
  ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  PreparedStatement ps = null;
  try {
    ps = conn.prepareStatement(rtp(UPDATE_JOB_DATA));
    ps.setBinaryStream(1, bais, len);
    ps.setString(2, job.getKey().getName());
    ps.setString(3, job.getKey().getGroup());
    return ps.executeUpdate();
  } finally {
    closeStatement(ps);
  }
}

  JobDetail jobDetail) throws SQLException, IOException {
ByteArrayOutputStream baos = serializeJobData(trigger.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(INSERT_TRIGGER));
  ps.setString(1, trigger.getKey().getName());
  ps.setString(2, trigger.getKey().getGroup());
  ps.setString(8, state);
  TriggerPersistenceDelegate tDel = findTriggerPersistenceDelegate(trigger);
    insertBlobTrigger(conn, trigger);
  else
    tDel.insertExtendedTriggerProperties(conn, trigger, state, jobDetail);
  closeStatement(ps);

  JobDetail jobDetail) throws SQLException, IOException {
ByteArrayOutputStream baos = serializeJobData(trigger.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(UPDATE_TRIGGER));
  ps.setString(6, state);
  TriggerPersistenceDelegate tDel = findTriggerPersistenceDelegate(trigger);
    updateBlobTrigger(conn, trigger);
  else
    tDel.updateExtendedTriggerProperties(conn, trigger, state, jobDetail);
  closeStatement(ps);

throws IOException, SQLException {
ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(INSERT_JOB_DETAIL));
  ps.setString(1, job.getKey().getName());
  ps.setString(2, job.getKey().getGroup());
  ps.setString(3, job.getDescription());
  ps.setString(4, job.getJobClass().getName());
  setBoolean(ps, 5, job.isDurable());
  setBoolean(ps, 6, job.isConcurrentExectionDisallowed());
  setBoolean(ps, 7, job.isPersistJobDataAfterExecution());
  setBoolean(ps, 8, job.requestsRecovery());
  ps.setBinaryStream(9, bais, len);
  closeStatement(ps);

  Calendar calendar) throws IOException, SQLException {
ByteArrayOutputStream baos = serializeObject(calendar);
byte buf[] = baos.toByteArray();
ByteArrayInputStream bais = new ByteArrayInputStream(buf);
  ps = conn.prepareStatement(rtp(UPDATE_CALENDAR));
  ps.setBinaryStream(1, bais, buf.length);
  ps.setString(2, calendarName);
  closeStatement(ps);

/**
 * <p>
 * Update the job data map for the given job.
 * </p>
 * 
 * @param conn
 *          the DB Connection
 * @param job
 *          the job to update
 * @return the number of rows updated
 */
public int updateJobData(Connection conn, JobDetail job)
  throws IOException, SQLException {
  //log.debug( "Updating Job Data for Job " + job );
  ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
  int len = baos.toByteArray().length;
  ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  PreparedStatement ps = null;
  try {
    ps = conn.prepareStatement(rtp(UPDATE_JOB_DATA));
    ps.setBinaryStream(1, bais, len);
    ps.setString(2, job.getName());
    ps.setString(3, job.getGroup());
    return ps.executeUpdate();
  } finally {
    closeStatement(ps);
  }
}

throws ClassNotFoundException, IOException, SQLException {
if (canUseProperties()) {
  byte data[] = rs.getBytes(colName);
  if(data == null) {
return getObjectFromBlob(rs, colName);

throws IOException, SQLException {
ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(UPDATE_JOB_DETAIL));
  ps.setString(1, job.getDescription());
  ps.setString(2, job.getJobClass().getName());
  setBoolean(ps, 3, job.isDurable());
  setBoolean(ps, 4, job.isConcurrentExectionDisallowed());
  setBoolean(ps, 5, job.isPersistJobDataAfterExecution());
  setBoolean(ps, 6, job.requestsRecovery());
  ps.setBinaryStream(7, bais, len);
  ps.setString(8, job.getKey().getName());
  closeStatement(ps);

ByteArrayOutputStream baos = serializeObject(calendar);
byte buf[] = baos.toByteArray();
ByteArrayInputStream bais = new ByteArrayInputStream(buf);
  ps = conn.prepareStatement(rtp(INSERT_CALENDAR));
  ps.setString(1, calendarName);
  ps.setBinaryStream(2, bais, buf.length);
  closeStatement(ps);

/**
 * <p>
 * Update the job data map for the given job.
 * </p>
 * 
 * @param conn
 *          the DB Connection
 * @param job
 *          the job to update
 * @return the number of rows updated
 */
public int updateJobData(Connection conn, JobDetail job)
  throws IOException, SQLException {
  //log.debug( "Updating Job Data for Job " + job );
  ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
  int len = baos.toByteArray().length;
  ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  PreparedStatement ps = null;
  try {
    ps = conn.prepareStatement(rtp(UPDATE_JOB_DATA));
    ps.setBinaryStream(1, bais, len);
    ps.setString(2, job.getName());
    ps.setString(3, job.getGroup());
    return ps.executeUpdate();
  } finally {
    closeStatement(ps);
  }
}

throws ClassNotFoundException, IOException, SQLException {
if (canUseProperties()) {
  byte data[] = rs.getBytes(colName);
  if(data == null) {
return getObjectFromBlob(rs, colName);

throws IOException, SQLException {
ByteArrayOutputStream baos = serializeJobData(job.getJobDataMap());
int len = baos.toByteArray().length;
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
  ps = conn.prepareStatement(rtp(UPDATE_JOB_DETAIL));
  ps.setString(1, job.getDescription());
  ps.setString(2, job.getJobClass().getName());
  setBoolean(ps, 3, job.isDurable());
  setBoolean(ps, 4, job.isConcurrentExectionDisallowed());
  setBoolean(ps, 5, job.isPersistJobDataAfterExecution());
  setBoolean(ps, 6, job.requestsRecovery());
  ps.setBinaryStream(7, bais, len);
  ps.setString(8, job.getKey().getName());
  closeStatement(ps);

ByteArrayOutputStream baos = serializeObject(calendar);
byte buf[] = baos.toByteArray();
ByteArrayInputStream bais = new ByteArrayInputStream(buf);
  ps = conn.prepareStatement(rtp(INSERT_CALENDAR));
  ps.setString(1, calendarName);
  ps.setBinaryStream(2, bais, buf.length);
  closeStatement(ps);

throws ClassNotFoundException, IOException, SQLException {
if (canUseProperties()) {
  byte data[] = rs.getBytes(colName);
  if(data == null) {
return getObjectFromBlob(rs, colName);