Subject Re: [Firebird-Java] Re: Empty blob query problem
Author William L. Thomson Jr.
Ok,
In doing my part I grabbed the latest CVS snapshot, and made the
modifications suggested below.

I did not find the getBlob(int) function but one called getBlob(boolean)

So I made the modifications, and compiled using ant. I tested out the
new driver, and I got the same results.

To me that function looks strange since it can be passed a value, but
the value is not used in the function. So why pass anything?

Anyhow I am pretty sure I made the modification suggested in the right
place and do not know where to go or look from here.

So if you or anyone else has any ideas I will swap out the code,
compile, and test. As I am barely learning the C API, I do not think I
can be much help other than as a tester. But I will do my part to test
if needed.

Especially since I am the one complaining. :)

Thanks for the suggestions, and let me know if you have any others or
ideas.


On Wed, 2002-07-24 at 11:27, rrokytskyy wrote:
> Hi,
>
> Seems to me that I found the place where it happens, but I do not
> know why this happens. When we get XSQLVAR structure from server it
> contains a mark that the fild is not null, but the ID of the blob is
> null.
>
> In org.firebirdsql.jdbc.FBBlobField, method Blob getBlob(int) I made
> a bug:
>
> if (blobId == null)
> blobId = new Long(0);
>
> Unfortunatelly I do not have time to make more thorough investigation
> of this issue. I would be very grateful if you replace this code with
>
> if (blobId == null)
> return BLOB_NULL_VALUE;
>
> and report results here. This might be a bug, or there might be a bug
> in GDS_Impl.java where the XSQLVAR is retrieved.
>
> I do not commit this code to CVS because I'm not sure if this is
> correct fix or not. Please make some testing.
>
> Best regards,
> Roman Rokytskyy

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com