Lazy blob is eagerly fetched

steveb · **Joined:** Mon Apr 03, 2006 10:44 pm **Posts:** 2

I have a blob which I want to be fetched lazily however the sql logging shows that it is being fetched in one go with the other attributes.

Code:

    /**
     * The actual data for the attachment.
     */
    @Lob
    @Basic(fetch = FetchType.LAZY)
    @Column(name = "DATA")
    private Blob data;

Should this work as I expect? This was tested with an in-memory hsqldb but it will eventually be used to store very large files in mysql.

Versions:
- hibernate 3.2.0-cr1
- hibernate-annotations 3.1beta9
- hibernate-entitymanager 3.1beta7

cheers

lhoriman · **Joined:** Mon Sep 15, 2003 6:28 pm **Posts:** 26

I just wanted to inject a comment that may save you some time later:

If you're working with Blobs, you'll solve a lot of problems by making the field lazy loaded. The bytecode instrumentation is easy to set up. In particular, you'll find that you can now cache the blob-containing entity.

emmanuel · **Posted:** Tue Apr 04, 2006 4:19 am

Plus a Log is lazy as per the JDBC spec (read the Javadoc)