Re: Problem with Utilizing executeBatch() with stored procedures

Hi,

I am getting the following

>>>>>>>>>>>>>>>>>>> PostgreSQL 8.2 JDBC3 with SSL (build 505)

On 5/7/07, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
> 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>
>
>
>

--
------------------
Best Regards
Kranti Kiran Kumar Parisa
Mobile: +91 - 9849 - 625 - 625 +91 - 9391 - 438 - 738