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}