How to deal with "oid" field when it contains NULL ?
От
RaviShankar K
Тема
How to deal with "oid" field when it contains NULL ?
Дата
Msg-id
02d101c120ac$de66fe40$0400a8c0@ejan.net
Список
Дерево обсуждения
Re: How to deal with "oid" field when it contains NULL ? Barry Lind <barry@xythos.com>
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 по дате отправления