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.
In response to
pgsql-jdbc by date
|Next:||From: burferd||Date: 2008-09-26 00:11:46|
|Subject: Re: Newby Question - accessing refcursor.|
|Previous:||From: burferd||Date: 2008-09-25 23:20:31|
|Subject: Newby Question - accessing refcursor.|