Brett Wooldridge <[email protected]> writes: > Hi all, > > > I just came across this in the manual, and if accurate raises some > concerns for me: > > For applications using the client driver, if the stream is stored in a > column of a type other than LONG VARCHAR or LONG VARCHAR FOR BIT DATA, > the entire stream must be able to fit into memory at one time. Streams > stored in LONG VARCHAR and LONG VARCHAR FOR BIT DATA columns do not > have this limitation. > > This seems to imply that if I have a BLOB containing 1GB of data, and > I'm using the client driver, the result cannot be streamed? > Can this possibly be correct? Given the apparent limit of VARCHAR of > ~32K, is there no way to stream large data to a client?
A lot of work went into Derby 10.2 and Derby 10.3 to avoid the need to materialize LOBs on the client, so I believe this statement isn't true anymore. I've filed https://issues.apache.org/jira/browse/DERBY-5056 to update the manual. Thanks, -- Knut Anders
