Re: Prepared statement with function as argument: how to bind values?

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: Prepared statement with function as argument: how to bind values?
Дата
Msg-id CAH_hXRacBHtR1bX0_VypvXcgtxKG6OKXkBk0BCKew5NyK=S9Eg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Prepared statement with function as argument: how to bind values?  (alexbruy <alexander.bruy@gmail.com>)
Список pgsql-jdbc
> As I
> understand, it says about number of columns because there are 5
> columns listed in query and I try to bind value to non existing 6
> column.

As I understand it,

 (1) the parameter handling code doesn't know or care you're executing
an insert, so it shouldn't deal in "columns" here, just in parameters
 (2) the question marks in 'POINT(?,?)' should not be treated as
parameter markers at all: it should just be a String constant.

Can you show us exactly how you're binding parameters in jdbc?
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

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

Предыдущее
От: alexbruy
Дата:
Сообщение: Re: Prepared statement with function as argument: how to bind values?
Следующее
От: Bodor Andras
Дата:
Сообщение: Re: Prepared statement with function as argument: how to bind values?