Re: Will Connection.createBlob be implemented any time soon?

On Tue, Jan 28, 2014 at 4:29 AM, Andreas Joseph Krogh
<andreak(at)officenet(dot)no>wrote:

> På tirsdag 28. januar 2014 kl. 10:21:34, skrev Florian Weimer <
> fweimer(at)redhat(dot)com>:
>
> On 01/28/2014 09:09 AM, Andreas Joseph Krogh wrote:
>
> > I need streaming yes, that's why I use Blobs.
>
> The PostgreSQL wire protocol does not support streaming BYTEA parameters
> and result data.
>
>
> Why do you assume I use BYTEA? I use OID for myu blobs.
>
>
>
> Your initial example does not actually use streaming
> in an essential way, so I'm not sure what you're trying to achieve.
>
>
> Read it again, it does use streaming. It copies the "is" stream out to the
> "os" stream, backed by the Blob.
> Using EclipseLink with the pgjdbc-ng driver it works perfectly using
> Connection.createBlob, streaming etc. I've tried streaming > 200GB stuff
> with a Blob field in a JPA-object and it works.
>
> What pussles me is why the "official" driver doesn't implement createBlob
> as I thought it should be a quit common use-case to want to stream large
> data-chunks in the db (for tx-purposes).
>

Apparently it isn't a common use-case as the driver has never had it.

>
> --
> Andreas Joseph Krogh <andreak(at)officenet(dot)no> mob: +47 909 56 963
> Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
> Public key: http://home.officenet.no/~andreak/public_key.asc
>
>