pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
JDBC 7.0 - ResultSet.getObject() bug
2+ messages / 2 participants
[nested] [flat]

* JDBC 7.0 - ResultSet.getObject() bug
@ 2000-05-23 13:48  Gunnar R|nning <gunnar@candleweb.no>
  0 siblings, 0 replies; 2+ messages in thread

From: Gunnar R|nning @ 2000-05-23 13:48 UTC (permalink / raw)
  To: pgsql-interfaces

Hello, 

I just discovered what I think must be regarded as bug in the JDBC driver
shipped with the 7.0 release. 

The JDBC spec states that ResultSet.getObject() should return "null" if the
there is an SQL NULL value in the column. The JDBC driver for postgres does
however in this case return an object, eg. in the case of an int value it
returns an Integer object with the value of "0". 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: JDBC 7.0 - ResultSet.getObject() bug
@ 2000-05-23 14:18  Peter Mount <petermount@it.maidstone.gov.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Mount @ 2000-05-23 14:18 UTC (permalink / raw)
  To: 'Gunnar R|nning' <gunnar@candleweb.no>; pgsql-interfaces

Hmmm, it should test using isNull() before trying to parse the object
type. I'll check.

Peter

-- 
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.



-----Original Message-----
From: Gunnar R|nning [mailto:gunnar@candleweb.no]
Sent: Tuesday, May 23, 2000 2:48 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] JDBC 7.0 - ResultSet.getObject() bug


Hello, 

I just discovered what I think must be regarded as bug in the JDBC
driver
shipped with the 7.0 release. 

The JDBC spec states that ResultSet.getObject() should return "null" if
the
there is an SQL NULL value in the column. The JDBC driver for postgres
does
however in this case return an object, eg. in the case of an int value
it
returns an Integer object with the value of "0". 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-05-23 14:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-23 13:48 JDBC 7.0 - ResultSet.getObject() bug Gunnar R|nning <gunnar@candleweb.no>
2000-05-23 14:18 RE: JDBC 7.0 - ResultSet.getObject() bug Peter Mount <petermount@it.maidstone.gov.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox