Postgres Pro
Downloads
Home   >   mailing lists

RE: null to zero? - Mailing list pgsql-jdbc

From chris markiewicz
Subject RE: null to zero?
Date
Msg-id 020601c0beaa$33ea1330$dbb846c6@cmarkiewicz
Whole thread Raw
In response to Re: Help for java  (jlemcke <jlemcke@netspace.net.au>)
Responses RE: null to zero?  (Peter Mount <peter@retep.org.uk>)
List pgsql-jdbc
Tree view 
hello.

it seems that a null value in an integer (int4) column gets converted to
zero at some point...is this accurate?  i look in the db and see null
(queried using IS NULL to make sure), but i call an rs.getObject(colName)
and get a java.lang.Integer with a value of zero...is this in jdbc or java?
an Integer can BE null, but it cannot have a value of null...

didn't see anything in the archives...

thanks
chris

pgsql-jdbc by date:

Previous
From: jlemcke
Date:
Subject: Re: Help for java
Next
From: Sheer El-Showk
Date:
Subject: Error codes in JDBC drivers