Java Utililty Methods SQL Blob

float[] ret = null;
try {
    int blen = (int) blob.length();
    int nbytes = Float.SIZE / 8;
    int olen = (int) (blen / nbytes);
    ret = new float[olen];
    DataInputStream dis = new DataInputStream(blob.getBinaryStream());
    for (int o = 0; o < olen; o++) {
...

byte[] bytes = null;
if (blob == null)
    return bytes;
try {
    bytes = blob.getBytes(1, (int) blob.length());
} catch (SQLException e) {
    e.printStackTrace();
return bytes;

BufferedInputStream is = null;
try {
    is = new BufferedInputStream(blob.getBinaryStream());
    byte[] bytes = new byte[(int) blob.length()];
    int len = bytes.length;
    int offset = 0;
    int read = 0;
    while (offset < len && (read = is.read(bytes, offset, len - offset)) >= 0) {
...

BufferedReader br = new BufferedReader(new InputStreamReader(blob.getBinaryStream()));
StringBuffer sb = new StringBuffer();
String line;
while ((line = br.readLine()) != null) {
    sb.append(line);
return sb.toString();

if (isJPEGImage(image)) {
    return "jpg";
} else if (isPNGImage(image)) {
    return "png";
} else if (isGIFImage(image)) {
    return "gif";
return "png";
...

ByteArrayOutputStream bout = new ByteArrayOutputStream();
InputStream in = b.getBinaryStream();
byte[] buffer = new byte[10240];
int len = 0;
while ((len = in.read(buffer, 0, 10240)) != -1) {
    bout.write(buffer, 0, len);
bout.flush();
...

ByteArrayOutputStream bout = new ByteArrayOutputStream();
InputStream in = b.getBinaryStream();
byte[] buffer = new byte[10240];
int len = 0;
while ((len = in.read(buffer, 0, 10240)) != -1) {
    bout.write(buffer, 0, len);
return bout.toByteArray();
...

if (isOracleServer(conn))
    return "BLOB";
return "LONGBLOB";

BufferedReader br = new BufferedReader(new InputStreamReader(blob.getBinaryStream(), "utf-8"));
String s = null;
StringBuilder sb = new StringBuilder();
while ((s = br.readLine()) != null) {
    sb.append(s);
return sb.toString();

String s = null;
InputStream is = null;
if (blob != null) {
    is = blob.getBinaryStream();
if (is != null) {
    BufferedInputStream bis = new BufferedInputStream(is, 4096);
    StringBuffer sb = new StringBuffer();
...