How do you Stream an image into a database using Hibernate?

Question

Pretty simple question with almost no answers on the web. I am using byte[] as my object. Currently I am reading the entire image into memory and then writing it. Very simple.

    @Column(name = "FILE_DATA")
private byte[] fileData;

I want to Stream it in. So I guess I need to use inputStream, but hibernate does not like that.

How do I set this up?

EDIT:

I tried this but got a -314 db2 error:

Blob b = null;
        try {
            Proxy proxy = new Proxy(Proxy.Type.HTTP, new InetSocketAddress("proxy.com", 80));
            URL urls = new URL(url);
            URLConnection conn = urls.openConnection(proxy);
            b = new BlobImpl(conn.getInputStream(), conn.getContentLength());
        } catch (Exception e) {
            e.printStackTrace();
        }

        att.setFileData(b);
        this.theDao.save(att);

Ahhhh...all this time, I was assuming that the file was local. This is a great question, but I think you need to flesh it out more. Try including a simple bare-bones method. Don't worry about catching exceptions. — Randy Stegbauer
– Randy Stegbauer, Commented Apr 24, 2012 at 15:14
As a test, can conn.getInputStream() be used to store the file on the local file system? — Randy Stegbauer
– Randy Stegbauer, Commented Apr 24, 2012 at 15:17

Shehzad · Accepted Answer · 2012-04-20 18:37:26Z

2

You can use Blob data type for inserting and fetching the images from database. It wil also provide you the option of Binary input stream. Just Use your db field as blob and create a blob ojbect instead of byte array.

b.getBinaryStream()

Also you can create Blob from bytes[]

Hibernate.createBlob(bytes);

And the simplest solution Saving on the hard drive and keeping information about the image on database.

answered Apr 20, 2012 at 18:37

Shehzad

2,95219 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

markthegrea Over a year ago

So how do I set up the column?

Shehzad Over a year ago

'@Column( name = "FILE_DATA" ) @Lob(type = LobType.BLOB)'

markthegrea Over a year ago

You are giving me just enough to make me want more. Is there some actual code? To create a blob, you need the content length. how do I get that with a stream? Do I have to read the stream first? If so, this is not helping.

Marko Topolnik Over a year ago

You don't have to read the stream. You can use File.length().

markthegrea Over a year ago

I tried this and got a -317. I believe this might work if DB2 was set up correctly.

|

Eugene Retunsky · Accepted Answer · 2012-04-20 18:19:53Z

0

One of possible solutions is to keep filenames (URLs) in the databases and stream data from the disk (network resources) and stream them.

I would prefer this approach for web - when you just return an URL and it's handled by browser and Apache/Nginx (so you don't have to worry about streaming at all).

answered Apr 20, 2012 at 18:19

Eugene Retunsky

13.2k5 gold badges54 silver badges55 bronze badges

1 Comment

markthegrea Over a year ago

This is the answer that is all over the web, but for some of us, it has been decided to save it to a database. This answer does not answer the question asked.

Randy Stegbauer · Accepted Answer · 2012-04-23 15:08:59Z

-1

I'm not sure I understand what you mean by "hibernate does not like that"?

Here's how simple it can be to define.

@Entity Photo {
    @Id @GeneratedValue
    private Long id = null;

    private String filename = null;

    @Lob
    private byte[] bytes = null;
    }

Then to load the data into the object...

String filename = // Where ever this comes from...
File file = new File(filename);
InputStream is = new FileInputStream(file);

Photo photo = new Photo();
photo.setFilename(filename);

// Create and fill the byte array from the file.
byte[] bytes = new byte[(int) file.length()];
is.read(bytes);
photo.setBytes(bytes);

Then eventually tell Hibernate to save it in the database.

session.saveOrUpdate(photo);

answered Apr 23, 2012 at 15:08

Randy Stegbauer

1,0942 gold badges11 silver badges26 bronze badges

2 Comments

markthegrea Over a year ago

This is not streaming. This is reading into memory and then saving it. I need to open the stream, and then send it to the database and save it. I don't want the memory impact of loading lots of images...

Randy Stegbauer Over a year ago

Oh. You want to stream it directly into the database, outside of Hibernate? You're right, this isn't that at all. However, java.sql.Blob (docs.oracle.com/javase/1.4.2/docs/api/java/sql/Blob.html) does have methods that might work for you.

Collectives™ on Stack Overflow

How do you Stream an image into a database using Hibernate?

3 Answers 3

6 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related