I meanwhile tried with the DatabaseReader: Postgres can store large objects internally and then saves only a reference in the actual table. The DatabaseReader retrieves the reference using ResultSet.getBinaryStream(). ResultSet.getBlob() retrieves the large object - maybe something for future improvement of the DatabaseReader?
Thanks! -- Jens Reufsteck Hobsons GmbH Wildunger Straße 6 60487 Frankfurt am Main Deutschland Tel: +49 (69) 255 37-140 Fax: +49 (69) 255 37-159 http://www.hobsons.de http://www.hobsons.ch >-----Ursprüngliche Nachricht----- >Von: news [mailto:[EMAIL PROTECTED] Im Auftrag von Kai Hessing >Gesendet: Donnerstag, 27. Juli 2006 14:28 >An: users@cocoon.apache.org >Betreff: Re: Postgres, Cocoon and Blobs > >Bertrand Delacretaz wrote: >> On 7/20/06, Kai Hessing <[EMAIL PROTECTED]> wrote: >>> Does anyone have an idea how I may access Blobs in a >>> Postgres-Database from cocoon?... >> >> I'm not sure if it will work out of the box for you, but the >> DatabaseReader should help - it uses ResultSet.getBinaryStream() to >> retrieve the data. >> >> See >> >src/blocks/databases/java/org/apache/cocoon/reading/DatabaseReader.jav >> a > >We didn't had this package in our build, but my collegue has >written a similiar short routine, which works as well :) Thanks. > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]