Lazy load byte[]

§upernova§oftware · **Posted:** Tue Jun 20, 2006 3:09 pm

I am using byte[] properties for binary objects as follows in PostgreSQL

Code:

   private byte[] file;
   @Basic(fetch=FetchType.LAZY)
   public byte[] getFile() { return file; }
   public void setFile(byte[] file) { this.file = file; }

I added the lazy fetch type when I started to see performace problems because this field is being included in the select, but this seems to be ignored.

Any advice would be greatly appreciated.

Arpit Patel · **Posted:** Tue Jun 20, 2006 3:22 pm

hi

why dont u store file on server itself . u just need to store its location in DB(i.e the relative path of file).

and yaa in mapping if u dont specify byte array as a blob than hibernate will treat that as tiny blob and u will get serialization exception. but in my opinion best way is store file on Server and store its location in database.

Regards
Arpit

§upernova§oftware · **Posted:** Tue Jun 20, 2006 3:27 pm

1. If I delete this row the file is automatically deleted.
2. If I back up the database this is automatically backed up.
3. If this is stored in the DB multible jboss instances can share this data.
4. Security is left to the db not the filesystem.

c_eric_ray · **Joined:** Wed Jul 26, 2006 11:06 am **Posts:** 11

go here for the answer.

http://forum.hibernate.org/viewtopic.php?t=962140

c_eric_ray · **Joined:** Wed Jul 26, 2006 11:06 am **Posts:** 11

See the bottom of this post for a few more details.

http://forum.hibernate.org/viewtopic.php?t=963507