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:42:21 GMT
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