Hibernate Community • View topic - PostgreSQL updating oid content by chunks.

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

PostgreSQL updating oid content by chunks.

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

danny.lesnik

Post subject: PostgreSQL updating oid content by chunks.

Posted: Mon Nov 22, 2010 4:01 am

Newbie

Joined: Mon Nov 22, 2010 3:41 am
Posts: 3

Hello,
I have the Web Service method which uploads 100 Mb movie file by 10K chunks.

Code:

public void addFileChunk(Long fileId, byte[] buffer);

I need to store this file in database,

If I were not using Hibernate, I would use the following code which appends each chunk to the end of the LargeObject.

Code:

LargeObject largeObject = largeObjectManager.Open(fileId, LargeObjectManager.READWRITE);
                    int size = largeObject.Size();
                    largeObject.Seek(size);
                    largeObject.Write(buffer);
                    largeObject.Close();

I'm curious how can I achieve the same functionality using Hibernate persistence objects?
What might be correct methodology to store files by chunk in database?

Top

danny.lesnik

Post subject: Re: PostgreSQL updating oid content by chunks.

Posted: Tue Nov 23, 2010 9:54 am