Re: Found a problem with 8.2-508 JDBC 4

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Found a problem with 8.2-508 JDBC 4
Дата
Msg-id Pine.BSO.4.64.0809111317070.12192@leary.csoft.net
обсуждение исходный текст
Ответ на Found a problem with 8.2-508 JDBC 4  ("Campbell, Lance" <lance@illinois.edu>)
Ответы Re: Found a problem with 8.2-508 JDBC 4  ("Campbell, Lance" <lance@illinois.edu>)
Список pgsql-jdbc

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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Campbell, Lance"
Дата:
Сообщение: Found a problem with 8.2-508 JDBC 4
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: looking for a jdbc method.