From: chap at anastigmatix.net (Chapman Flack)
Date: Wed, 19 Aug 2015 21:47:56 -0400
Subject: [Pljava-dev]  Sample Code ResultSetHandle interface
In-Reply-To: <55CF018E.3030205@t-online.de>
References: <55CF018E.3030205@t-online.de>
Message-ID: <55D531CC.4000404@anastigmatix.net>

Hello,

Just to be sure I understand correctly....

1. Using PL/Java you have implemented the sample listSupers method,
   and you have registered this as a PostgreSQL stored procedure,

2. It works, as shown by directly sending SELECT rte.listSupers()
   to PostgreSQL,

3. You have a standalone Java program that makes a normal connection
   to PostgreSQL (using the PostgreSQL JDBC driver?) and you want this
   program to use the JDBC CallableStatement interface to call the
   procedure you defined earlier.

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.

I am afraid the usefulness of my answer may end here, as I have no
experience using the CallableStatement JDBC interface myself. It seems
for most purposes you could equivalently (modulo some possible optimization)
use an ordinary Statement and the same SELECT statement that you confirmed
working in (2). Out of curiosity, does that work for you?

Have you had any better response raising the question on pgsql-jdbc ?

Regards,
-Chap