org.quartz.impl.jdbcjobstore.DB2v7Delegate Maven / Gradle / Ivy
/*
* Copyright 2001-2009 Terracotta, Inc.
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may not
* use this file except in compliance with the License. You may obtain a copy
* of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*
*/
package org.quartz.impl.jdbcjobstore;
import java.io.ByteArrayOutputStream;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import org.quartz.spi.ClassLoadHelper;
import org.slf4j.Logger;
/**
* 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
* {@link PreparedStatement#setObject(int, java.lang.Object, int)}
* rather than {@link PreparedStatement#setBytes(int, byte[])}.
*
*
* @author Blair Jensen
*/
public class DB2v7Delegate extends StdJDBCDelegate {
public DB2v7Delegate(Logger logger, String tablePrefix, String schedName, String instanceId, ClassLoadHelper classLoadHelper) {
super(logger, tablePrefix, schedName, instanceId, classLoadHelper);
}
public DB2v7Delegate(Logger log, String tablePrefix, String schedName, String instanceId, ClassLoadHelper classLoadHelper,
Boolean useProperties) {
super(log, tablePrefix, schedName, instanceId, classLoadHelper, useProperties);
}
/**
* Sets the designated parameter to the byte array of the given
* ByteArrayOutputStream. Will set parameter value to null if the
* ByteArrayOutputStream is null.
* Wraps {@link PreparedStatement#setObject(int, java.lang.Object, int)} rather than
* {@link PreparedStatement#setBytes(int, byte[])} as required by the
* DB2 v7 database.
*/
@Override
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 given Java boolean value.
* This translates the boolean to 1/0 for true/false.
*/
@Override
protected void setBoolean(PreparedStatement ps, int index, boolean val) throws SQLException {
ps.setString(index, ((val) ? "1" : "0"));
}
}