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