Subject AW: [Firebird-Java] BLOBs
Author Steffen Heil
Thanks to both of you for your answers.

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


> -----Urspr√ľngliche Nachricht-----
> Von: [mailto:Firebird-
>] Im Auftrag von Roman Rokytskyy
> Gesendet: Donnerstag, 29. Juli 2010 17:14
> An:
> 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
> 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
> 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]