I need help in inserting a file in MySQL.
I would be really greatful, if u could attach piece of code, for doing it.
Hope to get a reply soon.
Thanks in advance.

I found the solution. Here i m sharing the code.

FileInputStream fis=new FileInputStream(file);
byte b[] = new byte[fis.available()];
fis.read(b);
java.sql.Blob bb = Hibernate.createBlob(b);
TblobForm tblob = new TblobForm();
tblob.setfiledata(bb);
tblob.setId(1);
fis.close();
session.save(tblob);

I have 2 field id and photo
id is of type integer
filedata is of type blob.

And to retrieve from the database:


TblobForm form = new TblobForm();
byte b[] = form.getFileData().getBytes(1,(int)form.getFileData().length());
java.io.FileOutputStream f = new java.io.FileOutputStream(filename);
f.write(b);


I hope this will help u all.