Thread: Fwd: errors with getObject() with JDBC driver

Fwd: errors with getObject() with JDBC driver

From
Martin Zeigler
Date:
I am using version 7.0.2 of postgres on Redhat Linux 6.1.  I am also using
Sun's Java 1.3 JVM, using the java2 JDBC driver from postgres.  I have a table
containing several fields of "integer".  I have one row in the table where
these integer are null.  When I retrieve this row's values with my driver by
calling "getObject()" on the resultSet, it returns an Integer object containing
0.  The value is not 0, it should be null.  I verified the fields are null in
the database by issuing a query by hand.

Am I doing something wrong, or is this a bug with the driver?

Thanks,
Martin Zeigler


RE: Fwd: errors with getObject() with JDBC driver

From
Peter Mount
Date:
This should be fixed. I can't remember if it got into 7.0.3 but the current
source does include a check, and it should be returning null.

Peter

-- 
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council


> -----Original Message-----
> From: Martin Zeigler [mailto:mzeigler@home.com]
> Sent: Wednesday, November 29, 2000 2:12 AM
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] Fwd: errors with getObject() with JDBC driver
> 
> 
> 
> I am using version 7.0.2 of postgres on Redhat Linux 6.1.  I 
> am also using
> Sun's Java 1.3 JVM, using the java2 JDBC driver from 
> postgres.  I have a table
> containing several fields of "integer".  I have one row in 
> the table where
> these integer are null.  When I retrieve this row's values 
> with my driver by
> calling "getObject()" on the resultSet, it returns an Integer 
> object containing
> 0.  The value is not 0, it should be null.  I verified the 
> fields are null in
> the database by issuing a query by hand.
> 
> Am I doing something wrong, or is this a bug with the driver?
> 
> Thanks,
> Martin Zeigler
>