Re: patch: streaming of bytea parameter values - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: patch: streaming of bytea parameter values
Date
Msg-id Pine.BSO.4.56.0405070113120.32656@leary.csoft.net
Whole thread Raw
In response to patch: streaming of bytea parameter values  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: patch: streaming of bytea parameter values
List pgsql-jdbc

On Wed, 21 Apr 2004, Oliver Jowett wrote:

> This patch allows bytea parameters set via setBytes() /
> setBinaryStream() to be streamed to the backend. With the patch applied,
> the additional memory overhead for bytea parameters is small and
> independent of how large the parameter data is.

Have you given any consideration to extending this to handle streaming
large text fields via setAsciiStream(), setUnicodeStream(), or
setObject(int, Object, Types.LONGVARCHAR) ?  Also updateable ResultSets
have similar updateXXX to PreparedStatement's setXXX methods that could
benefit from a streaming interface.

There is also the implied assumption that V3 protocol implies a unicode
client encoding which implies a seven bit safe streaming option which
would be better spelled out in a comment or called in a way that used the
encoding variable to derive this fact.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Result Set Cursor Patch
Next
From: Oliver Jowett
Date:
Subject: Re: patch: streaming of bytea parameter values