Re: CallableStatements: index starts at 2

Поиск
Список
Период
Сортировка
От Andres Olarte
Тема Re: CallableStatements: index starts at 2
Дата
Msg-id 3fccaa690512140838o464dd369y4194a05c4f28d553@mail.gmail.com
обсуждение исходный текст
Ответ на CallableStatements: index starts at 2  (Thomas Frieling <frieling@8hertz.de>)
Ответы Re: CallableStatements: index starts at 2
Список pgsql-jdbc
You probably should use prepareStatement instead of prepareCall.  I had the same problem.  You can search the archives to look for a better explanation which I don't remmember right now

On 12/14/05, Thomas Frieling <frieling@8hertz.de> wrote:
It seems that in Version "8.2dev-500 JDBC 3" CallableStatements are
implemented differently from older Versions.
The index to set fields now starts at 2.

This _did_ work:
CallableStatement cS = con.prepareCall("{ call test(?)}";
cS.setString( 1, "abc" );

This _now_ works:
CallableStatement cS = con.prepareCall("{ call test(?)}";
cS.setString( 2, "abc" );

Thanks,
Thomas


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

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

Предыдущее
От: Thomas Frieling
Дата:
Сообщение: CallableStatements: index starts at 2
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: CallableStatements: index starts at 2