Re: Problem with Utilizing executeBatch() with stored procedures

What does the output of

org.postgresql.Driver.getVersion()

display ?

On 7-May-07, at 8:53 AM, Kranti Parisa wrote:

> Hi,
>
> Yes i added the jar file as external jar in Eclipse.
>
> Please find the screen shot in the attachment
>
> Regards
> Kranti
>
> On 5/7/07, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
> Are you absolutely sure that you have the correct driver in the
> classpath. The latest source has my code in it.
>
> Dave
>
> On 7-May-07, at 7:46 AM, Kranti Parisa wrote:
>
>> Hi,
>>
>> I downloaded the driver from the following link
>>
>> http://jdbc.postgresql.org/download.html
>>
>> and trying to write the following code in my test class in Eclipse
>>
>> CallableStatement cstmt = null;
>> try {
>> cstmt = con.prepareCall("{?=call test_cal_batch()}");
>> cstmt.registerOutParameter(1, Types.INTEGER);
>> cstmt.addBatch ();
>> cstmt.executeBatch();
>> //Object rs = cstmt.getObject(1);
>> /
>> } catch (SQLException e) {
>> // TODO Auto-generated catch block
>> System.out.println(e.getNextException ());
>> }
>>
>> getting the following error
>>
>> org.postgresql.util.PSQLException: A result was returned when none
>> was expected.
>>
>> Please suggest me some steps
>>
>> Regards
>> Kanti
>>
>> On 5/7/07, Dave Cramer < pg(at)fastcrypt(dot)com> wrote:
>> The latest released version is 8.2-505, this is what you want, and
>> it will work with an 8.1 server.
>>
>> Dave
>>
>> On 7-May-07, at 7:08 AM, Kranti Parisa wrote:
>>
>>> Hi,
>>>
>>> I am using the following driver with PostgreSQL 8.1 version
>>>
>>> postgresql-8.1-406.jdbc3.jar
>>>
>>> Please let me know if the version is correct.
>>>
>>> Regards
>>> Kranti
>>>
>>> On 5/7/07, Dave Cramer < pg(at)fastcrypt(dot)com> wrote:
>>> It's been fixed in the lastest version.
>>>
>>>
>>> Dave
>>> On 7-May-07, at 3:56 AM, 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
>>> >
>>> > ------------------
>>> > Best Regards
>>> > Kranti Kiran Kumar Parisa
>>> >
>>>
>>>
>>>
>>>
>>> --
>>> ------------------
>>> Best Regards
>>> Kranti Kiran Kumar Parisa
>>> Mobile: +91 - 9849 - 625 - 625 +91 - 9391 - 438 - 738
>>
>>
>>
>>
>> --
>> ------------------
>> Best Regards
>> Kranti Kiran Kumar Parisa
>> Mobile: +91 - 9849 - 625 - 625 +91 - 9391 - 438 - 738
>
>
>
>
> --
> ------------------
> Best Regards
> Kranti Kiran Kumar Parisa
> Mobile: +91 - 9849 - 625 - 625 +91 - 9391 - 438 - 738
> <postgresql.JPG>