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

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