Lazy Lob

sdanig · **Joined:** Mon Jan 16, 2006 4:33 am **Posts:** 11

Hibernate version: 3.1

Hibernate Annotations version: 3.1-b7

Annotated code:

Code:

@Entity( access = AccessType.FIELD )
public class Dog extends DomainObject {
   ...
   @Lob( optional = true )
   @Column( length = 131071 )
   private byte[] image;
   ...
}

It's my understanding that the fetch type defaults to lazy for Lobs (http://www.hibernate.org/hib_docs/ejb3-api/javax/persistence/Lob.html). However, looking at the generated SQL, the image is being fetched eagerly. Is this because it's a byte array? Would it be lazy for a java.sql.Blob? Would it still be eager if I were using a byte array and AccessType.PROPERTY on the entity?

Thanks!

emmanuel · **Posted:** Tue Jan 17, 2006 7:17 pm

In the next release, a LAZY Lob on enhanced class should do the trick.

emmanuel · **Posted:** Tue Jan 17, 2006 7:18 pm

I'm astonished the current one does not though

sdanig · **Joined:** Mon Jan 16, 2006 4:33 am **Posts:** 11

emmanuel wrote:

In the next release, a LAZY Lob on enhanced class should do the trick.

Thanks. Is there an issue in JIRA that I can keep track of?

emmanuel · **Posted:** Tue Jan 17, 2006 10:09 pm

This is already done in CVS

sdanig · **Joined:** Mon Jan 16, 2006 4:33 am **Posts:** 11

OK, thanks!

javatwo · **Joined:** Tue Sep 13, 2005 2:01 am **Posts:** 137

when will this (BLOB/CLOB lazy fetching) be available as release? I use a lot of BLOB for pictures. It is very slow because of fetching a lot of images from database.

emmanuel · **Posted:** Mon Jan 23, 2006 6:00 am

it is

javatwo · **Joined:** Tue Sep 13, 2005 2:01 am **Posts:** 137

Is it available for download? thanks!

emmanuel · **Posted:** Wed Jan 25, 2006 2:32 pm

did you try to look at it?

sdanig · **Joined:** Mon Jan 16, 2006 4:33 am **Posts:** 11

javatwo - he's probably referring to annotations 3.1-beta8, which just came out