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

Re: Newby Question - accessing refcursor.

From: Kris Jurka <books(at)ejurka(dot)com>
To: burferd <jarzabek(at)pobox(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Newby Question - accessing refcursor.
Date: 2008-09-25 23:31:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

On Thu, 25 Sep 2008, burferd wrote:

> I'm trying to fetch the data returned from the stored procedure with the
> method listed below.
> When I do, the execute() method throws the following exception:
> ERROR: cursor "<unnamed portal 1>" does not exist

To cursors (without hold) disappear at transaction end.  You need to 
ensure you have done Connection.setAutoCommit(false) or else the cursor 
will disappear before you can fetch from it.

>            cs.registerOutParameter(1, java.sql.Types.JAVA_OBJECT);

This should also be Types.OTHER instead of JAVA_OBJECT.

Kris Jurka

In response to


pgsql-jdbc by date

Next:From: burferdDate: 2008-09-26 00:11:46
Subject: Re: Newby Question - accessing refcursor.
Previous:From: burferdDate: 2008-09-25 23:20:31
Subject: Newby Question - accessing refcursor.

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