Re: Problem with Utilizing executeBatch() with stored procedures - Mailing list pgsql-jdbc

From Guy Rouillier
Subject Re: Problem with Utilizing executeBatch() with stored procedures
Date
Msg-id 463F5871.8000102@burntmail.com
Whole thread Raw
In response to Problem with Utilizing executeBatch() with stored procedures  ("Kranti Parisa" <kranti.parisa@gmail.com>)
List 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 by date:

Previous
From: "B. Jordan"
Date:
Subject: Re: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?
Next
From: "Jack Yu"
Date:
Subject: which jdbc jar files to use?