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

På tirsdag 28. januar 2014 kl. 15:31:20, skrev Dave Cramer <pg(at)fastcrypt(dot)com
<mailto:pg(at)fastcrypt(dot)com>>:   On Tue, Jan 28, 2014 at 4:29 AM, Andreas Joseph
Krogh<andreak(at)officenet(dot)no <mailto:andreak(at)officenet(dot)no>> wrote: På tirsdag 28.
januar 2014 kl. 10:21:34, skrev Florian Weimer <fweimer(at)redhat(dot)com
<mailto: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.    Apparently not common in pg-land.   --
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