Thread: Problem with Utilizing executeBatch() with stored procedures
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
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
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