Re: JDBC, prepared queries, and partitioning

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: JDBC, prepared queries, and partitioning
Дата
Msg-id 1202944752.16770.568.camel@ebony.site
обсуждение исходный текст
Ответ на JDBC, prepared queries, and partitioning  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: JDBC, prepared queries, and partitioning  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
On Thu, 2008-02-14 at 11:55 +1300, Oliver Jowett wrote:

> Using the version 2 protocol means that parameter values are sent inline
> with the query, which avoids the planning issue (but raises a number of
> other problems since the v2 protocol is much less flexible than v3)
>
> > Can I use v2 against 8.3?
>
> I think so. You obviously lose any behaviour that depends on v3, e.g.
> parameter metadata and smarter bytea streaming.

What we need is a "send parameters inline" mode that can be set as an
option for a PreparedStatement. Nobody wants to use V2, we just want the
ability to re-plan a query every time. Perhaps that is best implemented
as a server side option that can be exposed via JDBC option, since this
is an SQL requirement and nothing to do with Java.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: JDBC, prepared queries, and partitioning
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: JDBC, prepared queries, and partitioning