Hi,

I'm trying to store binary data to OracleDB (10gR2) using hibernate 3.1.3.

I've googled a lot, but everything with problems:
1) http://hansonchar.blogspot.com/2005/06/ ... te-in.html
but doesn't work for the big data
2) http://www.hibernate.org/56.html but ending with error:
org.hibernate.MappingException: Could not determine type for: hibernate.ByteArrayBlobType, for columns: [org.hibernate.mapping.Column(DATA)]

And it makes me crazy !!!

Please could someone point me to final solution ???

Thanks a lot.

Pat

I'm finding the same results...

I've looked at the following link also, and think I have a solution...
http://www.hibernate.org/56.html

I'll update if I get it working...

Just and FYI, I'm using a struts from to upload the file from the client.

Mapped my Oracle table (two columns) the primary key and the blob to the hdb.xml file. Created a POJO of the mapped table with getters and setter for the two columns. This is what I have in my struts action class...

UploadForm uploadForm = (UploadForm)form;
FormFile file = uploadForm.getScannedApp();

factory = (SessionFactory) servlet.getServletContext().getAttribute(HibernatePlugin.KEY_NAME);

session = factory.openSession();
tx = session.beginTransaction();

ScannedApp app = new ScannedApp();
app.setScannedFile(Hibernate.createBlob(file.getInputStream()));

session.save(app);
tx.commit();
session.close();

hi all,
I tried to insert BMP file its size = 2.5 MB , but it failed and throw IO Exception, but it done with no exception in JPEG files

I want to know also, how to retrieve data stored in BLOB?