clobToString

    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);    }