Hi,
I downloaded the driver from the following link
http://jdbc.postgresql.org/download.htmland 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