Skip site navigation (1) Skip section navigation (2)

Re: Cannot Retrieve Binary Data

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: patrick <pch(at)freeshell(dot)org>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cannot Retrieve Binary Data
Date: 2005-03-13 12:36:22
Message-ID: 423433C6.7090805@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
patrick wrote:

> There's no way to stream a bytea ? how postgres support bytea with 1G if 
> is not possible to insert and select ?

You need to use the binary parameter/result format (at the protocol 
level). The current JDBC driver uses the binary format for bytea 
parameters, but the text format for resultsets. psql uses the text 
format for both, I believe.

> FYI:
> i tried the same Test with postgres 7.4.7 and earlier and is even worst 
>  i was not able to insert.
> The  JDBC Driver  Return Out_Of_Memory during the query execution

I assume you mean with an earlier version of the driver? Earlier driver 
versions used the text format for both parameters and results, and also 
used a large amount of temporary heap space for large bytea parameters.

You may want to look at using the large-object interface if you are 
dealing with extremely large data; it allows random read/write access to 
the data without transferring it all across the wire in one go.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Michael LaccettiDate: 2005-03-13 19:21:57
Subject: RowSet error
Previous:From: patrickDate: 2005-03-13 09:13:39
Subject: Re: Cannot Retrieve Binary Data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group