Easiest way to convert a Blob into a byte array

Question

what is the easiest way to convert a Blob into a byte array?I am using MYSQL and i want to convert a Blob datatype into a byte array.

Iam using java programming language:)

Answer 1

the mySql blob class has the following function :

blob.getBytes

use it like this:

//(assuming you have a ResultSet named RS) Blob blob = rs.getBlob("SomeDatabaseField");  int blobLength = (int) blob.length();   byte[] blobAsBytes = blob.getBytes(1, blobLength);  //release the blob and free up memory. (since JDBC 4.0) blob.free();