Re: rs.getBigDecimal returning Null on field that is not null

Hi Kris,

Thanks for your anwser. I debugged the JDBC drivers, I searched a lot
to find the problem on my yard :-( I forgot to commented out an EXECUTE
statement. So the field were never calculated even thoutgh all the rest
of the code was there...

Sorry for the noice and thanks for your answer
Best Regards
David

Kris Jurka wrote:
>
>
> On Fri, 28 Sep 2007, David Gagnon wrote:
>
>> I ran into this problem that look like a bug if someone can confirm
>> and hopefully provide a workaround.
>>
>> I have a storedProcedure that use a refcursor + temp table to create
>> a report. The problem is that the NUMERIC field 13 I get in my
>> application is always NULL. When I run the stored procedure from
>> PGADMINIII I can see that field 13 has value 5.5400000000000000.
>>
>
>
> You've provided a lot of very complicated code that no one can run, so
> it's unlikely you're going to get any real useful help. You don't
> even include the Java code that's used to setup and use this function
> which would be nice if you believe it's a problem with the JDBC driver.
>
> I don't know of any bugs in this area and once the refcursor is setup
> the display process works pretty much like any other resultset, so it
> seems unlikely there's a serious bug that leaves out data here. If
> you can put together a small, self contained test case, I'll gladly
> take a look at it, but I don't see anything immediately wrong in this
> area.
>
> Kris Jurka
>