Re: How to retieve binary data (bytea) without problem ? - Mailing list pgsql-jdbc

From Alfredo Rico
Subject Re: How to retieve binary data (bytea) without problem ?
Date
Msg-id 89cc056d05092911376050d6bc@mail.gmail.com
Whole thread Raw
In response to Re: How to retieve binary data (bytea) without problem ?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Thank you Kris, I was absolutely confused about this situation.

I'll switch to Blob objects because increasing the JVM heap could harm perfromance...

Kind Regards.
Alfredo Rico,

On 9/29/05, Kris Jurka <books@ejurka.com> wrote:


On Thu, 29 Sep 2005, Alfredo Rico wrote:

> Your suggest is very correct and in fact it works very well but only if the
> file size is under 10 MB,
> The problem happens just at moment to execute:
> InputStream ins = rs.getBinaryStream( 1 );
>

The JDBC driver can stream data going to the server (setBinaryStream), but
cannot stream data returning from the server (getBinaryStream) because of
protocol limitations.  You have two options:

Switch from using bytea to large objects (Blobs).  Large objects were
designed to work with much larger data sizes and have a complete streaming
interface.

Increase the JVM's heap size.  Since you are using netbeans and you
haven't received many helpful suggestions here, you might try a netbeans
specific list for suggestions on how to accomplish this.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: XADataSource implementation
Next
From: "Vsevolod (Simon) Ilyushchenko"
Date:
Subject: Intermittent I/O error?