Re: Problem with Utilizing executeBatch() with stored procedures

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