From: Thomas.K.Hill at t-online.de (Thomas Hill)
Date: Sun, 16 Aug 2015 12:51:52 +0200
Subject: [Pljava-dev] Sample Code ResultSetHandle interface
In-Reply-To: <55CF018E.3030205@t-online.de>
References: <55CF018E.3030205@t-online.de>
Message-ID: <55D06B48.6050506@t-online.de>

Am 15.08.2015 um 11:08 schrieb Thomas Hill:
> 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
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at lists.pgfoundry.org
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev
Note: The sample code getNames for the resultsetprovider interface works 
fine. The error thrown when trying to run the above listsupers sample is 
"Malformed function or procedure escape syntax at offset 2." but 
listsupers dowsn't have any in out our parameters!?