Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea

Поиск
Список
Период
Сортировка
От Radosław Smogura
Тема Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
Дата
Msg-id 5cdf97054e76f67c40b74de114691762@smogura-softworks.eu
обсуждение исходный текст
Ответ на Workarounds for getBinaryStream returning ByteArrayInputStream on bytea  (Александър Шопов <lists@kambanaria.org>)
Ответы Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea  (Александър Шопов <lists@kambanaria.org>)
Список pgsql-jdbc
I see only two possibilities
1. Decrease fetch size, e.g. to 1.
2. Refactor schema.

Kind regards,
Radek

On Wed, 24 Nov 2010 22:50:46 +0200, Александър Шопов
<lists@kambanaria.org>
wrote:
> Hi everyone,
> I have a table containing file contents in bytea columns.
> The functionality I am trying to achieve is having a result set
> containing such columns, iterating over them and streaming them while
> zipping them.
[...]
> So what am I options? Refactor the DB schema to use blobs rather than
> bytea? Is it impossible to have bytea read in chunks?
> Kind regards:
> al_shopov

--
----------
Radosław Smogura
http://www.softperience.eu

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Александър Шопов
Дата:
Сообщение: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
Следующее
От: Александър Шопов
Дата:
Сообщение: Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea