Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea - Mailing list pgsql-jdbc

From Александър Шопов
Subject Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
Date
Msg-id 1290639211.3659.15.camel@dalgonosko
Whole thread Raw
In response to Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea  (Radosław Smogura <rsmogura@softperience.eu>)
Responses Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
List pgsql-jdbc
В 16:04 -0600 на 24.11.2010 (ср), Radosław Smogura написа:
> I see only two possibilities
> 1. Decrease fetch size, e.g. to 1.
Even if I do, bytea is potentially 1GB. Plus peaks in usage can still
smash the heap.
So refactoring to BLOBs is perhaps the only way out.
Will the JDBC driver always present bytea InputStream as
ByteArrayInputStream? No plans to change that? (even if there are, I
will still have to refactor meanwhile).
Perhaps this behaviour should be better communicated to DB schema
designers.
It seems to me from the Npgsql2.0.11 readme.txt that reading in chunks
is provided for .Net.
Is there need to perhaps make patches for this in the jdbc driver?
Kind regards:
al_shopov


pgsql-jdbc by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
Next
From: vwu98034@lycos.com
Date:
Subject: Do anyone know the cause of this exception?