Geoff hendrey <[EMAIL PROTECTED]> writes: > Hi, > > if I have a column in a ResultSet, and the column is a BLOB, when does Derby > actually send the BLOB to the JDBC client? > > A) Before rs.next() is called? > B) when rs.next() is called? > C) when rs.next().getBlob(i) is called?
Derby 10.2 fetches the entire BLOB when rs.next() is called. Derby 10.3 uses a different mechanism based on locators and doesn't fetch it until you need it (for instance when you call Blob.getBytes()). -- Knut Anders
