How does Hibernate handle Blob?

Question

I've got a table with the following structure:

int id | blob file_to_store | int version

This is how my domain works:

@Entity
@Table(name = "FileToStore")
public class FileToStore{

    @Id
    @Column(name = "id")
    private int Id;

    @Column(name = "version")
    private int version;

    @Column(name = "file_to_store")
    @Lob
    private Blob file;

    //gets and sets
}

Sometimes I just need a file version. Like this :

FileToStore fileToStore=FileToStoreService.get(id);
return fileToStore.getVersion();

Is that going to work fast or I have to write another SQL query to take version field only to avoid loading file? Oracle documentation says

Blob object contains a logical pointer to the SQL BLOB data rather than the data itself

Community · Accepted Answer · 2017-05-23 11:59:38Z

0

I guess your question boils down to wether Hibernate fetches lobs lazily. And based on discussion here Spring, Hibernate, Blob lazy loading I would advise to test it on your evnironment.

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Apr 21, 2016 at 8:24

valentyn.vak

312 bronze badges

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

Collectives™ on Stack Overflow

How does Hibernate handle Blob?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related