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

From Kris Jurka
Subject Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How
Date
Msg-id Pine.BSO.4.56.0503242002530.10416@leary.csoft.net
Whole thread Raw
In response to Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How to  (David Gagnon <dgagnon@siunik.com>)
Responses Re: [JDBC] plpgsql function with RETURNS SETOF refcursor  (David Gagnon <dgagnon@siunik.com>)
List pgsql-general

On Thu, 24 Mar 2005, David Gagnon wrote:

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

Right, my bad.  I see nothing wrong with your code, but you haven't
included a complete example.  There aren't any thread safety problems in
your code where the executePreparedStatementQueryMultipleCursor function
is called simultaneously? I've attached the test code I've used to verify
that this is not a driver problem.

Kris Jurka

Attachment

pgsql-general by date:

Previous
From: David Gagnon
Date:
Subject: Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How to
Next
From: Edson Vilhena de Carvalho
Date:
Subject: relid and relname