Java Utililty Methods SQL ResultSet Blob Read

Blob value = results.getBlob(parameterIndex);
if (results.wasNull()) {
    return null;
byte[] data = value.getBytes(0, (int) value.length());
value.free();
return data;

final Blob blob = rs.getBlob(ind);
if (blob == null) {
    return null;
final long len = blob.length();
if (len <= 0L) {
    return null;
if (blob.length() > Integer.MAX_VALUE) {
    throw new SQLException("BLOB exceeds Integer.MAX_VALUE in length; cannot be retrieved as byte array");
return blob.getBytes(1L, (int) len);

Blob dataAsBlob = rs.getBlob(col);
return dataAsBlob.getBytes(1, (int) dataAsBlob.length());

return readStreamToByteArray(rs.getBinaryStream(iColumn));

String strValueReturn = "";
Blob blob = result.getBlob(strField);
if (result.wasNull()) {
    strValueReturn = "";
} else {
    int length = (int) blob.length();
    if (length > 0)
        strValueReturn = new String(blob.getBytes(1, length));
...

ByteArrayOutputStream bos = null;
BufferedInputStream in = null;
try {
    bos = new ByteArrayOutputStream();
    in = new BufferedInputStream(rs.getBinaryStream(index));
    int noBytes;
    byte[] tmpBuffer = new byte[1024];
    while ((noBytes = in.read(tmpBuffer)) != -1) {
...

return null;

Blob clob = rs.getBlob(fieldName);
InputStream is = clob.getBinaryStream();
StringBuffer sb = new StringBuffer();
int readedBytes = 0;
int bufferSize = 4096;
do {
    byte[] bytes = new byte[bufferSize];
    readedBytes = is.read(bytes);
...

byte[] ret = null;
Blob blob = rs.getBlob(column);
if (blob != null) {
    long length = blob.length();
    if (length == 0) 
        ret = new byte[0];
    } else {
...