Re: Getting Reference cursors - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Getting Reference cursors
Date
Msg-id Pine.BSO.4.56.0506131030250.10929@leary.csoft.net
Whole thread Raw
In response to Re: Getting Reference cursors  (Andrés Luna <aluna@ifxcorp.com>)
List pgsql-jdbc

On Mon, 13 Jun 2005, [iso-8859-1] Andr�s Luna wrote:

> Thanks for your quick answer. However, now I change to the 8.0 driver
> and still doesn�t work. The same code now fails during stored procedure
> execution. Here is the stack trace.
>
> java.sql.SQLException: ERROR: cursor "<unnamed portal 1>" does not exist

I'm not sure why this is happening, perhaps you have autocommit on?
Although that should have caused a failure with the 7.4 driver as well.
I've attached the test case I used to verify this works.  Could you show
us the code that is failing here?

Kris Jurka
Attachment

pgsql-jdbc by date:

Previous
From: Andrés Luna
Date:
Subject: Re: Getting Reference cursors
Next
From: Sergey Pariev
Date:
Subject: Re: in(...) clause and PreparedStatement