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

Re: Problem with Utilizing executeBatch() with stored procedures

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Kranti Parisa <kranti(dot)parisa(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, guyr-ml1(at)burntmail(dot)com
Subject: Re: Problem with Utilizing executeBatch() with stored procedures
Date: 2007-05-07 12:39:40
Message-ID: A52433D0-4256-4D24-94EB-24A520F467F3@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2007-05-07 12:58:29
Subject: Re: Problem with Utilizing executeBatch() with stored procedures
Previous:From: QDate: 2007-05-07 11:57:42
Subject: OID Bug in AbstractJdbc2DatabaseMetaData.java

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