| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Andrés Luna <aluna(at)ifxcorp(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Getting Reference cursors |
| Date: | 2005-06-13 15:33:33 |
| Message-ID: | Pine.BSO.4.56.0506131030250.10929@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Mon, 13 Jun 2005, [iso-8859-1] Andrs Luna wrote:
> Thanks for your quick answer. However, now I change to the 8.0 driver
> and still doesnt 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 | Content-Type | Size |
|---|---|---|
| CursorMD.java | text/plain | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2005-06-14 08:29:35 | Re: in(...) clause and PreparedStatement |
| Previous Message | Tom Lane | 2005-06-13 14:34:43 | Re: timestamp & graph time scale |