org.quartz.impl.jdbcjobstore.DB2v7Delegate Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of quartz Show documentation
There is a newer version: 2.5.0
/* 
 * 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"));
    }
    
}