Re: JDBC, prepared queries, and partitioning

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: JDBC, prepared queries, and partitioning
Дата
Msg-id 47B4326D.3080907@opencloud.com
обсуждение исходный текст
Ответ на Re: JDBC, prepared queries, and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: JDBC, prepared queries, and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-jdbc
Simon Riggs wrote:

> Why not just fold in parameters if option is set and can continue to use
> normal V3 route, just with zero parameters? Any JDBC calls that want to
> inspect parameters can throw an exception when the option is set. So
> JDBC thinks there were parameters, yet Postgres server thinks there were
> no parameters.

Well, yes, that's essentially how our protocol-level abstraction works -
the main driver deals in terms of abstracted Query and ParameterList
objects, and the protocol layer maps those to something the server
understands. This is how we support the v2 and v3 protocols in the same
driver. I was suggesting a third protocol path ("v3simple" or something)
that did pretty much what you described .. but I fear you are
underestimating the work needed to implement it.

If you want to put together a patch, though, I'm happy to take a look at it.

-O


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

Предыдущее
От: Tomisław Kityński
Дата:
Сообщение: SMALLINT vs short or... int?
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: SMALLINT vs short or... int?