Re: Newby Question - accessing refcursor.

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@postgresql.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.