Re: jdbc xa support

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: jdbc xa support
Дата
Msg-id 42E1EDFF.7060206@opencloud.com
обсуждение исходный текст
Ответ на Re: jdbc xa support  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-jdbc
Heikki Linnakangas wrote:
> On Thu, 21 Jul 2005, Michael Allman wrote:
>
>> On Thu, 21 Jul 2005, Heikki Linnakangas wrote:
>>
>>> 2. Using prepared statements like "PREPARE TRANSACTION ?" won't work.
>>> You can only use prepared statements for normal SELECT/UPDATE/DELETE
>>> commands.
>>
>> Doesn't the driver support client side prepared statements?
>
> No, they're server side. I tried that too at first, but it didn't work.

Yeah, it boils down to: you can only put a ? placeholder where there's a
PARAM terminal in the server's SQL grammar, as the driver translates the
placeholders to '$n' strings on Parse and uses Bind to pass the actual
values on each execution. COMMIT PREPARED etc take a Sconst, not a
PARAM, for their argument.

-O

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

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: jdbc xa support
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: prepareStatement()