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@fastcrypt.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@fastcrypt.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@fastcrypt.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>