Thanks to both of you for your answers.

@Roman: Is there a way to tell if a field is NULL without reading it?

Regards,
Steffen

> -----Ursprüngliche Nachricht-----
> Von: Firebird-Java@yahoogroups.com [mailto:Firebird-
> Java@yahoogroups.com] Im Auftrag von Roman Rokytskyy
> Gesendet: Donnerstag, 29. Juli 2010 17:14
> An: Firebird-Java@yahoogroups.com
> Betreff: Re: [Firebird-Java] BLOBs
>
> > I'm no authority, but in general, Firebird only sends back blob id's
> > during primary select, and then fetches each blob you request
> > individually. So conditionally requesting it should do what you want.
>
> In general this is correct, but only if auto-commit is set to false. In

auto-

> commit mode Jaybird fetches all data to the client incl. the blob contents
> (subrequests are performed automatically).
>
> The rs.getBytes() will fetch all data in all cases, but rs.wasNull(...)

will only

> check a corresponding flag.
>
> So the answer to the second question is "in case when auto-commit is

false,

> BLOB data will be fetched only when you perform rs.getXXX methods, but if
> auto-commit is true (default value) blob contents will be fetched for the
> complete result set at once".
>
> Roman
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]