Re: Found a problem with 8.2-508 JDBC 4

Kris,
Thank you very much for identifying this. I even found that I had a
problem with my data model because of this issue.

Thanks,

Lance

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com]
Sent: Thursday, September 11, 2008 12:19 PM
To: Campbell, Lance
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Found a problem with 8.2-508 JDBC 4

On Thu, 11 Sep 2008, Campbell, Lance wrote:

> When the below SQL is executed the result set returns the value of
> "null" for the field "calendar_name". When I use driver "8.2-506 JDBC
> 4" and "8.2-507 JDBC 4" it work correctly and I get a valid value.
>
> SELECT ...,
> event.*,
> calendar.name as calendar_name

Evidently event.* contains a field called calendar name and you're
getting
bitten by this change (from the 508 changelog):

The JDBC spec says that when you have two duplicately named
columns in a ResultSet, a search by name should return the
first one. Previously our code was returning the second match.
(jurka) Thanks to Magne Mahre.

Kris Jurka