db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: when does a ResultSet actually retrieve a BLOB
Date Mon, 24 Sep 2007 07:39:53 GMT
Geoff hendrey <geoff_hendrey@yahoo.com> 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

View raw message