OpenJPA1.2 - lazy load a BLOB

db2, jpa, jpql, openjpa

Solution

@Lob
@Basic(fetch=FetchType.LAZY)
private String payload;

Problem

I have a very simple JPA entity. It features some simple metadata fields, and ID and a large ~500kB-10MB payload String. ``` @Entity public class MyEntity{ @Id @GenerateValue(Strategy=GenerationType.IDENTITY) private long myEntityId; private String metaData1; .. private String metaDataN; @Lob private String payload; // large. ``` } Most of the time, I am not intersseted in loading in the payload, but simply query the metadata fields. Is there a way to load the payload lazy without creating a specific Entity that wrapps the payload and have a lazy load one-to-one relation with that one from my main entity? The whole thing is implemented using OpenJPA 1.2 and a DB2 backing database.

Original source