Re: NULL Blob column error - PATCH FIX

Patch applied.

--Barry

David Wall wrote:
> Originally I thought this was going to be worse than I thought since I'm not
> familiar with the fastpath code at all. However, a check of ResultSet.java
> shows that the null check simply was not being done for getBlob().
> Therefore, this patch for 7.2.2 will resolve the "FastPath call returned
> ERROR: inv_open: large object 0 not found" exception when retrieving
> Blob/OID that is NULL. I noted that this bug remains in the latest CVS as
> well.
>
> [postgresql(at)dev1 jdbc2]$ diff -c ResultSet.orig ResultSet.java
> *** ResultSet.orig Sat Jan 5 14:26:22 2002
> --- ResultSet.java Tue Sep 10 11:03:11 2002
> ***************
> *** 931,936 ****
> --- 931,940 ----
>
> public Blob getBlob(int i) throws SQLException
> {
> + wasNullFlag = (this_row[i - 1] == null);
> + if (wasNullFlag)
> + return null;
> +
> return new org.postgresql.largeobject.PGblob(connection,
> getInt(i));
> }
>
>
> David
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>