From: chap at anastigmatix.net (Chapman Flack)
Date: Sun, 23 Aug 2015 12:25:55 -0400
Subject: [Pljava-dev] Sample Code ResultSetHandle interface
In-Reply-To: <55D531CC.4000404@anastigmatix.net>
References: <55CF018E.3030205@t-online.de> <55D531CC.4000404@anastigmatix.net>
Message-ID: <55D9F413.7060405@anastigmatix.net>

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