Subject Re: Obscure error
Author Roman Rokytskyy <>
> I get an error from some data which is in an odd state. I'm afraid
> I'm not sure how best to describe it, but it's a blob that has no
> content, but is not defined as null. This is the error (through
> ColdFusion MX):

Can you suggest how to get such field? I see the place in the code
where this happens, but I hardly see how can it happen. This code is
in FBLongVarCharField.getBlob():

if (rs.row[numCol]==null)

Long blobId = new Long(XSQLVAR.decodeLong(rs.row[numCol]));

At this point blobId is equal to new Long(0), which for FBBlob
implementation means "create new blob". There is either bug in FBBlob
assuming that there can be no 0 blob ID, or in long decoding
function. But say that for sure I will need some idea how to
reproduce this bug.

> Hope this helps, please let me know if I can be a little more
> specific or if you want me to try something.

A test case would be great!

Roman Rokytskyy