Re: JDBC driver's (non-)handling of InputStream:s

Поиск
Список
Период
Сортировка
От Guido Fiala
Тема Re: JDBC driver's (non-)handling of InputStream:s
Дата
Msg-id 200403311046.17224.guido.fiala@dka-gmbh.de
обсуждение исходный текст
Ответ на Re: JDBC driver's (non-)handling of InputStream:s  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
>> It would be great if you could supply a test case which exhibits this
>> behaviour.
>
>I can probably do that relatively easily (though of course subject to the
>behavior of the VM memory manager), though given Oliver Jowett's response
it
>seems pretty obvious what is happening - allocating a 5 MB byte array is
>failing and/or the byte array is constructed in a tight loop allocating
>incrementally larger arrays until the data fits.

It's slightly more "intelligent" - see code...

>Allocating such large arrays is bound to be unreliable in any case, so as
long
>as that is what's happening I fully understand it and there's probably not
>much to be done...

Thats true so long the consumer needs the data fully in RAM, e.g. an
Image-Label or similar. If the consumer is also stream-based it could be
avoided. Unfortunately the backend would still hold the results of the query
fully in memory which is also not always desired...

Guido

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

Предыдущее
От: Guido Fiala
Дата:
Сообщение: Re: OutOfMemory
Следующее
От: Hans-Jürgen Schönig
Дата:
Сообщение: very interesting JDBC problem ...