Re: Problem with Utilizing executeBatch() with stored procedures

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