public String clobToString(Clob cl) throws IOException, SQLException {
        if (cl == null){
            return  "";
        }
        
        byte[] thedata=new byte[(int)cl.length()];
        
        InputStream is=cl.getAsciiStream();
        is.read(thedata);
        return new String(thedata);
    }