Hi,

I wantto store an uploaded image in the DB as a BLOB.
The image data comes as org.apache.struts.upload.FormFile.

In my presistance class I have a property of type
java.sql.Blob mappd to blob in DB.

So, what do I need to do in order to store the image?

I can get byte array from the form file. But which Blob to create in order to pass to my presistance class propery?

MySQL driver has implementation of Blob I don't see any public constructor.

Am I missing something?
Please help.

Thanks in advance,
Igor

Hibernate.createBlob()

I've created one Blob object in my persistance object through Hibernate.createBlob(). but after I save this persistance object, there is no data in the MEDIUMBLOB field. Could you help me?


thanks in advance.

bruni

This works with PostgreSQL and OID field (BLOB)

String fileType = null;
String filename = null;
InputStream data = null;
int FileLength = 0;
java.sql.Blob fileData = null;

if (!theFile.isMissing()) {
fileType = theFile.getContentType();
filename = theFile.getFileName();
FileLength = theFile.getSize();
// create a uniuque name
java.io.File tempfile = java.io.File.createTempFile("" + Math.random(),null);
//tempfile = theAsset.getTempFilePath() + Math.random();
// save the file so that we can create an input stream with it.
theFile.saveAs(tempfile.getAbsolutePath());

fileData = Hibernate.createBlob(new FileInputStream(tempfile),FileLength);
SessionFactory sessions = ds.buildSessionFactory();
Session sess = sessions.openSession();
Transaction tx = sess.beginTransaction();
Ad obj_ad = new Ad();
obj_ad.setFileData(fileData);
obj_ad.setFileType(fileType);
obj_ad.setFileName(filename);
obj_ad.setFileLength(new Long(FileLength));
sess.save(obj_ad);
sess.flush();
tx.commit();
}