Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group