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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2008-09-26 00:23:04 | Re: Newby Question - accessing refcursor. |
Previous Message | Kris Jurka | 2008-09-25 23:31:24 | Re: Newby Question - accessing refcursor. |