BLOB in Hibernate

Question

I need to store images in a database, so I decided with a table design to accommodate it. The table design is

FILE_ID INT,
FILE_NAME VARCHAR(200),
FILE_CONTENTS BLOB.

I'm using Oracle database. I think Oracle supports BLOB upto 2 GB of storage. I'm using hibernate as the JPA provider. The model class is annotated with Hibernate annotations where the blob field is with the byte[] (byte array type). If the image size is with few megabytes then the hibernate can bring the contents into the memory. If the size of the contents is more than the size of the jvm, how is hibernate accomplishing to bring the contents into the memory?

can you post the line which stores the image into DB , how are you saving it , converting in to byte array or what ?? — Hussain Akhtar Wahid 'Ghouri'
– Hussain Akhtar Wahid 'Ghouri', Commented Jan 25, 2013 at 8:46

Andremoniy · Accepted Answer · 2013-01-25 07:32:48Z

2

Do not use byte arrays for these purposes. Use sql Blob type, and work with it using streams.

answered Jan 25, 2013 at 7:32

Andremoniy

35.2k25 gold badges143 silver badges259 bronze badges

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

1 Comment

vvekselva Over a year ago

Hi can you suggest me with the references

heikkim · Accepted Answer · 2013-01-25 07:26:58Z

1

Hibernate is not going to be able to pull the contents to memory because there will be not enough memory where to pull it. You will end up with an OutOfMemoryException.

answered Jan 25, 2013 at 7:26

heikkim

2,9852 gold badges25 silver badges35 bronze badges

Collectives™ on Stack Overflow

BLOB in Hibernate

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related