On Tue, Jan 28, 2014 at 4:29 AM, Andreas Joseph Krogh <andreak@officenet.no> wrote:
På tirsdag 28. januar 2014 kl. 10:21:34, skrev Florian Weimer <fweimer@redhat.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.
