/** * Returns the bytes from a result set * * @param res The ResultSet to read from * @param columnName The name of the column to read from * @return The byte value from the column */ public byte[] getBytesFromClob(Clob clob) { // read the bytes from an oracle blob // oracle.sql.CLOB clob = ((OracleResultSet) res).getBLOB(columnName); try { return ValueExchange.getByteArrayFromClob(clob); } catch (SQLException e) { e.printStackTrace(); return null; } }
/** * Returns the bytes from a result set * * @param res The ResultSet to read from * @param columnName The name of the column to read from * @return The byte value from the column */ public String getStringFromClob(Clob clob) { // read the bytes from an oracle blob // oracle.sql.CLOB clob = ((OracleResultSet) res).getBLOB(columnName); try { return ValueExchange.getStringFromClob(clob); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } }