Re: JDBC and processing large numbers of rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: JDBC and processing large numbers of rows
Дата
Msg-id 19456.1084332516@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: JDBC and processing large numbers of rows  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Oliver Jowett <oliver@opencloud.com> writes:
> Technically, "SELECT foo;" is two statements, "SELECT foo" and "", as
> JDBC doesn't require a statement terminator. The (simple-minded) JDBC
> query parser doesn't do anything special to ignore trailing empty
> statements.

FWIW, the backend's parser does go out of its way to discard empty
statements (a/k/a useless semicolons).  I do not know how hard it would
be to teach JDBC's parser to do likewise, but it might be worth the
trouble if not too painful.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Retrieve the postgres transaction id
Следующее
От: Guido Fiala
Дата:
Сообщение: Re: JDBC and processing large numbers of rows