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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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? >>> >> >
