Обсуждение: Re: Problem with Utilizing executeBatch() with stored procedures

Поиск
Список
Период
Сортировка

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
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
>

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
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

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
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

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
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>

Re: Problem with Utilizing executeBatch() with stored procedures

От
"Kranti Parisa"
Дата:
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

Re: Problem with Utilizing executeBatch() with stored procedures

От
"Kranti Parisa"
Дата:
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

Re: Problem with Utilizing executeBatch() with stored procedures

От
Kris Jurka
Дата:

On Mon, 7 May 2007, Dave Cramer wrote:

> It's been fixed in the lastest version.
>

When was this fixed?  As far as I recall you made a patch to fix this, but
never committed it or shared it with the list.  If you believe you
committed this, could you point us to the commit message?

Kris Jurka

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
Crap, you're correct,

I just committed it.

Dave
On 7-May-07, at 9:02 AM, Kris Jurka wrote:

>
>
> On Mon, 7 May 2007, Dave Cramer wrote:
>
>> It's been fixed in the lastest version.
>>
>
> When was this fixed?  As far as I recall you made a patch to fix
> this, but never committed it or shared it with the list.  If you
> believe you committed this, could you point us to the commit message?
>
> Kris Jurka

Re: Problem with Utilizing executeBatch() with stored procedures

От
"Kranti Parisa"
Дата:
Hi,

I am getting the following

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




On 5/7/07, Dave Cramer <pg@fastcrypt.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@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>




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

Re: Problem with Utilizing executeBatch() with stored procedures

От
"Kranti Parisa"
Дата:
Hi,

So finally.. we cant solve this problem now?



On 5/7/07, Dave Cramer <pg@fastcrypt.com> wrote:
Crap, you're correct,

I just committed it.

Dave
On 7-May-07, at 9:02 AM, Kris Jurka wrote:

>
>
> On Mon, 7 May 2007, Dave Cramer wrote:
>
>> It's been fixed in the lastest version.
>>
>
> When was this fixed?  As far as I recall you made a patch to fix
> this, but never committed it or shared it with the list.  If you
> believe you committed this, could you point us to the commit message?
>
> Kris Jurka




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

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
Sure, just grab the source from CVS and build the jar.

Dave
On 7-May-07, at 9:19 AM, Kranti Parisa wrote:

Hi,

So finally.. we cant solve this problem now?



On 5/7/07, Dave Cramer <pg@fastcrypt.com> wrote:
Crap, you're correct,

I just committed it.

Dave
On 7-May-07, at 9:02 AM, Kris Jurka wrote:

>
>
> On Mon, 7 May 2007, Dave Cramer wrote:
>
>> It's been fixed in the lastest version.
>>
>
> When was this fixed?  As far as I recall you made a patch to fix
> this, but never committed it or shared it with the list.  If you
> believe you committed this, could you point us to the commit message?
>
> Kris Jurka




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

Re: Problem with Utilizing executeBatch() with stored procedures

От
"Kranti Parisa"
Дата:
ook..

I havent done this before.. i will try to get that. but if its possible for you, please send me the jar file. it would be a great help.

On 5/7/07, Dave Cramer <pg@fastcrypt.com> wrote:
Sure, just grab the source from CVS and build the jar.

Dave

On 7-May-07, at 9:19 AM, Kranti Parisa wrote:

Hi,

So finally.. we cant solve this problem now?



On 5/7/07, Dave Cramer < pg@fastcrypt.com> wrote:
Crap, you're correct,

I just committed it.

Dave
On 7-May-07, at 9:02 AM, Kris Jurka wrote:

>
>
> On Mon, 7 May 2007, Dave Cramer wrote:
>
>> It's been fixed in the lastest version.
>>
>
> When was this fixed?  As far as I recall you made a patch to fix
> this, but never committed it or shared it with the list.  If you
> believe you committed this, could you point us to the commit message?
>
> Kris Jurka




--
------------------
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

Re: Problem with Utilizing executeBatch() with stored procedures

От
Dave Cramer
Дата:
Kranti,

If you have Ant installed it's pretty easy,

Just get the source,and type ant in the source directory.

The problem is my build is for java 6 currently, which I'm sure you don't want.

Dave
On 7-May-07, at 9:29 AM, Kranti Parisa wrote:

ook..

I havent done this before.. i will try to get that. but if its possible for you, please send me the jar file. it would be a great help.

On 5/7/07, Dave Cramer <pg@fastcrypt.com> wrote:
Sure, just grab the source from CVS and build the jar.

Dave

On 7-May-07, at 9:19 AM, Kranti Parisa wrote:

Hi,

So finally.. we cant solve this problem now?



On 5/7/07, Dave Cramer < pg@fastcrypt.com> wrote:
Crap, you're correct,

I just committed it.

Dave
On 7-May-07, at 9:02 AM, Kris Jurka wrote:

>
>
> On Mon, 7 May 2007, Dave Cramer wrote:
>
>> It's been fixed in the lastest version.
>>
>
> When was this fixed?  As far as I recall you made a patch to fix
> this, but never committed it or shared it with the list.  If you
> believe you committed this, could you point us to the commit message?
>
> Kris Jurka




--
------------------
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

Re: Problem with Utilizing executeBatch() with stored procedures

От
"Kranti Parisa"
Дата:
Hi Dave,

Fine, i will try to get that.

Thanks


On 5/7/07, Dave Cramer <pg@fastcrypt.com> wrote:
Kranti,

If you have Ant installed it's pretty easy,

Just get the source,and type ant in the source directory.

The problem is my build is for java 6 currently, which I'm sure you don't want.

Dave

On 7-May-07, at 9:29 AM, Kranti Parisa wrote:

ook..

I havent done this before.. i will try to get that. but if its possible for you, please send me the jar file. it would be a great help.

On 5/7/07, Dave Cramer <pg@fastcrypt.com > wrote:
Sure, just grab the source from CVS and build the jar.

Dave

On 7-May-07, at 9:19 AM, Kranti Parisa wrote:

Hi,

So finally.. we cant solve this problem now?



On 5/7/07, Dave Cramer < pg@fastcrypt.com> wrote:
Crap, you're correct,

I just committed it.

Dave
On 7-May-07, at 9:02 AM, Kris Jurka wrote:

>
>
> On Mon, 7 May 2007, Dave Cramer wrote:
>
>> It's been fixed in the lastest version.
>>
>
> When was this fixed?  As far as I recall you made a patch to fix
> this, but never committed it or shared it with the list.  If you
> believe you committed this, could you point us to the commit message?
>
> Kris Jurka




--
------------------
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