Re: access a BLOB coloumn from a CMP EJB

[Jeremy Boynes]

Stefan Schmidt wrote:
Gianny, Jeremy,
I got it! Apparently, the problem was on my site. I actually loaded the 
Blobs (images) directly via the PhpMyAdmin Gui (there is a file upload 
function) and then tried to access these blob fields via the EJB. To dig 
into my problem I tried the org.openejb.test.entity.cmp2.StorageTests on 
MySQL and this worked. So I ended up updating my blob fields via the EJB 
(loading the files via the EJB rather than PhpMyAdmin ) and  now it 
works! Seems like the PhpMyAdmin does something with the blob that Java 
doesn't like...


I think its the other way around - I am guessing that PhpMyAdmin is 
inserting the bytes directly but when you use the EJB it is Serializing 
the array and writing the serialized data stream.

When the EJB tries to read the bytes inserted by PhpMyAdmin it gets the 
raw data rather than the bytes for ObjectInputStream and is raising an 
error.

I think this is a bug as we should be able to support the raw data 
format correctly - we need to play nice with other applications.

--
Jeremy