Skip site navigation (1) Skip section navigation (2)

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

From: David Gagnon <dgagnon(at)siunik(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: rs.getBigDecimal returning Null on field that is not null
Date: 2007-10-01 10:48:39
Message-ID: 4700D087.6050303@siunik.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>


In response to

pgsql-jdbc by date

Next:From: Christian RouxDate: 2007-10-01 13:14:28
Subject: small bug
Previous:From: Heikki LinnakangasDate: 2007-10-01 08:38:52
Subject: Re: Prepared Statements vs. pgbouncer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group