From: Thomas.K.Hill at t-online.de (Thomas Hill)
Date: Sat, 15 Aug 2015 11:08:30 +0200
Subject: [Pljava-dev] Sample Code ResultSetHandle interface
Message-ID: <55CF018E.3030205@t-online.de>

Hi,

I have installed pl/Java and am struggling to understand how the code in 
the calling Java program needs to look like if I want to use the 
resultsethandle interface and just call the sample function listsupers.
Calling listsupers from pgAdmin (select rte.listsupers() in my 
environment) works fine and returns two rows.

I tried
         CallableStatement cstmt = null;
         try {
             cstmt = conn.prepareCall("{ ? = CALL 
\"rte\".\"listsupers\"() }");
             cstmt.executeUpdate();

             ResultSet rs = cstmt.getResultSet();
             while (rs.next()){
                         rs.getString(1);
             }

but this is throwning an error when the executeUpdate() is called.

Can someone please help?

Thanks