> 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.
> 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.
In response to
pgsql-jdbc by date
|Next:||From: Michael Laccetti||Date: 2005-03-13 19:21:57|
|Subject: RowSet error|
|Previous:||From: patrick||Date: 2005-03-13 09:13:39|
|Subject: Re: Cannot Retrieve Binary Data|