Postgres Pro
Downloads
Home   >   mailing lists

How to deal with "oid" field when it contains NULL ? - Mailing list pgsql-jdbc

From RaviShankar K
Subject How to deal with "oid" field when it contains NULL ?
Date
Msg-id 02d101c120ac$de66fe40$0400a8c0@ejan.net
Whole thread Raw
List pgsql-jdbc
Tree view
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
 
 
 
 
       
   

pgsql-jdbc by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: RE: Re: deleting large objects from jdbc
Next
From: Rene Pijlman
Date:
Subject: Re: Re: JDBC 2.0 conformance, documentation and todo list