Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How to

Hi Kris,

   I don't get error with the rsTmp.close() statement but with "
(rsTmp.next()) ".  The arraycopy is because I want to shrink the
original array (size 50) to it real size.  It's not intended to be a
deep copy.

Plpgsql function can return multiple refcursor .. so the question is how
I can get them via JDBC?  Below I included the function that doen't work
(throw exception in the while condition).  I also included a "WORKING"
function that actually return only one refcursor.

Thanks for your help .. if you see something wrong I'll be happy to know
it :-)

/David



public ResultSet[] executePreparedStatementQueryMultipleCursor() throws
SQLException {
       ResultSet rsTmp = ps.executeQuery();
       ResultSet[] tempArray = new ResultSet[50];  // Should be enough
       int j = 0;
       while (rsTmp.next()) {
           tempArray[j] = (ResultSet) rsTmp.getObject(1);
           j++;
       }

       rs = new ResultSet[j];
       System.arraycopy(tempArray, 0, rs, 0, j);

       rsTmp.close();
       return rs;
   }






 public ResultSet executePreparedStatementQueryCursor() throws
SQLException {
        ResultSet rsTmp = ps.executeQuery();
        rs = new ResultSet[1];
        rs[0] = (ResultSet) rsTmp.getObject(1);
        rsTmp.close();
        return rs[0];
    }

Kris Jurka wrote:

>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
>
>
>
>