Conversion Blob to Byte Array

[Abiodun Adisa]

I am trying to convert a Blob into a Byte array but sometimes when i run the application I get this exception

Blob may not be manipulated from creating session

this is the way i am converting Blob to byte Array

Blob blob = employerxLogo.getImageByte();
byte[] tempByte = null;
try {
[B]int tempInt = (int) blob.length();
tempByte = blob.getBytes(1, tempInt);[/B]} catch (SQLException e) {
// TODO Auto-generated catch block
throw new FacesException("Error");
}

Is there another way to convert a java.sql.Blob into a Byte array

[Parham Emami]

Hi,
I've used bobs with the following piece of code. You could adapt it to what you require:

public void setBlob(PreparedStatement pstmt, int index, Object obj) throws DAOException, SQLException {
ByteArrayOutputStream b_out = new ByteArrayOutputStream();
try {
ObjectOutputStream o_out = new ObjectOutputStream(b_out);
o_out.writeObject(obj);
o_out.close();
} catch (IOException e) {
log.error(e);
throw new DAOException(e);
}
byte[] b = b_out.toByteArray();
ByteArrayInputStream b_in = new ByteArrayInputStream(b);


pstmt.setBinaryStream(index, b_in, b.length);
}

this method could be used by your insert or update method like this:
setBlob(pstmt1, 2, myObject);

Cheers
Parham