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

[RaviShankar K]

Hi,       I could not mention my question clearly in my previous post.     My question is,         Will rs.getInt("someBlobColumn") always return 0 when oid type column contains NULL ?   Ravi     ----- Original Message ----- From: RaviShankar K To: [EMAIL PROTECTED] 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