Re: Change in parameters' order in prepared statement??

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Change in parameters' order in prepared statement??
Дата
Msg-id 431A89CB.7040201@opencloud.com
обсуждение исходный текст
Ответ на Re: Change in parameters' order in prepared statement??  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Oliver Jowett wrote:
> Andres Olarte wrote:
>
>>I recently updated the driver to the latest CVS version, and found a
>>change in the way parameters are handled.  Before, the first parameter
>>was 1, as in:
>>
>>update.setInt(1,cbid);
>>
>>But now it's 2, as in:
>>
>>update.setInt(2,cbid);
>>
>>I'm using only IN parameters to call a prepared SELECT. Is this the
>>correct behaviour? Is it going to stay this way?
>
>
> This sounds like a bug -- can you provide a more detailed testcase?

Per off-list discussion this seems to be a bug that affects non-{call}
queries prepared via prepareCall() only; if prepareStatement() is used,
it works fine. I haven't dug deeper, but perhaps this is a bug
introduced by the OUT parameter support.

-O

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Prepared statement not using an index
Следующее
От: Aydın Toprak
Дата:
Сообщение: simple insert operation