Eclipse Community Forums: Newcomers » BLOB with Lazy fetching

Help

Home

Home » Newcomers » Newcomers » BLOB with Lazy fetching

Show: Today's Messages :: Show Polls :: Message Navigator

BLOB with Lazy fetching [message #917578]

Thu, 20 September 2012 08:05

Zoltan Levardy

Messages: 4
Registered: September 2012

Junior Member

Hi,

it looks like that my recommendation as LAZY does not work with binary things.

this is my column:

    @Basic(fetch=FetchType.LAZY)
    @Lob
    @Column(name="file_content")
    private byte[] fileContent;

Eclipselink 2.0.2 simply read it into memory, what is very slow. Database is Oracle 11R2. How can I make this working - preferably less code modification?

thx

Report message to a moderator

Re: BLOB with Lazy fetching [message #917675 is a reply to message #917578]

Thu, 20 September 2012 10:09

Zoltan Levardy

Messages: 4
Registered: September 2012

Junior Member

already tried to separate content blob into a FileContent object (table, where id_file, fileContent). Still readying huge file contents into memory.

this is new obejct:

public class FileContent extends AbstractItem implements JsonItem {

	@Id
	@Column(name = "id_file")
	private Long id;

	@Basic(fetch=FetchType.LAZY)
    @Lob
    @Column(name="content_data")
    private byte[] contentData;

...

reference for this in old place (File, where pk is ID):

	@JoinColumn(name = "id", insertable=false, updatable=false)
        @OneToOne(optional = true, cascade=CascadeType.ALL)
	private FileContent fileContent;

Hmm. any hints?

Report message to a moderator

Re: BLOB with Lazy fetching [message #917772 is a reply to message #917675]

Thu, 20 September 2012 12:23

Zoltan Levardy

Messages: 4
Registered: September 2012

Junior Member

if forcing more Fetch Lazy, then null pointer exceptions coming:

    @JoinColumn(name = "id", insertable=false, updatable=false)
    @OneToOne(optional = true, cascade=CascadeType.ALL),[b] fetch = FetchType.LAZY)[/b]
	private FileContent fileContent;

Report message to a moderator