Re: Problem with Utilizing executeBatch() with stored procedures

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with Utilizing executeBatch() with stored procedures
Date: 2007-05-07 16:48:49
Message-ID: 463F5871.8000102@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jack Yu 2007-05-08 15:36:04 which jdbc jar files to use?
Previous Message B. Jordan 2007-05-07 14:53:54 Re: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?