Problem with Utilizing executeBatch() with stored procedures

From: "Kranti Parisa" <kranti(dot)parisa(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org, pg(at)fastcrypt(dot)com, guyr-ml1(at)burntmail(dot)com
Cc: "Kranti Parisa" <kranti(dot)parisa(at)gmail(dot)com>
Subject: Problem with Utilizing executeBatch() with stored procedures
Date: 2007-05-07 07:56:26
Message-ID: 4478b4ac0705070056p469415d7ib6a1e746de7a0921@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

------------------
Best Regards
Kranti Kiran Kumar Parisa

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heikki Linnakangas 2007-05-07 10:32:04 Re: Closing all existing PostgreSQL database connections
Previous Message Altaf Malik 2007-05-07 07:20:22 Re: postgresql-8.2-504.jdbc4.jar and backslash