Re: Problem with Utilizing executeBatch() with stored procedures

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Re: Problem with Utilizing executeBatch() with stored procedures
Дата
Msg-id 463F5871.8000102@burntmail.com
обсуждение исходный текст
Ответ на Problem with Utilizing executeBatch() with stored procedures  ("Kranti Parisa" <kranti.parisa@gmail.com>)
Список pgsql-jdbc
Kranti Parisa wrote:
> Hi,
>
> I saw few threads about this topic, but not able to get the solution.
> Please help me how can we solve this problem.
> I have a stored procedure which has to execute for all the given
> employee ids. so i want to do that as a batch to get performance.
>
> but i am getting this error
>
> org.postgresql.util.PSQLException: A result was returned when none was
> expected
>
> A million thanks in advance..
> Hoping for a quick reply

Can't do this with the current production drivers.  I'll forward you a
customized driver sent to me by Dave Cramer that allows invocation of
stored procedures in batch.  I haven't seen any commitment to add this
feature to future drivers.

--
Guy Rouillier

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

Предыдущее
От: "B. Jordan"
Дата:
Сообщение: Re: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?
Следующее
От: "Jack Yu"
Дата:
Сообщение: which jdbc jar files to use?