001    package railo.runtime.query.caster;
002    
003    import java.io.IOException;
004    import java.io.Reader;
005    import java.sql.ResultSet;
006    import java.sql.SQLException;
007    import java.util.TimeZone;
008    
009    import railo.commons.io.IOUtil;
010    
011    public class ClobCast implements Cast {
012    
013            public Object toCFType(TimeZone tz, int type, ResultSet rst, int columnIndex) throws SQLException, IOException {
014                    //IOUtil.toString(rst.getClob(columnIndex).getCharacterStream())
015                    
016                    Reader reader = null;
017                    try {
018                            reader = rst.getCharacterStream( columnIndex );
019                            if(reader==null) return null;
020                            return IOUtil.toString(reader);
021                    }
022                    finally {
023                            IOUtil.closeEL(reader);
024                    }
025            }
026    
027    }