[Pljava-dev] Sample Code ResultSetHandle interface

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