Thread: How to deal with "oid" field when it contains NULL ?

----- Original Message -----

From: RaviShankar K

To: pgsql-jdbc@postgresql.org

Sent: Thursday, August 09, 2001 PM 05:25

Subject: [JDBC] How to deal with "oid" field when it contains NULL ?

Hi,

 

    I am retrieving value of "oid" field using "getBlob(columnName)" method of ResultSet .

It is working fine if that field contains some "oid" reference . But if the field contains

NULL , then it is throwing following error .

 

    "FastPath call returned ERROR:  inv_open: large object 0 not found"

 

    I am able to solve the problem using the following way .

   

    ResultSet rs ;

    //If the value of reference is 0 , then there is no Blob value in the row for the column "columnX".

    if(rs.getInt("columnX") != 0){

        Blob someBlob = rs.getBlob("columnX");

    }

 

    Is there any better way than this ?

    Thanks in advance.

 

Regards,

Ravi

 

 

 

 

       

   

Ravi,

Your workaround seems appropriate.  This should be fixed in the driver
code as well.  Want to submit a patch?  If not I will add it to my list
of bugs to fix.

thanks,
--Barry


RaviShankar K wrote:
> Hi,
>
>
>
>     I am retrieving value of "oid" field using "getBlob(columnName)"
> method of ResultSet .
>
> It is working fine if that field contains some "oid" reference . But if
> the field contains
>
> NULL , then it is throwing following error .
>
>
>
>     "FastPath call returned ERROR:  inv_open: large object 0 not found"
>
>
>
>     I am able to solve the problem using the following way .
>
>
>
>     ResultSet rs ;
>
>     //If the value of reference is 0 , then there is no Blob value in
> the row for the column "columnX".
>
>     if(rs.getInt("columnX") != 0){
>
>         Blob someBlob = rs.getBlob("columnX");
>
>     }
>
>
>
>     Is there any better way than this ?
>
>     Thanks in advance.
>
>
>
> Regards,
>
> Ravi
>
>
>
>
>
>
>
>
>
>
>
>
>
>