001/**
002 *
003 * Copyright (c) 2014, the Railo Company Ltd. All rights reserved.
004 *
005 * This library is free software; you can redistribute it and/or
006 * modify it under the terms of the GNU Lesser General Public
007 * License as published by the Free Software Foundation; either 
008 * version 2.1 of the License, or (at your option) any later version.
009 * 
010 * This library is distributed in the hope that it will be useful,
011 * but WITHOUT ANY WARRANTY; without even the implied warranty of
012 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
013 * Lesser General Public License for more details.
014 * 
015 * You should have received a copy of the GNU Lesser General Public 
016 * License along with this library.  If not, see <http://www.gnu.org/licenses/>.
017 * 
018 **/
019package lucee.runtime.query.caster;
020
021import java.io.IOException;
022import java.io.Reader;
023import java.sql.ResultSet;
024import java.sql.SQLException;
025import java.util.TimeZone;
026
027import lucee.commons.io.IOUtil;
028
029public class ClobCast implements Cast {
030
031        public Object toCFType(TimeZone tz, int type, ResultSet rst, int columnIndex) throws SQLException, IOException {
032                //IOUtil.toString(rst.getClob(columnIndex).getCharacterStream())
033                
034                Reader reader = null;
035                try {
036                        reader = rst.getCharacterStream( columnIndex );
037                        if(reader==null) return null;
038                        return IOUtil.toString(reader);
039                }
040                finally {
041                        IOUtil.closeEL(reader);
042                }
043        }
044
045}