Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eB4IPRG09968 for ; Mon, 4 Dec 2000 13:25:27 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from mail.rdc1.tn.home.com (ha1.rdc1.tn.home.com [24.2.7.66]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAT2CGt94199 for ; Tue, 28 Nov 2000 21:12:19 -0500 (EST) (envelope-from mzeigler@home.com) Received: from maverick.zigsoft.com ([24.9.209.67]) by mail.rdc1.tn.home.com (InterMail vM.4.01.02.00 201-229-116) with SMTP id <20001129021219.LUAV13852.mail.rdc1.tn.home.com@maverick.zigsoft.com> for ; Tue, 28 Nov 2000 18:12:19 -0800 From: Martin Zeigler To: pgsql-interfaces@postgresql.org Subject: Fwd: errors with getObject() with JDBC driver Date: Tue, 28 Nov 2000 21:11:34 -0500 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00112821123701.22854@maverick.zigsoft.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200012/20 X-Sequence-Number: 357 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