How to save image to database using Hibernate?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

Had anyone saved picture to database using Hibernate successfully?
Can hibernate proccess Blob data type ? I have a table that has a Blob field.(I am using MySQL). It can't save the image if I use the code :

Code:

PrintWriter pw=null;
      resp.setContentType("text/html;charset=gb2312");
         InputStream in=req.getInputStream(); 
         byte b[]=new byte[in.available()]; 
         int i=-1; 
         while((i=in.read())!=-1){ 
            in.read(b); 
            System.out.println("Get byte[]: "+i); 
         } 
         
try{
Session _session=HibernateUtil.currentSession(); 
         Transaction t=_session.beginTransaction(); 
         Buildingpicture bp=new Buildingpicture(); 
         bp.setPicture_memo("qijiashe upload"); 
         bp.setPicture_name("Lyopic"); 
   
         System.out.println("Get Picture : "+b.toString()); 
         bp.setPicture_file(Hibernate.createBlob(in)); 
                          
          _session.save(bp); 
          
          _session.flush(); 
            t.commit(); 

          HibernateUtil.closeSession();
          in.close(); 
          pw=resp.getWriter();
          pw.println("Sucess...");

It is a Servlet. I want to save a user's upload picture to database. But the picture can't be saved to MySQL. I can get the inputStream indeed.
Is there any error in my code?
Thks!

Kaneda · **Posted:** Mon Jul 12, 2004 9:36 am

I'm not quit sure but I think you must close the stream before saving it or using the size of the array (i) as second parameter.

regards

Olaf

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

I close the Stream after I save the Object.So I think it is not the problem.
Anyone save image to database successful? Help!

Kaneda · **Posted:** Tue Jul 13, 2004 7:59 am

I save a lot of snapshot to a postgres database, but instead of blobs I use byte arrays. Saving and reading works fine.

I think you have to close the stream before saving it. How else the EOF should be reached without setting the number of bytes to be stored?

MarcioLima · **Posted:** Fri Sep 03, 2004 11:05 am

Kaneda wrote:

I save a lot of snapshot to a postgres database, but instead of blobs I use byte arrays. Saving and reading works fine.

I think you have to close the stream before saving it. How else the EOF should be reached without setting the number of bytes to be stored?

Kaneda, can you give me a example or how to read a Blob.

anthony · **Posted:** Fri Sep 03, 2004 11:11 am

http://www.hibernate.org/73.html may help

octopus · **Posted:** Fri Sep 03, 2004 11:54 am

Quote:

works fine (in oracle, at least) providing the following property set

hibernate.jdbc.use_streams_for_binary = true
hibernate.jdbc.batch_size = 0

It maps blob sql type to byte[] java type.