Postgres Pro
Downloads
Home   >   mailing lists

getColumnClassName() and getObject() types differ for smallint - Mailing list pgsql-jdbc

From Karl von Randow
Subject getColumnClassName() and getObject() types differ for smallint
Date
Msg-id 20050922223443.WBPU5449.mta4-rme.xtra.co.nz@Orac
Whole thread Raw
Responses Re: getColumnClassName() and getObject() types differ for
List pgsql-jdbc
Tree view 
Hi all,

I have encountered what I believe is a bug in the Postgres JDBC drivers 8.0
build 312 and 8.1dev build 401 in regards to the class returned for smallint
columns using getObject() compared to the class indicated by the
getColumnClassName() method.

For my smallint column:
ResultSetMetaData.getColumnClassName() returns java.lang.Short
ResultSet.getObject().getClass().getName() returns java.lang.Integer

I have tested and confirmed this behaviour in driver 8.0 312 and 8.1dev 401
against my PostgreSQL 7.3.2 installation using Java 1.5.0_04-b05 on Linux. I
have not had an opportunity to test against a different version of
PostgreSQL.

The problem does not exist in the 7.4 build 216 driver; it returns
java.lang.Short for both.

Kind regards,
Karl

pgsql-jdbc by date:

Previous
From: "dircha"
Date:
Subject: Re: ResultSet#xxxTimestamp for DATE column unexpected behavior
Next
From: Oliver Jowett
Date:
Subject: Re: getColumnClassName() and getObject() types differ for