From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | RaviShankar K <ravi(at)e-jan(dot)co(dot)jp> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: How to deal with "oid" field when it contains NULL ? |
Date: | 2001-08-09 16:43:36 |
Message-ID: | 3B72BDB8.7080706@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2001-08-09 16:45:39 | Re: Retrieving field of type bigint[] |
Previous Message | Barry Lind | 2001-08-09 16:39:00 | Re: deleting large objects from jdbc |