Skip site navigation (1) Skip section navigation (2)

Re: Getting Reference cursors

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 (view raw or flat)
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: CursorMD.java
Description: text/plain (1.1 KB)

In response to

pgsql-jdbc by date

Next:From: Csaba NagyDate: 2005-06-14 08:29:35
Subject: Re: in(...) clause and PreparedStatement
Previous:From: Tom LaneDate: 2005-06-13 14:34:43
Subject: Re: timestamp & graph time scale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group