Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How - Mailing list pgsql-general

On Thu, 24 Mar 2005, David Gagnon wrote:

>   I'm already able to get Refcursor from a stored procedure.  But now I
> need to get a SETOF refcursor and I can't make it work... Is that
> possible to do this via JDBC?
>
> He is the code I did.   The rsTmp.next() throws a  Connection is
> closed.  Operation is not permitted. Exception.
>
>
>         rs = new ResultSet[j];
>         System.arraycopy(tempArray, 0, rs, 0, j);
>         rsTmp.close();

System.arraycopy does not make a deep copy, so the rsTmp.close() closes
the ResultSet.  You really can't copy resources around like that.
Consider how you would copy a Connection object.  Does that establish a
new connection?  The underlying tcp/ip connection can't be copied.

Kris Jurka