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).
--
Andreas Joseph Krogh <andreak@officenet.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
