openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ignacio Andreu" <plunch...@gmail.com>
Subject Re: Problem with streaming support on PostgreSQL
Date Thu, 04 Sep 2008 12:51:56 GMT
About the documentation I will create a JIRA issue and I will provide a
patch with a detail about the use in postgres, also put an annotation in the
@LOB section to link with the streaming support.

On Thu, Sep 4, 2008 at 2:42 PM, Ignacio Andreu <plunchete@gmail.com> wrote:

> The problem is that you can't stream the data into a bytea, now I can't
> remember why. Otherwise, Postgres team recomends to use the pg_largeobject
> table to keep the integrity of your data.
>
>
> On Thu, Sep 4, 2008 at 12:27 PM, Ognjen Blagojevic <ognjen@etf.bg.ac.yu>wrote:
>
>> Ok, I altered the Image table as you proposed (BYTEA -> INTEGER), and now
>> it works just fine. Thank you.
>>
>> There should be a note in the "Streaming LOB support" documentation,
>> explaining how to use it with PostgreSQL DB.
>>
>> BTW, what is the problem with streaming and BYTEA columns? Using
>> pg_largeobject instead of bytea might be an expensive trade-off.
>>
>> Regards,
>> Ognjen
>>
>>
>> Ignacio Andreu wrote:
>>
>>> Hi,
>>>
>>> I've check the code and your e-mails, you said that you have the column
>>> as
>>> bytea, with the lastest code in the trunk your column must be an integer,
>>> OpenJPA uses it to reference the id in the pg_largeobject table. Please,
>>> can
>>> you alter this and try to run your case?
>>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message