Re: The column name was not found in this ResultSet

Поиск
Список
Период
Сортировка
was not found in this ResultSetwas not found in this ResultSet  (Craig Ringer <craig@2ndQuadrant.com>)
От Zsolt Kúti
Тема Re: The column name
Дата
Msg-id 20121122102533.79795a45@kuti-zsolt.intranet.prolan.hu
обсуждение исходный текст
Ответ на Re: The column name
Список pgsql-jdbc
Mon, 19 Nov 2012 09:31:17 +0800 -n
Craig Ringer <craig@2ndQuadrant.com> írta:

...
> In my opinion (a) would be horrible to use, and it appears to be
> contrary to the JDBC Resultset spec as well. You'd have to "double
> quote" every identifier if you wanted to use mixed case or any kind of
> non-alphanumeric strings, so:
>
>     rs.getString("B.F. Name")
>
> would have to become:
>
>     rs.getString("\"B.F. Name\"")
>
> or users would get syntax errors, identifier parsing errors, or
> bizarre errors about columns not being found.
>
> So (b) is the best compromise, really. Just alias your columns to
> disambiguate them in the result set by specifying `AS` aliases.

Craig! Thank you for the explanation!

I am to live with b...

Zsolt



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

Предыдущее
От: dmp
Дата:
Сообщение: Re: Problems with BIT datatype and preparedStatment
Следующее
От: pavel.arnost@loutka.cz
Дата:
Сообщение: Statement.setQueryTimeout() with autoCommit=false