01: /*
02: *
03: * The DbUnit Database Testing Framework
04: * Copyright (C)2002-2004, DbUnit.org
05: *
06: * This library is free software; you can redistribute it and/or
07: * modify it under the terms of the GNU Lesser General Public
08: * License as published by the Free Software Foundation; either
09: * version 2.1 of the License, or (at your option) any later version.
10: *
11: * This library is distributed in the hope that it will be useful,
12: * but WITHOUT ANY WARRANTY; without even the implied warranty of
13: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14: * Lesser General Public License for more details.
15: *
16: * You should have received a copy of the GNU Lesser General Public
17: * License along with this library; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19: *
20: */
21:
22: package org.dbunit.dataset.datatype;
23:
24: import org.slf4j.Logger;
25: import org.slf4j.LoggerFactory;
26:
27: import java.sql.PreparedStatement;
28: import java.sql.ResultSet;
29: import java.sql.SQLException;
30: import java.sql.Types;
31: import java.sql.Blob;
32:
33: /**
34: * @author Manuel Laflamme
35: * @version $Revision: 554 $
36: * @since Jan 12, 2004
37: */
38: public class BlobDataType extends BytesDataType {
39:
40: /**
41: * Logger for this class
42: */
43: private static final Logger logger = LoggerFactory
44: .getLogger(BlobDataType.class);
45:
46: public BlobDataType() {
47: super ("BLOB", Types.BLOB);
48: }
49:
50: public Object getSqlValue(int column, ResultSet resultSet)
51: throws SQLException, TypeCastException {
52: logger.debug("getSqlValue(column=" + column + ", resultSet="
53: + resultSet + ") - start");
54:
55: Blob value = resultSet.getBlob(column);
56: if (value == null || resultSet.wasNull()) {
57: return null;
58: }
59: return typeCast(value);
60: }
61:
62: public void setSqlValue(Object value, int column,
63: PreparedStatement statement) throws SQLException,
64: TypeCastException {
65: logger.debug("setSqlValue(value=" + value + ", column="
66: + column + ", statement=" + statement + ") - start");
67:
68: statement.setObject(column, typeCast(value),
69: DataType.LONGVARBINARY.getSqlType());
70: }
71: }
|