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

From: Kris Jurka <books(at)ejurka(dot)com>
To: David Gagnon <dgagnon(at)siunik(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How
Date: 2005-03-25 01:14:41
Message-ID: Pine.BSO.4.56.0503242002530.10416@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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 Content-Type Size
MultRefCursor.java text/plain 993 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Vilhena de Carvalho 2005-03-25 02:01:23 relid and relname
Previous Message David Gagnon 2005-03-25 00:49:07 Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How to

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Gagnon 2005-03-25 02:52:18 Re: [JDBC] plpgsql function with RETURNS SETOF refcursor
Previous Message David Gagnon 2005-03-25 00:49:07 Re: [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How to