io.logspace.agent.shaded.quartz.impl.jdbcjobstore.PostgreSQLDelegate 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 io.logspace.agent.shaded.quartz.impl.jdbcjobstore;
import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.ObjectInputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import io.logspace.agent.shaded.quartz.spi.ClassLoadHelper;
import org.slf4j.Logger;
/**
*
* This is a driver delegate for the PostgreSQL JDBC driver.
*
*
* @author Jeffrey Wescott
*/
public class PostgreSQLDelegate extends StdJDBCDelegate {
//---------------------------------------------------------------------------
// protected methods that can be overridden by subclasses
//---------------------------------------------------------------------------
/**
*
* This method should be overridden by any delegate subclasses that need
* special handling for BLOBs. The default implementation uses standard
* JDBC java.sql.Blob operations.
*
*
* @param rs
* the result set, already queued to the correct row
* @param colName
* the column name for the BLOB
* @return the deserialized Object from the ResultSet BLOB
* @throws ClassNotFoundException
* if a class found during deserialization cannot be found
* @throws IOException
* if deserialization causes an error
*/
@Override
protected Object getObjectFromBlob(ResultSet rs, String colName)
throws ClassNotFoundException, IOException, SQLException {
InputStream binaryInput = null;
byte[] bytes = rs.getBytes(colName);
Object obj = null;
if(bytes != null && bytes.length != 0) {
binaryInput = new ByteArrayInputStream(bytes);
ObjectInputStream in = new ObjectInputStream(binaryInput);
try {
obj = in.readObject();
} finally {
in.close();
}
}
return obj;
}
@Override
protected Object getJobDataFromBlob(ResultSet rs, String colName)
throws ClassNotFoundException, IOException, SQLException {
if (canUseProperties()) {
InputStream binaryInput = null;
byte[] bytes = rs.getBytes(colName);
if(bytes == null || bytes.length == 0) {
return null;
}
binaryInput = new ByteArrayInputStream(bytes);
return binaryInput;
}
return getObjectFromBlob(rs, colName);
}
}
// EOF