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

Re: Newby Question - accessing refcursor.

From: burferd <jarzabek(at)pobox(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Newby Question - accessing refcursor.
Date: 2008-09-26 00:11:46
Message-ID: 19680440.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks for the fast feedback, but changing the type to OTHER does not resolve
the problem, 
I still get the same error.


Kris Jurka wrote:
> 
> 
> 
> 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
> 
> -- 
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
> 
> 

-- 
View this message in context: http://www.nabble.com/Newby-Question---accessing-refcursor.-tp19680083p19680440.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.


In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2008-09-26 00:23:04
Subject: Re: Newby Question - accessing refcursor.
Previous:From: Kris JurkaDate: 2008-09-25 23:31:24
Subject: Re: Newby Question - accessing refcursor.

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