public inbox for [email protected]  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Sample Code ResultSetHandle interface
Date: Sun, 23 Aug 2015 12:25:55 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

On 08/19/15 21:47, Chapman Flack wrote:

> It seems to me that (1) and (2) indicate you have done the PL/Java and
> SQL parts correctly, and the question concerns the behavior of
> CallableStatement as implemented in the PostgreSQL JDBC driver.

Just to close the loop, Herr Hill found the answer in this section
of the pgsql-jdbc project documentation:

https://jdbc.postgresql.org/documentation/94/callproc.html#callproc-resultset-setof

It seems the PostgreSQL JDBC driver hasn't implemented CallableStatement
to work with a procedure returning a setof type, and the workaround is to
use a regular Statement with 'select * from theprocedure()'.

This is independent of PL/Java, but I suppose the pgsql-jdbc devs would
accept a patch removing that limitation.

-Chap

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Subject: Re: [Pljava-dev] Sample Code ResultSetHandle interface
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox